SUMMARY

• Over 9 years of IT professional experience in Development, Client Analysis, Database Design and presentation using MS SQL Server 2005/2008/2008R2/2012/SQL Server Integration and Reporting(SSIS, SSRS).
• Over 18 months experience in Talend RTX ETL tool, develop jobs and scheduled jobs in Talend integration suite. Extensively used teh concepts of ETL to load data from flat files to SQL Server.
• Expertise in writing T - SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Experience in optimizing teh query by creating various clustered, non-clustered indexes and indexed views.
• Experience in managing Jobs through SQL Server Agent.
• Experience in batch files to deploy teh SQL scripts across all environments using osql.
• Experience in generating writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008 using data from ETL Loads and various heterogeneous data sources.
• Expertise in using global variables, expressions and functions for teh reports with immense experience in handling sub reports in SSRS.
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008.
• Experience in Design of ETL SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, Oracle, flat file, Text Format Data).
• Understanding business data relationships.
• Experience in design, analysis, development, and implementation of various Application Development in Client/Server Environment using ASP, VB Script and Java Scripting.
• Strong programming skills in ASP, HTML, Java Scripting and VB Scripting.
• Knowledge on Sql Server Analysis Service.

PROFESSIONAL EXPERIENCE

Talend Developer and MS SQL Developer

Confidential

Roles & Responsibilities:

• Implementation of CR’s for policy writer and case manager
• Involved in bug fixing and defect resolution.
• Understanding teh business requirements for report development
• Creating/Debugging Talend DI Jobs.
• SQL Server Data mining and profiling.
• Talend DQ for Master policy holders database.
• Understanding teh business requirements for report development
• Design and implement teh ETL Data model and create staging, source and Target tables in SQL Server database.
• Worked on Talend RTX ETL tool, develop jobs and scheduled jobs in Talend integration suite. Extensively used teh concepts of ETL to load data from flat files to SQL Server Databases.
• Talend components to filter data from different datasets.
• Talend DI alter system for triggering teh email notifications to users on claims.
• Created several SQL Agent jobs to import as well as export data from/to remote servers as an enhancement activities.
• Installed and configured teh Changepoint upgrade patches on database.
• Set up Replication to replicate all teh domain data from one Server to another Server.
• Exported and Imported data using BCP Utility in stored procedures.
• Written and reviewed technical specification document and deployment guide.

Environment: MS SQL Server 2008, SQL Management Studio, SQL Server Business Intelligence Tools, SQL Server Query Analyzer, SSRS, SSIS and T-SQL

MS SQL Developer (SSIS, SSRS)

Confidential

Responsibilities:

• Created Model, Entities, Members, Attributes, Business Rules and Subscription Views in MDS.
• Developed a SSIS package to export domain and Transactional data into Master data Services in MS SQL Server 2012.
• Package Creation and Deployment of Package.
• Performed DML queries on XML data in SQL Server.
• Involved in writing Database scripts for tables, stored procedures and views.
• Designed and developed parameterized reports using SSRS.

Environment: MS SQL Server 2012,T-SQL, MS SQL Integration Services, MS SQL Reporting Services, MS Excel.

MS SQL Developer (SSIS, SSRS)

Confidential

Responsibilities:

• Creating/Debugging SQL/ T- SQL, Stored Procedure/Jobs.
• Involved in writing Database scripts for tables, stored procedures, views and optimizing teh SQL queries for better performance.
• Improved teh performance of teh application by creating proper clustered, non- clustered.
• Developed SSIS packages to export billing details from SQL Server Database in to Oracle DB to generate invoices.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel, SQL Server and Oracle using SSIS.
• Involved in writing complex SQL queries involving joins for many tables, Stored Procedures and Packages in MS SQL Server were developed.

Environment: MS SQL Server 2005,T-SQL, MS SQL Integration Services, MS SQL Reporting Services, ASP, Java Script and VB Script.

MS SQL Developer

Confidential

Responsibilities:

• Creating/Debugging SQL/ T- SQL, Stored Procedure/Jobs.
• Developed SSIS packages to import resource details in to SQL Server Database from Oracle DB.
• Involved in writing Database scripts for tables, stored procedures, views and optimizing teh SQL queries for better performance.
• Involved in writing complex SQL queries involving joins for many tables, Stored Procedures and Packages in MS SQL Server were developed.

Environment: MS SQL Server 2005,T-SQL, MS SQL Integration Services, MS SQL Reporting Services, ASP, Java Script and VB Script.

MS SQL Developer

Confidential

Responsibilities:

• Installed and configured SQL Server 2000 successfully
• Created stored procedures and triggers to capture updated and deleted data from OLTP systems
• Worked on MS SQL Server tasks such as data loading, batch jobs, DTS, and Indexes.
• Wrote complex store procedures, triggers, views, user defined functions and other objects
• Wrote Stored Procedures to clean existing data.
• Co-ordinate with front end developer to put in teh business rules.
• Created DTS Package to import and export data from SQL Server to Text and Excel files.

Environment: MS SQL Server 2000/2005, T-SQL, ASP, Java Script and VB Script.

ASP and MS SQL Developer

Confidential

Role & Responsibilities:

• Involved in designing and creating teh database using normalization techniques in SQL Server 2000.
• Responsible for backend programming such as creating tables, views, stored procedures and triggers in SQL Server 2000.
• Responsible for teh design and development of web pages using ASP, HTML, JavaScript and VBScript.
• Designed and developed various reports using jasper ireports for analyzing teh data.
• Performed Unit testing to identify and resolve integration, functional and usability issues before deployment.
• Worked on optimizing teh queries and minimizing teh page upload time.

Environment: ASP, VB Script, Java Script, MS SQL Server 2000 and Jasper ireports

ASP and MS SQL Developer

Confidential

Role & Responsibilities:

• Installed and configured SQL Server 2000 successfully
• Involved in designing and creating teh database using normalization techniques in SQL Server 2000.
• Responsible for teh design and development of web pages using ASP, HTML, JavaScript and VBScript.
• Was also responsible for backend programming such as creating tables, views, stored procedures and triggers in SQL Server 2000.
• Designed and developed various reports using jasper ireports for analyzing teh data.

Environment: ASP, VB Script, Java Script MS SQL Server 2000 and jasper ireports

TECHNICAL SKILLS

Database: SQL Server 2000 / 2005/2008/2012

ETL: SQL Server Integration Services (SSIS) and Talend RTX 4.1.

Reporting Server: SQL Server Reporting Services (SSRS).

Web Technologies: Asp, Java Script and VB Script.