SUMMARY

• 15+ years of experience in leading Technology and Business critical projects.
• Expertise in Basel compliance, CCAR, firm wide, non - firm wide, AML (Anti Money Laundering), risk modeling, credit scoring, financial reporting projects in banking and financial services industry. Experience in Finance, Risk, Treasury and Cash management domains.
• Experience in Banking and Financial services projects involving card services, consumer banking, business banking, wealth management, auto loans, student loans and capital markets.
• Extensive experience in Affordable Care Act, individual healthcare, small group healthcare, commercial healthcare, Medicare and regulatory healthcare insurance projects.
• Expertise in healthcare domain projects involving membership, billing, payments, claims, benefits, provider and customer service areas.
• Expertise in data integration, data governance, data stewardship, data profiling, data quality, data modeling, data analytics, data architecture, metadata management, reference data management and master data management.
• Experience in analysis, design, development and implementation of data warehouse systems (OLAP) and operational systems (OLTP).
• Strong understanding of ETL, reporting, business analytics (business intelligence) and data warehouse concepts.
• Experience with reports and dashboards development for operational and analytical needs and exploring data using data visualization tools.
• PMI certified Project Management Professional (PMP) with expertise in leading large scale projects.
• Experience in waterfall and agile (scrum and Kanban) projects.
• Excellent communication, problem-solving, critical thinking and analytical skills (Inquestra BSAC Certified - Business Analyst Certification).
• Led project requirement meetings, functional specification meetings, status meetings, architectural meetings, testing support, defect resolution, release support and warranty support meetings.
• Tracked, monitored and reviewed the project status with leadership teams.

TECHNICAL SKILLS

Operating System: OS/390, Z-OS, Unix, Linux, Windows

Languages: COBOL, JCL, Korn Shell scripting, Python, SQL and C

Database: Teradata 14/15, Oracle 11g, SQL server 2008, Amazon Redshift, DB2, IMS-DB, DATACOM, VSAM, Microsoft Access, IBM Netezza

Database Tools: SQL Assistant, BTEQ, Teradata Administrator, SQL server management studio, SQL Workbench, Aginity workbench,Toad, SPUFI and QMF.

ETL: Informatica PowerCenter, Microsoft SQL Server I ntegration Services (SSIS)

Big data: Hive, Impala, HUE

OLAP Cubes: Oracle Hyperion Essbase

Data Quality: Informatica Analyst, Ab Initio Data Quality Environment (DQE)

Data Modeling: Star Schema Modeling, Snowflakes Modeling, Fact Tables, Dimension Tables, Logical and Physical Data Modeling, ERwin 8x/7x, Visio

Data Governance: Orchestra Networks EBX5, Collibra

BI and Reporting: Tableau, QlikView, Business Objects, Cognos, SAS, MicroStrategy

Tools: ReqPro, ClearQuest, JIRA, HP ALM, Control-M, VersionOne.

Mainframe Tools: XPEDITER, CHANGEMAN, ENDEVOR, FILE-AID, FILE MANAGER, Abend-aid, SAR, IBM Debugger, File manager, IMS-DC, CICS

Cloud Products: Simcop Dimension, FIS Sungard Integrity

PROFESSIONAL EXPERIENCE

Confidential, Arlington, VA

Systems Analyst/Data Analyst/ BI Developer

Technical Environment: Unix, Cloudera Hadoop, Impala, SQL server, Oracle, JIRA, Collibra, Simcorp Dimension, FIS Integrity (Saas product), Business Objects, Tableau, TIBCO DV (CISCO DV), C#

Responsibilities:

• Create user stories and develop acceptance criteria.
• Perform Source to target mappings. Develop data flows, business process flows and architectural diagrams.
• Extract data from SQL server and oracle databases for payment and holdings reconciliations.
• Analyze Simcorp to create data mappings and reporting requirements.
• Develop SQL queries, stored procedures and views for data sourcing into SQL server and Oracle (simcorp), Tableau reports generation, BO reports generation, data ingestion to Hadoop, data quality checks and data reconciliation.
• Develop and modify operational and analytical Tableau reports and dashboards to provide collateral summary, Trade activity, Daily Borrowed Money, Debt Roll Forward and 2052A reports.
• Develop and modify existing business objects reports.
• Map and develop file configurations in FIS Integrity(SunGard) for BAI files. Create/generate various extracts (GL extract, Credit lines, Daily Balances etc) and develop feeds to various downstream systems.
• Develop process flows, architectural diagrams, design Web UIs and analyze C# code.
• Perform data integrations and automations involving Bloomberg, Simcorp dimension, MarkITWire, Polypaths, Broadridge processing systems, FIS Sungard, Hadoop data lake and various Banks.

Finance Data Analyst/ Data Governance Analyst

Confidential

Technical Environment: Unix, Cloudera Hadoop, Impala, SQL server, Oracle, JIRA, IBM InfoSphere DataStage, Collibra, Simcorp Dimension

Responsibilities:

• Analyze datastage jobs, sql server, oracle and data lake to identify the data lineage for FRY9C critical data elements
• Perform SQL queries, Impala queries and HIVE queries to identify the CDEs and various data attributes
• Work with data curators, data trustees, data owners and SMEs to meet data governance objectives.

Confidential, Reston, VA

Treasury - Systems Analyst/Data Analyst

Technical Environment: Unix, Netezza, Informatica PowerCenter 9.6/10.1, Informatica Analyst, JIRA, Toad and Oracle.

Responsibilities:

• Validate Business requirements, create user stories, prioritize user stories and develop acceptance criteria.
• Perform source to target mappings, create snapshot views and reporting views.
• Develop Technical Documentation - System analysis, Create Design documents, Technical Specification Documents, System Context diagrams, Interface Control Documents (ICDs) and Service-level agreements (SLAs).
• Work with data modelers and database administrators on developing data models and data dictionaries.
• Design Fact, Dimension and detail tables.
• Create snapshot views and reporting views to support various customer needs.
• Verifying the data models and data dictionaries.
• Perform data profiling and set up data quality rules for reasonableness, completeness etc using Infotmatica Analyst.
• Create Data governance documents for lineage and meta data documentation.
• Facilitate discussions and workshops with senior business and technology stakeholders.
• Perform data reconciliation between source databases, target databases, snapshot views and reporting views.
• Responsible to conduct the gap analysis.
• Participate in scrum sprint planning, daily stand-up, sprint review, sprint retrospective and in Kanban ceremonies.

Confidential, Richmond, VA

Data Analyst

Technical Environment: SQL server 2008, Teradata, Redshift, Python, Korn shell scripting, Tableau, Unix, Linux, SSIS, Oracle Essbase.

Responsibilities:

• Performed BAU data loads/processes in Teradata, SQL server and Redshift to meet various LOBs financial reporting needs and monthly financial measurements.
• Performed data analysis, pivoting, trending and variance analysis using SQLs, Tableau reports and Microsoft Excel.
• Performed data reconciliation of financial measurements and metrics.
• Analyzed, modified and executed stored procedures and scripts to support analytical needs
• Designed and developed tables and views to meet reporting and data visualization needs.
• Identified the issues and performed code fixes in scripts, jobs and stored procedures.
• Move data across Teradata, SQL server and Redshift databases.
• Designed, developed and published reports and dashboards for metrics and data visualization
• Automated manual business and IT processes to streamline the existing processes.
• Participated in scrum sprint planning, daily stand-up and sprint review etc.
• Pull and push data from cubes and perform data reconciliation

Confidential, Columbus, OH

Developer/Tech Analyst

Technical Environment: Informatica PowerCenter 9.0, Unix, Oracle, Korn Shell scripting, Control-M

Responsibilities:

• Performed daily, weekly, monthly and one-time data loads.
• Analyzed Unix scripts, Informatica workflows and stored procedures to perform data loads.
• Designed and developed data loads.
• Identified the issues and performed code fixes in Unix scripts, ETL jobs and stored procedures.
• Customized and executed Control-M jobs for test environments.
• Partnership with the development teams, Unix administrators, testing teams, database administrators and project managers performs data loads.
• Developed SQL queries to do data validations, dropping tables and recreating tables etc for supporting the testing teams.

Data Governance Analyst/Data Analyst

Confidential

Technical Environment: Informatica Analyst, Ab Initio Data Quality Environment (DQE), Teradata, Oracle, SAS, Visio, Microsoft Access, QlikView, Cognos and Tableau

Responsibilities:

• Established, guided and followed the data governance processes, policies and standards.
• Worked closely with enterprise data governance, data stewards, data analysts, data architects, model owners and business SMEs to meet data certification scope.
• Identified critical data elements and responsible for defining name, definition, security classification code, personal information classification code, business criticality etc.
• Identified data lineage, performed source vs. target mappings.
• Identified valid values, exception values and created gold list of values to manage reference data.
• Performed data profiling and analyzed data profiling results. Performed data analysis using SQL queries, reports and data visualization tools.
• Identified data quality issues, performed root cause analysis and resolved the data quality issues.
• Established and reviewed data quality rules and metrics.
• Performed data quality audits and data governance audits to identify inconsistent data, incomplete data, incorrect data, business rule violations, incorrect business name, incorrect definitions and incorrect data attributes etc.
• Prepared use cases, activity diagrams, workflow diagrams, sequence diagrams, class diagrams, data flow diagram, process flow diagram, etc using modeling tools
• Established data certification metrics and posted regular updates to data certification metrics.
• Worked across multiple business teams (such as Auto finance, Mortgage etc.), across business domains (such as Finance, Default etc.) and technology teams to perform data certification steps.

Confidential, Richmond, VA

Data Analyst/ Business Systems Analyst

Technical Environment: Informatica Analyst, Informatica PowerCenter 8.6.1, ERwin 7.3, DB2, Oracle, Teradata, Mainframes, IMS DB, IMS DC, QlikView, Cognos and Unix Scripting

Responsibilities:

• Performed a variety of tasks related to collecting, organizing and interpreting data.
• Handled inspecting, cleansing, transforming and modeling data.
• Created and modified logical and physical models for MA members and IRS reporting.
• Designed Fact and Dimension tables.
• Created data lineage and data mapping documents.
• Analyzed and modified various ETL jobs which are adding/updating the customer data.
• Helped testing teams with the SQLs, test data and Jobs execution.