SUMMARY

• Over all 8 years of experience in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2012/2008/2005/2000 .
• Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.
• Strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Worked Extensively on Business Intelligence (BI) technologies to provide Historical, Current and Predictive views of business operations.
• Strong experience in writing T-SQL, PL/SQL programming artifacts such as stored procedures, Triggers, Indexes, Views, Cursors, UDF using SQL server and Oracle Databases.
• Transformed the data using different transformations like fuzzy lookup, Aggregate, split, join, merge, derived column, and data conversion of SSIS.
• Proficient in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experienced in backend skills increasing SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers (DDL&DML), User Defined Data types and Functions(UDF).
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Ware House using SSIS.
• Expertise in using SSIS tools like Import and Export wizard, Package Installation, SSIS package designer.
• Experienced in designing Ad hoc reports and different types of Cross tabs, Tabular reports, Matrix reports, Custom reports, Drill Down, Drill Through reports, Crystal reports, Sub reports, Parameterized reports in multiple formats using multiple Data Sets and creating Charts using SQL Server Reporting Services SSRS 2005/2008.
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Experience and Expert in Generating on-demand and Scheduled Reports for business analysis or management decision using SSRS.
• Extensive experience in report writing using SSRS and also creating various types of reports like table, matrix and chart report, web reporting by customizing URL Access.
• Expertise in configuring and managing data sources, data source views, cubes, dimensions, roles and creating hierarchies with SSAS.
• Experience in building snowflake schema and star schema depending on business requirements in SSAS.
• Hands on writing MDX queries and experienced in writing “DAX functions” to create Explicit Measures in Power Pivot.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio.

Languages: C, C++, T-SQL,.Net, Visual Basic

Operating Systems: Windows Server 2003, Windows 2000 advanced Server, Windows NT/95/XP, and UNIX.

Databases: MS SQL Server 2012/2008/2005/2000 , MS Access 97/2000

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).

Scripting: HTML, DHTML, Shell Scripting, XML.

Reporting Tools: SSRS, SSAS, Crystal Reports

Data Modeling: Visio 2007 and Erwin 4.1

Application Packages: MS Outlook

PROFESSIONAL EXPERIENCE

Confidential, Rocky Hill, CT

Sr. SQL BI Developer

Responsibilities:

• Involved in ETL packages with different data sources and load the data in to target by performing different data transformation using SQL server integration service.
• Design the package that download the files securely from FTP server and load it into target database.
• Create the store procedure for multiple databases for purpose incremental. Worked with the Upsert functionality.
• Worked on SQL Server integration Service (SSIS) to design the package that daily file uploaded on server will successfully load in to database if any extra column or other error will send the notification email.
• Created different reports like drilldown, drill through report, sub report, parameterized reports using SQL Server Reporting Service(SSRS)
• Worked close with Business to identify the requirement of the report. Based on requirement created the report and upload to SharePoint, reporting server, add subscription to report using SSRS.
• Involved in Scrum meeting, provide the day to day activities, challenges, solution in assigned task.
• Involved in demonstrate the true capability of true BI and enable the business to gain better insight enabling them to drill much deeper into their data.

Environment: MS SQLServer 2008/2008 R2,Visual studio 2008,Windows XP,Sharepoint,Pivotal tracker, Agile Scrum, Task Factory(Pragmatic works),SSIS,SSRS.

Confidential, Bloomfield, CT

Sr. SQL BI Developer

Responsibilities:

• Used to obtain data and reports in general excel format including complex statistical calculations. Imported excel tabular data into SQL Server using Import Export wizard or SSIS depending up on the requirement.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Worked on ETL packages dealing with different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Responsible to support SQL Servers with ever-changing workloads, and achieving some level of predictable performance.
• Played important role in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Creating Ad Hoc and parameterized various Reports using SQL server 2008 R2 / 2012 Reporting Services.
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Generated Sub-Reports, Drill Down reports, Drill through reports and parameterized reports using SSRS. Deployed all the reports to reporting server, SharePoint, Excel & PDF and provided Documentation support on SSRS 2012 as assigned.
• Involved in setting up SQL Server Agent Jobs for timely updating of the tables on the linked servers to through SSIS and SQL store procedures.
• Worked on Reporting parameters included single valued parameters, multi-value parameters, which also consisted of different parameter types, like hidden, internal, default.

Environment: MS SQL Server 2012, MS SQL Server 2005/2008, SSIS, SSRS, Microsoft Visual Studio 2008, SQL Profiler, Microsoft Visio,, Excel 2003, Windows NT/2003,MS Office 2003Excel Power Pivot (1.0 and 2.0 versions).

Confidential, Minnetonka, MN

Sr. SQL BI Developer

Responsibilities:

• Responsible for design, analysis, testing, development and maintenance of various applications.
• Involved in setting up new databases and schemas and also set up linked servers, to be able to cross query multiple databases.
• Worked in the implementation of business intelligence solutions using SQL Server 2005/2008 Integration Services, Reporting Services and Business Intelligence Studio.
• Worked on Migrating Teradata into SQL Server Data by using MS SQL Server Integration Services (SSIS).
• Created ETL packages using SSIS to extract data from Oracle data access layer staging tables and transform, load into relational SQL server database.
• Worked on ETL Transformations to copy columns and load data from source like Oracle, DB2, Flat files to destination databases.
• Setting up SQL Server Agent jobs for timely updating the tables on the linked servers through SSIS and SQL stored procedures.
• Worked on transferring the MS ExcelSheet Reports into SSRS based reports by migration the data by using SSIS packages and then Use views and tables and stored procedures to develop new reports
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill through and web reporting by customizing URL Access.
• Involved with various other teams to understand the business and designing the packages and developing stored procedures according to the mapping documents
• Experience in handling claims/provider and payer data as well.

Environment: MS SQL Server 2008/2008 R2, Windows XP/NT, SharePoint, Visual Studio2008, SSRS, Mainframe DB2, Serena Dimensions 10 /12

Confidential, Sunnyvale, CA

Sr. SQL ETL Developer

Responsibilities:

• Worked on T-SQL for the retrieval of the data and involved in performance tuning of T-SQL queries and stored procedures.
• Involved in Creating SSIS packages using SSIS designer for export heterogeneous data from OLE DB Source (Oracle), Excel spread sheet to SQL Server 2005.
• Worked on Database Triggers to enforce Data integrity and additional Referential Integrity.
• Worked on Creating table, views, clustered and non-clustered index, user defined data types, and user defined functions.
• Created SSIS/DTS packages that would transfer data among servers and perform other data transformations; scheduled the same SSIS packages by creating the corresponding job tasks.
• Worked on SharePoint Enterprise Portal for hosting scorecards and SSRS Reports.
• Implemented security to web server and database server that affects report server installation. Managed role-based security to reports and reporting resources.
• Responsible for creating complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Worked on MS excel to generate Pivot-chart Reports, Pivot Table Reports, Sorting and Conditionally Formatting Data, Filtering.
• Worked on Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Implemented T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Co-ordinate with the business users to assist preparing the mapping documents.
• Generated trigger based daily, weekly and monthly reports regarding assigned projects to designated managers and clients.

Environment: SQL server 2008/2005, ETL, OLAP, OLTP, Oracle, SQL Server Agent, SSIS, SSAS, SSRS, MS Visual Basics 6.VSS, SQL Diagnostic Manager.

Confidential, Richmond, VA

SQL ETL Developer

Responsibilities:

• Worked on Stored Procedures and Database Triggers. Worked on large number of business analytical functions.
• Worked on Active-X scripting in SSIS for transformation of data into staging tables and also to extract data from database tables and write the data to text files.
• Involved in decrypting and re-encrypting the complete database objects, Performance tuning and Query Optimization.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Transformed data from various data sources using OLE DB connection by creating DTS packages.
• Identified the database tables for defining the queries for the reports in SSRS. Defined report layouts for formatting the report design as per the need. Identified and included report parameters for parameterized report in SSRS
• Worked on many complex stored procedures / functions and used them in Crystal Reports directly to generate reports on the fly.
• Utilized T-SQL developer tool in developing all back end database interfaces.
• Created Windows Logins and privileges to User Accounts/Groups and objects.
• Managed up-gradation of DTS packages to SSIS packages for ETL
• Worked on large number of business analytical functions, Stored Procedures and Database Triggers.
• Created an automated ETL summary report which consists of the summary information for all the loading activities done for day and month
• Worked on any deadlocks issues with the databases / servers on a real-time basis.
• Involved in various stages of testing - UT, System Test, Integration Test, UAT.

Environment: SQL Server 200/2005,SSIS,.T-SQL, MS-Excel, Windows 2000/NT/XP, Active X and MS Reporting Services, DTS, Net,VB.Net, Crystal Reports

Confidential

SQL Developer

Responsibilities:

• Used SDLC methodologies for project analysis and implementation.
• Used UNIX environment for performing the testing.
• Installed SQL Server Management tools using SQL server setup program. Tested the installation of SQL Server and implemented different security modes.
• Monitor failed and long running MS SQL Server jobs.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Writing technical documents using the functional specifications.
• Optimized the queries to improve the performance of the application.
• Migrating data, tables, stored procedures and other objects from SQL Server 7.0 to 2000.
• Database and object creation: Developed stored procedures, Triggers, Tables, Views.
• Maintaining user account administration for different domains.
• Created Indexes and involved in Performance tuning.
• Used custom user controls for reusability.

Environment: MS SQL Server 2003/2000/7.0T-SQL, DTS.