SUMMARY:

• Highly effective Leader/Data Architect with over 12 years of experience, specialized in working with relational and Non - relational database platforms, creating Data warehouse and data marts.
• Offering an array of skills in data platforms, consulting, IT expertise, data governance, defining data requirements and analysis. A thought leader with excellent ability to successfully implement end-to-end architecture and design for data warehouse and business intelligence.
• Data Architecture & Design
• End-to-End Vision
• People Management
• Team Leadership
• Data Modernization
• Hiring & Staff Development

TECHNICAL SKILLS:

ETL & Modeling Tools: Informatica Power Center 8, Informatica Data Quality (IDQ), SAP BODS / BODI 3.0/4.0, SSIS, SSRS, Tableau 7, Erwin, ER/Studio, Visio, Power Designer MDM (Master Data Management), Unix Script, DQ (Data Quality), AWS (Amazon Web Services)

US Health Care: HEDIS (NCQA) certification, CMS (Medicare, Medicaid), ACO (Affordable Care Organization), MMIS, Electronic Medical Records (EMR), Health Information Management (HMR)

Databases: Oracle 10g/11g, Sql Server 2008/2012, Teradata 13, MySQL, MongoDB(NoSQL) PL/SQL, T SQL (MS SQL Server 2005, 2008, 2012), MySQL, PostgreSQL, Java, Java Swing

Testing Strategies: Automation and Manual Testing

Project Management Tools: MS Project, Atlassian JIRA Project Tracking, TFS

Software development methodologies: Agile / Scrum / Waterfall Methodology

Hadoop eco system: HDFS, Map Reduce, Pig, Hive, Scoop, Flume

PROFESSIONAL EXPERIENCE:

ETL/Informatica Lead Architect

Confidential, Richardson, TX

• Lead a team of developers, test and support engineer's and owned the project deliverables to the LoB.
• Defined system specifications for the extract, transform, and load (ETL) and Informatica of the source-to-target data, executing data transfer using MS SSIS tool.
• Coordinated project activities involving system users, and IT development staff to identify user requirements and meet user specifications.
• Provided the business model and data models for business units with Teradata to determine “To-Be” architecture.
• Facilitated and documented evaluation of business/IT systems for an internal IT systems Audit project.
• Helped in creating a comprehensive Project Plan (MS Project) outlining all tasks and deliverables supporting the development of a data model.
• Provided recommendations on data gathering and analysis based on best practices and emerging technologies.

Confidential, Minneapolis, MN

Data Architect - Data Analyst - Data Modeller

• Extensively involved in analysis, assisting in design of Confidential Enterprise Data Warehouse (EDW).
• Involved with Data quality by establishing the validity and accuracy of the data.
• Involved with Data governance in understanding the data relationships for compliance and regulatory reporting.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements
• Involved in migration projects to migrate data from Teradata to SQL Server 2012.
• Followed Agile, and Waterfall SDLC methodologies for project execution, and used Storyboards as one of the requirements elicitation technique.
• Used SQL and Teradata to perform data analysis.
• Involved in creating Logical, Physical data models using Erwin data modeler and simultaneously involved in doing Reverse and Forward engineering.
• Organized data model presentation to be meaningful for analysis, analyze data model content and add metadata definitions as needed,
• Summarized the data model from a business rule and model feature perspective
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Participated in daily SCRUM meetings to discuss the bottlenecks and the tasks status
• Defined roles and responsibilities related to data governance and ensure clear accountability for stewardship of the company's information assets
• Facilitate the development and implementation of data quality standards, data protection standards,

Confidential, Minneapolis, MN

MSBI Architect & Project Lead

• Lead a team of developers, test and support engineer's and owned the project deliverables to the LoB.
• Provided technical directions to the team by setting up the priorities and providing the vision.
• Mentored the team members on technical aspects including proper selection, design and implementation of various test automation Framework, Tools and Strategies.
• Managing the design and site delivery team's performance of delegated responsibilities.
• Did Performance Tuning on a daily basis for preventing issues and providing capacity planning.
• Developed stored procedures, triggers using PL/SQL, Dynamic SQL, and Exception handling for lowering traffic between servers & clients.
• Designing, developing and implementing complex, large scale database applications or data warehouses
• Loading data by using the Teradata loader connection, writing Teradata utilities scripts (Fast Load, Multiload, BTEQ) & Macros and working with loader log.
• Defined standards and procedures for data modeling, database design, reference data management, and ETL and Teradata requirements and design.
• Helped the team to analyze the data by performing Hive queries and running Pig scripts to know customer purchase behavior.
• Set technical direction and drove implementation of a Business Intelligence
• Defined roles and responsibilities related to data governance and ensure clear accountability for stewardship of the company's information assets
• Facilitate the development and implementation of data quality standards, data protection standards, retention standards (specific to audit requirements) across the enterprise
• Serve as a liaison between Business and Functional areas and technology to ensure that sensitive data are clearly defined, communicated and well understood and considered as part of operational prioritization and planning.

Environment: Oracle, PL/SQL, Erwin Data Modeler, Teradata, Unix, SQL Server 2012 (SSIS, SSRS), Data Governance

Confidential

Data Architect & Sr. ETL Developer

• Worked independently and as part of a team to accomplish critical business objectives and to make decisions under pressure.
• Involved in design and development of efficient ETL code and processes that are optimized for the task at hand.
• Performed periodic reviews of the ETL deliveries via code reviews, testing and code walkthroughs.
• Was involved in the Data Architecture and in developing the overall ETL architecture, including solution architecture as needed
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Modified existing mappings for enhancements of new business requirements.
• Collaborated with development and management team to plan project sprints and ensure that they understand and fully comply with data quality standards, architectural guidelines and designs.
• Contribution in designing database, creating database schema, creation using RDBM, data migration using Teradata.
• Created functions, procedures, triggers, indexes using Oracle database programming language
• A process driven project management professional with quick problem-solving skills, excellent interpersonal and communication skills.
• Collected the business requirements, translated them into sound technical requirements, and designed & executed against them.
• Developed logical and physical database designs the Enterprise Data Warehouse and dimensional models for its dependent data marts using Erwin.
• Using Erwin tool to develop logical and physical database designs for a strategic enterprise Oracle OLTP database supporting Java-based web services applications.
• Reviewed and validate technical metadata and data lineage for data elements.
• Defined and validate business metadata for each data element.
• Implemented changes to business definition and metadata.
• Was responsible for managing all aspects of the data governance team, including resource, project and vendor management.
• Interacted with senior management, other technology personnel, clients and vendors.

Environment: Amazon Web Services (AWS), Master Data Management (MDM), Teradata, Melissa Data, Unix, Oracle 10g, Toad for Oracle, JIRA, Java, Erwin Data Modeler

Confidential, Rochester, MN

Data Architect, & Big Data Hadoop Developer

• Extensively involved in analyzing the patients data in the department of Radiation & Oncology.
• Involved in converting SAP BO XI Crystal reports to MS SSRS reports
• Analyzed software requirements to determine the design within the time constraints.
• Was effectively & actively involved in presenting the status updates to project management and the doctors.
• Analyze the input data coming from various sources and designed the schema to ingest the data.
• Extensively involved in Data Architecture, Data Analysis, Data Modeling, Database and code performance tuning, PL/SQL query tuning, Index tuning, creating stored procedures, triggers
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Was responsible for creating data models for both logical and physical and data analysis.
• Complete logical data model design and definition in Erwin, assurance conformance of models to enterprise standards for data definition and data model practices
• Facilitated logical JAD sessions to discuss/gather business requirements for both internal and customer facing applications for all assigned projects. This process included; scheduling meetings with the business and application groups, documenting agendas and minutes.
• Work with TERADATA DBA to manage long running and CPU intensive queries to run the Teradata environment smoothly.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Monitored and performed tuning on Oracle database server.
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Reviewed and validate technical metadata and data lineage for data elements.
• Defined and validate business metadata for each data element.
• Implemented changes to business definition and metadata.
• Was responsible for managing all aspects of the data governance team, including resource, project and vendor management.
• Interacted with senior management, other technology personnel, clients and vendors.

Environment: Oracle 10g, PL/SQL, Informatica Power Center 8.6, Erwin data Modeler, SQL Server SSRS reporting, Data Governance, Business glossaries retention standards (specific to audit requirements) across the enterprise

Confidential, Minneapolis, MN

Data Architect - Data Analyst - Data Modeller

• Extensively involved in analysis, assisting in design of Confidential Enterprise Data Warehouse (EDW).
• Involved with Data quality by establishing the validity and accuracy of the data.
• Involved with Data governance in understanding the data relationships for compliance and regulatory reporting.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements
• Involved in migration projects to migrate data from Teradata to SQL Server 2012.
• Followed Agile, and Waterfall SDLC methodologies for project execution, and used Storyboards as one of the requirements elicitation technique.
• Used SQL and Teradata to perform data analysis.
• Involved in creating Logical, Physical data models using Erwin data modeler and simultaneously involved in doing Reverse and Forward engineering.
• Organized data model presentation to be meaningful for analysis, analyze data model content and add metadata definitions as needed,
• Summarized the data model from a business rule and model feature perspective
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Participated in daily SCRUM meetings to discuss the bottlenecks and the tasks status
• Defined roles and responsibilities related to data governance and ensure clear accountability for stewardship of the company's information assets
• Facilitate the development and implementation of data quality standards, data protection standards,
• Serve as a liaison between Business and Functional areas and technology to ensure that sensitive data are clearly defined, communicated and well understood and considered as part of operational prioritization and planning.

Environment: SQL Server 2012 PDW, Teradata 13.1, Fusion, SSRS, SSIS, Putty, MLOAD, TPUMP, Informatica Power Center 8.6/8.5, Oracle 10g, PL/SQL, Erwin data modeler

Confidential, Fargo, ND

Sr. Database Developer & Data Architect

• Was extensively involved in NCQA HEDIS Software Certification product Sightlines Performance Measurement support
• Developed and coded requirements within software application for NCQA certification for HEDIS/Stars, P4P, ACO (Affordable Care Organization), and PCMH initiatives.
• Access, evaluate, and improve quality of health care by using NCQA’s HEDIS measures.
• Created data marts on SQL Server 2005/2008 and Oracle platforms for internal quality initiatives, HEDIS, CAHPS, and/or CMS/Medicare Star Ratings annual submissions.
• Lead analysis and data mapping for health plan's medical, lab, EDI data, and Rx data (claim, REV, CPT, ICD9, LO INC, NDC diagnosis codes, etc.) and communicating with health plan clients.
• Oversee multiple projects across all phases of development.
• Monitor workflow and make timeline adjustments as needed.
• Collaborated with development and management team to plan project sprints.
• Heavily involved in developing Oracle PL/SQL queries, Stored Procedures, Triggers
• Implemented PL/SQL solution to update/replace process on integration layer
• Wrote PL/SQL code and documented the same to support updated logic and related functionality
• Developed mapping parameters and variables to support SQL override.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Requirement Analysis, Data Elements Analysis, Data Analysis, Data Mapping, Logical and Physical Data Modeling, Technical design documents, Solution Architecture are the key tasks.
• Converted existing BO reports to tableau dashboards
• Owned and managed all changes to the data models. Created data models, solution designs and data architecture documentation for complex information systems.
• Effectively articulated reasoning for data model design decisions and strategically incorporated team member feedback to produce the highest quality data models.
• Worked with project and application teams to ensure that they understand and fully comply with data quality standards, architectural guidelines and designs.
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Defined roles and responsibilities related to data governance and ensure clear accountability for stewardship of the company's information assets
• Facilitate the development and implementation of data quality standards, data protection standards, retention standards (specific to audit requirements) across the enterprise
• Serve as a liaison between Business and Functional areas and technology to ensure that sensitive data are clearly defined, communicated and well understood and considered as part of operational prioritization and planning.
• Reviewed and validate technical metadata and data lineage for data elements.
• Defined and validate business metadata for each data element.
• Implemented changes to business definition and metadata.
• Was responsible for managing all aspects of the data governance team, including resource, project and vendor management.
• Interacted with senior management, other technology personnel, clients and vendors.

Environment: Oracle 10g, NCQA HEDIS, Erwin Data Modeler, PL/SQL, SQL Server 2012, SSRS

Confidential, Minneapolis, MN

Data Architect, Data Modeller, ETL Developer

• Verified functionality, system interfaces, and business processes function according to documented requirements.
• Was part of EDI team in planning delivery of solutions, answering technical and procedural questions with the team members.
• Was involved in data warehouse performance planning and execution and delivering data
• Identified and fixed all defects with high severity and high priority prior to implementation.
• All extract files were Ftp’d to McKesson using a sftp process
• Involved in creating document-specific Mapping and Translation Requirements Specifications.
• Developing translation mapping documentation
• Send two years historical data starting at October 1, 2009, and then continued sending the three extracts on a monthly basis, which include current, renewing, new and terminated members.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Owned and managed all changes to the data models. Created data models, solution designs and data architecture documentation for complex information systems.
• Effectively articulated reasoning for data model design decisions and strategically incorporated team member feedback to produce the highest quality data models.
• Worked with project and application teams to ensure that they understand and fully comply with data quality standards, architectural guidelines and designs.
• Involved in doing data analysis, SQL Development, reviewing complex operational databases and fixed the problem by doing SQL, PL/SQL development.
• Worked with IT and business users to understand production issue
• Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Power Center
• Developed mapping parameters and variables to support SQL override.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Dealt with Fine-tuning Stored Procedures to improve performance with a Query plan using SQL Tuning advisor.
• Reviewed and validate technical metadata and data lineage for data elements.
• Defined and validate business metadata for each data element.
• Implemented changes to business definition and metadata.
• Was responsible for managing all aspects of the data governance team, including resource, project and vendor management.
• Interacted with senior management, other technology personnel, clients and vendors.

Environment: Oracle 10g, SQL Server 2012, Informatica Power Center 8.1, Erwin Data Modeler

Confidential, Minneapolis, MN

Systems Analyst & Data Architect

• Supported production, development and testing databases with database ranging from 100GB to 3TB.
• Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
• Excelling in using the tools such as TKPROF, EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL queries.
• Creating Scripts, Jobs, Workflows, Data Flows and Executing jobs with Data Integrator Designer.
• Work with Functional SAP/ERP teams closely to understand the gaps, coordinate with business on specific business rules, work with data migration programmers on transformation rules and meet project standards using proven data load tools and methodology.
• Prepare technical specification document by getting involved in JAD session.
• Designed and developed ETL processes using Informatica Power Center to load data from Oracle, SQL Server 2008, Flat Files, and XML files to staging database and from staging to the target Data Warehouse database.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Experienced with precise (DB performance tuning tool).
• Experience in Data guard Implementation.
• Was involved in developing a Disaster Recovery (DR) plan & implemented a DR exercise.
• Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions
• Provided project estimates, level of efforts (LOE) and extensively working with SME, PM, BA in creating project based plans
• Researched, defined and analyzed changes to both state and federal laws affecting the Medicaid Management Information System (MMIS)
• Wrote BTEQ scripts to transform data and Fast Export scripts to export data.
• Extensively involved in Manual, UAT & Automated testing.
• Was involved in creating and implementing Conceptual, Logical and Physical data models.
• Reviewed and validate technical metadata and data lineage for data elements.
• Defined and validate business metadata for each data element.
• Implemented changes to business definition and metadata.
• Was responsible for managing all aspects of the data governance team, including resource, project and vendor management.
• Interacted with senior management, other technology personnel, clients and vendors.