SUMMARY

• Technical - Lead Projects carrying 14+ years of experience in Banking and Financial services domain with strong analytical & interpersonal skills, ability to interact favourably with clients, senior managers and team members.
• Strong customer interaction skills and excellent expertise in Requirements gathering, Analysis, Estimation and Capacity Planning
• Extensive experience in working with a variety of projects involving Global Banking, Financial Institutions in APAC & WHEM & Retail industry.
• Very Good Exposure in working with JDA Enterprise Planning application for Retail Domain.
• Hands on Experience in Data Warehousing/ETL programming using Oracle
• PL/SQL and Enterprise Planning of data warehouse project tasks such as data extraction, cleansing, transforming and loading Warehouse using Oracle SQL, SQLLoader, PL/SQL Procedure/Functions/Packages.
• Highly proficient in Oracle SQL Query Performance maintenance - tuning and PL/SQL optimization using SQL Trace, Explain Plan, Profiler, Indexing and Hints
• Highly proficient in creating ETL jobs with oracle External tables worked with Dimension tables, fact tables.
• Defining, designing, developing & optimizing ETL processes for enterprise data warehouse
• Presently working as the Lead Consultant and coordinating the work with multiple region developers from NA,EMEA and APAC
• Highly skilled and shown eminence in all phases of a Software Life Cycle - Requirements, Analysis, Documentation, Design, Build, Testing / Support and Comprehensive Deployment Planning.
• Sound techno-functional expertise in dealing a variety of Reporting Tools, Database Solutions and Business Problems
• Experience in build and maintenance of a highly complex Retail Banking & Over the Counter derivatives (OTC) Applications
• Possesses strong technical expertise in Oracle stored procedures, packages, and functions
• Strong knowledge in Oracle cursor management, global temporary tables, exception handling
• Working knowledge in designing and developing data architectures using common and standard data modelling techniques
• Experienced in creating data flow diagrams, data dictionary, ER models and has exposure to varied database design and normalization techniques
• Agile KANBAN process has been adopted for production support initiatives e.g. Automation tasks

TECHNICAL SKILLS

• Oracle(SQL,PL/SQL), Performance Tuning
• SQL PLUS
• SQL loader
• MS SQL Server 2012IBM Netezza Database, SSIS Packages, Visual Studio 2012,Hadoop No SQL DB
• MS Visio 2013
• Microsoft Project Planner (MPP)
• SQL, PL/SQL, Unix Shell Scripting,IBM Netezza Database, Aginity Workbench for Netezza V4.7
• JDA Enterprise planning V7.9
• Golden Source 8.3.1.01REL (Workflow, Mapping Designer, JMS Publishing),SQL Loader,Data Mart.
• Erwin8.2
• Autosys, Control M
• Jasper iReport, Core Java Programming Basics, Tortoise SVN,ALM, Actuate Business Intelligence and Reporting Tools (BIRT) - IBM

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer

Responsibilities:

• As a Production support Lead on the project, I have been coordinating with the offshore team and interacting with product people for issues/Incident of application
• I have been involved in understanding the requirement of automation and translation both some of the manual work in to ITRS automation tool.
• Demonstrated expertise utilizing ETL tools, including SQL Loader systems like SQL Servers, and Oracle
• Exceptional background in analysis production issues and suggesting to the Dev team for permanent fixes.
• Strong leader with experience training developers and advising technical groups on ETL best practices
• Team player with excellent communication and problem-solving skills

Confidential

SQL Developer

Responsibilities:

• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
• Demonstrated expertise utilizing ETL tools, including SQL Loader systems like SQL Servers, and Oracle
• Strong leader with experience training developers and advising technical groups on ETL best practices.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Team player with excellent communication and problem solving skills

Confidential

SQL Developer

Responsibilities:

• As a Sr. Netezza/PLSQL Consultant working with internal customers collaboratively gather information and gain complete understanding of existing data, models, processes and other variables required to perform data/code conversion activity, focused on providing well-conceived technical support in converting existing MSSQL code to Netezza, Testing with the team for accuracy of data between MSSQL and Netezza databases.
• Worked with Netezza External table to export data to the CSV files
• Worked with Workbench Command line tool to replicate the jobs from SSIS packages to Netezza.
• Written with Netezza User defined function using C++ and deployed in database for ease of use.
• Creating Stored procs,UDF,DDL etc.
• Supported ad hoc analyses as assigned by management
• Fully accessed and understood data sources for use in analysis including EDW, Unica, CRM and other systems within the company
• Worked closely with various IT team to implement the procedures in production.