SUMMARY:

• Results - driven IT data consultant experience in architecting, leading, and managing a range of business data systems. Consulted with management of 30+ companies in the field of Banking, Finance, Mortgage, Healthcare, Hospital, Pharmacology, Pharma, Pension, Utility (Electricity, Water), Human Resources.

PROFESSIONAL EXPERIENCE:

Confidential

Data Governance Lead

Responsibilities:

• Working with Product Stakeholders, Global Data Governance Teams, Squads, and Engineers; conducting Data Governance literacy programs across enterprise and new resources; planning and strategizing Data Governance programs across North American Nike Data Products; Guiding, mentoring, and recommending various DG tasks; working with data engineers on Source To Target Mappings (STMs) and building Technical Lineage in Collibra; working with Collibra Architects and Admins in developing, testing, migrating, and publishing various Collibra assets and work products; Working on various features of Collibra - Community, Domains, Assets, Complex Relations, Imports, Exports, Glossaries, Calculations, Metrics, etc., conducting various data analysis in Snowflake, Hive, Teradata; working with Metadata applications to ensure DG compliance; working effectively on Jira creating user stories; creating various DG content on Confluence, Share Point, Box; creating various DG processes in XMinds, Lucid Charts.

Environment: Collibra, Snowflake, Confluence, Jira, SharePoint, Hive, Kafka, Lucid Chart, PEGA, Box, Metadata, Agile, Informatica DQ, Informatica Analyst, Enterprise Architecture, Privacy, Lineage, STMs, Consumer Analytics, ERWIN.

Confidential

Data Consultant & Advisor

Responsibilities:

• Advising and solutioning on Data Privacy, Data Fabrication, Data Masking, Data Modeling, Data Governance, Data Analysis, Data Architecture, and Data Encryptions for 50+ systems of 3000 applications across Human Resources (HRIT) departments at Confidential .

Environment: Peoplesoft, Windows, Oracle, DB2, ERWIN Data Intelligence, Data Vault, SharePoint, Citrix, SQL Developer, Confluence, JIRA, AGILE, Data Lake, DW, ODS, Metadata, Master Data Management, HR Analytics, Tableau, Workday, Visio, Delphix Data Mask, Wherescape Red, Toad Oracle, Password Safe, Git Hub Autosys

Confidential

Senior System & Solution Consultant

Responsibilities:

• Analyzed, offered solutions, and thought leadership to the Data Replication ecosystem on Federal Employees Program Operations Center (FEPOC) systems.
• Managed, led, and offered solutions on IBM Replication Dataset (1TB) of Health Insurance Enrollment, Claims, Drugs, Medicals, and Crime & Frauds.
• Developed MDH reports on Business Glossary, Technical Assets, Business Assets, Data Quality, Logical Assets, DQ Rules, Reference Data, Work Queue, Metadata Reports (Legacy and Custom), Diagrams, etc.
• Designed and updated data models using ERWIN per the Data Vault concepts.
• Implemented Data Vault Architecture across 10 technical and functional business systems.
• Identified and created candidate Hubs, Hierarchies, Links, Associations, and Satellites per the business requirements.
• Accountable for Data Transfer Strategy, Data Models, Datawarehouse, Data Marts, Data Lake, Cognos Reports, Source to Target Mappings, FRS, ETL Designs, RTM, and Test Strategies (Parallel and Regression Tests) Downstream System Lineage and Data Impact Analysis.

Environment: DB2, Toad, Erwin, CYBER ARK, Visio, Enterprise Architect BPMN, SharePoint, Unix, Ab Initio ExpressIT, Ab Initio Metadata Portal (MDH), IBM Cognos, HEDIS

Confidential

Lead Data Architect

Responsibilities:

• Consulted with the Application, Business, and Project owners and modeled enterprise-view conceptual and logical models, business processes for implementing Reference Standards, Dietary Supplements, Food Ingredients, Biologics, and Medicines, recommending data strategies across cross-inter-enterprise systems and interoperability using various Enterprise Architect, BPMN tools.
• Working with enterprise application and data teams; directing business teams in gathering data requirements.
• Leading real-time analytics application team built on Apache, Big Data ecosystems; solutioning various data scenarios related Big and Relational data.
• Building comprehensive Ontology trees for utility-related case systems; guiding data management team in ingesting data from various sources to data lake; guiding UI/UX team in designs, integration, and deployment.
• Recommending various practices in data, application development, and architecture including LAMDA; designing and reverse-engineering various data use cases and source systems; bringing up databases for various business systems from scratch; reverse-engineering various COTS dB systems’ data models - CISCO, Salesforce.
• Designing GDPR, data security frameworks aligning to AW business capabilities and processes; customizing COTS applications such as Sales Force and Cisco (Cisco User Intelligence Center).
• Profiling data fed into 10s of systems; conducting a quality data audit on source systems; leading and managing off-shore Data Analytics team of 6 members.
• Closely working with Vendor CTO and Client-side CTO on various technical solutions and visions; implementing data solutions on AWS Cloud Platform.
• Developing Ontology (Semantic layers), Metadata for various product dimensions.
• Part of Center of Excellence team and play a role of internal SME; developing product content for users and new clients using ASCII Editor; participating in product innovations and roadmaps.
• Guiding the team of Business Analysis and UI/UX engineer in understanding the data flows between various systems such as Water Meters, Meter Health Matrix, and Meter Billing and Payments.
• Recommending candidate data points to SAP ABAP programmers and SAP SMEs to be implemented on the SAP configurations.
• Developing and distributing pseudo code that can be run on SAP database to capture the business logic and rules.
• Guiding SAP database team and Big Data (Data Lake) engineers to supply data through Federated Hub to up and downstream systems; extracting or reverse-engineering existing data models and presented business capabilities to SAP implementation team.Led a team of 6 data management consultant; implemented data integrity and quality across the SQL Server database systems; offered solutions to Director Data Analytics & team besides recommending and refactoring enterprise data models.

Environment: Erwin, SQL Server, SQL & Advanced SQL, SSIS Integration Services, Data Dictionary

Confidential, Jersey City, NJ

Data Quality Architect

Responsibilities:

• Gathered business / data requirements for data models and BI Dashboards; developed Reference Data Models for Priced / Revenue systems; profiled Reservation, Stay, Booked, Discount, Global Location and Priced Data used Advanced SQLs, HIVE SQL, Tableau, and MicroStrategy; generated DDLs for MongDB, Hadoop Systems, and JSON
• Published and presented Data Models to Stakeholders and Extended Groups.
• Extracted and profiled Reference Data for data models
• Implemented Referential Integrity of data from desperate systems
• Developed Source To Target mappings
• Interfaced with Business Teams, Data Teams, and Enterprise Teams, and Reported Teams; developed Platform Analytics / Dashboards used Tableau and MicroStrategy
• Offered solutions and implemented the BI and Product MDM, Vendor MDM, Customer MDM integration strategies on AWS Cloud Platform and Data Lakes, API integration, SOA roadmap, SOA governance to integrate the data and services into Collibra, MapReduce, Big Data.

Environment:HIVE, Horton Networks, Ambari, Oracle, Tableau, Talend MDM, MicroStrategy, Embarcadero, Lucid Chart, Red Shift, AWS, Data Lake, EC2. Roles & Responsibilities: Data Models, Data Governance, Data Quality, Data Profile, Data Analysis, BI Reports, and Analytics

Confidential

Lead Data Governance Architect

Responsibilities:

• Created Data Governance Framework (POC) worked with EPIC Analytics, Clarity Reports, and EDW groups.
• Wrote Data Requirements and Specifications for BI Reports in Tableau; Managed Tableau Server and User Access; built Relational / Entity Models for Clarity (OLTP) System used query designer in SSMS
• Built BI Data Layer / Star Schema used ERWIN for Tableau Reported; integrated Active Directory and Tableau Server for User-level access to specific reports; Tableau Offered solutions and Administration; provided guidance to BI Analytics Developer, Analysts, and Functional team on DG
• Developed Data Dictionary and extracted Reference Data from various sources; Reviewed and recommended ETL processes between Source and Target systems; identified Master Data Management (MDM), Data Quality, Data Governance requirements and use case for the project and ensured those requirements
• Acted as an internal SME worked with Enterprise SMEs; Estimated tasks and provided Level of Efforts (LOEs) on Data Analytics deliverables; leaded and mentored ETL Analysts and BI Development team; reported to C-Levels and provided thought leadership across implementation life cycle.
• Developed training content and presented interim dashboards to the C-Levels
• Recommended Data Governance Roadmap and Transformations; created and updated Data Models and Objects for 23 OLTP Health Systems (CADENCE, AMBULATORY, EPIC, to name a few) and extracted Data Dictionary, Data Lineage, and Reference Values for EDW and ODS.

Environment: Tableau Developer, Web, PostgreSQL, Server, SQL Server, SQL Server Studio Management 2014, Erwin, ER Studio, Visio EPIC, HEDIS, Clarity, Visio, Crystal Reports, Caboodle EDW, Python, MDM (Master Data Management), R Roles &Responsibility: Data Analytics, Data Governance, Reported, Data Models, Data Dictionary, Data Architecture, Master Data, Metadata, ETL, Compliances, Standards, Health Care analytics

Confidential

Lead BI Data Architect

Responsibilities:

• Analyzed and conducted the TAX-AIDE / Non-Regulatory Reports Requirements sessions with the Business users; developed SQL Pseudo codes and executed the same logic in MicroStrategy implementation.
• Developed ‘Table Views’ to achieve a unique combo of data; guided DBAs to catalog ‘Table Views into EDW; Guided MSTR Admin to catalog ‘Table Views’ to the Primary Source Db; Developed MSTR Schema Objects such as Attributes and Metrics included custom Hierarchy per the requirements; designed and developed Parent-Child relations and other hierarchies used MSTR Architect; developed MSTR Public Objects included Consolidations, Custom Group, Transformations; developed simple, compound, and derived metrics extensively used CASE and Apply Simple functions;
• Developed various prompts and filters on existed reports per the business requirements; manipulated and modified existed view filters as part of reports fixes used both MSTR Desktop and Web; tested Reports outputs (Reports Summary) and versions used Integrity Manager; managed Support or Vendor team on their deliverables and offered guidance on best practices
• Created trained materials and train the business users on usability and navigation of MSTR reports; created and updated Source to Target and sheets; created and updated Regulatory OLTP Data Model objects / EDW Data Models per the Report specifications
• Extensive SQL Analyses and Validation; developed Python scripts to estimate data volume in Sales Force; fixed bugs and migrated the updated objects between environments
• Participated on Technical Reviews and managed Vendor Codes and Deliverables; Validated and verified User Level accesses to ensure data conformance; Verified and generated reports in Sales Force; guided ETL developers and shared data flow logics; ensure data integrity; implemented MSTR and DQ Governance and Practices across deliverables and tasks.

Environment: Sales Force, Netezza, MicroStrategy Desktop 9.4.1, MicroStrategy Web, MicroStrategy Integrity Manager, SharePoint, ER Studio Architect 16.0, Service Now, Python, TOGAF, Informatica IDQ. AXON, MDM, Dimensional Modeled, MicroStrategy Architect. Roles & Responsibilities: Core BI Developer / Consultant, Data Conversion, Data Validation, Database Design, Data Analysis, Enterprise Data Architecture.

Confidential

Lead BI Data Architect

Responsibilities:

• Architected BI Framework for DCAS BI Reports from implementation standpoint; supported PMO and CIO in creating Service Level Agreements, Project Plan, Statements, Goals, Objectives, and Infrastructure Setup, Vendor Agreements from MicroStrategy standpoint
• Led and mentored, trained the Business Intelligence team of three developer’s effort day-to-day basis; reviewed Vendor Artifacts such as DW / Data Mart Data Dictionary, Source to Target (S2T) Mapped, Design Solutions, and Database Designs; recommend changes; conducted comprehensive data analyses and profiled data on Data Mart (source of BI reports; conducted Reports Requirements sessions on various DCAS Capabilities such as Benefit Issuance, Application Intake, Case Maintenance, Program Integrity, and Crimes& Frauds.
• Reviewed Federal Reports Templates and documented gaps as part of Reports requirements; mentored the BI Team; created / modified DCAS (OLTP) Data Models used ERWIN; prepared Reports Project Plan and Level of Effort (LOE) used MS Project, developed various project artifacts such as Statement of Work (SOW) BI Design Solutions, RACI Matrix, and BI Approach deck included MSTR best practices, Development Logs, Test Cases
• Developed and customized various ad hoc SQLs supported Case Workers and UAT Specialists used SQL Developer; configured and set up MicroStrategy Repository and Servers worked with Solution Architects with Office of Chief Technology Officer (OCTO); loaded Source Tables and updated table structures on MicroStrategy; designed and configured Schema Objects on MicroStrategy along with MSTR Standards and Compliances; modeling Logical Design and System Hierarchy on MicroStrategy Architect used Curam’ Express Rules (CER)
• Reviewed SQLs from Vendor and extracted Reports logics to integrate the same in MSTR Reports; reviewed and validated SQLs, extracted Reports Data for SMEs and UAT reviews; managed Schema and Public Objects for BI Team and ensured consistency while developed reports
• Administered various tasks such as Change Journal Logs, Object Locks, User Access, and Privileges, DW Catalogue, and Migration; Conducted SDK POC on SharePoint Server, Hadoop, AWS Amazon Simple Db, and Fire Bird Databases; Extensive hands-on in MSTR Web Server and Designs; created, manipulated MSTR Templates, Intelligent cubes; automated, scheduled, and published MSTR reports to target audience; developed DCAS-specific various types of facts, metrics used built-in MSTR formulae and functions.
• Supported various SQL and database activities; provided solutions and guidance on various Data Warehouse Principles and Practices in line with BI framework and other downstream systems; managed database teams from Vendor and Infrastructure Architects, SOX Compliances at OCTO; Implemented MSTR and DQ Governance and Practices across deliverables and tasks.

Environment: IBM Curam, Oracle 11G12C, Oracle SQL Developer, Advanced SQL, MicroStrategy 10.2 (Designer, Developer, Architect, Administration) MicroStrategy Web, Python, AWS Cloud, MicroStrategy Command Manager, MicroStrategy Object Manager, MicroStrategy dB Query Tool, Oracle Data Warehouse Builder, Tableau 9.3, HP ALM, HEDIS, Hadoop, SharePoint, DHS DCAS, OLTP / DW / DataMart / Dimensional Modeling(Star Schema) Roles & Responsibilities: Data Architecture, Data Integration (Informatica IDQ), Data Conversion, Master Data Management, Enterprise BI Architecture, Solutions, and Reported, MicroStrategy Project Administration, DW Data Mart, Curam’ Social Management Functions.

Confidential, Charlotte, NC

System Architect

Responsibilities:

• Worked with SMEs and gathered data requirements; access Adaptive (Sun Guard) Counter Party Risk Measures Application and analyze Function points; accountable for E2E implementation of Data Modeled 26 System of Records (Legacy SORs); recommend Data Architecture / Modeled Design solutions per Business Scenarios / Use Cases; created Data Models for PFE (OLTP) / Risk Analysis Measures (Monte Carlo Simulation) for CRISM, Time Series Systems
• Conducted extensive data mined, profiled, and analysis on the Counter Party / Market Risk data; created dashboards and pivots as part of data profiled; designed; developed both Logical and Physical Models (LDMPDM) for Counter Party / Risk Market Technology products; deployed and tested DDLs in various databases such as SSMS, Oracle, DB2, Hadoop, AWS Amazon Simple dB as Model Assessments; integrated Subject Areas and generated enterprise DDLs; create, update, import, and manage NSM / DSM files; create, update, import, and manage Validation rules
• Configured and revised UDP data; SCHEMA objects and Referential Integrity; created, updated, and managed Role Names between Logical and Physical Objects; generate and deploy DDLs in SQL Server 2011; guided DBAs on DDL execution; advised Technical Analysts in ETL S2T Mapped; created Data Model templates and sessions; resolved Change Requests (CRs) and updated data models; provided Data Modeled design standards, solutions to various data marts and product teams; deployed data governance, standards, and compliance in data modeled deliverable(s); managed Data Modeled deliverables on SharePoint Server; analyzed CRiSP Reported database for Canned Reports, CCAR Reported, Top 50 Reports, and Monthly Management Packages
• Guided BAs, QAs in interpreted and tested data models; customized Schema Objects; created logical models and system hierarchies in MicroStrategy to generate ad hoc reports; developed Enterprise Risk Reports (POC) used MicroStrategy and Other BI Applications as Assessment; developed various ERWIN Data Mart / Repository Reports like Global Reports, Diagram Reports, Validation Reports, and Others Reports (Model Contents, Model Locks); implemented Data Modeling and DQ Governance and Practices across deliverables and tasks.
• Analyzed and recommended best practices in the Single-Family enterprise data models and designs; developed and implemented various data quality principles, policies, and practices across the SF databases in terms of codes and rules.

Environment: SQL Server, ER Studio, Macros

Confidential, Washington DC

Enterprise Data Modeler

Responsibilities:

• Conducted initial assessment on the design gaps in the Loan ELDM; generated various reports, data extracts for Loan Logical Models from EMR, IMR repositories; reviewed and recommended Loan logical design approaches and processes; worked with the Application Modelers for further assessment and effort estimate; conducted gap analysis between Application and Logical Model objects worked with Business Architecture Group
• Implemented reverse engineered / roll up modeling approach, wherever applicable; created Data Model Design Approach framework to ensure logical modeling accuracy and consistency; analyzed and extract the Financial “Agreement / Commitment” application business processes and translate the same as High Level Logical Models; defined the Pricing Execution (PE) application entities and attributes and identify associated objects; conformed Enterprise Data Governance (EDG) standards across the PE (OLTP) Logical Model; implemented Financial Data Governance Standards such as MISMO, SIFMA, and Corporate Data Dictionary (CDD); developed a comprehensive conceptual, logical data model for the “Commitment” subject area; trained the business users on the logical models and navigation
• Identified associations, relationships, constraints, primary keys for each ALDM Commitment entity used exited application models and business processes; Implemented the Confidential Data Modeled standards such as Primary Qualifier, Class Word, and Domain, Definitions, Reference Values, and DG adherence; created and updated Reference Values (RefVals) used built-in ER Studio Marcos; created Traceability Matrix for the ‘Commitment Platform’ business requirements and ELDM’ managed design specifications in ER Studio Repository with minimal execution for the Commitment subject area; installed, Configured, and Reverse-engineered data models from Oracle Databases and merged various Subject Areas; assessed and estimated level of effort (LOE) for the CU Underwrite data model from existed conceptual model; extracted various reports, data dictionary, and reference values as part of quality check and peer validation; managed the Agreement / Commitment repository version for continual updates and CQ defects; analyzed the ELDM CQ tickets from the business stakeholders for further processed; assigned, resolved, and ensured the ELDM defects in Clear Quest; acted as Interim Data Lead and convert XML / XSD outputs from Source Systems and create dashboard used functional specifications for Stakeholder Review and Business Insights
• Participated in Pricing Execution Stakeholder review sessions, Data Model sessions, and ECF project discussions; offered Enterprise support to Enterprise ER Studio Administration - Application Production Server Management, User Support, Repository Monitored, Repository Services Management, and Repository Clean up, Server Upgrades& Licenses, Embarcadero Vendor Management, and Data Model Object Reported.

Environment: ER Studio Data Architect, Repository, My SQL, SQL Developer, Oracle 11i, SharePoint 2010, MS Office, MS Visio, Clear Quest Roles & Responsibilities: Principal Consultant - Enterprise Data Architecture Modeling, ER Studio Enterprise Administrator, Data Lead, Datawarehouse, Meta Data Management.

Confidential

ETL System Architect

Responsibilities:

• Interfaced with the Maryland State Departments (DHR, DHMH, and Department of Health) Stakeholders to define and understand Data Conversion requirements for SNAP, TANF, HEAP, MEDICAID systems; acted as Subject Matter Experts (SME) to Development and Test teams, and enhanced groups in the Healthcare ecosystem; developed Logical, Physical Data Models for Health Insurance Exchange (HIX OLTP) and Data Conversion effort in ER Studio / Informatica; managed ER Studio controlled repository for distributed teams across data centers; developed Data Common Layer Architecture for distribution of converted data by various groups; created ETL table space on test schemas and manage user privileges as part of catalogues; developed and implement Data Quality Rules used Informatica Data Quality (IDQ)
• Designed and integrated logical data models with existed data model used ER Studio and TOAD; worked with business and technical leadership(s) to research, access, and design conversion of legacy data as per the Curam application (Target); managed SDLC phases of data conversion worked with PMO and other technical reviews with the Department PMOs; guided internal teams to source, validate, and resolve data issues in Informatica suite; interfaced with Enterprise Architecture groups to align data model with Healthcare Ecosystem; led a full cycle of logical data model design, implementation physical model, and reviews of logical and physical data models
• Mentored interns on ETL, Data Quality, Reference Data, and Cross-Walk Tables; aligned Data Models, Business Process Models per existed HIPAA Use Cases - by leading the team of modelers; implemented Informatica Data Conversion and DQ Governance and Practices across deliverables and tasks; directed release management process for updates to UAT and PROD environments; assisted Informatica Developers with Data Models and Attributes; worked with Service Oriented Architecture (SOA) Group and delivered Conversion Architecture artifacts; guided QAs in validated outputs as per the Design and Data Specifications; supported the Data Conversion PMO in created Project Charter, Plan, LOEs, Problem Statements, Goals, and Objectives.
• Led Data CoE (Center of Excellence), reported to Director - Solution Services; managed Vendor deliverables; responsible for Data Integration and Master Data Management leaded a team of developers and architects in Informatica suite; guided Enterprise Architecture Review Board (ARB) and implemented TOGAF across data implementations; audited vendor deliverables and business processes used ARIS.
• Implemented standards such as CDASH and CDISC standards; offered solutions and designed various data artifacts related clinical and pharmaceutical systems, included data models, frameworks, architectures, processes, and practices.
• Supported Clinical Research, Clinical Programming development effort; interfaced with CQA and Regulatory Teams; profiled data from CTDS, GCP CDMS, and CCDM for ETL ecosystem.

Environment: Windows, Informatica Power Center Suite, Informatica IDQ, MDM, Trillium ARIS, TOGAF, Data Integration, Data Conversion, Data CoE, Business Processes, SharePoint, JIRA Roles & Responsibilities: Enterprise Data Architecture, Data Integration, Data Conversion, Master Data Management, Center of Excellence, Business Processes, IT Audits, Clinical & Pharma Data Management, Informatica Administration, SharePoint Content Management

Confidential

Business Data Analyst

Responsibilities:

• Managed database requirements of enterprise systems - OIT, BHPR, FDA, BPIC, DHS, and SSA; managed processes of Project / Program Management for 4CAST, a National Healthcare Grants Allocation Framework; contributed, supported to the vendor Project Management Office deliverables such as Charter, Plan, LOE, Vision, Mission, Requirements, Specifications, Design, and other Practices from the Data Management and Modeled standpoint; defined project KPIs for the backend database; conducted Stakeholder analysis and created use cases and data models; optimized product development approach across the Bureaus by usability survey; implemented Business Data Metrics across Bureaus Database systems; various development design solutions; created comprehensive data dictionary from various Health Care databases; analyzed huge volume of Source Data used SQL Server; created ERDs for various Federal Bureau / Office databases used Erwin; developed prototype s (wireframes) used Axure; developed online data framework used ADOBE suite;
• Reviewed deliverables - plans, designs, codes, documents, test cases, processes; developed Test Plan and Test Scripts along with RTM; managed project artifacts on SharePoint Project site and user management and customization; designed and implemented SharePoint Project Sites; aided EPLC business process in project gate review sessions; hands-on experience in data related to - Federal Funds, Grants, Cooperative Agreements, Agency Transfers; created and reviewed various HRSA EPLC security polices and governance models; supported users in ad hoc database application issues; created ad hoc BI reports used SAS and SSIS to support various Bureaus; interfaced with various HRSA bureaus and the COO team; created and contributed to Project Bids and Statement of Work (SOW) worth of $20 million for implemented Enterprise Handbook (EHB) across HRSA.
• Led a team of ten ETL Developers to plan, design, and implement Data Warehoused for the State-wide source systems - TCCMS, TENNCARE, VRTS, and COTS as part of Data Conversion.
• Contributed, managed, and reviewed various PMO deliverables such as Project Charter, ETL Plan, Problem Statements, Vision, Mission, Goals, Objectives, and Other Benchmarks as Vendor deliverables to the State of Tennessee as part of Daily Refresh Data Conversion engagements; extracted historical data from five different legacy systems (Mainframe and Oracle - Health Care, Medicare, Medicaid, Claims, Crimes & Frauds) to load data into Oracle target database - Vision Integration Platform (VIP); Designed various Informatica mappings for complex transformation logics to manipulate and load the data; extensive usage of Lookup Transformation to match data from multiple tables to retrieve data; analyzed data to create business requirements for Data Conversion; contributed to help Quality Analysts (QAs) understand the design and development of the ETL logics; guided other ETL leads and conform ETL development standards; designed complex mappings by identified target load orders and constraint-based loaded; created Tasks, Worklets, and Workflows used Informatica Workflow Manager; experienced in created and converted database objects used Oracle, SQL Server from Flat files, Copy Books, and XML; Scheduled various ETL jobs, use cases and workflows used Visio, Win SCP, Putty, K Shell Scripts;
• Executed pre / post-session Unix commands to clear caches, drop tables; modified partitions and indexes; prepared LLD and HLD to documents on the requirements and S2T mappings; created defect tickets and managed bug fix flows on JIRA; Managed various phases of SDLC and technical / gate reviews on the vendor deliverables to the State; trained the ETL developers and the State employees on deliverables; produced unit test results used and validated data consistency.
• Implemented ETL and DQ Governance and Practices across deliverables and tasks.

Environment: Informatica Power Center 8.6 /9.1, IDQ, MDM Oracle 10g, My SQL, SQL Developer, Oracle Data Warehouse (ODI 11C) Builder, API / Services, Erwin R/3, SAS, HEDIS, Curam Framework, XML, PL/SQL, Win SCP, Putty, JIRA UNIX, Mainframe, Windows, e Room Roles & Responsibilities: ETL Data Architecture, Business System Analysis, Data Analysis, Data Modeling, Master Data Management.

Confidential

Software & Information Architect

Responsibilities:

• Reviewed and analyzed BRDs for Functional Requirements, System Requirement Specifications and ETL Designs; created Enterprise Bus Matrix per BRDs; analyzed source data of various telecom systems for ETL rules; developed star schema data models on TEMS OLTP / OLAP data; optimized, tuned the existed Informatica mappings in various levels; tuned ETL performance by implemented Bit Map, B-Tree indexes in the design without impacted existed designs
• Contributed to Master Data Management (MDM) to integrate the ‘Conform’ dimension consumed by multiple applications; updated telecom use cases, data models pertained to ETL processes; participated and guided in Informatica, Oracle software upgrades and licensed efforts
• Supported Project Management Office by contributed to various PMO artifacts included Charter, Vision, Mission, LOEs, Project Plan, Problem Statements from the Data / ETL standpoints.
• Managed offshore-onsite deliveries in the SharePoint /.Net/Python/EMC-Documentum environments and implemented best practices.

Environment: Windows 2003, eRoom, .NET, SQL Server, SharePoint, Documentum(eRoom), Web Services, MS Office, MS Project, MS Visio Roles & Responsibilities: Project Lead, Remote Virtualization, Content Automation / Architecture, SharePoint Integration, Infrastructure Governance, Business Processes, Business Continuity