PROFESSIONAL SUMMARY:

• Sr. Data Analyst
• Technical Business Analyst
• Data Team Lead
• Sr. Oracle Database developer
• Sr. Data Analyst with strong experience in relational database.
• 13+ years’ experience in relational database.
• Oracle PL/SQL, UNIX Shell Scripting.
• Hands on experience in data analysis, data mapping, data conditioning, data quality.
• Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Oracle Enterprise Manager query observation.
• Extensive experience in using Cursors and Ref - cursors for processing of data.
• Good Knowledge on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records and Types.
• Strong programming skills on Oracle SQL, PL/SQL indexes, bulk collects and bulk variables.
• Extensive experience in data migration techniques using SQL* Loader.
• Worked with query tools like Toad, SQL*Plus, PL/SQL Developer.
• Extensively worked on Materialized Views, Database links and Table partitioning.
• Experience in logical and physical design of Databases, Data Modeling and Data Architecture.
• Experience in data warehousing project.
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.
• Proven ability to handle multiple tasks with strong technical aptitude and learning skills to adapt the rapid changing technologies and implementing the same at work.
• Good experience of onshore/offshore working model.
• Experience in data ware housing project, ETL tool.

TECHNICAL SKILLS:

Programming Languages: Pl/Sql, Sql

DBMS and RDBMS: Oracle 8i/9i/10g/11g, Sqlserver

Hands on Experience: Unix, Perl scripting, Oracle Forms 6i, Oracle Reports 6i, Oracle Developer 2000

Tools: TOAD, Pl/Sql developer, ER Win, Oracle Enterprise Manager (OEM), Autosys, Oracle SQL Developer, Informatica Powercenter, Informatica MDM

Repositories: SVN, Clearcase, RTC

PROFESSIONAL EXPERIENCE

Confidential, Dayton, OH

Sr. Technical Business Analyst & Data Analyst Lead

Responsibilities:

• Technical Business Analyst mainly for provider domain. To start the project and account, interacting with business, identify process, capture the direct and indirect requirements.
• Data analysis, data profiling and present the reports to the business to support the process improvement suggestions.
• Lead the Cognizant Analyst team and interact with client on behalf of Cognizant for business, requirement
• Data quality analysis with profiling, Informatica Powercenter data mapping analysis.
• Data Analysis on Facets, Cactus, McKesson Contract Manager tool.

Environment: Sql server, Informatica MDM, Informatica Powercenter, SSIS

Confidential, Goodyear, AZ

Data Quality and Analyst lead

Responsibilities:

• Lead the Cognizant team and interact with client on behalf of Cognizant for project related matters..
• Data quality analysis with profiling team using Informatica IDQ.
• Team and project management.

Environment: Sql server, Informatica IDQ

Confidential, Irving, TX

Data team lead

Responsibilities:

• Data team lead working with offshore and onshore team leading and driving the data team in the application.
• Data quality analysis with profiling team, data mapping.
• Working with MDM, TIBCO, Abintio teams and DBA for development and performance troubleshooting.
• Extensively worked in Oracle SQL, PL/SQL, Query performance tuning, Functions, Procedures, Tables, Views, Indexes, Synonyms and Sequences.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, AUTOTRACE and AWR.
• Involved in performance testing the application for Oracle 10g to 11g R2 upgrade.
• Tuning of the SQL queries, using index, Explain Plan, Hints to reduce the response time.

Environment: Oracle 10g,11g, Sql developer, RTC

Confidential, Stamford, CT

Senior Oracle Database -Technical Lead

Responsibilities:

• Single person database developer with access to production environment in leading Investment bank.
• Onshore database developer for Trading application in leading investment bank with exposure to production environment.
• Design and Developing of workflow procedures.
• Assisting DBA for with basic analysis with handling multiple dbs.
• Implemented PL/SQL queries, triggers and Stored Procedures as per the design and development related requirements of the project.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL* Loader, Query performance tuning, created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Partitioning maintenance of the tables.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, AUTOTRACE and OEM tool (AWR, ADDM)
• Written the ETL code in PL/SQL as per the functionality in Cognos.
• Has done end to end testing of the applications and Error casual analysis
• Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.
• Involved in testing the application for Oracle 10g to 11g R2 upgrade.
• Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries
• Database designing using ERWin

Environment: Oracle 10g,11g, TOAD, OEM, Pl/Sql Developer, ERWin, SVN, Unix Shell script, Perl scripting.

Confidential, Stamford, CT

Senior Oracle Database - Technical Lead

Responsibilities:

• Onshore developer, working with client and users on requirement analysis.
• Requirement analysis, design the system and get the work flow approved from client.
• Assign the task to offshore java developers and deliver the release and post production support.
• Database development of the complex logic and bulk processing of the data.
• Design and Developing of workflow procedures.
• Assisting DBA for with basic analysis with handling multiple dbs.
• Implemented PL/SQL queries, triggers and Stored Procedures as per the design and development related requirements of the project.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL* Loader, Query performance tuning, created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, AUTOTRACE and OEM tool (AWR, ADDM)
• Has done end to end testing of the applications and Error casual analysis
• Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries
• Database designing using ERWin

Environment: Oracle 10g,11g, TOAD, OEM, Pl/Sql Developer, ERWin, SVN, Unix Shell script, Perl scripting.

Confidential

Senior Oracle Database Developer (Technology Analyst)

Responsibilities:

• Single offshore database developer.
• Database development of the complex logic and bulk processing of the data.
• Design and Developing of workflow procedures.
• Implemented PL/SQL queries, triggers and Stored Procedures as per the design and development related requirements of the project.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL* Loader, Query performance tuning, created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.
• Database designing using ERWin

Environment: Oracle 10g,11g, TOAD, Pl/Sql Developer, ERWin, SVN, Unix Shell script.

Confidential

Oracle Database Developer (Software Engineer)

Responsibilities:

• Cognos ETL tool developer
• Design and maintain sql and pl/sql code.
• Design and Developing of workflow procedures.
• Implemented PL/SQL queries, triggers and Stored Procedures as per the design and development related requirements of the project.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL* Loader, Query performance tuning, created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.

Environment: Oracle 10g, TOAD, Pl/Sql Developer.

Confidential

Oracle Developer

Responsibilities:

• Single person database developer/support for the internal application for material management.
• Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system.
• Requirement gathering and worked according to the CR.
• Code Development as per the client requirements in SQL, PL/SQL, Oracle Forms 6i
• Involved in the development backend code, altered tables to add new columns, Constraints, Sequences and Indexes as per business requirements.
• Perform DML, DDL Operations as per the Business requirement.
• Creating views and prepares the Business Reports.
• Resolved production issues by modifying backend code as and when required.
• Used different joins, sub queries and nested query in SQL query.
• Strong communication with users for requirement and defect fixes.

Environment: Windows 98/NT/2000, Oracle 9i/8i, TOAD, Database Tools/Utilities.

Confidential

Oracle Developer

Responsibilities:

• Strong team player in database development.
• Hands on experience in retail banking projects.
• Code Development as per the client requirements in SQL, PL/SQL, Oracle Forms 6i, Developer 2000
• Involved in the development backend code, altered tables to add new columns, Constraints, Sequences and Indexes as per business requirements.
• Perform DML, DDL Operations as per the Business requirement.
• Creating views and prepares the Business Reports.
• Resolved production issues by modifying backend code as and when required.
• Used different joins, sub queries and nested query in SQL query.

Environment: Windows 98/NT/2000, Oracle 9i/8i, TOAD, Database Tools/Utilities.