SUMMARY

• Over 8+ years of Professional experience in the IT industry as a MS SQL Server Developer using Microsoft SQL server 2014/2012/2008 R2/2005/2000 in Retail, E - Commerce and Health Care Domains.
• Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like MS EXCEL.
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Expert in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Strong Experience in various Extracting, Transforming and Loading ETL/SSIS data flow ETL/SSIS using SSIS.
• Excellent in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, also created Indexed Views, complex Stored Procedures, Triggers, effective functions to facilitate efficient data manipulation and data consistency.
• Highly Proficient in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts.
• Good SQL Server Administration skills including, Backups, Restore, database maintenance, user authorizations and Database creation.
• Experience in using tools like Database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Thorough understanding of Kimball/Inman strategies, KPI, Data mining structures.
• Advanced extensible reporting skills using SQL Server reporting services (SSRS). Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports.
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
• In depth understanding of SQL Server Migrations and problem management
• Good experience in using tools such as SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
• Experience in deploying reports on SharePoint Server using SharePoint Integrated Mode.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduling Packages.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
• Have excellent communication skills, analytical skills, understanding of business requirements in various domains
• Proficient in gathering Business Requirements from business stakeholders, Analyzing documenting System Requirement specification, Functional Requirement specifications and maintaining Requirements.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL 11g, Dynamic SQL, MDX, C, C++, C#, ASP (.NET), XML

Databases: MS SQL Server Denali, 2014,2012,2008R2, 2008,2005,2000

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Informatica, Visual Studio, Crystal Reports.

Database Design Tools and Data Modelling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modelling, FACT& Dimensions tables, Physical & logical data modelling and De-normalization techniques, Kimball &Inmon Methodologies

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities: SQL Server Management Studio, SSDT, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Power Pivot, Microsoft Office (MS), Lotus Notes, Excel Power Pivot, Excel Data Explorer, Tableau.

Operating Systems: Windows 10/8/7/Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Castle Rock, Colorado

Sr. MSBI developer

Responsibilities:

• Installed and Upgraded from SQL Server 2008 to SQL server 2012 on Various Servers.
• Migrating Databases from SQL Server 2008 to SQL Server 2012.
• Planned, defined and designed data based on the business requirement
• Creating dashboard, scorecards using performance point server according to client requirements.
• Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS and also prepared ETL/SSIS mapping processes and maintained the mapping documents.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Developed SSIS Templates, which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Designed logical/physical data models using Erwin tool 8.0.Uses of power pivot.
• Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Experienced in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server.

Environment: MS SQL Server 2014/2012, Performance point server, MS SSRS 2012, MS SSIS 2012, T-SQL, VB Script, Windows Server 2012, Erwin 8.0

Confidential, Indianapolis, Indiana

Sr. ETL MSBI developer

Responsabilités:

• Work closely with business users to congregate and comprehend requirements.
• Preparation of documentation for all the requirements and enhancements to reports.
• Provided Design documents for offshore and has been an On-Shore Offshore Coordinator and has been a lead for about 8 resources at off-shore.
• Design and develop SSIS packages, Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance.
• Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source and SQL server using SSIS.
• Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Developed SSIS Templates, which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created SSIS packages to copy tables, schemas and views and to extract data from Excel.
• Created cross validation rules to ensure mapping accuracy.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services (SSAS).
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed Dimensions, Data source views, SSAS Cubes, deployed and processed SSAS objects, created SSAS storage and partitions and aggregations.
• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created different chart reports helped in analyzing perform counters using SSRS.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Azure, SQL Server 2014 using T-SQL.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Coordinating post-implementation events such as testing.

Environment: SQL Azure Database, SQL Server 2014/2012, SSIS, SSAS, SSRS, TFS, VSO, SSDT 2012, VBScript, XHTML, XML, MS Excel, Windows 2005/2008/2012 Server.

Confidential, St. Louis, MO

Sr. SQL Server BI Developer

Responsibilities:

• Interacted with users to gather business requirements.
• Designed the POS pricing process requires the loading of various input files and processing of these files.
• Project involves 3 stages initial loading phase where first stage involves data is loaded from flat files to temporary tables, in the second stage data is flowing through temp tables to staging and in final stage data is moved to main tables Prod roles, Promotions and product.
• Create ETL process to move data from AS400 to SQL Server using SSIS.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules.
• Fine-tuned and checked the performance of existing objects in SQL Server and implemented transactional logic for them.
• Used Red gate SQL Compare to create a report and SQL change script with schema differences between production, development and testing servers.
• Used Red gate SQL Data Compare to generate a script with data differences between production servers.
• Involved in usage of various SSIS components like for loop, Foreachloop, Derived column, sql execution task, Variables, and Error Handling etc.
• Extensively worked with SSIS tool suite; designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Aggregator, Multicast and Derived Column.
• Designed ETL packages for extracting the data and load into the appropriate tables in the database using SQL Server Integration Services (SSIS).
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Fine-tuned and checked the performance of existing objects in SQL Server and implemented transactional logic for them.
• Transformed the logical data model into physical data model.
• Used various transforms in SSIS to load data from flat file to the MS SQL database.
• Created error handling for all the control flows.
• Involved in design and analysis of underlying database schema, altering and creation of the table structure.
• Created test scenarios for the application which involves in three stages.
• Documented the technical specifications and test scenarios for the project.

Environment: MS SQL Server 2012/2008 R2, T-SQL, SSIS Business Intelligence Development studio.Net Framework, VB Script, MS Visio, Visual Studio 05, Visual source safe, Windows server 2008 R2.

Confidential, Durham, NC

SQL Server BI Developer

Responsibilities:

• Created database objects like Tables, Indexes, Stored Procedure, Triggers, Functions, Constraints and Views.
• Fine-tuned Stored Procedures to improve performance that was achieved by removing unnecessary Cursors and Temporary Tables.
• Worked on Linked Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLEDBDrivers.
• Responsible for Design and Normalization of the database tables.
• Prepared Data Flow Diagrams, Entity Relationship Diagrams and Table Structure.
• Created and Migrated DTS packages from SQL Server 2000 to SQL Server 2005 Integration Services (SSIS).
• Gathered requirements for the creation of Data Flow processes for the SSIS packages.
• Used various Control Flow Tasks in the development of various complicated packages.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Developer and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Experience in Developing and Publishing Reports in SQL Server 2005 using SSRS (SQL Server Reporting Services).
• Created various kinds of reports involving Drill Down, Drill through Report, Parameterized Reports and Ad-hoc Reports.
• Designed the Sales and Manufacturing Summary reports in SSRS 2005 from the requirement document.
• Identified and worked with Parameters for Parameterized Reports in SSRS 2005/2008.
• Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.

Environment: SQL Server 2008/2008R2, T-SQL, Windows Server, Microsoft Visio, Performance Monitor, SQL Server Profiler, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).

Confidential

Jr.SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Analyzed business requirements and created logical and physical data models.
• Develop Extract Transform Load packages to the Chancery Student Information System.
• Develop/Maintain interfaces with other systems such as Exceed Special Education System, Library System, Food Services and Operational Data Store.
• Designing of SSIS Packages to get data files SFTP Server and batch processing of incoming data and purging of old files.
• Created SSIS packages to migrate data from different data sources to data warehouse.
• Created SSIS packages for different vendor applications like I-station, GTflag, Health Master, LEP, Homeless, Hippy, Euphoria, SpecialED, and CareerCrusing.
• Successfully extracted transformed and load data into data warehouse.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Used different control flow and data flow transformation to developed packages.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Wrote complex Stored Procedures and triggers to capture updated and deleted data from OLTP systems.
• Involved in discussion of new database creation and migrate object from old database to new development database.
• Designed and created Report templates, bar graphs and pie charts based on the student health care system data.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008 R2.
• Designed reports using MS SQL server Power Pivot-tables, bar-charts, Line-charts and Pie-charts on data from cubes and SQL Server in Excel 2007.
• Created data driven subscriptions for different users using Report Manager.

Environment: MS SQL Server 2005, T-SQL, SSIS Business Intelligence Development studio, .Net Framework, C# Script, Visual Studio 2005/2008/2010 , Windows server 2003/2008, SharePoint 2007.