SUMMARY:

• 8+ years of experience in design, analysis & development of SQL Server 2005/2008/2012 and SQL Server Business Intelligence Development Studio with strong background in data warehousing, Data Modeling and ETL experience
• Extensive experience in creating database objects like T - SQL scripts, stored procedures, views, tables, indexes and user defined functions using SQL Server 2005/2008R2/2012.
• Experienced in installing, configuring, managing, monitoring and troubleshooting MS SQL Server and implementing backup and recovery strategy for databases.
• Extensive knowledge and experience of Transact-SQL (DDL, DML) and in creating indexes, views, stored procedures, user defined functions, derived tables, and triggers to facilitate efficient data manipulation and data consistency.
• Experienced in designing and scheduling SSIS Packages for transferring data from multiple data sources to SQL server.
• Proficient in SSIS error handling, event handling, precedence constraints, break points and re-running of failed SSIS packages using checkpoints.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Experienced in writing Parameterized Queries for generating Tabular, drill down, drill through and sub-reports using SSRS and in generating on-demand and scheduled reports for business analysis or management decision.
• Test Controllers configurations, SQL Server Analysis Services (SSAS) & MDX querying.
• Experienced in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Expertise in Dimensional Modeling, Star Schema/Snowflake Schema, Fact and Dimension tables.

TECHNICAL SKILLS:

• T-SQL
• MS SQL Server 2012/2008/2005
• MS Access
• (SQL Server integrating Service) SSIS
• (SQL Server Reporting Service) SSRS
• (SQL Server Analysis Service) SSAS
• SQL Server Management Studio
• SQL Query Analyzer
• SQL Profiler
• Excel
• Access
• XML.
• HTML
• C++
• C#
• VB script.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

SQL/BI Developer

Responsibilities:

• Involved in the gathering requirements from the business users and created the Functional Specifications, Technical Specs, Design Documents and Approach Documents and Implementation of BI Analytics needs.
• Did business area analysis, requirements definition, source data identification, data quality definition, transformation, and summarization processes.
• Designed the Structure of Staging Database and Staging Tables used in the ETL Process to dump data into a common Staging.
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data into Production Data Base Tables.
• Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration Services (SSIS).
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Created and deployed Matrix, Grid, Chart, and Gauge Reports utilizing SSRS. Created parameters for SSRS reports as well as drill-down and interactive sorting capability. Implemented subscriptions and snapshots in the SSRS Report Manager. Integrated reports from SSRS with SharePoint 2010 and created/deployed reports and BI Dashboards in PerformancePoint/SharePoint 2010. Created pivot tables in Excel Services/PowerPivot 2010 and integrated within SharePoint.
• Analyzing facts and dimensions for data analysis and design within SSAS. Created KPIs for reporting of scorecards and/or performance management. Created and deployed cubes, perspectives, partitioning, hierarchies, aggregations, users and roles in SSAS. Created report actions that are linked to a SSAS cube within pivot tables.

Environment: MS SQL Server 2012, SQL server Reporting Services 2012, SQL Integration Services 2012,Microsoft Visual Basic, SQL Server Management Studio, MS Excel, T-SQL, SharePoint 2010, Power View, C#, VB script.

Confidential, Salt Lake city, UT

Business Intelligence Developer

Responsibilities:

• Worked with Business Analysts to understand the requirements and did Analysis, Design, Coding, Implementation and Production move
• Implemented a customer Account Analysis Business Intelligence solution for a financial institute.
• Optimized the performance of the queries with modification in T-SQL queries, eliminated redundant and inconsistent data, established joins and created indexes wherever necessary.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Designed and modified the existing packages accordingly by using the transformation tasks such as Script Component, Lookup, Derived Column, Condition Split, Union All, Copy Column, Aggregate and Audit Transformation.
• Created packages using Integration Services (SSIS) for extracting data from Flat Files, Excel files, OLEDB, Access etc to SQL Server.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases & data mart databases.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created on-demand and scheduled reports for business analysis and management decisions using SQL Server Reporting Services (SSRS).
• Created SSIS Packages using Script Task and various Shell scripts, C#, VB script.
• Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Developed detail and summary reports, line and pie charts, trend analysis reports, sub-reports, and MDX queries according to business requirements using SSRS.
• Involved in the maintenance of the existing cubes of the data warehouse by adding additional dimensions, user-defined hierarchies, calculated members using SSAS.

Environment: MS SQL Server 2008, SQL server Reporting Services 2008/R2(SSRS), SQL Integration Services 2008(SSIS),SQL Server Analysis Services 2008 (SSAS), SQL Server Management Studio(SSMS), MS Excel, T-SQL, SharePoint 2010, C#, VB script.

Confidential, Chicago, IL

Business Intelligence Developer

Responsibilities:

• Extensively used joins and sub-queries for complex queries involving multiple tables from different databases.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large amount of data from various data sources and forms such as Excel files, XML, CSV and flat files using SSIS.
• Designed and created SSIS packages using transformations such as sort, merge, merge join to load data into fact and dim table using lookup task.
• Designed and deployed ETL solutions in SSIS. Imported data from OLTP, flat files, or other data sources and created data flow solutions to cleanse and validate imported data. Inserted and/or updated newly cleansed and validated data into OLTP or OLAP databases.
• Designed indexed views for the reporting services in order to bring down the retrieval time.
• Extensively used SQL Reporting Services and Report Builder Model to generate custom reports.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Identified and worked with parameters for parameterized reports in SSRS.
• Involved in Creating Dimensions and Cubes and deployed it on to the server for the managers to analyze the ongoing production support for the application as required.

Environment: MS SQL Server 2005, SQL server reporting Service (SSRS), SQL server Integrating Service (SSIS), SQL Server Analysis Service (SSAS), MS Access 2003, Import and Export Data(DTS), MS Project Server.