Experience

Anthem

• United States
• Insurance
• 700 & Above Employee

• Business Info Developer Consultant Senior

  • Sep 2014 - Present

  • Performing the requirement gathering, detailed impact analysis, Design and Programming functions that are required to support the extract, transform and load of various source system types such as relational, flat files, mainframes, XML, web services, EDI formats data (including health care membership data) using Informatica on Oracle and Teradata databases in a UNIX environment platform• DevOps Automation for all EDA (Enterprise Data Analytics) applications using DevOps tools by integrating Source Code Management, Code Deployment, Control-M Jobs Migration, Control-M Jobs Execution for data loads, Test Automation Integration, Failed test case integration in JIRA as part of end to end pipeline• Code BTEQ scripts and UNIX shell scripts• Perform command level programming in UNIX• Design, develop and test database applications, including metadata management • Hadoop Big data platform, including pig,sqoop and hive scripting and Informatica Big Data Edition (BDE) for performing the extract, transform and load process within the Hadoop File System (HDFS) across various data warehousing applications• Laying down and formalizing the Best practices and standards to be followed across the various Data warehousing projects• Detailed Code review of various Membership and Clinical subject area applications• Doing detailed impact analysis for various new business requirements to be implemented across multiple clinical and membership applications• Providing detailed LOE (Level of Effort) for various applications depending upon the requirements provided in the BSD (Business Solution Design)• Prepare detailed technical requirements including robust design across the ETL framework as part of the design phase of the project



Kaiser Permanente

• ETL Lead / Business Analyst

  • Feb 2013 - Sep 2014

  • Involved in ETL design strategy to populate the multiple staging tables-Landing tables and Staging tables leading up to the Dimension table.• Worked with multiple source systems such as Flat files, Teradata database.• Developed mappings by implementing the High Level Design Document, was involved in discussions in preparing the low level design document and used several transformations such as Filter, Expression, Aggregator, Connected and Unconnected Look-up, Router, Normalizer, Joiner, Stored Procedure, XML , Sequence generator and Ranker Transformations.• Configuration and Management of users,groups,Custom roles and granting the necessary privileges using Informatica Administration console for the entire Informatica users within Shared Business Intelligence Services (SBIS)• Configuration and Management of various services (Repository service, Integration service, Model repository service, Reporting and Dashboards service etc) using Informatica Administration Console• Manage the user account lockouts with Informatica Administration Console• Applied SCD Type 1/2/3 Dimension concepts to populate the Data Warehouse Dimension tables.• Unit Testing was done extensively with comprehensive test cases and scenarios to validate the data in the Data Warehouse tables. • Data profiling was done during the initial phase to determine relevant sources and to determine design strategy.• Used Parameter files extensively for defining database connections along with external driven parameters.• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance and used various mechanisms such as indexing, partitioning, SQL tuning from both Informatica as well as database standpoint.• Extensively used various External loaders with Teradata in Informatica• • Tuned Informatica mappings and sessions for better performance using various strategies based upon the analysis performed.



Travelers

• ETL Lead / Business Analyst

  • Feb 2012 - Feb 2013

  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse• Created mapping documents to outline data flow from sources to targets• Involved in Dimensional modeling (Star and Snowflake Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts• Designed and customized data models for Data warehouse supporting data from multiple sources on real time• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse• Configuration and Management of various services (Repository service, Integration service, Model repository service, Reporting and Dashboards service etc) using Informatica Administration Console• Involved in the maintenance and Management of Informatica platform pertaining to enabling and disabling the various Information services as required• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables• Used Debugger to test the mappings and fixed the bugs• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure and Union to develop robust mappings in the Informatica Designer• Developed mapping parameters and variables to support SQL override• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder



United Health Group

• ETL Architect / Data Integration developer

  • Aug 2009 - Jan 2012

  • Understand business needs and overall business strategy of the business customer• Participated in analyzing and interpreting user requirements into technical architecture and design specifications• Contributed to the requirements analysis and solution design for the Clinical Reporting Platform• Extensively used Informatica Workflow manager & Workflow Monitor tools to Load data from Teradata table sources into the Flat file• Performance tuning of various Informatica workflows by identifying the bottlenecks in sources, targets, mappings and sessions• Real time processing using Web services Provider, Consumer and XML Transformations with Informatica• Developed an overall understanding of the end-to-end process from source systems to end-user analytic and reporting tools• Installation of Informatica server and Client suite for the development team• Setup and configuration of all Informatica administration activities using the Admin console as part of the Shared Analytics Environment (SAE) team• Developed reusable transformations, Mapplets and Worklets to reduce development• Applied Push down optimization at database level for the mappings which involved loading data to target using target lookup to avoid load to Informatica server• Responsible for working with the business users, solution architects and development leads to define and implement overall application level architecture• Development of various complex informatica mappings with different transformations like Aggregator, Joiner, Look-up, update strategy, Filter, Source Qualifier, Expression• Involved in end to end data integration of Ovations (Care) data into ECODS• Involved in loading data from UNIX file system to HDFS• Involved in creating Hive tables, loading with data and writing hive queries which will run internally in mapway• Used Power exchange for Hadoop to extract data from HDFS or load data to HDFS or Hive



First Data Corporation

• ETL Architect / Data Integration developer

  • Sep 2008 - Jul 2009

  • Created sessions for mappings and utilized workflow manager & monitor to create, schedule and monitor workflows• Analyzed Informatica Session logs for failed processes and accordingly create and assign defects• Tuned the existing mappings and sessions to improve the performance• Involved in preparing test plans and testing all the ETL process• Used SQL tools like TOAD to run SQL queries and validate the data loaded in to the target tables• Developed Data Integration Workflows and load processes• Ensured adherence to locally defined standards for all developed components• Performed data analysis for both Source and Target tables/columns• Provides technical documentation of Source and Target mappings• Supports the development and design of the internal data integration framework• Understands data integration processes and how to tune for performance• Implement/coded the business requirements adhering to the tech design• Developed Code based on Detailed Designs. (Includes Source to Stage, Stage to Integration, Integration to Dimension and Dimension to Fact) for the health care domain frame work .e.g. Type1, Type2 Dimensions, Factless Facts, Snapshot, Additive Facts• Developed unit test cases for the business components that are created• Implemented change requests and fixing of defects• Scheduled of Health care domain framework related Informatica workflows using Client Approved Third Party Scheduling Tool Autosys• Prepared WSR (weekly status report), project plans and Gantt charts and identify work breakdown structure allocation of the tasks among team members and track the progress of project assigned to them• Reviews (Code, UT Plan, SIT Plan)• Subject Matter Expert (SME) for my application and assisting the team members for any application specific related queries• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables• Used Debugger to test the mappings and fixed the bugs



Halifax

• Banking
• 700 & Above Employee

• Etl Architect

  • Apr 2008 - Aug 2008

  • In depth understanding of client’s ETL framework and project execution methodology • Anchoring various initiatives involving development of reusable components and technical artifacts• Suggesting alternative solutions to a problem. (problem solving approach)• Translating the solutions provided by systems designers into detailed program specifications• Interfacing effectively with project managers and other project stakeholders to ensure that appropriate decisions around ETL design and build are taken • Doing Impact analysis of the existing system and on the basis of this preparing High level design document.• Interfacing with ETL designers and understand the Build requirements before percolating the relevant tasks to team members• Mentoring Senior. Developers and Developers working in the application team.• Creation of low level design artifacts and mapping documents from high level business requirements • Managing data structures, performance tuning, query optimization and tuning, etc to improve database performance• Participating in code reviews and ensure that all solutions are aligned to defined architectural and functional specifications



Citi

• United States
• Financial Services
• 700 & Above Employee

• Consultant / ETL Developer

  • Jan 2005 - Mar 2008

  • Provide thought leadership and influence senior stakeholders on choice and implementation of AB INITIO platform in GIS• Develop and formulate the objectives and career road map of Senior Developers• Responsible for end to end delivery for my project (GIW-Global Information Warehouse)• Framing and implementation of Technology Standards & Guidelines across applications within the project• Effort estimation of AB INITIO based ETL projects within the organization• Formulating design patterns as per project requirements and develop reusable components based on ETL AB INITIO framework • Anchoring, conducting various training sessions and mentoring AB INITIO resources• Resolving technical issues which the team encounters on day to day basis• Played a vital role as an onshore coordinator for my project for 18 months during my deputation period to New Jersey (USA)• Doing Impact analysis of the existing system and on the basis of this preparing High level design document• Managing ongoing support of the systems for any break occurrences, including identifying the cause of the problem, identifying, developing, testing, and installing the fix to the system* Involved in creation of Data marts depending on various subject areas like cash, security transactions etc• Involved in supplying data by building AB INITIO graphs from Enterprise Data warehouse to downstream applications like CDS (Citidirect for Securities), Cable and Wireless etc for their customer reporting• • Performing physical database design at the object level, create DDL scripts, define database snapshots, table partitions, and backup/recovery strategy for Oracle 9i/10g databases • Oracle database tuning and administration including security management, instance performance monitoring, table space utilization, schema object management, database capacity planning, “bottlenecks” and “offensive” SQL activity monitoring and resolution



Citi India

• India
• Financial Services
• 700 & Above Employee

• Project Engineer

  • Oct 2003 - Dec 2004

  • Develop the architectural design for a highly scalable, large volume enterprise solution• Perform high-level architectural planning, proof-of-concept and software design• Deep understanding of all technical components of the application solution• Define and implement standards, shared components and approaches• Function as the Design Authority in technical design reviews• Contribute to development project estimates, scheduling and development reviews• Approve code reviews and technical deliverables• Assure architectural integrity• Maintain compliance with change control, SDLC and development standards• Develop and review implementation plans and contingency plans