SUMMARY:

• Extensive experience in requirements gathering, analysis, design, development, testing and validation in Information Systems, data bases, data warehousing(DW), data integration(DI), OLAP and business intelligence(BI) space.
• Extensive experience in Full Life Cycle Implementation of Data Mart / Data Warehouse applications using Teradata, Informatica PowerCenter 9.x / 8.x / 7.x components like Designer, Workflow manager, Workflow monitor, Repository manager, Informatica Data Quality(IDQ), Informatica Master Data Management(MDM)) Informatica Cloud/AWS and Microsoft SQL Server Integration Service(SSIS).
• Experience leading and managing small and medium sized Data warehousing and Business intelligence engagements and mentoring junior or associate consultants in both onshore and offshore model.
• Strong experience in implementing manual change data capture and delete detection functionality in data warehouse.
• Strong experience in Informatica administration like installations, configurations, etc. on Informatica PowerCenter (9.x/8.x/7.x) in windows and Linux environment.
• Strong experience in Business Intelligence technologies like Cognos 8 BI (8.x, 10.x) - Framework Manager, Report Studio, Query Studio, Cognos connection, Cognos Administration and Business Objects Web Intelligence, Desktop Intelligence, Universe design, Crystal Reports, etc.
• Experience in Dimensional Data Modeling using Star, Snowflake Schema, Fact & Dimensions tables, Physical & Logical Data Modeling using Erwin.
• Strong Data cleansing, Data quality, Data archiving and Data/Code Migration knowledge and experience using manual process and Informatica Data Quality (parsing, standardization, Column profiling, Value profiling, Pattern profiling, Scorecards, Matching, Cross table profiling, Address validation, etc.), IDE .
• Extensive working experience in RDBMS like Oracle 11g/10g/9i/8i, MS-SQL Server, SQL, PL/SQL.
• Good experience in UNIX writing shell scripts, performance tuning on database and Job Scheduling.
• Skilled in Unit Test, System Integration Test and UAT (preparing test plan, test cases, validation, etc.)
• Good understanding of EPIC 2014(EMR - Electronic medical record software) modules like Ambulatory, Inpatient, Hospital billing, professional billing, ADT (admit, discharge and transfer).
• Good understanding of ETL and/or data requirements for the Comprehensive Capital Analysis and Review (CCAR) project for banking sector.
• Experience in preparing Project documents like Mapping document (source to target), Technical Specifications, Requirements documentation, Installation documents, Test/QA documentation and migrations documents.
• Ability to meet deadlines and handle pressure coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.
• Good understanding of big data/Hadoop concepts and data profiling and analysis in HIVE using HUE.

SKILL:

RDBMS: Teradata 13.x/14.x, Oracle 11g/10g/9i/8i, SQL Server 2012/2008/2005/2000, DB2

ETL Tools: Informatica PowerCenter 9.1.0/8.6.1/8.5/8.3/8.1/7.1/6.2, Power Exchange, Informatica Data Quality (Analyst Tool), SSIS, Informatica MDM, Informatica Developer, Informatica Data Explorer, Informatica Metadata manager, etc.

DB Tools: TOAD, SQL * PLUS, SQL * LOADER, Teradata, Import and Export, Oracle SQL Developer

Reporting Tools: Cognos BI 10.1/8.4/8.3, SAP Business Objects Enterprise XI, Desktop Intelligence 12.1.0.914, Web Intelligence, Universe Designer 12.1.0.914, OBIEE, SAP Crystal Reports, Tableau, etc.

Dimensional Data Modeling / Tools: Star Schema Modeling, Snow-Flake Schema Modeling, Logical and Physical Data Modeling, Erwin

ERP: SAP, Oracle EBS (Financials - AP/AR/GL, PO, MFG, Customer Service, EAM, Sales, etc.)

Languages: PL/SQL, SQL, UNIX Shell Scripting, JAVA, J2EE, C, C++, HTML, R (for identifying patterns and statistical analysis)

Operating Systems: Windows NT/95/2000/XP/2003/2007, Unix-AIX, Linux

Other Tools/Software: Microsoft Office 2010 (Excel, PowerPoint), WINSCP, PUTTY, FileZilla, FTP, SFTP, SCP, Telnet, Oracle Developer, Mercury Quality Center, Rational Rose, Microsoft Visio, Rightnow CX (hosted enterprise CRM), Lotus Notes, WinSCP, EPIC 2014(electronic medical record software) .

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Senior Analyst (Data/DW/BI)

Responsibilities:

• Working with users, subject matter experts (SME) in creating mock-ups, prototypes, wireframes, Functional Requirements(FRD), business requirements(BRD), Technical design specification documents for reports, screens and ETL interfaces, Mapping document (Source to Target), data lineage documents, etc. for placement, referrals, investigations, health/medical diagnosis, etc. related data in DHS.
• Validated BI/DW deliverables in DEV, QA and Prod to ensure minimal business impact and delivery of complete solution.
• Designed and monitored data quality using automated ETL process to ensure accuracy, completeness, timeliness, etc.
• Data Analysis/Profiling to discover and fix the underlying data anomalies, design issues, data modeling issues, patterns, etc. using SQL, PL-SQL, R, etc.
• Led BA team by designing process flow and assigning tasks/screens to BA’s for requirements gathering.
• Led BA team towards setting standards for requirements documents, standards/templates and other artifacts.

Senior Analyst (BI/DW/Data/Business)

Responsibilities:

• Collaborated with senior management to understand the data architecture strategy and long term plans.
• Collaborated with technical and business teams to understand and plan the business/application/data requirements by participating in JAD sessions, mock-ups, prototypes, technical design documents, and business (user) requirements documents, test documents, etc.
• Created design documents, ETL mapping specification, source to target documents, data lineage documents, etc. for DW/BI solutions and provided estimates for the same.
• Performed Data analysis/Profiling on State Agency’s (NC, AL, CO, etc.) data (health claims, Medicaid/Medicare recipients, subrogation, call center operations, etc.) to understand requirements of data and business, to ensure data follows the defined standards and to identify data anomalies.
• Performed analysis, planning and customization of Enterprise data warehouse (EDW).
• Designed DW/ETL and data integration solutions using ETL tools like Informatica Power Center 9.x, Teradata scripts (TPT) and SQL to support business metrics (HIPP, Call center operations, Claims, Subrogation, etc.) for the HMS Enterprise data warehouse (EDW).
• Extracted analytics data from API, Service now, JSON, XML, Web, Flat files, Databases, etc. to load into EDW (Teradata) using Informatica (ETL) and Teradata for analysis and BI reporting.
• Validated BI/DW deliverables in DEV, QA and Prod to ensure minimal business impact and delivery of complete solution.
• Designed and monitored data quality using automated ETL process to ensure accuracy, completeness, timeliness, etc.
• Communicated status, concerns, etc. timely to the stake holders to mitigate risks of timely delivery.
• Reviewed and/or created Tivoli job schedules for EDW jobs.

Environment: Teradata, Teradata SQL Assistant 14.x, Teradata parallel transporter(TPT), DB2, ETL, Informatica Power Center 9.x, Oracle, TOAD, DB2, AIX 7.1, Service Now, Share point, Informatica web services/XML/HTTP/API/JSON, Tivoli, etc.

Senior Analyst (BI/DW/Data/Business)

Responsibilities:

• Participated in Joint Application Development (JAD) sessions with project sponsors, end-users, developers, subject-matter experts, Business Analyst and stakeholders to understand and plan the business and data requirements.
• Created and/or enhanced mock-ups, prototypes, wireframes, technical design documents, business (user) requirements documents, test documents, source to target mapping documents, etc. to deliver data integration and DW/BI solutions.
• Performed Data analysis and Data Profiling on data (patient vitals, admitting, discharge, transfer, imaging, lab, pharmacy, claims, fee schedule, hospital billing, professional billing, ambulatory, inpatient, etc.) to understand requirements of data and business, to ensure data follows the defined standards and to identify data anomalies.
• Performed analysis and customization of Heath Catalyst (before Healthcare Data works) Healthcare Data warehouse system to load fee schedule and claims data from Clarity to Enterprise data warehouse (EDW).
• Performed impact analysis for EPIC 2014 to EPIC 2015 upgrade project using Informatica Metadata manager(data lineage) to ensure the ETL objects are migrated on least business impact.
• Designed DW and ETL solutions using ETL tools (Informatica Power Center 9.x) and SQL to support business metrics for the Cedar-Sinai Enterprise data warehouse (EDW).
• Utilized logical models in Erwin and extracted physical model and DDL scripts required for ETL/EDW.
• Reviewed Erwin logical data models with data architect to ensure they fit user requirements in terms of data quality & BI needs.
• Validate BI/DW deliverables in DEV, QA and Prod to ensure minimal business impact and to deliver complete solution.
• Designed and monitored data quality using automated ETL process to ensure accuracy, completeness, timeliness, etc.
• Communicated status, concerns, etc. timely to the stake holders to mitigate risks of timely delivery.
• Assigned and tracked incidents (in Service Now) to Analyst, Developers, DBA’s, etc. to deliver and deploy DW solutions.

Environment: SQL, PL-SQL, Oracle SQL Developer, Data Quality, ETL, Microsoft Excel, Informatica Power Center 9.x, Oracle, TOAD, SAP Business Objects, AIX 7.1, Tableau, EPIC 2014(Electronic Medical Record - EMR software), Clarity, Quest, Power Path (laboratory management solution), Service Now, Healthcare Data Works Knowledge edge (bought by Heath Catalyst), Erwin, etc.

Senior Analyst (BI/DW/Data/Business)

Responsibilities:

• Working with users, subject matter experts (SME) in creating mock-ups, prototypes, wireframes, Functional Requirements(FRD), business requirements(BRD), Technical design specification documents for reports, screens and ETL interfaces, Mapping document (Source to Target), data lineage documents, etc.
• Propose possible alternative technical front end, Data and ETL solutions that fulfill the business requirement in the technical infrastructure.
• Working with Developer, QA (onshore/offshore) and manage development, QA/testing and deployment as per Service Level Agreements (SLA’s).
• Data Analysis/Profiling to discover and fix the underlying data anomalies, design issues, data modeling issues, etc. using SQL and PL-SQL.
• Working with developers (onshore and offshore) to understand the current design and implement new business requirements with least impact to the business.
• Design and lead front end solutions, data solutions and ETL interfaces to solve business problems and fulfill business requirements for MISIS.
• Test and validate reports, screens or ETL interfaces before deployment and report bank any issues to Development and QA.
• Investigate data quality issues by manually analyzing data and those reported by users of the Data Warehouse/Information System and manage it to resolution.
• Managing and tracking bugs and enhancements on Microsoft TFS (Team Foundation Server).

Environment: SQL, PL-SQL, Oracle SQL Developer, Data Quality, ETL, SSIS, SSRS, TFS (Team Foundation Server), Visual Studio 2010, SQL Server Studio, Microsoft Excel, Informatica, Oracle, OBIEE, ODI, Scrum/Agile methodology, .NET, C#.

Data warehouse Solutions Analyst/Lead (BI/DW/Data/Business)

Responsibilities:

• Conducted weekly status calls with business users, SME’s, Data Analysts and DMO and with other development teams to understand and plan their requirements about routine maintenance, downtime, code migrations, enhancements, change requests, etc.
• Managed and led the offshore team & onshore team to deliver DW/ETL business solutions within the agreed SLA's to help deliver as per the scheduled regulatory reporting release for CCAR.
• Participated in Joint Application Development (JAD) sessions with project sponsors, end-users, development team members, subject-matter experts and DMO to communicate their perspectives with each other, resolve any issues.
• Prepared and managed time/cost/resource estimates needed for projects (SOW / WO) and worked in architect role as and when needed.
• Defined scope, goals and deliverables (that support business goals) by collaborating with senior management and stakeholders.
• Communicated project requirements and expectations to technical team and communicated delivery estimates to DMO in a timely and clear fashion for each schedule of regulatory reporting for CCAR.
• Designed/architected data integration and ETL solutions (using ETL tools and SQL) to create and support business metrics for CCAR and loan data.
• Performed Data analysis, Data lineage and Data Profiling using SQL queries and tools before and after designing ETL solutions to ensure the DMO and federal CCAR regulatory reporting requirements are met.
• Created mock-ups, prototypes, technical design documents, source to target mapping documents, data lineage documents, etc. from the business (user) requirements documents received form the business users or Data Analysts or DMO.
• Performed EDIT CHECK (using RULE ENGINES) validation to validate CCAR (loan and mortgage) data to ensure data quality before submitting to Federal Reserve.
• Performed data analysis/profiling of the loans and mortgage data (BDE, UBDW, Green Plum, MSP, AFS, SIL, etc.) before populating into the data warehouse.
• Utilized concepts and functionality of Informatica Data Quality (IDQ), Informatica Data Explorer (IDE) tools to profile and monitor data issues, discover and analyze all data anomalies across all data sources.
• Assigned and tracked incidents (in HPSM) to Analysts, Developers, DBA’s, etc. to deliver and deploy DW solutions.

Environment: SQL, PL-SQL, Flat files, Oracle SQL Developer, Data Quality, Informatica 8.x/9.x, IDQ, IDE, Green Plum, PG ADMIN 3, Oracle, Autosys, Unix, Linux, APEX, Scrum/Agile methodology, HP Service manager(HPSM), etc.

Data warehouse Solutions Analyst

Responsibilities:

• Collaborated with all levels of management in Requirements gathering & Data Modeling (Dimensional and Relational) for EDW.
• Designed/architected ETL solutions to create and support business metrics for Accounts Receivable Dashboard for data in SQL Server and Teradata.
• Used Data quality tools and/or queries for Data Analysis, Data Profiling (row/column level, statistics, pattern, standardization, address validation, deduplication), Data Validation, etc. to ensure data quality.
• Involved in migration of EDW ETL objects from Microsoft SSIS to Ab Initio.
• Performed source system data (Oracle EBS, Teradata) profiling and work with the business users to cleanse the data before loading in the Data mart.
• Performed ETL Testing/Validation (Designed and documented test strategy, test plan, test cases, test results, etc.) post migration of ETL jobs from SSIS to Ab Initio.
• Performed high code review of Ab Initio graphs (ETL) n Ab Initio GDE to ensure business logic is as per original SSIS code and user requirement.
• Validated ETL data in the data mart using the Business Objects reports/ dashboard developed by the development team.
• Created SAP Business Objects QAAWS queries to analyze and test the data in the data mart.
• Catered the OLAP data to the reporting and BI team for the end user reports and dashboards.
• Provided OLAP data to the AR dashboards using analytical functions and SSIS packages.

Environment: Microsoft SQL Server 2005/2008, Microsoft SQL Server management studio 2005, Microsoft SQL Server Integration Service(SSIS), Ab Initio, TOAD, SQL SERVER 2008, SAP BUSINESS OBJECTS 4.x, T-SQL, SQL, PL-SQL, Flat files, Oracle SQL Developer, Data Quality, Informatica 8.x/9.x, IDQ, IDE, etc.

Data Warehousing/Business Intelligence Analyst

Responsibilities:

• Collaborated with senior management to understand the data architecture strategy and long term plans.
• Collaborated with technical and business team to understand the data requirements.
• Performed source system data (Oracle ERP/EBS, SQL Server) profiling to cleanse the data before loading in the ODS and DM.
• Performed OLAP and OLTP Design/architect roles for high level design and configuration at the beginning of the project.
• Designed physical and logical data models (relational and dimensional) for ODS and DM layers to support changing business requirements.
• Reverse engineered the reports and identified the Data model elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Assisted business users in data testing and validation (UAT) by developing Test plans, Test Cases (negative, positive) and reports.
• Implemented the end to end Standard Noetix Analytics 4.x/5.x Data warehousing solution (ODS, DM) & other DW solutions using Informatica, UNIX, Oracle, PL/SQL, T-SQL.
• Designed/architected/Developed various ETL solutions to load data from various sources using transformations like Source Qualifier, Expression, Filter, Router, Update, Sorter, Lookup, Aggregator, Joiner, and SQL to support business requirements.
• Performed ETL Testing/Validation (Designed and documented test strategy, test plan, test cases, test results, etc.) to ensure data was complete and correct as per the data models.
• Identified data issues and improved data quality by Data Profiling (row/column level, statistics, pattern, etc.), Structural Profiling (PK Inference, FK Inference), Score carding, IDQ and IDE tools.
• Implemented Type 1, Type 2 and Type 3 slowly changing dimensions (SCD), parameter files using Informatica Powercenter.
• Utilized concepts and functionality of Informatica Data Quality (IDQ), Informatica Data Explorer (IDE) tools and manual data quality processes to profile and monitor data issues, discover and analyze all data anomalies across all data sources.
• Created and enhanced the existing reports and dashboards in Cognos 8.x query studio and report studio to fit user requirements.
• Created and enhanced data models in Cognos frame work manager to fit BI requirements.
• Installed and configured Cognos 8.x on Linux machine as part of BI delivery.
• Created mock-ups, prototypes, technical design documents, source to target mapping documents, data lineage documents, etc. from the business (user) requirements documents.

Environment: Informatica Power Center 9.1/8.6.1/7. x, Data Quality, IDE, IDQ, Cognos 8 /10, Oracle 9i, Oracle OBIEE, Oracle SQL Developer, SQL server 2005/07, PL/SQL, SAP Business Objects XI/3.x, Flat files, UNIX-AIX 5.1, Linux, Putty, WinSCP 4.3.2, Toad for Oracle 8.6.1, MS-office, MS-Visio, Lotus Notes.

Data warehouse/Informatica Developer

Responsibilities:

• Participated in analysis, engineering, development and Support of Jaros Analytics product (Packaged Enterprise Data warehousing solution).
• Actively worked with Informatica Power Center to create and manage Data Marts and Data Warehouse including scheduling jobs, troubleshooting job failures, performance tuning, creating enhancements, managing Cognos reports design and development, etc.
• Provided on call DW support to GE on rotation basis even on the weekends.
• Worked extensively on resolving support tickets, defects, bugs, data issues, job failures, etc. of the DW/BI solution.

Environment: Informatica 8.1.1, TOAD, Oracle11g, Oracle SQL Developer, UNIX, Cognos 8.3, Cognos 8.4, SQL, PL-SQL, Putty, WinSCP, etc.

Data warehouse/ETL Developer (PL-SQL/SQL)

Responsibilities:

• Participated in Joint Application Development (JAD) sessions with project sponsors, end-users, development team members, subject-matter experts and stakeholders to understand their requirements about routine maintenance, downtime, code migrations, enhancements, etc.
• Created and maintained database/ETL objects (stored procedures, triggers, etc.) for cast heat, slabs area to populate data warehouse for Steelmaking Process Control Project
• Participated in creating test plans, Unit testing and System Integration Testing of the DW objects.
• Assisted business users in data testing and validation by developing Test plans, Test Cases (negative, positive) and reports.
• Performed ETL Testing/Validation (Designed and documented test strategy, test plan, test cases, test results, etc.) using Cognos reports to ensure data quality.

Environment: Oracle 9i/10g, SQL, PL/SQL, UNIX, Cognos 8.3

Database projects Developer/ Data Analyst

Responsibilities:

• Participated in requirements gathering sessions and meetings with business users to analyze gather and document new business requirements for new projects or change requests/enhancements to the existing projects.
• Managed and maintained three major in-house database projects namely, Utility Database, Interim, community service tracking system using Microsoft Access, SQL, etc.
• Developed reports as per business requirement to support business decision making of functional managers.
• Developed test strategy, test plan, test cases, test results, etc. to validate user data and reports to ensure accuracy.

Environment: Microsoft Access, SQL, Microsoft Excel, Some custom applications, Windows 2000

Database Developer-Trainee

Responsibilities:

• Participated in user sessions and meetings to analyze gather new business requirements.
• Participated in design and development of a HRM software solution (using Java/J2EE, Oracle, ASP) for an organization
• Managed timely delivery/completion of each phase, activity or deliverable and the project as a whole.
• Participated in presenting/training the final product to the users.
• Lead the project team of 3 people and coordinated project and team from start to finish.

Environment: Oracle 9i/10g, SQL, PL/SQL, UNIX, Java