Development, Support, Automation, Analytics & Reporting

Handling two projects of Development & Production Support Teams as Lead Analyst with 20+ team members. 

Working on Business & Impact Analysis, Data Modeling, Database structures, ETL Designing, Development, Deployment, Reporting, Shell Scripting, Performance Tuning, Incident Management, Resource & People Management and Procurement management

Responsible on 14 applications of Commercial & Investment Banking Data management projects on their Development, L2/L3 Production Support & Maintenance, Data processing, Performance Tuning, Database Tuning, Break fixes, DR Sync & BC Events and daily Data loads monitoring of all the applications.  

Worked on the data deals with Home sites, Opportunities, Contacts and other data flows from multiple application servers to SQL server DB and SFDC with synchronizing its business processes. Worked as data architect on data migration and SFDC Data model, creating ICS & ICRT tasks & processes and the process automation using scrum sprints.

FEDEX-MISA (Management Information System - Archive) is an international clearance archive that retains international shipment data for customs audit purpose for all countries. MISA is a distributed system, designed for historical clearance archival and reporting.

Creating design specification. Analysis of existing Informatica System and convert Sybase code to Teradata as per the requirements. Migration and conversion of Informatica mappings from Sybase to Teradata database. Creating scripts for loading data to target data warehouse for BTEQ and Fast Load. Generate Hyperion reports in both Sybase and Teradata sides using scrum & sprint methodologies.