Implement and maintain data lake in AWS and help integrate data for customer onboarding platform. Provide data analytical capabilities, independent querying, normalization, data transformation for Analytical, Financial and Compliance reporting.

➢ Provide architectural solutions to form overall IT strategy to architectural teams. ➢ Build ETL rules and generate Informatica Maps to suit complex business requirements for data warehousing. ➢ Participate with Database Architects for designing complex data models to suit databases such as Oracle, DB2, and Netezza by analyzing data requirements and profiling. ➢ Generate PL/I SQL scripts for ad-hoc data transformation requirements. ➢ Maintain and Report on Informatica metadata using the Informatica Power Center Repository tool.➢ Build data extraction from mainframe and other distributed servers using Informatica Power Exchange. ➢ Design and maintain Microstrategy reports and dashboards and provide support as necessary to improve performance or make enhancements. ➢ Configure mobile delivery platform and distribution services for usage of Microstrategy reporting using Microstrategy mobile interface.

Data Warehouse modeling➢ Developed and built a data warehouse infrastructure from the ground-up using Netezza, Informatica and Microstrategy➢ Modeled logical designs using ERWIN diagram and applying principles of schema and optimizations➢ Familiar with data normalization concepts such as 3NF, Star and Snowflake schema ➢ Designed a portion of data warehouse using Star modeling to generate the right Fact and Dimension tables from a conglomeration of existing tablesMicrostrategy➢ Developed Microstrategy Reports and Dashboards using Intelligent Cubes, Dashboards using Panels, Widgets and Selectors, Panel Stacks➢ Used Narrowcast for report delivery for both Web and Mobile platformsInformatica➢ Utilized Informatica for PowerCenter Designer for development of Transformation and Mapping➢ Performance tuning in Informatica and Netezza to better utilize Transformation and SQL optimization➢ Used PowerExchange for sourcing data from different systems such as DB2, mainframe flat files, Unix file system and Oracle databasesTeradata➢ Performance tuning in Teradata applying strategies such as defining proper Primary Index, Secondary Index, Join Indexes (Aggregate, Sparse)➢ Brought down AMP CPU consumption and Spool space requirements for Teradata queries used by analytical applications that use Stored Procedures➢ Utilized different Teradata utilities such as BTEQ, Fast Export, MLOAD and Fast Load for high volume data transfersInfrastructure upgrades and migration➢ Migrated Netezza infrastructure from Mustang to TwinFin➢ Migrated workflows already developed in Informatica to a homegrown ETL tool➢ Analytical application in Sybase was migrated to TeradataHadoop➢ Hadoop Map-reduce, HIVE, PIG, HBASE, ZOOKEEPER and SQOOPMiscellaneous➢ Developed Perl and Unix scripts for file manipulations➢ Common Utility Scripts for cross-team usage

➢ Responsible for delivery of projects and managing a team of nearly 100 resources both in US and India➢ Technically led and managed several mainframe projects➢ Gave several value proposals for new project development and strategies➢ Created business roadmap and planning for my business unit➢ Constantly touch base with American Express Leadership to understand vendor requirements and expectations

➢ Review deliverables and provide inputs for offshore team (mainframe)➢ Thoroughly understand business requirements and translate to design

Involved in migration project to convert mainframe code to handle Euro currency when the market switched to Euro