SUMMARY

• Over 7years of experience in analyzing, designing, tuning and developing client/server, Business Intelligence (BI) database application, using MS SQL Server 2012/2008R2/2008/SQL Server Integration, Reporting and Analysis Services (SSIS,SSRS,SSAS).
• Extensive SQL Development experience inStudent algorithms, healthcare, logistics, retail and investment departmentwith a strong understanding of data & analytics.
• Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact - SQL queries, stored procedures, and triggers usingSQL Servers.
• Expert in creating indexes, temporary tables and common table expressions (CTEs) to facilitate efficient data manipulation and data consistency.
• Excellent knowledge in Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Expert in developing, deploying packages and extracting data using SSIS from OLTP to OLAP.
• Experienced in ETL Processes. Worked extensively on data extraction, cleansing/data integration, and loading from different data source using SSIS.
• Created SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Experienced in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities. Also, experience in Optimizing MS SQL Query using tools like SQL Server Profiler, Database engine tuning advisor, and Dynamic management views.
• Efficient in generating Tabular, parameterized reports, drill down, drill through, cascading parameterized, and matrix reports using SSRS 2012/2008R2.
• Experienced in using global variables, expressions and functions for the reports.
• Proficient in Installation, Configuration and migrating and upgrading of data from MS SQL Server 2008 to 2008 R2 and 2008R2 to 2012.
• Experienced in Cube designing in Business Intelligence Development Studio to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R2/2008
• Oracle 11g
• C#
• T-SQL
• HTML
• XML
• MS Visual Studio 2010/2008
• SSRS
• SSIS
• SSAS
• SQL Profiler Management Studio
• MS Visio 2008
• MS-Outlook 2012/2010/2007
• Crystal Reports
• Microsoft Excel.

PROFESSIONAL EXPERIENCE

MS SQL Server Developer/BI/ETL Developer

Confidential - Olympia, WA

Responsibilities:

• Performed senior-level application design, development, testing, and transition of application knowledge.
• Worked individually and collaboratively in creating complex SSRS Quick views (Dashboards) and Data table (drill through reports) with vast amounts of parameters and visual basic functions.
• Deployed reports to user applications (Website and report server).
• Built complex ETL SQL scripts (stored procedures) for SSIS Packages to acquire the most efficient ways of loading huge amounts of data to the Data Warehouse.
• Built Data Warehouse packages for Student Growth Percentile project with various Fact and dimensions tables taking a snowflakes layout.
• Applied reverse engineering techniques with quick resolutions to existing SQL Scripts, Reports, and ETL Packages and Website applications problems.
• Extensive usage of Team Foundation server for regular check-ins for source control capabilities.
• Migrated reports between servers; example from Development Server to UAT Server using TFS 2012.
• Perfect communication with project’s Business Analyst to meet the business requirements successfully.
• Supported OSPIstaff in development of user documentation, training material, and implementation plans.
• Attended daily scrum sessions to ensure clear communication with existing project sprints.

Environment: MS SQL Server 2008R2, Visual Studio 2010/2008, MS Windows 7, Microsoft Excel, C#, Team Foundation Server 2010/2008, Remote Server, Lync, Share Point, Microsoft Outlook 2010. Microsoft Office 2010.

MS SQL Server Developer/BI/ETL Developer

Confidential - New York City, NY

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, SSIS packages, SSRS reports.
• Wrote complex T-SQL queries and Stored Procedures for generating reports.
• Designed and tested packages to extract, transform and load data using (SSIS).
• Performed data scrubbing using Data Flow transformation task before deploying to the data warehouse based on the project requirements.
• Used various SSIS tasks such as Conditional Split, Merge Join, Data conversion, OLE DB Command,Derived Column on the data retrieved, performed Data Validation Checks during Staging.
• Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of data.
• Used stored procedures, wrote new stored procedures and triggers and modified existing ones.
• Planned and Designed SSIS packages based on the business requirements.
• Performed error handling using Script Task and event handlers.
• Created sub-reports, drill down reports, parameterized reports using SSRS.

Environment: MS SQL Server 2012, SSIS, SSRS, SQL Profiler, Windows Server 2012, Lotus Notes 7, Microsoft Excel 2013, MS Visual Source Safe, Visual studio 2010, Oracle10g, Microsoft Excel, C#.

MS SQL / BI Developer

Confidential -Wayne, NJ

Responsibilities:

• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler and tuning advisor.
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.
• Created a series of dashboards and charts using Report Builder for a clear representation of statistics.
• Involved in deploying, configuring and managing reports using Report Manager.
• Documented new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Provided documentation about database or data warehouse structures.
• Developed cubes for reporting purposes using star and snow-flacks layout.

Environment: MS SQL Server 2008R2, T- SQL, PowerPivot, MS Excel 2010, SSIS, SSRS, SSAS, Development Studio, Team Foundation Server(TFS).

MS SQL / BI Developer

Confidential, New York, NY

Responsibilities:

• Migrating data between SQL servers 2008 to SQL server 2008R2.
• Performed database monitoring and tuning using SQL profiler.
• Thoroughly used CTE’s and Temporary tables to simplify complex queries involving multiple tables.
• Lead the development of automated SSIS packages to extract, transfer, load and convert data from existing data warehouse to reporting database server.
• Converted, loaded and integrated data from Access, Excel, text/.csv files and internal database applications including the mainframe with data captured for security applications.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation for the public data collected.
• Created Error and Performance Reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created high quality reports, dashboards and analytics to meet the needs of various business clients such asOperations, Sales, Customer Service, Finance, and Executives.
• Created Sub-Reports, Drilldown-Reports for the clients.
• Used conditional formatting to change the behavior of the report depending upon the requirement.

MS SQL / Data Warehouse Developer

Confidential, Lexington, KY

Responsibilities:

• Involved in requirement gathering, analysis, design, development and deployment of reports.
• Fixed the bugs present in already existing reports and in the stored procedures.
• Responsible for Import and export of data between the environments.
• Created various geographical and time dimension reports of fiscal year, quarter month, week and daily reports for all domains and published through Report Server.
• Developed many Tabular Reports, Matrix Reports, chart Reports using SQL Server Reporting Services (SSRS).
• Designed, Developed and Deployed Ad hoc, Sub-Reports, Drill down reports, Drill through reports and Parameterized reports in MS SQL Server environment using SSRS-2005.
• Involved in the development and designing of XML, HTML using Cascading Style sheets for displaying the reports on the Report Server.
• Analyzed & designed the business rules for data cleansing that are required by the staging & OLAP and OLTP databases.
• Used the star and snowflake schemas while developing the data warehouse.
• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Data dictionary and Metadata.
• Configured the report viewing security for various users at various levels using Report Manager.