Led the business requirement and data analysis for onboarding mTRADE in CIB Whole Loan Trading Program.• Worked with key business partners on collecting reporting requirements for Mortgage Trading program.• Met with business team to onboard new General Ledger accounts for the new SOR.• Created the BRD for Customer Facing Recon which is used for reporting variance.• Created BRD for Operational Finance Dashboard to include new SOR data related job processing.• Created Accounting Engine process flow for Journal Entry sub-ledger posting, data quality and consumption.• Engaged in Production Support on call monitoring for Accounting Engine process.Environment: Tableau, Oracle, Hive, Teradata, Python, Agile JIRA, Power BI, SharePoint, ServiceNow

Led the key role in data transformation for the card services business.• Created new data model for moving data from different source systems into a common pool.• Liaison with business and technology teams to identify functional requirements and build system solution design.• Analyzed legacy data systems for transformation and designed solutions for integration into the new data model.• Led the Agile scrum team creating epics and stories for the sprint cycle to meet various business milestones.• Created use cases from business context to deliver data centric approach in data architecture.Environment: Tableau, Oracle, SQL Server, Teradata, Python, Agile JIRA, Big Data, SharePoint, ServiceNow

Work with the credit data mapping for the data lake integration from upstream source systems and roll out data for downstream business consumers within the bank.

Lead the development and delivery of Enterprise Risk Aggregation for Portfolio Concentration Reporting, SCCL & Credit Risk Reporting, Risk Appetite Metrics, Risk Exposure Reporting and Legal Lending Limit.• Re-engineered a complex enterprise risk aggregation data warehouse to enable better integration and simplicity of data usage for business. • Liaison with source and business partners to include data from new System of Records and Lines of Business for enterprise risk aggregation analytics.• Process data from source systems for Enterprise Risk Aggregation Teradata Warehouse to facilitate data analytics and business reporting.• Interact with technical and business partners of source systems and create ETL data mapping for risk aggregation and portfolio concentration.• Lead the Technology Sync meetings with business and source data partners to resolve issues and plan for upcoming production releases.• Worked on Recovery and Resolution Plan Releases to meet regulatory requirements from a data warehouse and reporting perspective.• Lead the UAT and Production Enterprise Metadata Hub validation for Enterprise Risk Aggregation Project Releases.• Maintain and review OLA's and SLA's with upstream source partners for timely data delivery to Enterprise Risk Aggregation data warehouse.Environment: Teradata, ERwin, SQL Server, Abinitio, Tableau, MicroStrategy, Autosys, MS Project, Visio, JIRA.

Worked with multiple clients in the area of Business Intelligence and Data Analytics, leading the Business and Systems integration efforts.Details elaborated below for each Client Project.

Coordinate multiple projects within the Card Services ETL Data Mart group to ensure smooth delivery of Big Data implementation initiatives.• Served as liaison for various projects like SAS Grid, Fraud, CRH, Autosys and Talend.• Communicated with ABIT Share services team (ETL, Infrastructure and Database Team) regarding requirement changes/ design updates / outages/ fire drills/ project timelines and delivery status.• Created and revised project plans in Excel and MS project to track project status.• Identified issues, escalated when necessary and negotiated resolution to complete tasks in established timelines.• Collaborated with management and architecture teams in evaluating Hadoop/ Vertica, and initiated POC’s.• Conducted weekly brainstorming session with key stake holders to mitigate any issues.• Created spreadsheets as user interface for the business users to confirm on the data required for migration.• Served as the point of contact within ABIT shared services for Project team (Testing and Development) and Technology partners to coordinate the project delivery efforts, track progress and manage overlaps.• Awarded Accenture performance points for successful collaboration with client teams and delivery of projects.Environment: Hadoop, Vertica, Talend, Informatica, Autosys, MS Project

Analysis, design, development, testing and defect triage within the data warehouse database.• Conducted JAD session with business users and technology teams for modifying pool processing logic to exclude loan re-adds when removed from a pool due to collateral maturity.• Developed PL/SQL procedures for the business requirements.• Analyzed payment processing logic to include new business rules and triaged new issues for development team.• Trained new associates onboarding project and walkthrough business users with new system functionalities.Environment: Oracle, Autosys, Toad 9.5, PuTTY, ClearCase 7.1.1.4, ClearQuest, BuildManager.

Integrating data from alliance partner sources into the Clinical Aggregation Layer data model.• Documented changes discussed in meetings and implemented new data mappings to update data model.• Bridged the gap among various upstream/downstream data points in CAL by creating data flows for interfaces.• Facilitated to lead discussions that result in consensus and buy-in.• Extensive experience in Multi-Dimensional Data modeling using Enterprise Architect.Environment: Enterprise Architect 9, Informatica, Autosys, Oracle

Data modeling of Merck animal health data in SQL Server to service MicroStrategy report development.• Analyzed rebate data in conjunction with EDI data feed to provide insight into key performance metrics.• Modeled multi-dimensional data framework for building report dashboards in MicroStrategy platform.• Wrote complex SQL queries using temporary tables for report data validation and data reconciliation.• Conducted business analysis meetings with animal health divisional managers to encapsulate business data rules.Environment: MicroStrategy 9.2.1, T-SQL, SSIS, SSAS, SSRS, CA ERwin r8, SQL Server 2008 R2, Excel

ETL development and MicroStrategy business data analysis for the Time Warner Cable digital conversion project. • Conducted business analysis meetings to design and document business intelligence reporting solution.• Analyzed data in the data warehouse for MicroStrategy report data mapping to meet client dashboard metric requirements.• Performed detailed Data Analysis to identify data sources, data gaps, redundancies & anomalies.• Reviewed the Informatica mappings and workflows for ETL data transformations in the Data Mart.• Reviewed Informatica IDE and IDQ tools for data profiling.Environment: MicroStrategy 9.2.1, Netezza 6.0.3, Oracle, Informatica PowerCenter 8.6.1, WinSQL 9.0, MDM

MicroStrategy and Informatica business intelligence development in the ECDM project for GCCIBT group.• Installed and configured MicroStrategy 9.0.2 products for the ECDM project at Bank of America.• Designed the logical data model and created the MicroStrategy project for ECDM reports.• Created MicroStrategy Reports and Dashboards for EPI data hub management.• Reviewed the ETL mappings, sessions and workflows for loading data into EPI target tables.• Reviewed UNIX shell scripts that send out an E-mail on the success/failure status of process indicating the destination folder where the files are available.Environment: MicroStrategy 9.0.2, Netezza, WebSphere, Oracle, Informatica 9, Autosys, Linux, Sun Solaris

Lead the development and delivery of Business Objects reports within Global Finance Technology.• Led the financial reference data universe/reports design for international demand deposit system and merger projects. • Architected complex Business Objects universes, reports, dashboards, managed repository and users.• Participated in fit/gap analysis of functional requirements for SAP and Legacy systems financial account mapping.• Designed, developed and tested SQL queries to implement complex business rules.• Worked with business/technology teams to identify data and reporting requirements/issues for Washington Mutual - Bear Stearns merger project and design Reporting solutions.• Led the XI R3.1 upgrade project for the financial accounting reports in Global Finance Technology.• Created test plans, reviewed test cases and assisted business users to complete UAT testing.• Supported go-live production testing and completed root cause analysis for production issues.• Reported daily project status updates, coordinated data refreshes and managed offshore resources.• Participated in setting up Performance goal/objectives and Performance Appraisal.• Recommended and implemented new standards/development guidelines as best practice to improve processes.Environment: SAP Business Objects 3.1, XI-R2, Designer, Dashboards, Cognos 8.3, Informatica 8.6.1, Control-M, Visio, Crystal Reports, Oracle10g, Toad, UNIX-AIX, Project 2007, Clarity, ERwin, LiveLink and Mercury QC

Build reporting solutions for the BI competence center.• Designed and developed Base Revenue Report solutions in Business Objects XI-R2 for operational performance analysis.• Designed Business Objects Universe to link data from heterogeneous source systems.Environment: Business Objects XI-R2, Oracle 10g, Autosys, Toad, UNIX, Windows.

Handle reinsurance application systems, reporting and data requirements for Underwriting, Claims and Operations department.• Recognized for outstanding internal customer service in 2006 for consistently delivering projects in line with CMMI quality standards meeting IT goals and milestones.• Established Universe design applying multi-dimensional data modeling concepts to address transparent retroceded business reports that track policy movement and claims data distributed in multi-tier levels governed by special rules.• Scheduled daily control and monthly perpetual ledger data reconciliation reports to satisfy Sarbanes-Oxley requirements.• Eliminated statement processing errors by implementing Oracle stored procedures and packages to validate business rules. Created sub-ledger data exception reports to analyze the root cause, initiated a project, formed a team and conducted Joint Application Development (JAD) sessions with key business users. • Developed the Admin Rules system using Java technologies including XML, XSLT, Eclipse and Weblogic.• PL/SQL code for OFAC/AML• Elicited requirements, documented current business process and automated the underwriting workflow which increased productivity 30% by enabling robust turnaround on client decisions.• Reduced processing costs 25% by redesigning monthly billing statement reports to automate manual processes.• Increased productivity of underwriting systems 10% by automating the handling of application downtime. Took initiative to resolve this issue by designing and developing an alert system to monitor and automatically notify events to staff.• Collaborated with external vendors as SME for successful outsourcing and training of reinsurance administration support systemsEnvironment: Business Objects XI-R2/6.5, PL/SQL database programming, T-SQL, Visual Basic, ERwin, Project 2003, Quest, Java, Eclipse, XML, XSLT, WebLogic, LiveLink, Visual C++, Oracle 9i/10g, SQL Server 2000, Windows, Unix

Lead the design and development of real-time application systems and reports for Carpenter Steel melting shop.• Engineered data extraction, transformation and loading to facilitate data flow between SQL Server and Oracle database using database pipelines. This made real-time application data available to analytical systems.• Designed and developed cross-tab reports to analyze and alert variances in melting shop furnace material mixing.Environment: Oracle, SQL Server, PL/SQL, T-SQL, Access, PowerBuilder

Managed and mentored the software development teams working for multiple client projects across North America.Screened and hired developers to form teams for meeting various client requirements.

Led development of the integration module for Infoway ISP project and created GUI for Oracle database user administration.

Led an application development team in Japan to work in collaboration with CSK technical team for Yamaha Corporation.

Responsible for TMS-5 telecommunication product re-design and development for Lucent Technologies.

Developed modules for an integrated enterprise-wide computerization project for DGP Windsor Limited.

Worked on Master Data Module that was part of enterprise-wide computerization product for Lakhsmi Vilas Bank.