SUMMARY:

• More than 16 years of total IT experience and Technical proficiency in the Data Warehousing and database related technologies teamed with Business Requirements Analysis, Architecture & Design, Data Modeling, Development, testing and documentation.
• Strong Data warehousing knowledge & experience in Dimensional Data Modeling, Star Schema/Snowflake modeling and in DW/BI tools including Informatica, BO, Data Quality and MDM.
• Expertise with data architecture principles and standards for the various systems and components based on design patterns. Develop implementation plan for key aspects of enterprise data architecture based on business requirements and IT strategies.
• Strong experience creating conceptual and logical data models. Experience in creation of ER Diagram, Data Flow Diagram and Business Process Diagram by understanding the as - is, to-be systems and coming up with gap analysis.
• Expertize leading the Development strategies for warehouse implementation, data acquisition and managing the Enterprise Data Models, including data dictionary/metadata registry.
• Expertise in establishing and manage Enterprise Data Standards and Document all data architecture design and analysis work.
• Evaluates new data sources for adherence to the organization's quality standards and ease of integration.
• Setting Data Policy and provide Technical guidance and solution for the management, storage, access, navigation, movement, and transformation of data
• Experienced in Leading and managing Horizontal teams in delivering high quality DW/ETL solutions.
• ETL Expert with extensive experience in ETL Architecture/design, development and maintenance using Informatica PowerCenter 9.x/8.x/7.x/6.x/5.x and Oracle PL/SQL.
• Experienced in Tuning Informatica Mappings to identify and remove processing bottlenecks
• Experienced in BI tools like BusinessObjects. Designed and developed BO Universes using Business Objects Universe Designer.
• Automation and scheduling of database processes, UNIX shell scripts and Informatica workflows /sessions using Appworx and CTRL M.

TECHNICAL SKILLS:

DW / Business Intelligence: Informatica PowerCenter 9.x/8.x/7.x/6.x/5.x, Business Objects 6.5/5i, Informatica Data Quality (IDQ), Informatica Developer/Analyst 9x

Schedulers: AppWorx 5.1.1, CTRL-M

RDBMS: Oracle 11g/10g/9i/8i/7x, DB2

Front End/GUI: D2k, Oracle Forms 6i, Reports 6i

Language: PL/SQL, C, C++, UNIX Shell

OS/Environment: UNIX, Windows 95/98/2000/XP, Windows NT

Source Control: Visual Source Safe, Clear Case

Data Modeling techniques: ERWIN 9.x/8.x/7.x/4.1, Dimensional Data Modeling

Project Management: Waterfall / Agile, VersionOne, MS Project, MS Office, Visio

Big Data / Cloud Tech: Hadoop, Hive, Azure, NoSQL-MongoDB

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT

Data Architect

Responsibilities:

• Created Conceptual and Logical model for Fraud Case Management Data mart, IBM CFM data model and Data Analytics.
• Worked as Lead Data modeler/ Data Architect on Data Analytics and Data Reporting work streams of CFM program.
• Responsible for identifying internal data sources and designing data solution to provide required WHOs and WHATs data for IBM CFM ingestion.
• Working with IBM to provide robust data model and Data reporting Layers for various current and future reporting needs.
• Led and facilitated data architecture & design discussion with technical leads, business customers and SMEs from internal / external system in order to derive data requirements and data design.

Confidential, Hartford, CT

Data Architect

Responsibilities:

• Creating Conceptual Data Model to portray the high Level business concepts in Group benefits Billing Process.
• Leading Data Modeling & Development strategies for warehouse implementation.
• Developed Logical dimensional Models to satisfy business, BI and analytical requirements.
• Applied Corporate Data Modeling Best Practices, Modeling Standards, Naming Conventions to Entities / Attributes / Relationships
• Reverse Engineer RMB Data model to understand source system Entities and Relationships.
• Created the Multi-Dimensional data model (STAR Schema) and enhanced it to meet the growing requirements
• Creating the data flow diagram depicting the movement of data into and out of the application/data mart.
• Supported and contributed in defining the ETL architecture and acted as data SME (subject matter expert) with respect to data profiling assessments and participate in JAD session/interviews.

Confidential, Hartford, CT

Data Architect/ Lead Data Modeler

Responsibilities:

• Gathering Data Requirements for the Project and Participated in JAD sessions.
• Creating Conceptual Data Model to portray the high Level business concepts and Perform Logical Data Modeling to specify the various entities and their relationships.
• Reverse Engineer Guidewire ClaimCenter Data model to understand source system Entities and Relationships.
• Designed multiple Star Schema based data Warehouse focusing on Different subject areas like Claims, Loss Events, financials, subrogation, bodily injury for Auto/Property/workers compensation LOBs .
• Applied Corporate Data Modeling Best Practices, Modeling Standards, Naming Conventions to Entities / Attributes / Relationships

Confidential, Mooresville, NC

Data Integration Architect / Data Architect

Responsibilities:

• Defining Data Integration framework and ETL architecture
• Develop and maintain a formal description of the data and data structures -- includes data definitions, data models,data flow diagrams
• Apply Corporate Data Modeling Best Practices, Modeling Standards, Naming Conventions to Entities/Attributes/Relationship
• Health check assessment, Code Optimization and Performance tuning of ETL jobs

Confidential, Boston, MA

ETL / Data Architect

Responsibilities:

• Leading a cross domain (Horizontal) team in delivering solution to customer in the Health Care sector for DW domain.
• Responsible for Delivering new and complex high quality solutions for Large Projects, enhancements and effective maintenance/production support for multiple Applications in ETL/DW domain
• Performed Source System analysis and Data analysis to build Integrated Provider management System of truth.
• Functional and Non-Functional Requirement Study to define data elements in scope
• Providing aid in Data Mapping (Source-to-Target), Gap Analysis, and Data Integration activities
• Analyze the current business model and identify gaps between current state and future state scenarios in the business process
• Update, Maintain Conceptual Model, Logical Model and Physical Models with multiple subject area
• Utilize in-depth knowledge of functional and Technical experience in DW, ETL-Informatica to deliver solutions to customer and provided Solution on building a Claims ODS
• Worked as an ETL Architect for a Data Migration project to Integrate Health Care Providers Data in BCBS-MA
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Assisting team in Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.

Confidential, New York

Team Lead/ ETL Architect

Responsibilities:

• Responsible for Design and Development of ETL Using Informatica. Guiding and assisting team for creating LLDs and robust ETL solutions.
• Creation of Project plan, Proposal and Estimations.
• Status reporting and Coordination for setting priorities
• Project Lead and coordination of the Data Warehouse and Business Intelligence solutions using onsite-offshore delivery model.
• Project planning and implementation: Following SLAs and deadlines, drive system development and implementation of project work, defining and verifying business requirements, help developing system solutions to meet the business needs.
• Requirement planning, resource planning and allocation.
• Development of ETL modules using Informatica 8.6.1, Oracle and UNIX.

Confidential, Danbury, CT

Project Lead

Responsibilities:

• Responsible for Design and Development of ETL Using Informatica. Guiding and assisting team for creating LLDs and robust ETL solutions.
• Creation of Project plan, Proposal and Estimations.
• Status reporting and Coordination for setting priorities
• Project Lead & management and coordination of the Data Warehouse and Business Intelligence solutions using onsite-offshore delivery model.
• Project planning and implementation: Following SLAs and deadlines, drive system development and implementation of project work, defining and verifying business requirements, help developing system solutions to meet the business needs.
• Requirement planning, resource planning and allocation.
• Development of ETL modules using Informatica 8.6.1, Oracle and UNIX.

Confidential, TX

ETL Lead/ Onsite Coordinator

Responsibilities:

• Worked as onsite Analyst on Requirement understanding and providing Solution.
• Responsible for Design and Development of ETL Using Informatica.
• Converting Complex business requirements into Informatica mappings
• Created and scheduled Informatica workflows and dependent UNIX Scripts through CTRL M tool. Schedule jobs sequentially and concurrently.
• Created Unit Test Plans and performed Unit and Integrating testing of Informatica Sessions, jobs.
• Coordination with Onsite team of Contractors and Offshore Team for Daily Activities and tasks

Confidential, NY

ETL Lead/ Onsite Coordinator

Responsibilities:

• Working as onsite Analyst, handling Requirement gathering, understanding and user interaction.
• ETL Lead - Responsible for Designing of ETL Using Informatica. Created LLD and HLDs.
• Created UNIX scripts to implement complex ETL jobs, like ftp scripts and scripts to validate the data and make the data reader to Informatica.
• Created and scheduled Informatica workflows and dependent UNIX Scripts through CTRL M tool. Schedule jobs sequentially and concurrently.
• Converting business requirements into Informatica mappings
• Created Test cases and testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Autosys jobs and the Target Data.
• Coordination with Offshore Team for Daily Activities and tasks

Confidential

Onsite Coordinator, Analyst /Designer, Team Lead

Responsibilities:

• Working as onsite Analyst, handling Requirement gathering, understanding and user interaction.
• Involved in getting requirements from Actuaries and Valuation users. Interaction with LTCG to understand data feeds and to resolve any data issues.
• Developed Staging Environment to contain all actuarial data coming from LTCG in form of data feeds. Built several controls and validation to ensure data accuracy.
• Involved in Database Design of Staging environment and Datamart.
• Design and Developed ETL module for Staging and Datamart load using PowerCenter 7x.
• Developed Active life reserves and Case Reserves feeds of Group data for Valuation user.
• Coordination with offshore team for development, testing and query resolution.
• As a Tech lead/ Team lead back at Offshore ensured on time delivery of Project, handled Client Communication, review of deliverables from TMs, assisting in any technical issues, Task allocation /Monitoring and status Reporting to PM /Client.

Confidential

Project Leader/ Analyst/Developer

Responsibilities:

• Worked as onsite resource, handled Requirement gathering, understanding and user interaction
• Knowledge transition from TCS and showing Patni’s capabilities in executing enhancements independently
• Worked on enhancements like adding expected lapse and mortality for PCS3 products, Adding expected mortality on lives basis and introducing Benefit codes into system to enable analysis based on benefit types.
• Development of Informatica mappings and workflows.
• Setup of offshore Team, team members and Streamlining the processes
• Development and implementation of a Module using PowerCenter.
• Development and implementation of a Module using PL/SQL.

Confidential

Designer/Developer

Responsibilities:

• Requirement analysis and Designing of ETL mappings using Informatica PowerCenter.
• Co-ordination & Communication with Onsite Coordinator
• Preparing of test cases, unit testing
• Development of complex Informatica mappings and workflows with source and target as flat files.
• Dealing with different type of files like XML, Delimited and Fixed width format file in Informatica. These files are converted as per GroupVA Database requirements and business logic. Similarly Output files from other systems and GroupVA Database are converted as per TPA’s requirements.

Confidential, Richmond

Technical Analyst/Developer

Responsibilities:

• Developed Complex Informatica PowerCenter mappings using various transformations like Joiner, Aggregator and Router transformations. Developed Informatica Mappings contains Different type of source/target like Flat files, Relational tables and XML.
• Preparing of test cases, Unit testing, Integration testing
• Requirement analysis and Designing of ETL mappings using Informatica PowerCenter.
• Handled migration of Informatica from Ver. 5.1 to Ver. 6.2.1.
• Enhancement of BO Universe and Development of BO Reports
• Developing Oracle PL/SQL Procedures. Worked on DE (DISTRIBUTION Effectiveness) module.
• Worked on Development and maintenance of AppWorx Jobs and Shell Scripts
• Responsible for Migration of AppWorx jobs from ver. 4.5 to Ver. 5.1
• Deployment and Migration of Informatica mappings and workflows from Test to Model to Production environment.

Confidential

Developer

Responsibilities:

• Detailed analysis of user requirements
• Developed D2k Forms to maintain the Master table information
• Developed Informatica mappings using expression, aggregator, filter, normalizer, joiner, lookup, router, update strategy and procedures to develop and feed Data Marts
• Deployed and tested sessions in Informatica Server
• Development of Informatica mappings to load Dimension Tables, Sales and Invoice Fact tables and Generating AR Extract.

Confidential, California

Developer

Responsibilities:

• Requirement analysis and coordination with Onsite team member.
• Developed Prototype for reports based on all possible groupings required for health managed organizations (HMO) and different Products.
• Preparation of Unit test cases and execution of Test plans.
• Responsible for Development and Modifications of reports using Reports 9i.
• Prepared technical specifications and doing Peer reviews of reports.

Confidential

Responsibilities:

• Developed Voucher and Ledger Detail Forms For FACS using Forms 6i.
• Responsible for Development and Modifications in TDS system.
• Worked on TDS Requisition, Freezing, Unfreezing, and Payment to Govt, challan generation and posting, generation Master-Detail Forms for TDS System using Forms 6i.

Confidential

Developer

Responsibilities:

• Involved in Sales, Purchase and Production Modules
• Developed Master-Detail Forms, Matrix Reports, Chart Reports for above modules using Forms & Reports 6i
• Developed procedures, Functions and Database Triggers in Oracle 8i.
• As a UI team member participated in discussions to make innovative UI design

Confidential

Developer

Responsibilities:

• Developed User-friendly forms with forms 6i.
• Developed different reports with reports 6i
• Prepared technical documentations and unit test plan for forms and reports.
• Took active part in implementing above package on client site.

Confidential

Developer

Responsibilities:

• Involved in all phases of Projects life cycle.
• Developed Particle Count Test Module Independently
• Integrated and tested both modules(Particle Count Test and Ferrography) using test data