Professional Summary Present Employer: CGI Information Systems ( "http://www.cgi.com" www.cgi.com) - Founded in 1976, Canada based CGI (NYSE: GIB) serves 5000+ clients worldwide on various technology areas. * 2017 Annual revenues of CA$ 10.8 Billion. * 72,500+ Employees Across the globe * 100+ Office locations in 25+ Countries Experience Summary Project #2 Project Name: Sapphire MIS Reporting, GBA, DB Insight Client: Deutsche Bank (DB) Role: Senior Developer, Team Lead Duration: Apr 2010 - Present Description: Sapphire is an MIS reporting platform in Deutsche Bank's GPF (Global Prime Finance) business. Sapphire, a self-service solution, is an end to end solution for upper management to identify and track various client performance metrics. Helps the DB management to identify the key clients and invest in building the relations. This platform provides * Insights to management on various client vitals like Balances, P&L trends, Interest/Fee Pricing, ROA etc. * Inputs to focus on opportunity areas and key strategic relations. * Dashboards for data visualizations and Automated report deliveries. Responsibilities: * Manage Development & Production support (SL3) team, provide delivery metrics to management on project milestones and deliveries. * Understand the functional requirements and analyze the technical feasibility and design. * Responsible to develop, support and maintain the ETL (Extract, Transform and Load) processes, using PL/SQL stored procedures, functions, packages and Triggers. * DDL Creation for database objects like tables, views, materialized views * Create and modify UNIX shell Scripts to process the source/feed files. * Handle errors using Error/Exception Handling extensively for the ease of debugging and displaying the error messages in the application. * Create/Modify sql script to load data into database using SQL Loader. * Analyze application log files in Unix environment to identify application errors and bugs. * Participate in QA/UAT phases and liaising with stakeholders for business sign-off. * Responsible for deployment and post production support activites. * Provide guidance to L2 on resolving issues. * Guide Microstrategy Report developers on Query performance tuning and SQL Optimization. * Planned and coordinated Oracle database upgrade from 10g to 11g. * Planned and coordinated Database Migration from physical machine to DHS (Virtual) server. * Involve in the continuous enhancements and fixing of production issues. * Participated in Sybase to Oracle Migration Activities for DB Insight project (outside Sapphire project). Migrated the entire Sybase processes to Oracle database analyzing the Sybase objects. * Participated in Oracle Data modelling for GBA Module (outside Sapphire Project) Environment: Oracle 11g, TOAD, UNIX, Microstrategy 9 Project #1 Project Name : Client Reporting (CPORT) Client : Deutsche Bank, New York Role : Developer Duration : Dec 2006 - Apr 2010 Project Description Deutsche Bank Client Reporting (CPORT) module dealt with providing reports for DB's end clients, primarily hedge funds, with daily reports on their trading/holding. The platform was built originally for Prime Brokerage clients, which was later extended to a multiproduct reporting platform. It also helps Deutsche Bank Internal uses with their regulatory reporting requirements. CPORT interfaces with 40+ internal systems to source different types data including client static information, trading/holding information and financing/charges/commission information. Platform used Informatica as ETL tool, Oracle was DWH and Actuate/BIRT tool for Reporting needs. Responsibilities: * Understand the business requirements and converting them to Design documents. * Worked extensively in the translation of business requirement into data warehouse design and developed ETL logic based on the requirement, using Informatica Power Center 7. * Developed mappings using Joiner, Sorter, Connected Lookup, Router, Filter, Update Strategy, Expression using Informatica. * Worked with all the client components of Informatica like Repository Manager, Designer, Workflow Manager, Work flow Monitor. * Created PL/SQL stored procedures with Ref Cursors for Actuate reports. * Created DDL scripts to create tables, queries for new enhancement in the application using TOAD. * Involved in the continuous enhancements and fixing of production issues. * Creating Actuate reports as per the requirement. * End to End validation of mappings/reports and standard checks. * Creating release objects and performing post sanity checks * Peer review of mappings and reports. Environment: Oracle 9i, TOAD, Informatica 7, Actuate 8, Windows XP
Description
