SUMMARY:

• BI Architect having 11 years of expericence in Information Technology with a strong background in Data Integration and Data Warehousing in healthcare and Manufacturing domains.
• Experience in database design, entity - relationship modelling, dimensional modelling using star schema, snowflake schema and hybrid methodology.
• Experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool Informatica Power Center.
• Experience in designing metadata framework for tracking data linage between legacy systems.
• Solutioned Enterprise data hub architecture and design
• Involved in all phases of the SDLC, Scrum and Agile methodology including Strategic Study, Requirements Analysis, Gap Analysis, Application Design, Architecture, Technical Design, Development, Testing, Debugging, Implementation, Documentation, Maintenance, Client interaction and team leadership.
• Participated in POC projects for assessing data visualization tools like Tableau.
• Performed multiple roles of Business Analyst, Technical Architect, ETL Lead, ETL designer, DW developer, Power Center Admistrator for BI projects
• Developed design prototypes for ELT (Extract, Transform and Load) process for MPP appliances.
• Designed and developed strategies for ETL framework to support Audit, Balance and control functions.
• Designed data acquistion strategies for data integration projects.
• Participated in Design sessions for implementing Operational Data Hub roadmap using hib and spoke architecture.
• Strong in data analysis using SQL
• Experience with Data Warehouse implementation projects from feasibility study, ROI analysis, business requirements, fact, measure and dimension identification to development planning and successful production implementation of projects.
• Expertize in framing test strategies for Integration testing, performance testing, functional testing, regression testing and user acceptance testing.
• Knowledge of No SQL Mongo DB, Big data and Hadoop.
• Participated in designing data quality framework using DQI and IDQ for data profiling and quality checks.
• Strong functional knowledge of Claims processing and claims analytical reporting in payer healthcare industry.
• Experience with Data Visualization, Dashboards and Scorecards using BI Analytics tool.

TECHNICAL SKILLS:

OS/Environment: Windows 9x/ NT/2000/ XP, UNIX, Linux

Database Technology: Oracle 10g/9/8i, Ms: Access, SQL Server 2000, Netezza

Products/ Tools: Toad, I3, Visio, MS: Project, SVN, Tidal, Erwin, Jira, Aginity, MS Excel, SQL Loader, Erwin, Appworx, SQL Plus, PL SQL Developer

Business Intelligence /Analytics: Informatica PowerCenter 7.3/8.1/8.6/9.1/9.6/ Grid, Power Exchange 8.6, Cognos Reportnet, Cognos Impromptu Business Objects, Oracle Data Quality Inspector (DQI), Integration Services, SSIS, SSRSTableau

Languages: SQL, PL/SQL, C, Visual Basic, HTML, XML, Java Script, Shell scripts

WORK EXPERIENCE:

Confidential, San Francisco, CA

Solution Architect

Environment: Netezza, Informatica Power Center, Oracle, Unix, Tidal, IDQ

Responsibilities:

• Analysis for identifying impacted Vendor Extracts due to Member Migration.
• Requirement Analysis for identifying the usage of these reports for BI Analytics.
• Involved in STTM activity for mapping extract data elements to Facets data source as part of Data Governance initiative.
• Suggested solution approaches with Pros and Cons and ROI on design approach.
• Designed merge and dedupe architecture and split parameterized logic for a scalable extract generation solution.
• Estimated project work in terms of resources, efforts and timelines.
• Planned releases based on the group migration schedule and Enterprise release plan.
• Coordinated with SCRM, QA and UAT teams on code promotion, environment management and testing strategy.
• Involved in ODS data modelling to support data elements required from Facets for gererating the extracts.
• Solutioned the ETL and ELT data flow framework and Tidal schedule design.

Confidential, San Francisco, CA

Solution Architect, Project Delivery Lead

Environment: Netezza, Informatica Power Center, Oracle, Unix, Tidal, IDQ, Sterling

Responsibilities:

• Scope, Estimate and define timelines for all deliverables.
• Participate in the data discovery sessions and work with data modellers in designing the IDS data model.
• Identify relationships between data elements and carry out gap analysis based on data elements identified for ACO enablement.
• Solution framework for ELT process using MPP Netezza appliance.
• Design environment and database and code deployment promotion path.
• Plan releases using Agile methodology for incremental project implementation.
• Design Information framework to enable audit, balanace and control functionality.
• Design Tidal batch jobs based on the schedule and dependency to enable file dependent real time data acquisition process.
• Design backup and data load strategies for integration and system functionality testing.
• Plan development and resource assignment and ensure quality deliverables.

Confidential, San Francisco, CA

Solution Architect

Environment: Netezza, Informatica Power Center, Oracle, Unix, Tidal, IDQ, ERWIN

Responsibilities:

• Analyze business requirements document for scope and functionality of project.
• Coodinate with SME’s for mapping Facets ICD-10 codes to ODS and Mart targets.
• Work with business stakeholders for identifying business and transforamtion rules for loading ICD-10 and backward map ICD-9 data in marts.
• Model ODS layed to include ICD-10 codes and backward map ICD-9 codes.
• Participate and contribute to Data Governence meetings.
• Design ICRM interface flow for backward converting ICD-10 to ICD-9 codes.
• Solution and Design ETL data flow and architecture.
• Estimate efforts for procurement management for T&M and Fixed Fee SOW for development through implementation phase.
• Plan project staffing and deliver a staff plan.
• Lead and mentor onsite development leads and offshore teams.

Confidential, San Francisco, CA

ETL Architect

Environment: Informatica Power Center, Oracle, Unix, Tidal

Responsibilities:

• Analyze business requriement document.
• Coordinate with Trizeto and Rosetta SME for identifying business rules in order to map Enterprise marts to Facets source system.
• Define business transformation logic based on data analysis and Facets data models.
• Present business mapping rule in front of Data Stewards for discussion and approval.
• Attend Data Governanace meetings.
• Coordination with Business Functional Units and stakeholders for scope defination.
• Solution and Design ETL data flow and architecture.
• Model RDI ODS layer for adding new data elements required for mart analtical reporting.
• Work with Solution Architecture team for identifying downstream application and system impact.
• Estimate efforts for procurement management for T&M and Fixed Fee SOW for development through implementation phase.
• Plan project staffing and deliver a staff plan.
• Lead and mentor onsite development leads and offshore teams.

Confidential, San Francisco, CA

Technical Lead

Environment: Informatica Power Center, Oracle, Unix, Tidal

Responsibilities:

• Analyse and understand techncial and functional changes on Facets system.
• Analyse and identify downstream impact within Enterprise Information System.
• Solution the approach for upgrading all environments to use Facets 4.81 environment without impacting any inflight projects.
• Document and present impact analysis results to stakeholders.
• Estimate efforts for procurement planning.
• Create work break down structure and assoicate them to phases further assigning them to development leads.
• Work with SCRM team to plan project environment and deployment plan.
• Coordinate with QA,UAT teams and project stakeholders for issue identification, resolutions, clarifications and status reporting.
• Coordinate with offshore teams for development and data integration planning and execution.

Confidential, San Francisco, CA

Technical Lead, Business Analyst

Environment: Informatica Power Center, Oracle, SQL Server, Unix, Tidal

Responsibilities:

• Solution and Design ETL data flow and architecture
• Release planning for parallel project development and implementation.
• Facets change pack impact analysis to Enterprise marts.
• Working with SCRM team for planning code merge and deployment for multiple inflight project.
• Planning of project enhancement releases from development to QA, UAT and production implementation.
• Providing ROM and binding estimates for SOW and WO procurement process.
• Staff planning and resource utilization management.
• Mentor team leads and offshore delivery team members.
• Coordinate and plan QA and UAT cycles.
• Introduce process improvements for streamlining delivery and timely deliverables.
• Generate statistics and dashboards for project performance matrix reporting.
• Maintain quality deliverables from onsite and offshore teams across all spectrum of projects within EIS BI.

Confidential, San Francisco, CA

Technical Lead

Environment: Informatica Power Center, Oracle, SQL Server, Unix, Tidal

Responsibilities:

• Designed ETL process for incremental claim extraction.
• Coordinated with Data Modeller to design Claims Subject area.
• ETL Development lead and Single point of contact for Claims Rosetta marts.
• Work prioratization and distribution within the offshore team.
• Interact with Business and SME for requrirement clarification.
• Coordinate with QA and UAT team for defect resolution and clarifications.
• Co-ordinate with Enterprise Productivity team for QA of Account Scorecard.
• Prototype ETL mappings and standartize ETL best practises.
• Building run schedules for the Informatica jobs and building dependencies in Tidal.
• Create and customize UNIX shell script/Perl script for the ETL load process (Audit, Balance and Control Process).

Confidential, Plano, TX

PowerCenter Adminstrator, ETL Lead

Environment: Informatica Power Center, Oracle, SQL Server, Unix, Integration Services

Responsibilities:

• Prepare functional specifications document and source to target mapping documents.
• Automate data load and processing of Monthly Account Scorecard.
• Co-ordinate with Enterprise Productivity team for QA of Account Scorecard.
• Data Quality Analysis on EDW data.
• Prepare high level and detailed documents for sourcing new data source in EDW.
• Preapare adhoc reports requested by users and management from EDW.
• Assist and coordinate with EDW development teams with UAT and Production deployments
• Root cause analysis and failure resolution for ETL production programs.
• Create and Manage PowerCenter Repository objects and Users.
• Migrate ETL objects across repositories as part of Model office and Prod releases.
• Coordianate with offshore support team.
• PowerCenter migration from version 7.3 to 8.6 for all environments
• Planning and strategize Repository and Server upgrade.
• Coordinate the upgrade with involved stakeholders.
• Setup new environment and design test plans.
• Repository backup and Upgarde
• Installation and configuration of PowerCenter Server.

Confidential, Cincinnati, OH

Technical Lead

Environment: Informatica, Oracle, Cognos Report net

Responsibilities:

• Understand the business process flows and gather requirements.
• Document the gap analysis with improvement areas & implementation approach.
• Involved in effort estimation.
• Capture high level in scope/out of scope items along with milestone dates and deliverables.
• Involved in ODS data modeling and table metadata design.
• ETL design for the application and Report Net specifications.
• Documenting the design specs and reviewing the test cases and test plans.
• Integration testing and User Acceptance testing.
• Co-ordination and delegation of work to offshore teammates.

Confidential, Cincinnati, OH

Technical Lead

Environment: Informatica, Oracle

Responsibilities:

• Identify problems and issues faced by FTZ users, categorize them as functional or technical and provide solutions.
• Provide process improvement suggestions using Six Sigma methodology resulting in dollar savings.
• Eliminate reconciliation issues occurred due to mismatch of inventory between GE legacy systems and EZFTZ application.
• Provide inputs for any proposed process changes in Confidential supply chain systems interfacing with FTZ.
• Identify data quality issues with GE legacy systems and highlight them with Business leaders.
• Debugging and Troubleshooting Informatica Mappings.
• Identify the queries causing performance bottlenecks using I3 tool.
• Creating Indexes and Partitions for improving load times.
• Tuning Informatica Sessions and batches for optimizing load times
• Tuning Informatica Mappings to identify and remove processing bottlenecks
• Performance tune Oracle queries
• Backup and archival strategies for application data.
• Installation, Testing and configuration of EZFTZ application patches and oracle upgrades.
• Acted as EZFTZ application administrator.
• Write white papers documenting best practices for ETL development approach and application support.

Confidential, Cincinnati, OH

Technical Lead

Environment: Informatica, Oracle

Responsibilities:

• Interact with GE functional team for requirement analysis and document functional/nonfunctional requirements and specifications.
• Identify pain areas in the existing system and suggest solutions for improving the timeliness of data availability.
• Design ETL process for data loads using Informatica.
• Prepare technical mapping documents laying out the process flow.
• Design and develop UNIX scripts to FTP files from store and forward server in GE to GE OLTP systems.
• Develop mappings for extracting data from inventory database, purchasing database, warehouse database and loading the data to EZFTZ application.
• Coordinate with offshore development team.
• Drive user acceptance testing and Implementation in production.

Confidential, Cincinnati, OH

Technical Lead

Environment: Informatica, Oracle, Cognos, DQI

Responsibilities:

• Create work breakdown structure and estimate the project work.
• Coordinate with multiple groups/vendors to identify FTZ audit/compliance requirements.
• Design and develop ETL process with emphasis on error handling and re-usability
• Develop and automate load strategies for the data from various sources.
• Deliver different Cognos report prototypes and reports showing forecasted savings
• Build Oracle DQI checks to log and notify data quality defects to source systems.
• Integration/Random testing and User acceptance testing
• EZFTZ application administration.
• Design and Develop Informatica mappings.