SUMMARY

• Confidential TEMPhas over 20+ years of hands - on IT experience, in a variety of different roles, across multiple verticals.
• Confidential is articulate; innovative, creative, self-motivated, a designer, an architect, client-focused, and keeps abreast wif the latest technology in the IT industry.
• Confidential is talented in numerous areas wif a focus on Program / Project manager, Application Architect / Designer, Data Architecture.
• Confidential TEMPhas an excellent track record of implementing large-scale, mission-critical projects, providing end-to-end solutions to the clients.
• Confidential TEMPhas been a pivotal resource on large scale; high visibility technology projects.
• Confidential TEMPhas working experience across the diverse set of technologies and utilizes them to provide business, wif data-centric and client-focused solutions.
• Confidential is an astute strategist wif an excellent track record of building and aligning organizations to achieve excellence, profitability, and unparalleled client service through technology.

TECHNICAL SKILLS

Proficient in: Informatica 10.x PowerCenter Repository Manager, PowerCenter Designer, PowerCenter Workflow Manager, PowerCenter Workflow Monitor, Informatica Developer, Informatica MDM 10.x, IBM DataStage suite 11.5, IBM Data Manager, Erwin 2018, Microsoft office Suite, IBM Cognos Suite, Tableau Key-Value Stores/NoSQL/RDBMS

Databases: Oracle on Oracle ODA, Oracle, IBM DB2, Hive, PostgreSQL, Teradata, Greenplum, Cassandra, HBase, MySQL

Languages: PL/SQL, HQL, Shell Script, Python, Perl, Scala, Julia OS All flavors of Linux/UNIX and windowsClient State of New Jersey (Optum/DXC)

PROFESSIONAL EXPERIENCE

Confidential

Business Data warehouse Developer

Responsibilities:

• Designed and developed out bound data feeds from NJ State, Health PAS (Molina Healthcare) Business Data warehouse, an Optum Solution, using Informatica 10.x PowerCenter Repository, Designer, Workflow Manager, Workflow Monitor, Informatica Developer.
• Well versed in installation / configuration and administration of the Informatica Suite and integration wif BDM if required.
• Migrated data from HPAS system into NJBDW (New Jersey Business Data warehouse). Migrated billion+ claims and associated members / accounts / activities.
• Member, Provider and Claims processing.
• Designed, Developed and Maintained, using Erwin 2018, EDW VLDB data model.
• Recommended, Tuned Oracle 12c on ODA (Oracle database Appliance)
• Strong understanding and experience wif Informatica PowerCenter
• Strong understanding and experience wif Informatica Data Quality
• Design, develop, test, implement, and troubleshoot ETL mappings and workflows in a large Data Warehouse environment using, but not limited to, Informatica PowerCenter Designer, workflow manager, Workflow Monitor.
• Strong experience developing and maintaining Informatica mappings/workflows, using param based workflows execution, in VVL data warehouse environment
• Strong experience optimizing Informatica mappings, sessions and workflows
• Strong understanding of dimensional modeling and ETL
• Strong understanding and Experience writing complex SQL, PL/SQL and Performance Tuning is a plus
• Strong database experience, data analysis and analytical skills
• Experience creating ETL design documentation and maintaining overall design document and deliverables
• Strong written and oral communication skills
• Planned and established process for production support

Confidential

Data warehouse Architect

Responsibilities:

• Architected and Designed NY Health Exchange enrollment, data warehouse for following programs
• Extended ETL Job Streams to ingest data from disparate data sources into Informatica PowerCenter.
• Build multiple job streams in using Informatica Designer and Workflow Manager
• Architected and Designed redemption data Mart integrating data into all payers data warehouse.
• As a Delivery lead for the Health Exchange data mart initiative, architected, designed, and developed HIX data mart business intelligence system.
• Modeled in ERwin, ingested data from DB2 into ODS and built Data Marts using IBM DataStage 11.5
• NYSoH HIX Data mart enables ability to analyze application, eligibility, enrollments, and effectuations utilizing IBM DataStage.
• Business intelligence was built around number of enrollments, new enrollments, Brand new enrollments, cancellations, terminations, issuers, assistors / brokers etc.
• Coordinated Teradata Data Pipeline across multiple lines of businesses
• Integrated and ingested data from PostgreSQL and Cassandra data sources
• Lead Integration and implementation of new technologies into existing Data warehousing / Business intelligence systems

Confidential

Business Intelligence / Data warehouse Architect

Responsibilities:

• Created Project plans, estimated time, cost and labor for implementation of Siebel BI solution for Life science.
• Architected, designed and Implemented Business Intelligence / Data warehouse strategy Using Informatica Designer.
• Built ETL Streams using Workflow Manger
• Administered and Monitored Workflows using Informatica Administrator
• Prompted BI self-service environment
• Developed change management Practice and Procedures
• Trained staff in BI application(s)
• Built Master data Management solution from diverse data sources and Implemented company wide acceptance for the Master Data.
• Architect, designed, and implemented data warehouse solutions using IBM Informatica PowerCenter and data movement service, in the following business areas:
• Planned and estimated projects time and effort for Global debt analysis team.
• Architected BI model and created a self-service BI environment.
• Recommended BI standards, Procedure and Best Practices
• Trained internal saff on BI Tools