Ragupathi Elumalai

• Collaborated with TI department to develop infrastructure build-out strategy and outline project scope for NPT/DC Exit initiatives. Notable projects include CDM, CAPS, CMDM, CSDR DBaas, CSDR Informatica, Supervision and Registration disclosure Applications.
• Planned and implemented patches and upgrades to system hardware and software thereby eliminating more than 5000 security vulnerabilities for various applications.
• Coordinated several operational risk deliverables including audit issues for multiple Risk and Finance Applications
• Champion SDM Agile practices and helped team to integrate with JIRA reporting to process 100s of support requests.
• Saved $100,000 by implementing cost-saving initiatives by decommissioning unwanted databases, applications and file systems. Notable projects include SafeAct, AIM, ABT, RAR,POP applications.

• Spearheaded procurement of Investran data feed for Volcker Banking Book models
• Received KT from only contractor in team and managed very critical Associate Investment Monitoring surveillance system that generates alerts over 1000 per day.
• Resolved Core BAU issues and recommended actions based on production and GBAM operational trend reports.
• Participated in disaster recovery testing of GBAM Operational Dashboard.

• Conducted Proof of Concept research, gathered information from multiple Test Data Automation(TDA) tools such as TOSCA and Delphix and presented results.
• Developed innovative CFT wide SLA automation new product offering which monitored over 36,000 daily jobs and also can scale to enterprise level.
• Successfully led EDM/DSA Project and setup KBE's/KDE's and Data Lineage process
• Participated and leveraged CICD tools such as uBuild/uDeploy/XLR for GBAM Dashboard.
• Conducted market research and demo of Actifio, Solix, Computer Associate's TDM and Informatica TDA tools

• Participated in Informatica 9.6 and CSDR Exadata migration
• Participated in Data Sourcing Analysis, Becubic Scanning of CSDR/CDM.
• Continued to enforce DQ Standards in all new data procurement projects
• Build new capabilities in GBAM Dashboards such as Data Load Routines and integrate monitoring of new applications such as Corkite, SMARTS
• Participated in ADS Data Analysis, Enterprise DQ SQL Code and Result reviews

• Stood up Corkite 2.0 new infrastructures quickly for Database,ETL,Web and Autosys.
• Successfully re-engineered Quartz Python structure into Oracle database models within very short span of time and performed one time data loads
• Proved successful working within tight deadlines and fast-paced atmosphere and project was delivered 20% ahead of time.
• Demonstrated proficient leadership skills to build competent data teams

• Determined root cause of data quality errors and recommended long-term solutions.
• Led operational team in development, rollout and management of new preventive data controls across all 900+ inbound and outbound feeds including FTEN , RAM.
• Mitigated operational risks by overseeing adherence to DQ standards at the UAT sign off stage itself.
• Single handedly driven entire vision for state of art GBAM Operational Dashboard web application that track DQ metrics from raw Data files, Autosys, Informatica and Oracle database that can solve number of complex day to day problems.
• Empowered Business Analyst, ETL developers, QA Testers and Production Support team members and brought transparency to internals of very complex 15TB Compliance Surveillance Data Repository.
• Spearheaded cross-functional initiatives such as EDM/KBE/KDE for 13 AITs and Data Load Routines within GBAM Dashboard.

• Resolved Trade Surveillance Tier 3 issues and recommended actions based on production and GBAM operational compliance reports.
• Demonstrated proficient leadership skills to motivate and build competent onshore/offshore L3 support teams.
• Collaborated with senior management to develop strategic initiatives and long-term goals such as upgrade to Informatica and underlying hardware.
• Participated in disaster recovery tests
• Led team to establishing standards, determining specifications and creating Service and Operational Level Agreements (SLA) with upstream and downstream data providers.
• Identified gaps in ETL process controls and fixed 1000's of files for data accuracy and consistency. Also implemented preventive and detective health checks and alerts.
• Performance tuning to Informatica processes, database procedures and database optimization that lead to load time reduced by 65%(13 hours to 5 hours) and Actimize report time enhanced by 30% and DB space reduction of 80% using compressions.

• Used critical thinking to break down complex problems arising out of Merrill-BofA Merger, evaluate solutions and make decisions.
• Built consolidated data warehouse solution for three LOB such as Investment, Corporate and Commercial Banking client and Pipeline data
• Worked extended hours across night, weekend and holiday shifts to achieve Legal Day 1 and 90 reporting requirements.
• Worked within applicable standards to build out Integrated Management Reporting Iteration 1 and 2
• Provided SME knowledge on Navigator data for Bankers, Organization and Client dashboard
• Collaborated with cross functional team members to achieve target results.
• Provided Tier 1 IT support and Increased customer satisfaction by resolving issues

• Reconstructed legacy Investment Banking Data Warehouse systems to increase efficiency by 50%
• Managed over 10 resources that included consultants, third-party support providers(MDM TIBCO) and also offshore resources from MLITS, India.
• Investigated system issues and implemented resolutions to reduce downtime.
• Created Data Warehouse operating procedures to strengthen controls.

Annual Disclosure(AD)

• Interacted with internal customers to understand business needs and translate into requirements and project scope.
• Derived conceptual ETL designs from business objectives to deliver Annual Disclosure Reporting according to specifications for usability, performance and functionality.
• Assigned tasks to onsite and offshore team, managed end-to-end deployment and delivery
• Collaborated with vendor to streamline offshore development footprint.

European Client Profitability(ECP)

• Provided Tier 1 daily support with escalated ticket resolution and liaised with business and technical leads.
• Worked closely with test, development and requirements team members to analyze, investigate and resolve common issues.
• Reduced processing time by analyzing job schedules and implementing appropriate modifications.
• Identified root causes of recurring problems to implement effective solutions.

Claims Management Reporting(CMR) for Farmers Insurance

• Provided SME expertise in turn-key project that integrated CRN-Siebel,FileNet Insurance claims system into a Data Mart
• Installed, integrated and deployed Cognos Suite 7 reporting and ETL product in client environments.
• Managed project scope, schedule, status and documentation.
• Automated Manual touch points and Error notification
• Worked closely with offshore/onsite teams to define and prioritize partner feature requests
• Assisted QA team that uses SQL, Test Director

Web Report Builder Tool for United Technologies

• Single handedly drove Report Builder tool development for Employee Self Service (ESS) that serves 150,000 employees with their Salary, Benefits, Appraisals, Job Posting and Trainings.
• Responsible for end-to-end development, QA testing and Delivery of various modules such as SQL Query Builder, Meta Designer, Report Scheduling & Execution, Report Layout Formatter & Security Builder

Digital Risk Manager Suite for GE Aircraft

• Built databases and analytical table structures to provide Engine Services, Engineering, and Sales department one common integrated cost-forecasting model which is expected to produce one consistent output
• Designed data models using ERwin for complex analysis needs.
• Identified issues within databases, performed troubleshooting and implemented effective solutions.

Order Release Automation for GE Power

• Provided accurate estimates by defining scope, timelines, potential setbacks and limitations.
• Planned, designed and scheduled phases for large Data Mart ETL project using Perl, SQL*Loader and PL/SQL scripting. This sources from 4 systems BOLD, BUBS, CMS, and RISK and also send to 2 external systems PPSD, OSS using UNIX scripting.
• Met project deadlines without sacrificing build quality and adhere to organization's QMS metrics.
• Reduced overall QA testing hours 50% by writing and optimizing automation test scripts in SQL.

Digital Cockpit Data Warehouse for GE Aircraft

• Developed data pipeline from OSB and Non-OSB sources using PL/SQL and Informatica 5 so that Customer satisfaction manager can address customer queries on Overhaul, Component repair, Accessories.
• Performed in-depth gap analysis using SQL Impact in order to migrate Smarts 2000 reports into Cognos.

Cold Rolling Mill Information Systems (CRM-IS)

• Designed and Implemented Lab Management,Order Allotment and Dispatch Management Systems with guidance from POSCO, S.Korea.
• Proposed technical feasibility solutions for new system designs and suggested options for performance improvement of technical components.
• Supported system users, educating users through user manuals

Continuous Galvanizing Line Information System(CGL-IS)

• Built databases and tables to support web applications, L3 to L2 telegrams, IBM and SAP system interfaces with 99.99% uptime
• Set up and controlled user access levels across databases to protect important data.
• Utilized RDBMS tools and utilities to monitor, tune and optimize system performance.
• Created and updated database designs and data models using Designer 2000