SUMMARY

• 7 years of experience in development, coding and testing of business/commercial applications using SQL Server 2008/2012 and Microsoft Business Intelligence (MSBI) tools like SSIS and SSRS.
• Strong experience in database development using Stored Procedures, Indexes, Views and User - Defined Functions to facilitate efficient data manipulation and data consistency.
• Extensive experience in Writing Transact SQL (T-SQL) Queries, Dynamic-queries and implementing SQL Server Indexing.
• Experience in creating Jobs, Alerts and scheduling Packages.
• Extensive experience in Extraction, Transformation and Loading of data directly from heterogeneous source systems like Excel files, Flat files and other databases using SQL Server Integration Services.
• Sound knowledge in database programming using SQL server 2008/2012.
• Experience in implementing Error Logging and Error handling for SSIS Packages.
• Has knowledge in SQL Server Analysis Services.
• Exposure of Data Warehousing methodologies such as Multidimensional modeling (Star / Snowflake Schemas).
• Good understanding and experience of OLAP Cubes, Dimensions, Slowly Changing Dimension phenomenon, surrogate key assignment using SSAS
• Experience in using Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
• Experience on Report Design, Development and Deployment using SSRS.
• Experience in writing Parameterized queries for generating Tabular reports, Formatting report layout, sub reports using Global Variables, Expressions, Functions, Sorting teh data, defining data source and subtotals for teh reports using SSRS.
• Experience in building various types of SSRS reports like table, matrix, and chart report.
• Knowledge of using power pivot and power query using Power BI.
• Strong Business and Application analysis skills with excellent communication and professional skills.
• Excellent problem solving, analytical and interpersonal skills.

PROFESSIONAL EXPERIENCE

Technologies: Microsoft Business Intelligence Tools(MSBI)

Languages: C#, MSSQL

Operating system: Windows server 2003/2008,Windows 2007/8/8.1

Databases: Microsoft SQL Server 2008/2012

ETL Tools: SQL Server 2008/12 Integration Services

Reporting Tools: SQL Server 2012 Reporting Services

Analysis Tools: SQL Server 2012 Analysis Services

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Environment: SQL Server, SSIS 2008/12

Responsibilities:

• Involved in requirements & Design phases.
• Involved in database backup in production.
• Extracting data from multiple sources like flat files and SQL server and transforming, cleansing, validating data and loading into final Destination.
• Created SSIS Packages by using different data transformations like Derived Column, Look up, Data Conversion, Conditional Split, merge, merge join, Union all and Execute SQL Task to load data into database.
• Maintaining log information in SQL Server table to track errors and recording package execution status.
• Performing error handling for debugging SSIS packages.
• Developed single value and multi valued parameterized reports for Business Users using Microsoft SQL Server Reporting Services (SSRS).
• Created Drill Down reports using Microsoft SQL Server Reporting Services (SSRS).
• Enhanced reports by teh charts and graphs using Microsoft SQL Server Reporting Services (SSRS).

Confidential

ETL Developer

Environment: SSIS, SSAS SQLSERVER 2008R2

Responsibilities:

• Analyzing teh Business Requirement Specification document from teh client.
• Design and develop SSIS packages.
• Created teh dataflow using transformations like Derived Column, Union All, Conditional Split and Script Component, Lookup.
• Used Control Flow Tasks like Execute SQL, File System, send mail, Dataflow Task, Execute Process Task and Execute package Task.
• Scheduled teh ETL Package Using SQL Server 2008/2012 Management Studio.
• Created Event Handlers for teh Packages Using Event Handler Tab.
• Involved in creation of teh package and was responsible for moving teh package from development server to production server.
• Involved in designing of cubes using SSAS

Confidential

SQL Server Programmer, Product support Engineer

Environment: Windows Server 2008, SQL Server 2008

Responsibilities:

• Data Center Maintenance - General data center maintenance activities and analysis.
• Using performance log check processor utilization, memory usage, disc space
• Availability and network bandwidth testing etc.
• Backup - Scheduling and monitoring teh Daily Differential backup and Weekly full backup for all business critical Databases.
• Maintenance of Execution Status - their are number of jobs scheduled in data server, according to schedule frequency those job statuses require to update in status report.
• Uploading teh Files - Uploading teh Disbursement, repayment and Pre-closure files into Ganaseva Application by Running teh Scripts and after uploading teh data generating teh reports and sending reports to concern department and uploading customer data.
• MIS Reports: Preparing teh Monthly MIS reports and preparing teh MIS reports on requirement.
• SSIS-Importing teh received files into teh database using teh SSIS services and also by import and export wizard.
• SSRS: Preparing teh reports using teh reporting services and deploying teh same in production server and giving teh rights to teh accessible customers.

Confidential

Tester

Environment: Java, Servlets, JSP, EJB and PL/SQL; Database: Oracle 9i

Responsibilities:

• Reviewing Functional Specification.
• Reviewing Technical Specification.
• Involved in Analysis and Design phases.
• Creation of Test plan and Writing Test Cases.
• Participating Test Case review meetings.
• Test Case Execution.
• Bug management dat includes creation, troubleshooting, fix validation, closure.