SUMMARY:

• Experience of working in all SDLC stages roles. Business Analyst, Developer, Data Analyst, Quality Analyst and Testing.
• Expertise in identifying the scope of the project, Interpret Business needs, Translate them into technical requirements, Writing Use cases, Translate technical issues, fill the gap between business users and technical team, Test and validate the requirements.
• Expertise in preparing business requirement documents, Use case document and Mapping documents.
• Experience of working in Oracle 8i, Oracle 9i, Oracle10g, SQL server and Teradata databases and VB, UNIX, Autosys and SSIS.
• Expertise in Tables creation, Indexes, Constraints, Sequence, Synonyms, Stored Procedures, Packages, Triggers, Views, Materialized Views, Functions, External Tables, Joins, Global Temporary Tables .
• Extremely used the features to optimize performance like Bulk Binds, Bulk Collect, Ref. Cursor and dynamic SQL.
• Expertise in creation of table partitioning by range, list, hash, composite methods and indexes for managing large tables, normalization.
• Extreme Use of exception handling methods along with pragma exception init in order to associate our own created exception names.
• Maintain and Enhance ETL processes respected to data import and export, assembly and aggregation of data.
• Extensive experience in data transformations, conversion and interface, data loading, database modeling and performance tuning using Explain Plan, SQL trace and TKPROF Utilities.
• Expertise in using SQL*Loader for loading data into single table and multiple tables.
• Experience of data migration in Oracle, from SQL server to Teradata using SSIS/Nexus..
• Experience of code conversion from SQL server to Teradata.
• Experience of working in TOAD, SQL Developer, SQL Management Studios, SQL Teradata Developer and NEXUS.
• Expertise in UNIX Shell scripting.
• As Confidential Data Analyst, have Expertise in Coordinating with customers and staff and provide support to all data analysis. 
• Expertise in Data profiling and Data trend analysis.
• Experience in Performing audit on data and resolve business related issues for customer base. 
• As Confidential Quality Analyst, expertise in developing QA checks, edit tools utilizing comprehensive business requirements, functional documentation and processes. 
• Experience in Developing and maintaining Quality Assurance procedure documentation. 
• Involved in writing Test cases, doing smoke test as testing framework.
• Experienced in Confidential Banking Industry - Retail, Wholesale, Treasury and Credit Risk - BASEL, LCSC and HCL.
• Good organizational and prioritization skills.
• Working experience in Production, Development, Staging and QA environments.
• Exceptional ability to quickly master new concepts/Technologies and capable of working in-group as well as independently with excellent communication skills.

TECHNICAL SKILLS:

Skill-Profile : SQL, PL/SQL, VB, UNIX Shell Scripting.

Operating System: Windows, Linux, UNIX and Sun Solaris.

Databases : Oracle 8i/9i/10g, MS SQL Server, MS-Access, Teradata

Version Control Mgmt.: Harvest.

Tools : TOAD, SQL Developer, Autosys, Microsoft Office products (Word, Excel, PowerPoint, VISIO), HARVEST, Quality Center, SQL Loader, SQL Server 2005, SQL server management studio 2008, Teradata manager, Teradata SQL assistant, SQL server import/export, Teradata Fast load, SSIS, NEXUS, SharePoint.

PROFESSIONAL EXPERIENCE:

Confidential

Role: Database Analyst, Risk Analyst, Data Analyst and Quality Analyst.

Responsibilities:

• Prepare detailed technical design requirements to collect the syndicated loans from central database and transform to specific format to meet OCC and Federal Reserve guidelines.
• Create process to retrieve financial data elements from BASEL and ART (Asset rating tool) applications.
• Create process to collect the syndicated loans from LOB applications.
• Create process to Integrate loans from different SOR to single aggregation process to be managed by SME’s.
• Create source to target data mapping documents and transformation logic details to retrieve data from central database and format to meet OCC/Federal Reserve/BASEL guidelines.
• Create prototype to get the final report.
• Design and build tables, indexes, views and stored procedures.
• Develop SQL code and financial formulas to build specialized SQL reports.
• Creating reports in Excel and provide summary in Confidential PIVOT tables.
• Create Data profiling and Data trend analysis quarter over quarter to identify outliers.
• Create SQL scripts to identify missing mandatory data elements, data syntax issues and data format issues and fix them before submitting the data to Fed/OCC.
• Create test plans and SQL scripts for OCC/Fed/BASEL reporting.
• Create and update mapping tables in SQL to transform the raw data from source to specific values expected as per Fed reporting requirements.
• Carrying out reconciliation process to tally the outstanding amounts.
• Maintain and Enhance ETL processes with respected to data import and export, assembly and aggregation of data from source business systems into Confidential central data warehouse repository.
• Perform Data quality validation, analysis and research.
• Import/Export Data to/from Teradata to SQL server, Access and Excel spreadsheets.
• Code conversion from SQL server to Teradata.
• Testing, Bug fixing and Documentation.

Environment: SQL Server 2005, SQL server management studio 2008, Teradata SQL assistant, SQL server import/export, SSIS, Nexus.

Confidential

Role: Business Technology Analyst.

Responsibilities:

• Interacted with Business users to identify the business requirements.
• Created the Business requirement documents.
• Created Use cases and Mapping documents.
• Involved in UAT testing with the Business Users.
• Extensively involved in System Study & Business Requirements Analysis.
• Involved in the preparation of Functional Specs as part of the solution team.
• Co-ordination with the Business for the requirement and translate the business needs into Technical design.
• Strong analytical skills in resolving and providing solutions.
• Handling Major /Minor Enhancements for the application.
• Created detailed design documents
• Involved in the management of customer logged issues by providing priority based timely resolution.
• Responsible for tuning of SQL queries written in procedures/functions at the back end which are called from the front end forms.
• Created UNIX Shell script for automating the process.
• Created Autosys for scheduling the UNIX jobs
• Developed PL/SQL Packages, Functions and Procedures to implement the Business Logic using Bulk collect, bind variables, Ref cursors, dynamic SQL’s.
• Create Oracle Partition tables like Range/List/Hash/Composite.
• Developed shell scripts for batch processing and database transactions.
• Tuning complex queries using Query Optimizer hints, joins and indexes.
• Worked on complex queries using analytical functions like Lead/Lag/Rank/Dense Rank/First/Last.
• Create CTL files and UNIX shell scripts to read, move and processed data files. Use multiple different ftp servers for file delivery and receipt.
• Write PL/SQL procedures, packages, materialized views and develop other database scripts like tables, synonyms, sequences, triggers,
• Creating indexes on tables to improve the performance by eliminating the full table scans and Views for hiding the actual tables and to eliminate the complexity of the large queries.
• Generating trace files using TKProf and analyzing the explain plan.
• Worked on the solution designing and giving inputs to handle complex solutions.
• Worked on UNIX-shell Scripting.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked on SQL loader to load the files.
• Review source code and generate peer review reports.
• Involved in build management and build resolution activities of the project.
• Involved in testing, bug fixing and documentation of the system.

Environment: Oracle Database 10g, Autosys, Toad, UNIX, Windows.

Confidential

Role: Technology Analyst.

Responsibilities:

• Involved in system analysis, Design, Coding, Data Conversion, Development and Implementation.
• Data transfer from Input tables to the Output tables using procedure.
• Wrote Package containing several Procedures and Functions in PL/SQL to validate the Bond Balances before loading into Application database.
• Created various database objects like views, indexes, sequences, synonyms.
• Extensively involved in writing SQL queries (Sub queries and Join conditions) and PL/SQL programming.
• Involved in Creation of tables, partitioning tables, Join conditions, and correlated sub queries, for the business application development.
• Experience in partitioning and sub-partitioning like range, list, and hash.
• Worked on user-defined and also the system defined exceptions to handle different types of errors like NO DATA FOUND, TOO MANY ROWS, and PRAGMA EXCEPTION INIT.
• Expert knowledge in cursor, ref cursor, system ref cursor, collection and dynamic SQL.
• Made use of for all and bulk Collect feature to process the data from cursor/ Ref Cursors and put the processed data into Confidential collection.
• Used set operators in PL/SQL like unions, union all, intersect and minus.
• Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF to tune SQL queries.
• Usage of SQL Loader to load the data from external files that is exported from Server
• Write and modify database stored procedures and sql queries in TOAD to improve database performance.
• Created UNIX Shell script for sending email to alert users for erroneous records.
• Worked on UNIX shell scripts to automate the process.
• Worked on Autosys to schedule the jobs.
• Involved in writing shell scripts for executing the oracle scripts.
• Review source code and generate peer review reports.
• Involved in testing, bug fixing and documentation of the system
• Writing scripts for automating the build process and release.
• Provide mentoring for junior team members.

Environment: Oracle Database 10g, Autosys, Toad, UNIX, Windows

Confidential

Role: Technology Analyst/Senior System Engineer.

Responsibilities :

• Creation of database objects like tables, views, procedures and functions.
• Developed PL/SQL-Packages, SQL Scripts and Database Triggers for making history of insertion, updating, deletion and all kind of Audit routines.
• Used various Joins for data retrieval from multiple tables according to the requirement.
• Experience with usage and creation of indexes on the table for better performance of complex query.
• Wrote complex SQL queries with Co-Related Sub queries, nested loops for faster data retrieval from multiple tables.
• Extensively used cursors, sequences in the procedures according to the requirement.
• Used Dynamic SQL for Query Optimization and by using this dynamic sql it increases the performance and also to perform error detection and cleanup.
• Involved in Doing Partitioning and Sub partitioning on table to improve performance.
• Worked on User-defined and System defined exceptions to handle different types of Errors.
• Used SQLCODE and SQLERRM for the exceptions error code.
• Extensively worked on SQL Loader for loading data into tables from flat files and CSV files.
• Extensively used FORALL and BULK COLLECT to fetch large volumes of data from table.
• Worked on UNIX shell scripts to automate the process.
• Worked on Autosys to schedule the jobs.
• Requirement capture, analysis of requirements, design solution based on client’s needs.
• Exposure to full life cycle of product development starting from requirement analysis to deployment and maintenance.
• Responsible for designing, developing, specification of test plans
• Documentation of User manual and generic documentation required for the module.
• Training the new resources and knowledge sharing by in-house training sessions.

Environment : Oracle Database 10g, Autosys, SQL Developer, Harvest, SSH Tectia, UNIX, Windows.

Role : System Engineer 

Responsibilities

• Coordinated with clients, Requirements gathering and designing.
• Utilized SQL developer tool in developing all back end database interfaces.
• Developed user documentation for all the application modules.
• Developed complex packages, stored procedures and functions to implement business logic.
• Worked extensively on exception handling to trouble-shoot PL/SQL code.
• Created Indexes and sequences for faster retrieval of the visitor information and enhance the database performance.
• Wrote complex queries to generate reports as per client request as Confidential part of production support.

Environment: Oracle Database 10g, Autosys, SQL Developer, VB, Harvest, SSH Tectia, UNIX, Windows.

Role : System Engineer

Responsibilities

• Involved in Creation of tables, Join conditions, nested queries, views, sequences, synonyms for the business application development.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
• Created dynamic SQL to support dynamic nature of front to end applications.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Used UNIX for Automatic Tasks like loading data into Tables, Importing and Exporting data.
• Wrote complex queries to generate reports as per client request as Confidential part of production support.

Environment: Oracle Database 10g, Autosys, SQL Developer, WCF, WPF, UNIX, Windows.