SUMMARY

• Over 10 years of progressive experience in various roles involving Technical Lead, Technical Business Analysis and Leading applications built on Oracle, PL/SQL, ETL technologies (Informatica, SQL Loader), Data warehousing, Control M.
• Started as a Database Developer and progressed to a Technical (Database and ETL) Lead/ Business System Analyst role acting as a liaison between business and IT and leading projects through successful implementation.
• Possesses outstanding analytical and communication skills.
• Excellent SQL skills and very strong ETL and data warehousing experience.
• Go - getter and a very quick learner delivering quick and high quality results.
• Working with reputed firms in a Co coordinating role for 7+ years has built a strong business background, which coupled with technology foundation helps effectively bridge the gap between business and IT.

PROFESSIONAL EXPERIENCE

Confidential, NC

Data Analyst and Development Lead

Responsibilities:

• Collaborate with Business, Business Analyst, Solution Architect and Third Party Suppliers to get the requirements
• Document a Technical Design depending on the requirements and explain it to the development team
• Leading the development and deployment activities
• Deep diving into data to understand issues or data requests raised by the business; Writing complex SQL queries required for the analysis.
• Writing sql loader control files for data loads, complex PL SQL Packages, Stored Procedures, Triggers, Views etc.
• Performance tuning using partitions, parallelism, indexes, used explains plan, forcing a plan, gather statistics, hints, pinning etc.
• Analyzing the production issues and leading them to successful closure
• Leading the UAT (User Acceptance Testing) activities

Confidential, NY

Reporting and ETL Lead/ Technical Business Analyst

Responsibilities:

• Technical Business Analysis for maintenance, support and other BAU activities for ALGO (system for collateral management of OTC trades)
• Involved in the end to end development of the Collateral Management System for Repo trades.
• Worked as a Data Analyst as well as ETL and Reporting lead / coordinator in an onsite- offshore model.
• Worked with the Business to understand the requirements, identifying the data attributes required by the application and designing the upstream feeds accordingly.
• Working with the upstream (reference data systems) and downstream systems in CS to design the feeds and the interfaces.
• Participated in Design and Architecture meetings and proposed technical solutions to address business requirements
• Worked mainly on Reporting, Reference data, Calculation engine, Call processing workflow, inventory management modules for the CMU.
• Used Informatica for ETLs and Crystal Reports as reporting tool.
• Involved in writing Functional as well as Technical specification documents.
• Involved in database architecture design.
• SQL scripts for creating Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
• Developed and modified PL/SQL packages, procedures, functions as per requirement.
• Wrote complex SQLs using various joins, sub queries, inline views to retrieve data from various upstream systems for data analysis.
• Responsible for data analysis, data governance, data management etc.(Reference data and Master data)
• Creating weekly status reports.
• Conduct and support User Acceptance Testing.

Confidential

Technical Lead

Responsibilities:

• Leading a team of 3.
• Development (PL/SQL procedures, UNIX, sql loader etc.)
• Maintenance and support of the data mart.
• Responsible for handling technical and other programming issues.
• Database management by creating table spaces, allocating table spaces, partitioning.
• Writing jobs for database maintenance eg. for creating new partitions and purging old ones, collecting statistics.
• UNIX shell scripting for calling sql loader scripts, sql scripts.
• Writing complex sql loader control files for loading data from various sources feeds of various formats to one or more tables.
• Worked extensively on Ref Cursor, External Tables, Collections (Nested Tables and Varray) in complex backend packages.
• Creation, scheduling of jobs in Autosys.
• Developed complex Informatica mappings and implemented SCD type-I, Type-II and Type III mappings to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations.
• Created and Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Created synonyms for copies of time dimensions, used the sequence generator transformation type to create sequences for generalized dimension keys, stored procedure transformation type for encoding and decoding functions and Lookup transformation to identify slowly changing dimensions.
• Fine-tuned existing Informatica mappings for performance optimization.
• Worked on Informatica Designer tools - Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Developer and Server Manager to create and monitor sessions and batches.
• Production support and job monitoring
• Fixing production issues
• Client Communication
• Conducting Knowledge Transfer sessions.

Confidential

Sr. Developer

Responsibilities:

• Involved in the requirement gathering and analysis.
• Created technical design documents.
• Worked with dimensional modeling.
• Worked with Facts, dimensions, snowflake schemas.
• Worked with factless facts, non-additive facts, junk dimensions, conformed dimensions, look up and agreement tables.
• Worked extensively with slowly changing dimensions - SCD type 1, type 2 and type 3.
• Designed the ETL for STG and DW Areas.
• Designed the ETL processes using OWB 9iR2 to load data from multiple sources into the staging area.
• Developed mappings using OWB for data loading. Created Process flow, scheduled & monitored session.
• Designed the LDM and KPI
• Test Cases creation.
• Testing

Confidential

Developer / Sr. Database Developer

Responsibilities:

• Analysis of the requirements.
• Estimations, Prototype creation using front page.
• Involved in the database design using Erwin.
• Generated SQL scripts for creating Tables, Views, Primary Keys, Indexes, Constraints, Sequences, Materialized Views, Synonyms.
• Developed and modified complex PL/SQL packages, procedures, functions, triggers
• Wrote complex SQL queries using joins, sub queries and correlated sub queries, inline views etc. DDLs, DMLs, Dynamic SQLs
• Scripts for data auditing
• Used Explain plan, indexes, hints, partitioning for performance tuning.
• Debug, testing Pl/Sql packages.
• Deployments