6 Years of experience in Datawarehousing and Business Intelligence which includes Datawarehouse ,ETL and BI Reports Designing and Development. Have extensively worked on tools Informatica Powercenter and IBM Cognos. Have also worked on IBM ISAS which involves text analytics, social media analytics and IBM Cognos stack. Visited client location couple of times for requirement gathering, presales presentations and as developer. Have knowledge on tidal scheduling tool and shell scripting.

Technology Analyst @ Working as a ETL developer for one of the largest automobile industry in world. Worked on Informatica Powercenter and IBM Cognos 10.1 tools for ETL and Reporting respectively. Role: • Involved in the ETL technical design discussions and prepared ETL high level technical design document. • Involved in the analysis of source to target mapping provided by data analysts • Involved in ETL low level design and prepared design document for each of the target table • Extracting Data from Cloud, Scaling at ETL layer and Pushing back to Salesforce Cloud. • Supported during QA/UAT/PROD deployments and bug fixes. • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables. • Involved in code Reviews as per ETL/Informatica standards and best practices • Worked with Reporting team to improve performance of reports. • Unit Testing, Peer Review of ETL and Database code. • Created integrated workflow per subject area keeping the dependency within the subject area • Wrote Unit Test cases and executed test scripts successfully. • Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager. • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer. From May 2012 to Present (3 years 8 months) BI Developer @ Datawarehouse and Business Intelligence consultant having key skills as IBM Cognos, IBM Infosphere Warehouse, IBM DB2 and Microsoft SQL Server BI Stack. Worked as an Developer and Datawarehouse Designer. From April 2010 to May 2012 (2 years 2 months) Consultant Test Engineer @ Worked as an Consultant test engineer. Job responsibilites involved manual database testing (Oracle 10g). From November 2009 to February 2010 (4 months)

HSC @ St. Joseph Convent, Valsad From 2001 to 2003 Abhishek Shrivastava is skilled in: Cognos, Microsoft SQL Server, Microsoft BI, Informatica, IBM DB2, IBM Smart Analytics, IBM Infosphere Warehouse, Business Intelligence, OBIEE, ETL, Data warehouse Architect, DB2, Pre-sales, Data Warehousing, Oracle