Sachin T.

Develop and maintain data governance policies and procedures. Ensure the accuracy and integrity of data. Advocate for the use of data to improve business decision-making. Work with stakeholders to define business requirements and translate them into data-driven solutions. Oversee the development and implementation of BI projects. Communicate the value of BI to stakeholders.

Working as Senior BI Analyst and Support Lead. Working with business users, BI developers/analysts and security team to support reporting dashboards. Working on performance improvement of different BI dashboards. Design Data model to implement reporting solution for key database performance metrics. Development and support of reporting dashboards from Hadoop using Impala. Development of prototype reporting dashboards.

Working closely with Business Users to understand the reporting requirements. Requirements analysis and detailed functional design for the various blocks identified within the application. Design and develop report dashboards with rich visualization to track key business metrics. Design and develop ETL jobs to simplify reporting solution. Implementation of best design practices for DWBI implementation. Designing data model from scratch to aid team in data collection to be used for reporting. Conducted presentations to other lines of business. Focused on security by taking different security measures. Coordinate with internal and external resources to determine potential data gaps. Work with business users and analysts and developers to define metrics and create data mapping document and data dictionary. Designed Logical and Physical data model. Define the overall BI data architecture, including ETL processes, ODS, EDW, data marts. Mentored team in development of ETL, data Model and Analytical Components. Perform detail data analysis to validate data integrity and identify data quality issues and their root cause. Test and validate dashboards to ensure data accuracy and quality. Work with the data architect to insure that logical and physical data models support the analytic needs of the business. Provide DWBI technical and architectural guidance to projects and teams, ensuring that new initiatives enable effective data reporting. Collaborate with key business users to identify needs and opportunities for improved data management and delivery.

Developed requirements and specifications in coordination with the Enterprise Reporting team, Database Administrators and ETL Architects to build and enhance the data warehouse. Performed data modeling using Star Schema to meet customer business and technical requirements. Developed of report specification & template to be used for report creation and testing. Designed the user experience from an end user finance and reporting perspective. Designed and developed Dashboard reports and certain drill through OLAP reports for advance analysis to meet the specified business requirement(s). Implemented incremental data load strategy. Coordinated with the business users for the unit & system testing of the reports. Coordinate with DBA to fine-tune the database with respect to reports thereby improving the query response time. Ensured quality of data and solutions prior to releasing to production. Provides technical support in retrieving data from a variety of database types and languages. Proactively identifies and addresses scalability and performance bottlenecks to support data volumes. Evaluated and recommended new tools in reporting, and analysis where appropriate. Defined test conditions and test scripts to ensure system stability and validity.

Worked as an DWBI Analyst in Vanguard Group Inc for Enterprise Data and Money Movement reconciliation. Was responsible for understanding Business process and coordinating with Business analyst and users to get specific user requirements. Responsible for Designing, Developing, Documenting and Testing, Code deployment, Scheduling jobs in Production and non-Production environment. Gathered Business Requirements, interacted with the Users, Project Managers and SMEs to get a better understanding of the Business Processes. Transformed business needs and requirements into design and implementation of data warehouse and BI reporting. Created different KPI using calculated key figures and parameters. Built a prototype dashboard to provide insights into the operations of a business function. Wrote complex SQL’s. Created databases views, procedures and functions. Worked with ETL Developers, DW/BI architect, BSAs and DBAs to address issues reported by business. Arranged walkthrough sessions with the user group and QA teams to confirm that all the requirements have been captured and obtained sign off on the requirements documents.

Worked as an DWBI developer in Integrated Product Development. Worked on complete lifecycle of an application from analysis, design, implementation, testing and production support. Worked on data migration project from legacy system to Enovia PLM. Interacted with BA’s to analyze requirements for the new system. Involved in Data Modeling and Data Warehousing Using Multi-Dimensional Model, Star and Snow Flake Schemas. Designed and developed complete DWBI solution.

Worked as an ETL Developer. Created mapping documents to outline data flow from sources to targets. Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse. Created the environment for Staging area, loading the Staging area with data from multiple sources. Modified existing mappings for enhancements of new business requirements. Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions. Involved in system testing, performance and System Integration testing stages of the project. Created batch schedule with Control-M in all Production and non-production environments. Created UNIX shell scripts for Informatica ETL tool to automate sessions. Created DB2 PL/SQL procedures and functions. Conducted peer review of the design and code ensuring proper follow up of Business Requirements while adhering to quality and coding standards. Performed troubleshoot on all system performance to maintain data integrity.