Associate Consultant
16+ years of IT experience of designing, developing and implementing data solution for large scale business in the field of Business Intelligence. DWBI Team set up, plan and manage projects aligning business goals with technology solutions to drive process improvements, competitive advantage and bottom-line gains. Excellent communicator; leverage technical, business and financial acumen to communicate effectively with client executives and their respective teams.
Having knowledge in agile and waterfall project management methodologies. Known for ability to produce high-quality deliverables that meet timeline and budgetary targets. Expertise in data warehouse ETL Design and ETL process handling.
Involved in the complete project cycle which included Requirement gathering, Create functional specs, Develop detail design, Build Create Unit Test plan and test cases, Create deployment and Change control documents. Hands on experience on Integrating Informatica with Salesforce data. Experienced in interacting with business users, business analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
Experience in developing and tuning Informatica codes, writing PL/SQL codes like stored procedures, triggers, functions, using Oracle 11g new features like virtual columns, Index organized tables, developing UNIX scripts, and Trouble shooting. Well versed with administration of Informatica 7.1 for production systems. Exposed to working in Agile Methodologies, onsite-offshore structure and effectively coordinated tasks between onsite and offshore teams.
Associate Consultant - Tata Consultancy Services
(2016-05)
Technology Specialists - AXA group solutions
(2012-02 - 2016-03)
Programmer - Informatica - Adobe India Pvt Ltd
(2010-12 - 2012-01)
Adobe registered vendor Sunovaa Tech Pvt Ltd
Senior Analyst - IBM Global services
(2008-06 - 2010-11)
ETL Support Engineer - Accenture Services Ltd
(2005-02 - 2008-06)
ETL Designer / Business Analyst - LCH Clearnet
(2016-05)
Regulatory Reporting project. LCH were required to implement a suite of new regulatory requirements and apply to their National competent Authority for re authorization as an approved CCP. LCH group entities are regulated in a number of jurisdictions by a number of different regulators. EMIR and Dodd Frank are the primary regulations under which LCH operates.
ETL Lead - Leading Asset management company
(2012-01 - 2015-02)
CFS - AUM project. Assets Under Management (AUM) of corporate financial system represents all managed and billable assets. The project involved supporting and maintaining various applications of AUM reporting group by migrating all the systems from legacy environment into ODS and thereby improve accuracy and completeness of AUM Reporting.
Senior ETL developer - Pfizer
(2008-03 - 2010-11)
Enhancement Projects. Worked on various small projects (New projects requirements) including Salesforce Automation project (SFDC or Veeva) where Pfizer transformed their US physician commercial operating model to become more customers centric while increasing Sales and marketing effectiveness, involving data migration from existing SFA application to SFDC and from SFDC to different other applications. Also worked on Massively Parallel Processing remediation project where Pfizer needed to replace near 'end of life' infrastructure with the latest with state-of-the-art Massively Parallel Processing (MPP) technology, involving migration of the US Commercial Pharmaceuticals Data Warehouse from the current technology/platform (Solaris – Oracle) to the MPP (Teradata) technology/platform.
Production support specialist/Lead - WaMu (Washington Mutual card services)
(2005-02 - 2006-03)
NILE GOLDEN GATE project. Credit Card - Maintenance Project. Project involved the maintenance of various data marts of the clients and also managing the data that comes from various vendors from where the everyday data file gets generated and sent to servers through an automated process. The project also involves extracting the data from the OLTP systems and Loading the data on to the data warehouse for managerial analysis by the management with the transformations as required by the business.
