SUMMARY:

• A competent professional with more than 8 years of experience with Confidential in all phases of SDLC, focusing on conceptualizing business needs and translating them into viable technical solutions.
• Well versed with ASE Sybase 12.5, Microsoft SQL Server 2005/2008, Data Analysis, Informatica9.5, and IDQ.
• Have the experience in handling end - to-end development of software projects from inception, requirement specifications, planning, designing, implementation, documentation and closure with cross-cultural teams.
• Proficiency in complete SDLC including application development, enhancement, requirements analysis, design, testing, performance tuning, data migration and training as well as post production support.
• Also have the exposure in project management activity and Audits in projects.

TECHNICAL

Operating Systems: Windows XP/2007/2010

Languages: SQL, T-SQL, PL/SQL

Databases: Sybase 12.5/15, MS SQL Server 2005/2008

Version Control Systems: MS Visual Source Safe (VSS), Synergy 7.1, Subversion(SVN)

ETL Tool and Others: Informatica9.5, Performance Tuning, IDQ, Data Analysis

FUNCTIONAL:

• Ensuring on time delivery within the quality parameters.
• Cooperating with other team members for efficient work progress.
• Following the best practices for project support and documentation as set by the peers.
• Designing, developing, testing, troubleshooting and debugging of the applications.
• Providing post-implementation, application maintenance and enhancement support to the client with regard to the product / software application.

CAREER SCAN:

Confidential

DWBI Analyst/View Modeler

Database/Tools: Teradata 13.11

Responsibilities:

• Creating Views in Teradata Environment as per the requirement analysis and Business logic.
• Testing Views as per the requirement and notifying to OBIEE Reporting team to get the sign off.
• Integrating the new changes as per the business/Requirement in the views and fixing issues found in OBIEE report.
• Responsible for coding, implementing and testing the customized solutions for new implementations and upgrade.
• Creating SQL script of the views from DEV to QA server for migration.

Confidential

Data Analyst

Database/Tools: Teradata 13.11, Data Analysis

Responsibilities:

• Analysis of source and target systems
• Source data profiling to identify any data quality issues and identification of data cleansing rules
• Detailed Gap analysis to identify the issues between source and target systems.
• Creating common data definitions for the data elements across multiple source systems
• Create data mapping document between Source and Target systems
• Capturing special data scenario, data constraints, data exceptions
• Conducting multiple sessions with Business SMEs, Business Analysts, System Architects, Data modelers and Designers for walkthrough and review of findings.

Confidential

Data Quality Developer

Database/Tools: IDQ 9.5, Informatica Analyst, Informatica Monitor, Data Analysis

Responsibilities:

• Creating mapping in IDQ developer tool with the transformations to load data in flat file target.
• Creating data objects from Unix flat file and executing for profiling followed by thorough analysis in Informatica Analyst tool
• Testing each mapping and profiling the input and output files to check the cleansed data.
• Preparing technical mapping documents such as TDS (Technical Design Specification) for various region.
• Handling performance tuning of SQL queries.

Confidential

Sr. Sybase Developer, ETL-Informatica

Database/Tools: Sybase 12.5

Responsibilities:

• Prepared SQL queries for extracting the data from source.
• Preparing different types of technical documents such as TDS (Technical Design Specification).
• Functioned in association with database objects like tables, stored procedures, functions, views, etc.
• Generated different types of scripts and loading data into Sybase server.
• Responsible for UI testing after validating with client and frontend team.
• Handling performance tuning of SQL queries.
• Prepared different types of technical documents

Confidential

Operating System: Windows 2007

Database/Tools: Sybase 12.5, Informatica 9.5, Unix

Sr. Database & ETL Developer

Responsibilities:

• Responsible for developing mapping in Power center environment and executing Workflow sessions.
• Integrating the new changes as per the business change in the mapping.
• Functioning in association with database objects like tables, stored procedures, scripts etc.
• Providing production support in case of deployment and client issue.
• Generating different types of scripts.
• Handling performance tuning of SQL queries and procedures.
• Creating and scheduling CA batch job.
• Preparing different types of technical documents such as TDS (Technical Design Specification).

Confidential

Sr. Sybase & ETL Developer

Database/Tools: Sybase 12.5, SQL Server 2008, Informatica 9.5,DB Artisan

Responsibilities:

• Prepared SQL queries for extracting the data from source.
• Developed the transformation logic to achieve the required output.
• Functioned in association with database objects like tables, stored procedures, functions, views, etc.
• Generated different types of scripts.
• Loading and testing the Informatica mapping to load data.
• Handled performance tuning of SQL queries.
• Prepared different types of technical documents

Confidential

Database/Tool Used: Sybase 12.5, Informatica, CA Batch Job

Database & ETL Developer

Utility: MS Office, ASE Isql, Subversion

Responsibilities:

• Interacted with client for requirement gathering, system study & analyzed user requirements.
• Designed software, database and reports.
• Testing the Informatica mapping to load data.
• Created SQL queries, stored procedure and functions.
• Handled performance tuning, improvement of SQL queries.
• Responsible for coding, implementing and testing the customized solutions for new implementations and upgrade.
• Assisted in functional testing of the system and ensured that it meets the user specifications.
• Delivered and implemented the project as per scheduled deadlines.
• Accountable for planning and coordinating post-implementation and maintenance support to the client.

Confidential

Database: SQL Server 2005, Oracle 10g

Database Developer

Utility: MS Office 2010, Synergy 7.1

Responsibilities:

• Responsible for requirement gathering, system study & analyzing user requirements.
• Designed the user interface (UI), database and prepared SQL queries, stored procedure and functions.
• Handled performance tuning and improvement of SQL queries.
• Maintained the database.
• Also successfully resolved/handled the issues/Tickets assigned in Salesforce.
• Delivered and implemented the project as per scheduled deadlines.
• Accountable for coding, debugging & testing the software.
• Provided training and maintenance support to the clients.

Confidential

Database: Oracle 10g, DB2

Software Developer

Utility: MS Office, SqlLoader

Responsibilities:

• Studied FSD and documented project flow.
• Designed and created forms and database.
• Migrating the scripts from DB2 to oracle
• Coding done using the SqlLoader (Writing Control files by using SqlLoader)
• Prepared SQL queries, stored procedure and functions.
• Accountable for coding, debugging & testing the software.
• Provided training and maintenance support to the clients
• Handled performance tuning and improvement of SQL queries.