SUMMARY:

• Over 14 years of experience in diversified platforms. Have worked through the entire project life cycle (E2E), CRM implementation to warehouse to reporting. Extensive experienced in Banking/Finance, Insurance, Healthcare, Pharmaceutical and Education sector.
• Expertise with multiple mainstream banking systems like AFS, ALS, Datascan, Lightning, Paragon etc.
• Extensive experience working in regulatory space including CCAR, CapPR, IHC, EU/US LCR, Call Reports and compliance landscape like BSA/AML, CTR,SAM,KYC,CIP,CDD etc.
• Solid domain knowledge in loans, deposits, mortgage & securities.
• In - depth knowledge of OLTP/OLAP/ODS, E-R modeling, database Schemas (Star schemas, Snowflake schemas), Dimensions and fact tables.
• Experience in creating conceptual and logical models.
• Expert level knowledge Oracle, Teradata and SQL Server databases.
• Expert in performance tuning of PL-SQL Codes.
• Extensive experience in writing efficient stored procedures and packages, analytical sql.
• Extensive experience in Data Warehousing development using ETL tools such as Informatica Power Center 9.x/8.x/7.x.
• Strong logical and analytical reasoning skills, good communication, listening and Intrapersonal Skills.
• Experience working with onsite-offshore model.
• Have worked with popular CRM’s like Siebel, Sales f orce and other industry applications like i-Facets, CANVAS and lifeRay.

TECHNICAL SKILLS:

Languages/Scripts: SQL, PL/SQL, MatLab, MathCAD, Visual Basic, JavaScript, R,JMP

RDBMS: Oracle 11g/10/9i/8.i/7.x, Teradata, MSSQL server, MS-Access 2000

Reporting Tools: BI Publisher, OBIEE, Actuate Reporting System, Oracle Discoverer,Cognos

ETL Tool: Informatica Power Center 9.x, 8.x, DAC 10.1.3.xBusiness Object Data Integrator (BODI)

UNIX Shell Scripting: Kron, Python

CRM: Siebel, Sales f orce.com

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

Manager/Application Data Architect

Responsibilities:

• Managed project ILM (E2E), a work stream of Intermediate Holding Company (IHC); mandate from Confidential III. Partnered with LOB’s to define the sphere of information that would be reported upon.
• Design and develop strategic approach to align with BIDM standards; including the FARM tactical data model to support the same.
• Guide and Mentor the development team to successful delivery of Phase 1 of the project.
• Define an array of Health Checks that would reconcile the Banks data with FRB statements.
• Designed/Developed Informatica framework for US/EU LCR/5g reports that would feed into Triton (Balance sheet reporting at BNPP level across the globe).
• Designed/Developed cash flow model from scratch for Liquidity Coverage Ratio (LCR) in lieu of QRM for treasury.
• Played a key role in CAPPR working on CRE and Corp submissions to meet an aggressive deadline.
• Implemented multiple Call Reports (RC-E, RC-B, RC-O etc.)
• Collaborated with internal partners to define application standards and convention to integrate multiple moving parts between apex reporting and Finance Data Mart.
• Played a key role in CTR (Currency transaction report) from data collection from FIS to FInCen submission using Actimize. Provided consultation in other compliance tracks like SAM,OFAC,KYC.

Environment: Informatica 9.6, Oracle 11g, MS Sql-Server, OBIEE, Actimize, Dinodo, Touchpoint.

Confidential, San Francisco, CA

Manager | Consultant

Responsibilities:

• Assessed current ETL implementation to identify pain points, fail over recovery, and optimization of ETL jobs implemented in BODI.
• Oversaw DnB Fast-track data enrichment project of syndicate data. Implemented in informatica and Unix this project automates data movement from SFDC to Dun and Bradstreet and vice versa.
• Developed road map for implementing Early warning system that validates key metrics exposed to business and customers to identify patterns and spikes representing bad data at early stage.

Environment: Informatica 9.1, Business Object Data Integrator (BODI), Oracle, Tidal, Perforce, Confidential, Unix, Workbench.

Confidential, San Jose, CA

Data Architect (Consultant)

Responsibilities:

• Requirement gathering, development, testing, debugging of Confidential ‘s new ODS (called Foundational Data Source).
• Multitasked to work on more than one High priority projects Confidential and NetSpace Locator.
• Served as Analyst & Developer for locator project to gather requirement, micro analyses of data, developing ETL’s to automatically push CVS files to Locator FTP.
• Developed mappings to bring data from Salseforce./Amazon cloud to Confidential warehouse (ETL1).
• Experience working with Force.com UI to research source data for discrepancies.
• Worked with Sales f orce to create test scenarios and check if data flows to ODS.
• Extensive experience developing mapping based on subject area and grouping them using worklets.
• Developed Audit mapplets.
• Implemented error logic and reconciliation process.
• Implemented Incremental logic to consolidate data from legacy and new cloud system.
• Designed and developed workflows that would maintain history on transactions similar to SCD2
• Created tasks that would automatically send email alerts when jobs fail.
• Performance tuned initial load workflows and incremental mappings.
• Developed concurrent workflows to improve performance.
• Extensive experiencing using routers, update strategies, lookups, SP transformation, sequence generator, aggregator, normalize, joiner, expression transformation.
• Have implemented Source driven methodology for incremental loads.
• Performed admin tasks like migrating all repository objects from Development environment to Staging environment using pmcmd command.
• Mentored junior team members, provided guidance to complete the deliverables in time.

Environment: Informatica Power Center 9.1, Confidential, Amazon Cloud, Oracle 11g, SqlServer 2008,Terradata, HP Quality center, JIRA, $U, TOAD, ERWIN, MQ series, XML, Unix, Windows