SUMMARY

• Over 10 years of experience in IT industry in working on large - scale projects, including Data Warehouse, Data Integration, Data Migration and BI Reporting, Utilizing various ETL and BI Tools. Work experience with Automobile, Banking, Hi-tech, Telecom, Financial, Utilities and Healthcare sectors.
• I have Implemented 5 full lifecycle data warehouse and Data migration projects using the SDLC methodology.
• Domain expertise in understanding business process, system analysis, development, implementation and support, of applications in database, data warehouse and BI environments.
• Extensive experience in ETL methodologies for supporting Data Warehouse and Data Migration using ETL Tools like Informatica PowerCenter v 10.1/9.x, Informatica power exchange 9.6, Informatica Data Quality, informatica Cloud and SSIS by implementing the informatica velocity methodology standards.
• Experience in Design and Development of Data visualization reports by using Various BI tools like MS PowerBI, Oracle BI and SAP BO in building Data marts for business users and stakeholders.
• Interacted with Business Users to analyze the business process and converted them into techinical requirement by documenting the business rules in Technical Design Document and Mapping Design Document.
• Experience with Ralph Kimball’s Dimensional modelling and Bill inmon methodology using Star schema and Snow Flake schema.
• Experience in working with business users to clarify the requirements and issues with the data and did the impact analysis of change requirement and communicated the risk assessment of the new scope and new timelines.
• Strong in analytical and conceptual skills for database design and development
• Extensively used various Performance Tuning techniques to investigate various bottlenecks in informatica at session and mapping level to improve the performance for data loads.
• Worked with business users and gathered analytics reporting requirements and created business and functional documents, designed physical data model and data-mart, developed RPD data model and created analysis reports and dashboards based on functional requirement document using Oracle BI.
• Excellent Production support experience in analyzing the failure and log files to find the root cause analysis and improve the session performance.
• Extensively worked on Developing, Monitoring and Jobs Scheduling using CA workload automation, Control M, Tidal, Autosys, informatica scheduler and Shell Scripts.
• Excellent in documentation of business logic, Technical specifications, Database Scripts, UNIX shell scripts, Unit testing, Performance tuning and Trouble ticket resolution.
• Providing ongoing support for maintenance and enhancing the application to meet the changing business requirements through a Change Management process
• Strong Business partner facing, written and presentation skills and team player with ability to work alone or as a part of team.
• Good understanding of SDLC and Agile methodologies.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.1/9.6/8.6/8.1/7.1/6.2/5.1 (5 years), Power Exchange 8.1, IDQ, IDE, SSIS, SAP BO Data Services, OBIA, DAC, Seibel, PeopleSoft, JD Edwards.

BI/OLAP Tools: SAP Business Objects BOXI 4.0/R3.1, oracle BI, SSRS, MS Power BI

Databases: Oracle 10g/9i, MS SQL Server 2005/2000, UDB DB2 V 8.x/7.x, Teradata v10, 13.1, Sybase 11, SAP HANA.

Modeling: Star-Schema Modeling, Snowflake Modeling, FACT and Dimension Tables, ERWIN 4.1/4.0/3.5.2 , Power Designer 6.0, Oracle Designer 2000

Programming: SQL, PL/SQL, Unix Bash Shell, HTML, VBScript, JavaScript, XML.

Tools: MS OFFICE, MS SharePoint, FTP Pro, Quest Central for DB2, TOAD, SQL Navigator, SQL Developer, Embarcadero, SQL*Loader, Visual Interdev 6.0, Autosys, MS Visio, Control-M

Operating systems: UNIX (4 years) Sun-Solaris 10, AIX 4.3/4.2, HP/UX, Windows 95/98/00/NT/XP, Windows Server 2003, IIS 6, MS DOS

Version Control: Informatica Version control, CVS, PVCS, MS VSS, Rational Clear Case, Subversion, Serena Dimensions, Star team, CaliberRM, SDLC, AGILE, Water Fall