SUMMARY

• Over 3 years experience in all phases of Software development lifecycle, from gathering requirements to testing and production support (Oracle SQL/PLSQL, Teradata, Micro strategy 10.x/9.x, COBOL, JCL and DB2).
• Excellent skills in Oracle SQL/PLSQL, Teradata, DB2, COBOL and JCL.
• Expert in analysis of existing system, data model and data flow of the architecture in banking domain.
• Expert in using analytical functions in oracle SQL and Teradata.
• Writing complex SQL queries to compare the data between source and target systems.
• Worked extensively in SQL performance tuning.
• Created Functional and Technical Mapping specifications documents.
• Strong experience in understanding Business Applications, Business Dataflow and Data relations.
• Strong Knowledge of Dimensional Data Modeling - Physical and Logical Data Modeling using Erwin 4.1/3.x., Star Schema modeling and Snow Flake Schema modeling.
• Experience with Waterfall and Agile model.
• Perform all Oracle and DB2 data analyst related activities independently and great troubleshooting skills in mission critical data analyst production environment.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Managing reports, analysis and decision-making for a change request.
• Very good in system documentation and knowledge gathering for new projects.
• Strong understanding with the software development lifecycle (SDLC).
• Extensively worked in the development projects in the Banking and Finance vertical.
• Able to play a key role in analyzing problems and come up with creative solutions as well as producing methodologies and files for effective data management.
• Good ability to quickly grasp and master new concepts and technologies.
• A fast learner who is a practical and ingenuous problem solver.
• A fluent and articulate communicator, flexible and responsive.

TECHNICAL SKILLS

Technical Skills: Mainframe, Data Warehouse Architecture

Tools: SQL Navigator, Toad, SQL Developer

BI Tool: Micro strategy 10.x/9.x

Methodology: Agile & Waterfall

Programming Languages: COBOL, JCL, C, VSAM

Other Utilities: Endeavor, TSO/ISPF, SPUFI, Expeditor, Interest, File Master, DMLO, OLQ

Databases: DB2, IDMS, SQL Server, Oracle SQL/PLSQL, Teradata

Test Management Tools: HP Quality Center, ALM

Operating System: Windows 98, 2000 & XP

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• As part of Requirements Analysis, the requirements were analyzed and the discrepancies were identified.
• Performed detail data profiling for production support tickets to resolve the issues.
• Created new enhancement mapping document from source and target systems.
• Involved in SQL performance tuning.
• Interaction with onsite team for gathering requirements, to meet targets and deliver solutions in accordance with Confidential quality control standards and business practices and procedures.
• Created Technical Mapping document.
• Batch Jobs were automated to reduce the manual intervention.
• Developed business oriented data dictionaries.
• Through Knowledge Transition, domain and technical knowledge were imparted to the new entrants and also fellow team members.
• Status Reporting - Reports to track defect status were generated and the process was sped up.

Environment: CICS, COBOL, JCL,SQL Navigator, DB2 and Oracle.

Confidential

Mainframe Developer

Responsibilities:

• Involved in different phases of the software life cycle like analysis, development, testing and implementation.
• Responsibilities would typically include understanding of business requirements, preparing of low level design document, coding and unit testing.
• Analysis of impacted applications
• Data support for User acceptance testing
• Proactive involvement in training the new joiners
• Effective Communication with onsite counterparts.
• Additional responsibilities include task allocation, status reporting, peer review, queries resolution, task implementation and quality compliance.

Environment: CICS, COBOL, JCL, SQL Navigator and DB2.

Confidential

Mainframe Developer

Responsibilities:

• Involved in analyzing and fixing the Production Errors as and when generated in the CMR System.
• Also involved in Analysis, Design, Development and testing of various programs as part of the enhancements.
• Consolidating the Requirements into a project specification for the enhancement tasks/bug identified.
• Identified existing production issues and provide the solutions to resolve the issues.
• Writing complex SQL queries to validate data for unit testing.
• System Understanding and domain knowledge to handle the requirements.
• Developing the necessary modules as per the Technical & Business Requirements.
• Responsible for defect free individual module deliverables on time.
• Responsible for tracking the defects and various tasks using Prolite.
• Provide permanent fixes for recurring issues in the system.
• Involved in collection of Metrics for Production fixes, handling tele-conferences and discussions with the Onsite Team/Client and generate Weekly Status Reports.

Environment: CICS,COBOL, JCL and DB2.