SUMMARY

• Software Engineer having 9+ years of IT experience in software development.
• Around 7+ years of experience in Development for large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
• Experience in MSBI tools like SSIS, SSRS used in development and implementation of the Project.
• Expertise in Relational database design, including T - SQL - creating tables, stored procedures, views, user-defined functions, triggers, Performance tuning (tuning complex queries and indexing strategies)
• Good understanding of SQL Server internals, DMVs.
• Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Having experience in creating master and child packages, package configurations, event handlers, logging and deploying packages.
• Experience in creating Jobs and scheduling Packages using Sql server agent service.
• Create SSIS Packages used Control flow, Data flow and tasks requirement.
• Good working experience on creation of various Reports using SSRS.
• Created Tabular, Matrix and List reports with and without parameters using SSRS.
• Hands on experience in building and deploying the reports by using SSRS.
• Good at developing reports using different SSRS functionalities like cascading parameters and Multi Value Parameters. Having excellent communication and Presentation skills.
• Expertise in generating reports using Crystal Reports, and MS Excel spreadsheets.
• Working knowledge of .Net Framework 2.0 (VB.NET and C#.NET), VB6.0, Oracle 9i, My Sql, MS Access.
• Strong experience in software development life cycle -design, development, testing, maintenance, and reengineering.
• Experience includes in Confidential, CRM, Retail domains.

TECHNICAL SKILLS

Databases: SQL SERVER 2005/2008/2012 , MS-Access and MY SQL

Programming: VB.NET, C#.NET, Visual Basic, VBA

MSBI Tools: SSIS, SSRS

Reporting Tool: Crystal Reports

Web Technologies: HTML, XML, CSS

Tools: CVS, PL/Sql developer for Oracle, Visio, Toad, JIRA, Rally

Scripting: VBScript, JavaScript

Workflow Tools:Cisco Process Orchestrator

Functional Domain: NGO Fund Raising, Retail, Inventory, HRIS

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Understanding the requirements to designing new services and Bundled services and developed workflows using CPO tool ( Confidential Process Orchestrator).
• Involved in testing the services.
• Writing SQL queries to generate complex reports.
• Involving in creating packages in SSIS Designer using various Control Flow Tasks and Data Flow Transformations to implement Business Rules.
• Regularly using For Loop Container, For Each Loop Container, Sequential Container and Control Flow Tasks like Execute SQL Task, Send mail Task, Execute Process Task, Execute Package Task, File System Task, Script Task, Execute Package Task and also the Data Flow Task.
• Involving in designing, coding of the SSIS Packages.
• Involving in deploying and scheduling SSIS packages.
• Creating tabular, matrix, drill- down and drill through reports and graphs using SSRS.

Environment: SQL Server 2012, SSIS, SSRS, Oracle, Confidential Prime Service Catalog and Confidential Process Orchestrator

Confidential

Contact Manager

Responsibilities:

• Client Interaction
• Analysis and understanding work pack requirements in ADD (Architectural design document)
• Preparing DDD (Detailed design document) based on work pack requirement.
• Analyzing impacted SLO items in backend.
• Analyzing MS-Access code to identify Contact Manager application impacts on front end side.
• Writing reusable scripts for updating impacted SLO items in backend.
• Creating and modifying stored procedures and functions based on requirement.
• Writing Test case document.
• Testing
• Worked on VB script batch files.
• Involving in designing, coding, testing of the SSIS Packages.
• Support to clients and update on the status of tasks performed.
• Understanding SSIS package and analyzing the impacts of data transfer.
• Part of complete project life cycle.
• KT to production support team.

Environment: SQL Server 2012, Java, MS-Access, VBScript

Confidential

Responsibilities:

• Client Interaction
• Requirements gathering
• Analyzing existing Donor management system for Confidential developed in MS-Access and maintenance.
• Estimations
• Design and Issue resolution
• Tasks allocation
• Tasks verification/ testing
• Involved in writing stored procedures, functions and views SQL Server 2008.
• Analyzed the sources, targets, transformed the data, mapped the data and loading the data into targets using SSIS packages.
• Created Transformations and Mappings using SSIS Designer and processing tasks to move data from multiple sources into targets.
• Designed and developed SSIS package to load data from Source systems to Target system.
• Development of Reports
• Performance tuning.
• MS-Access

Environment: SQL Server 2005/2008, VB.Net, SQL Server Reporting Services, SQL Server Integration Services

Confidential

Responsibilities:

• Client Interaction
• Requirements gathering and analysis of existing reports
• Development and maintenance.
• Generated various report using crystal reports and SQL Server Reporting Services

Environment: VB 6.0, Crystal Reports, SQL Server 2008/2005

Confidential

Responsibilities:

• Client Interaction
• Requirements gathering
• Estimations
• Development and maintenance.
• Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks.
• Performed and fine-tuned Stored Procedures and SQL Queries and User Defined Functions.

Environment: SQL Server 2008, VB.NET

Confidential

Responsibilities:

• Development and testing
• Developed various Drilldown, Grouping, Sub-Reports and Cross-tab reports using Crystal Reports depending on the business requirement.
• Involved in writing stored procedures, functions and views SQL Server 2005.
• Client Interaction for project execution

Environment: SQL Server 2008, C#.NET

Confidential

Responsibilities:

• Involved in Requirement Analysis.
• Development and Maintenance.
• Involved in data migration.
• MIS reports and detailed reports design and development.
• Involved in writing stored procedures, functions and views using SQL Server 2005.

Environment: C#, ASP.NET, MSSQL 2005, Crystal Reports XI, JavaScript

Confidential

Responsibilities:

• Client Interaction
• Requirements Gathering
• Creation of use case document, Flow diagrams.
• Creating Mapping Documents for migrating data from an existing system, Scripts for migrating the data.
• Design development and Code Review.
• Developed stored procedures and events for uploading contacts.

Environment: VB 6.0, Oracle, MS-Access, JSP, Struts2.0, MySQL

Confidential

Responsibilities:

• Study of Requirements, Use case listing
• Creation of use case document, Use-case diagrams, Sequence/Flow diagrams, Class diagrams for Object Oriented (OOPs) application using UML.
• Design, Development and Maintenance.
• Migration of data from all individual sources and the data that is maintained by the RMs in different formats.

Environment: VB.NET, SQL Server 2005

Confidential

Responsibilities:

• Development of store procedures and reports Testing
• Developed detailed reports and MIS Reports using Crystal Reports and performance tuning.
• Data migration from MS-Access to Oracle database

Environment: Asp.Net, C#.Net, Java Script, Crystal Report, Oracle 9i

Confidential

Responsibilities:

• Developed Stored Procedures, views, functions.
• UI Customization
• Coding for the Timesheet module.

Environment: SQL Server 2000, VB6.0, Power Builder7.0, Oracle 9i