May 2014 – Jan 2017 · 2 yrs 8 mos · Bangalore

• Led technology development for the BCE data mart (Morgan Stanley, Consultant via Synechron).
• This data mart manages exchange/vendor fees and client charges, identifying cost-saving opportunities and optimizing client negotiations.
• Built and automated ETL processes (Informatica) to extract, transform, and reconcile high-volume data across various sources.
• Performed data quality analysis, resolved time-sensitive issues, and ensured system performance (databases, Informatica).
• Onboarded new asset classes and automated data archiving for efficient reporting.

Feb 2013 – May 2014 · 1 yr 3 mos · Bangalore

• Role: Associate Developer
• Project: DAC (Data Acquisition and Control)
• Description: It is a typical financial Dataware housing project deals with the transactional and positional data coming from different suppliers and different sources (financial systems). It acts as a bridge between the upstream sources (suppliers) and downstream consumer (different consumer applications).
• Responsibilities:
• Designed and implemented Reconciliations at different granularity.
• Worked solely on Framework re-engineering project at same time ensuring nothing is breaking in the process.
• Partnering with Plan, Operations and converting the Business requirements to functional and technical specifications
• Involved in optimising the ETL-Process by identifying the bottlenecks and provided appropriate solutions for the same.
• Worked as Business analysts for few tasks and delivered them on time.
• Lead the entire framework of Cash Securities, MRI, DPS, Reconciliation and F&O.
• Involved in finding out the Issues at Business Process and in the code level and suggesting the appropriate fix where ever is needed.
• Involved in attending the project meetings, requirement gathering, managing and guiding the team to meet the deadlines on time and preparing monthly and annual metrics of the team .
• Involved in redesigning of process by fixing the issues that are existing and automation of process where ever it is possible.
• Involved in on boarding/Off boarding the supplies into/from the system.
• Played tech lead role and handled 5 people under me.
• Created Business Objects web intelligent Reports using universe on need basis.
• Environment: Informatica 8.6.1/9.1.0,Business Objects Reporting, Oracle 11g,UNIX,HP QC,Autosys,Sql/PL/Sql,Oracle Web sphere .Ear File Deployments,qlikview

Apr 2011 – Jan 2013 · 1 yr 9 mos · Bangalore

Jan 2010 – Mar 2011 · 1 yr 2 mos · Bangalore Urban, Karnataka, India · On-site

• Western Power (Australia)
• It mainly deals with the distribution and transmission systems of Western Power. This project will implement the Dataware House Solution that enables the end user to take future decisions to manage the assets of the organization and to know the utilization of organization assets in an effective manner. The design of the system is to integrate various OLTP systems and keep it in a single warehouse, for the reporting needs.
• Involved in understanding the requirements and designing the data model using power designer
• Developed the strategies like CDC (Change Data Capture), Auditing, Recovery Strategy etc.
• Involved in preparing the summary tables to meet reporting requirements efficiently.
• Prepared standard document and guide the team members to meet the deliverables in time.
• Developed complex mappings .created workflow connections, session parameter files etc.
• Involved in movement of code from development to SIT and from SIT to UAT and prepared the deployment document for UAT.
• Involved in developing of stored procedure for CDC, Auditing etc.

Sep 2008 – Dec 2009 · 1 yr 3 mos

• AP Civil Supplies Department, India.
• Project: Beneficiary Management System
• Developed a web-based system for the Andhra Pradesh government to manage ration card distribution. This system tracks beneficiary data, including income eligibility and biometrics (like iris scans), to ensure proper allocation of rations. Designed for scalability, it has a central server that connects to client applications in over 100 centers. The system also implements different user roles for efficient administration and monitoring, allowing authorized personnel to track operations and generate reports.
• Responsibilities:
• Involved in full stack development of windows application End-End.
• Developed User controls such as Image cropper and Image Optimization tools, internet connectivity check module, application version check module etc.
• Worked on ODAC (Oracle Data Access Components) Tools & wrote complex dynamic stored procedures Pl/SQL in oracle 11g.
• Developed web-based reports in asp.net.