SUMMARY:

• Experienced and dedicated professional with over 12 years of IT experience playing various roles as Data warehouse Architect, Big Data Architect, ETL Architect, Data Analyst, Business Analyst, Project Lead in various assignments covering all phases of Development, Testing, Maintenance, Implementation & Support.
• Experience in Data warehousing (DWH) projects including Data Quality, Data Governance, and Data Profiling with hands on full BI Lifecycle (SDLC) Starting from Analysis, Development to Implementation, Support and Training.
• Experienced in Data Warehousing tools using industry accepted methodologies and procedures who translates complex technical information into clear, easily understood information for business and technical participants at all levels within an organization.
• Extensive experience in Business Intelligence & Data warehousing solutions for different industry verticals such as Health care, Retail, Insurance and Telecom,
• Worked with major customers directly with UHG, BCBSND, Confidential, Confidential, Confidential, North Dakota state government healthcare Medicaid projects.
• Strong experience in interacting effectively with business stakeholders and technical teams at all levels of the organization.
• Analytical problem solver and critical thinker, innovative and creative, cooperative, results oriented, on - going learner, hands-on, self-motivated, multi-task oriented.

TECHNICAL SKILLS:

BI / DWH / ETL: Informatica Power Center 8, SAP BODS / BODI 3.0/4.0, SSIS, SSRS, Tableau 7, MDM (Master Data Management), 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),

Identity Verification Services: Melissa Data

Databases: Oracle 10g/11g, Sql Server 2008/2012, Teradata 13, MySQL

Programming Languages: PL/SQL, T-SQL (MS SQL Server 2005, 2008, 2012), MySQL, PostgreSQL

Testing Strategies: Automation and Manual Testing

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

Software development methodologies: Agile / Scrum / Waterfall Methodology

Data Modelling Tools: Erwin, ER/Studio, Visio, Embarcadero

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

PROFESSIONAL EXPERIENCE:

­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­ Confidential

Project Lead & Data Architect

Responsibilities:

• As a project lead manager, was responsible for the following;
• 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.
• Provided Career management and competency development for the team.
• Mentored the team members on technical aspects including proper selection, design and implementation of various test automation Framework, Tools and Strategies.
• A process driven project management professional with quick problem-solving skills, excellent interpersonal and communication skills.
• Ability to work in a fast-paced environment.
• Ability to work well under pressure and work independently with minimal supervision.
• Managing the design and site delivery team's performance of delegated responsibilities.
• Was responsible to ensure assigned projects are completed within schedules while meeting client needs, business objectives and design guidelines.
• Was responsible for managing project deliverables including risk allowance, monitor and control changes/variations.
• Was responsible to coordinate and foster teamwork between all project stakeholders.
• Was responsible for guiding and managing coordination with vendors and business partners through the completion of the projects.
• Utilized Tableau server to publish and share the reports with the business users.
• Also, involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Was, the escalation point of contact between the Client, and company as needed to ensure projects are delivered on time within company quality standards.

Environment: SSIS, SSRS, Oracle, SQL Server, Tableau

Confidential

Sr. DWBI Developer & Data Architect

• 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.
• Heavily involved in developing Oracle PL/SQL, MySQL queries, Stored Procedures, functions.
• Prepared solutions and documentation to load “final/cleansed” data into the primary tables in the database
• Leverage a wide variety of enterprise and open source tools to build best-in-class ETL solutions
• Performed QA and testing throughout the development process.
• Monitored production ETL processes and troubleshoot technical issues.
• 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.
• Used Debugger to test the mappings and fixed the bugs.
• Oversaw multiple projects across all phases of development.
• Monitor workflow and make timeline adjustments as needed.
• Worked as part of an interdisciplinary team to achieve project milestones.
• 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.
• Developed MapReduce programs to parse the raw data, populate staging tables and store the refined data in partitioned tables in the EDW.
• Created Hive queries that helped market analysts spot emerging trends by comparing fresh data with EDW reference tables and historical metrics
• A process driven project management professional with quick problem-solving skills, excellent interpersonal and communication skills.
• Prepared projects, dashboards, reports and questions for all JIRA related services
• Developed JIRA workflows and schemes
• Create team specific Agile process flow in JIRA to move tasks from one activity to another.
• Helped other project managers to customize JIRA for their requirements
• Collected the business requirements, translated them into sound technical requirements, and designed & executed against them.
• Collaborated and communicated with technical experts and business stakeholders as needed throughout projects.
• Developed and managed project distributed computing system

Environment: Amazon Web Services (AWS), Master Data Management (MDM), Melissa Data, MySQL, Toad for MySQL, SSIS, JIRA, Hadoop, Oracle PL/SQL

Confidential 

Sr. DWBI Developer & Data Architect

• Extensively involved in analyzing the patients data in the department of Radiation & Oncology.
• Developed necessary requirement documents
• 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.
• Provided design recommendation and options to the development team to effectively develop and design as per the specifications.
• Analyze the input data coming from various sources and designed the schema to ingest the data.
• Assisted/mentored other team members with the project and scripting issues.
• Extensively involved in Data Architecture, Data Analysis, Data Modeling, Database and code performance tuning, PL/SQL query tuning, Index tuning
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Converted existing BO reports to tableau dashboards
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• 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.
• A process driven project management professional with quick problem-solving skills, excellent interpersonal and communication skills.
• Prepared projects, dashboards, reports and questions for all JIRA related services
• Developed MapReduce programs to parse the raw data, populate staging tables and store the refined data in partitioned tables in the EDW.
• Created Hive queries that helped market analysts spot emerging trends by comparing fresh data with EDW reference tables and historical metrics
• Create team specific Agile process flow in JIRA to move tasks from one activity to another.
• Helped other project managers to customize JIRA for their requirements

Environment: SQL Server 2012, SSRS, SSIS, Oracle PL/SQL, Informatica Power Center 8.6, Tableau 7, JIRA, Hadoop, Oracle PL/SQL

Confidential

Sr. Systems Analyst

• 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.
• Used Teradata utilities Fast Load, Multi Load, TPump to load data from different source systems
• Wrote BTEQ scripts to transform data
• Wrote Fast export scripts to export data
• 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.
• Extensively involved in Manual, UAT & Automated testing.
• 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.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Was involved in ETL testing and reporting the same to the users if any bottlenecks present.
• Participated in daily SCRUM meetings to discuss the bottlenecks and the tasks status
• Was involved in documentation and unit test, UAT test of the code

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

Confidential

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, LOINC, 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.
• Develop status reports and resource plans.
• Make vital decisions and drive decision-making across projects.
• Implement and maintain development best practices.
• 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.
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Extensively involved in Manual, UAT & Automated testing

Environment: Oracle 10g, NCQA HEDIS, Tableau 7, Oracle PL/SQL

Confidential

Sr. DWBI Developer & Data Architect

• 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.
• Used Quality Stage to ensure consistency, removing data anomalies and spelling errors of the source information before being delivered for further processing.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• 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
• Involved in creating document-specific Mapping and Translation Requirements Specifications.
• Analyzing source/destination application specifications
• Developing translation mapping documentation
• Configuring, developing and testing mapping interfaces
• 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.
• Used existing ETL standards to develop these mappings.
• Extensively involved in Manual, UAT and Automated testing using SQL.
• Worked closely with the QA team

Environment: Oracle 10g, SQL Server 2012, Informatica Power Center 8.1, Tableau 7

Confidential

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
• Used Teradata utilities like Fast Load, Multi Load and Tpump to load data.
• 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.

Environment: Oracle 10g /11g, PL/SQL, AIX server, MS Projects 2000, Erwin Data Modeler, Business Intelligence solutions (SSIS, SSRS), SAP BODS, Teradata, Informatica power center 8, XML forms analysis & design, MS Visio