Abhishek Gupta

I am working as senior software engineer in Accenture, Chennai. I have total 9 years of work experience in Informatica Power Center (ETL). Apart from that I am also perusing part time PhD. i am ready to teach any where in your location or mine. My experience is as below:-
• Experience in Business Intelligence solutions using DWH/DM design, etl and reporting tools.
• Experience in DWH/DM design andetl using informatica power center 10.1.0/9.5/9.1.0/9.0.1/8.6/8.5.1.
• Experiencein Dimensional data modeling, star/snowflake schema,data ware house, FACT tables and dimensional tables.
• Experience in Business Intelligence and crystal reports.
• Implemented ETL solutions in various domains such as Banking, Finance, Telecom, Mfg, sales and insurance applications using SQL and Informatica.
• Been Part of various integration, reporting, migration, enhancements engagements.
• Experience in requirement gathering,planning,analysis design unit testing code migration, quality assurance testing, UAT, production support with expertise in developing business applications much based on RDBMS.
• Experience in leading team, good understanding of onsite-offshore environment.
• Experience in analyzing the data to learn data characteristics.
• Experience in migrating the code Experience in between environments, with proper documentation.
• Extensive Experience ininformatica to deal with heterogeneous sources and target systemswhich include leading RDBMS (likewise Oracle), flat-files.
• Extensive Experience ininformatica to SCD types, Fact Loads and Audit Balance Controls.
• Extensive Experience in ETL error handling, performance tuning an code optimization.
• Hands on Experience in scheduling Control-m.
Databases:- Oracle 9i/8i/8.0i7.0, pl/sql, sql*plus,developer 2000.