PROFESSIONAL SUMMARY

• Around 7 years of IT experience in the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2/2010/2012.
• Expertise in SQL Server Integration Services SSIS and SQL Server Reporting Services SSRS with good knowledge on SQL Server Analysis Services SSAS .
• Experience in report writing using SQL Server Reporting Services SSRS and creating various types of reports like drill down, drill through, Parameterized, Cascading, Conditional , Table, Matrix, Chart and Sub Reports.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Experience in report writing using SQL Server Reporting Services SSRS and creating various types of reports like drill down, Parameterized, Cascading, Conditional , Table, Matrix, Chart and Sub Reports.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Excellent in High Level Design of ETL DTS Packages SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like Excel, CSV, Oracle, flat file by using multiple transformations provided by SSIS such as Derived column , Conditional Split, Bulk Insert , Merge and union all.
• Developing SSRS reports on SQL Server 2005/2008/2012 . Good understanding of SSAS, OLAP cube and Architecture.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Worked Extensively on ETL process using SSIS package.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Good understanding of Data Warehousing concepts and ability to utilize star schema and snow flake schema according to the requirement.
• Experience in using T-SQL in SQL Server 2000/2005 and 2008 platforms.
• Experience in Performance Tuning and Query Optimization.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Transformed data from one server to other servers using tools like Bulk Copy Program BCP , Data Transformation Services DTS and SQL Server Integration Services SSIS
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
• Good knowledge of System Development Life Cycle SDLC , Agile and Waterfall development environments

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Role- SQL BI Developer

Responsibilities:

• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Developed and executed several optimized queries in SQL.
• Developed tables, views, triggers and stored procedures using T-SQL
• Implemented ETL using SQL Server Integration Services SSIS to load patient insurance data into in-housed database.
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Use SQL Server SQL Profiler to enhance query performance improvement.
• Enhanced and deployed the SSIS Packages from development server to production servers.
• Loading data from various sources such as flat files to SQL Server databaseusing SSIS Package.
• Used temporary tables, table variables in stored procedures to simplify complex queries.
• Used SSIS to build high performance data integration solutions, including extraction, transformation, and load ETL packages and also scheduled the SSIS packages and jobs.
• Used SQL server reporting services SSRS delivering enterprise, web-enabled reporting to create reports that draw content from a variety of data sources.
• Designed and created report models based on users' requirements, explained and trained users to use report builder to generate their own personalized reports.
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Created SSIS packages and scheduled jobs to call the packages and stored procedures.
• Involved with modifying reports by parameterizing or including formulas for existing reports.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services SSRS .
• Taking Database full Backup, Transaction log backup differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.

Environment: MS SQL Server , DTS, SSIS, SSRS, SSAS, T-SQL , C .net, XML, ETL.

Confidential

Role: SQL BI Developer

Responsibilities:

• Worked with Business Analysts in gathering business requirements and translating them to technical specifications.
• Created tables based on business needs, created views, used stored procedures, functions and indexes
• Created jobs, alerts and scheduled DTS to generate reports.

Designed and implemented Parameterized and cascading parameterized reports using SSRS for branches.

• Created ad-hoc reports for business users using SSRS 2005 and 2008.
• Extensively used SQL Server Reporting Services to generate reports such as drill down, parameters, group, cascading, chart financial reports based on business requirements.
• Developed ETL application to load branch into the archive database servers.
• Developed ETL packages with various different data sources SQL Server, Flat Files, Excel source files, XML files etc. and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services SSIS ETL development tool.
• Involved with the loading of SSIS packages into SQL Server from flat files and excel spreadsheets.
• Implemented Extraction, Transformation and Load ETL , import, export activities by DTS /SSIS package
• Created SSIS Packages for migration of data between SQL Server and other databases such as MS Access, DB2, and Oracle.
• Generated reports using SQL Reporting Services SSRS for customized and ad-hoc queries.
• Involved in designing, developing, debugging and testing of reports in SQL Server 2008 Reporting Services SSRS .
• Generated several drill down and drill through reports using SSRS.
• Developed custom reports using SQL Server Reporting Services SSRS to review score cards, business trends based on the data from different retail locations.
• Generated ad-hoc, matrix, stepped, block and tabular reports using SQL Server reporting services based on customer needs and requirements.
• Performed data analysis to generate various trend reports for commercial accounts based on branches.

Environment: MS SQL Server , DTS, SSIS, SSRS, SSAS, T-SQL , C .net, XML, ETL,DB2,Oracle. Confidential

Role: SQL BI Developer

Responsibilities:

• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Extract Transform Load ETL development using SQL Server 2008 Integration Services SSIS .Involved in creating SSIS jobs to automate the reports generation
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Created complex SSIS packages using proper control and data flow elements with error handling.
• Installation and configuration of SQL Server 2008.
• Involved in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using Sql Server Reporting Services 2008.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Developed the chart type, tablix, matrix reports in SSRS Sql Server Reporting Services
• Wrote the expressions in SSRS wherever necessary.
• Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Involved in modifying report content and exporting reports in multiple formats based on the business requirements.
• Designed and implemented Parameterized and cascading reports using SSRS 2008.
• Created derived columns on the final fact and dimension tables as per the business requirements.

Environment: MS SQL Server, DTS, SSIS, SSRS, SSAS, T-SQL , OLAP, XML, ETL.

Confidential

Role: SQL BI Developer

Responsibilities:

• Converted Data Transformation Services DTS application to SQL Server Integrated Services SSIS as assigned.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Involved in creating highly interactive score cards and Dashboards using Performance Point Server.
• Designed SSIS Packages to extract, transfer, load ETL existing data into SQL Server 2008 from different environments for the SSAS cubes.
• Generating reports using SQL Reporting Services SSRS for customized and ad-hoc Queries.
• Involved in designing, developing, debugging and testing of reports in SQL Server 2008 Reporting Services SSRS .
• through reports using SSRS.
• Expert in creating Star schema cubes using SSAS.
• Designed and created the table schema and stored procedures that will be used in Data QC.
• Designed and developed the Data QC Maintenance website that will be used to maintain the application tables, execution of main Data QC store procedures, and report generation that will be exported to Microsoft Excel file.
• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
• Responsible for documentation of system related activities.
• Provides technical documentation of the system
• Code reviews to move it to the production developed by developers.

Environment: MS SQL Server, DTS, SSIS, SSRS, SSAS, T-SQL , Star Schema,QC, XML, ETL.