TECHNICAL SUMMARY

• Over 8 years of experience in the field of Data Warehousing and Business Intelligence applications as an ETL Developer wif expertise in SQL Server Integration, Analysis and Reporting Services.
• Expert in working wif the Business Intelligence Development Studio (BIDS), which includes SQL server Integrated Services (SSIS), SQL Server Analytical Services (SSAS) and SQL Server Reporting Services (SSRS).
• Expertise in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2014/2012/2008/2005.
• Experience in Writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views, Indexes, Complex stored procedures, function(UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2005/2008 R2/2012/2014.
• Solid understanding of RDBMS database concepts and Experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Expert in working wif SSIS for creating packages to transform data from different OLEDB Provider like DB2, MS Access, Flat File, Excel, Oracle and Automate the ETL.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Proficient in Extraction Transformation and Loading (ETL) process by pulling large volumes of data (VLDB) from various data sources using SSIS
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Proficient in OLTP, OLAP and Data Warehousing Design concepts.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Parameterized, Cascading, Conditional, Table, Matrix, Chart, Adhoc and Sub Reports.
• Experience in generatingDrill through and Drill down reports wif Drop down menu option, sorting the data, defining subtotals in SSRS.
• Generated reports using SSRS, Excel (Pivot) dat could be used to send information to diverse group of users.
• Experience in Advanced Excel like Power View, Power BI, Power Pivot and Excel Data Connection.
• Developed reports using global variables, expressions and functions using SSRS
• Knowledge and experience in designing, developing and deploying Reports and Dashboards.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Expertise in SQL Server Analysis Services (SSAS) CUBE design, development and deploying.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 Server to achieve the efficiency of SQL Server Analysis Services (SSAS).
• Experience on performing Data loads to Dimension, Fact tables, Data warehouse, Data marts, and OLAP cubes.
• Expertise in MDX to create Named Sets, Named Members, Calculated Members and other calculations.
• Monitored and Tuned MS SQL Server databases wif tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.
• Excellent noledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Involved in optimizing code and improving efficiency in databases including re - indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development and Implementation.
• Knowledge in TFS (Team Foundation Server).
• Good Knowledge and Hands on experience in Data Mining and Data Integration.
• Able to work wif a team or individually wif excellent communication skills, and ability to meet deadlines in a fast-paced work environment.

TECHNICAL SKILLS

Databases: SQL Server 2014/2012/2008R2, MS-Access 2012, Oracle 11g/10/9i,DB2

Database Tools: SSMS, BIDS/Visual Studio, TOAD

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, SQL* Plus

Languages: C, C++, VB.NET, C#.NET, JAVA, PHP, UNIX, SQL, T-SQL, PL/SQL, MDX, DAX

Data Warehousing/BI Tools: SQL Server Business Intelligence Development - SSIS, SSAS, SSRS, DTS, Performance Point Server, Self-service BI (Power BI, Power Pivot, Power View, Power Map, Power Query)

RDBMS: SQL Server 2005/2008R2/2012/2014, Oracle 11g/10/9i

IDE: Visual Studio 2005/2008R2/2012/2014

Operating System: Windows 10/08/07, Ubuntu, Unix

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Methodologies: Agile, Waterfall, Scrum, SDLC

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

SQL/SSIS/SSRS/SSAS Developer

Roles &Responsibilities:

• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• 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.
• Created different Parameterized Reports (SSRS 2008/2012) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Created Ad-Hoc Reporting wif Report Builder and Programming Reporting Services.
• Designed and deployed reports wif Drill Down, Drill Through, Matrix Reports, Chart Reports and Dropdown menu option and Parameterized and Linked reports.
• Generated parameterized queries in SSRS 2008 R2/2012using data from SSAS Cubes and various heterogeneous data source
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2013using SSIS.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Deployed different SSIS packages on test and production servers.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Designed, Developed, Tested, Published and maintained PowerBI Functional reports, Dashboards based on user requirements.
• Created interactive Dashboards using Power BI for analytics Team.
• Created Dashboards using Power BI for analyzing MS Product Key Activations, MS Product Key Blocks & MS Product Key distribution shared across different partners.
• Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
• Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
• Upgraded existing packages developed using SSIS 2012 to SSIS 2014 packages.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2/2012.
• Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Create ad-hoc SQL queries for customer reports, executive management reports
• Created Reports, Report model Definitions, Scorecards, KPIs, and Dashboards utilizing Performance Point Server 2007/SharePoint Server

Environment:T-SQL, SQL Server 2012, SSIS (2012/2014), SSRS (2008 R2/2012), Maestro Jobs, Visual Studio2010/2013, MS Excel 2013, Power Designer.

Confidential, WA

SQL/SSIS/SSRS/SSAS Developer

Roles & Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Designed ETL packages dealing wif different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Implemented the concept of Incremental Data Load and Slowly Changing Dimension (SCD) Type 2 for dimension packages to move data from staging to dimension tables in SSIS.
• Implemented Package Configurations, Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Created Drill-through, Drill-down, Chart Reports, Cross Tab Reports and Sub-Report using RDL.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Created interactive Dashboards using Power BI for analytics Team.
• Created Dimensionsand cubes wif star schemausing SQL Server Analysis Services (SSAS).
• Created OLAP Dimensions, Measures and Cubes using SSAS.
• Created components, tools, techniques, methods and procedures used in an on OLAP environment for accessing and translating data into understandable and usable business information using SSAS.
• Migrated and recreated existing dimensions and cubes using star schema on 2012 server to achieve the efficiency of SSAS.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Used SQL Server Profiler to trace the slow running queries and tried to OptimizeSQL queries for improved performance and availability.

Environment: MS SQL Server 2008R2/2012, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), MS EXCEL, SQL Server Profiler, Team Foundation Server (TFS).

Confidential, Greensville, SC

SQL/SSIS/SSRS/SSAS Developer

Roles & Responsibilities

• Primary role was SQL Server Developer wif SSIS and SSAS.
• Created and executed SSIS (.dtsx) packages to extract data from the various data sources such as flat file, excel and from other database such as Oracle and by different data loading operations for many applications which is main purpose of ETL development using SSIS 2005/2008.
• Wrote SSIS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Managed the migration of SQL Server 2008 databases to SQL Server 2012.
• Created tables for data ware housing applications and populated the tables from the OLTP database using SSIS packages.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP wif the halp of SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements wif error handling.
• Enhancing and deploying the SSIS Packages from development server to production server
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Termextraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task 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.
• Developed cubes by defining data sources and data source views and using SQL server analysis services (SSAS).
• Reviewed cube, changed the cube and documentation according to the requirement based on product valuation and revenue opportunities.
• Involved in defining Referenced Relationships wif the measure groups and fact tables.
• Defined Granularity wifin a measure group and drill through actions.
• Implemented the calculations to aggregate physical measures.
• Using MDX created calculated members for customized calculated measures.
• Analyzing the Performance of a cube by partitioning it and creating Perspective Cubes.
• Wrote MDX queries and expressions for use in Front End BI Applications.
• Created KPI Objects in line wif Requirement Docs and Optimized cubes for better query performance.
• Created reports from cubes by writing MDX queries.
• Writing various Stored Procedures, Triggers, Functions, and Views based on the functionality requirements for various teams and also to load data from the OLTP database.
• Wrote Triggers (After and Instead of) and stored procedures to capture updated and deleted data from OLTP systems.

Environment: SQL Server 2008/2012, BIDS 2008/2012, SSAS 2008/2012, SSIS 2008/2012, DTS, MDX, VB, MS Access, Visual Studio, T-SQL, Windows XP

Confidential, White Plains, NY

SQL/SSIS/SSRS/SSAS Developer

Roles & Responsibilities

• Worked as a developer in creating complex Stored Procedures, Triggers, Functions.
• Developed Triggers to raise events on executing insert, delete and update stored procedures.
• Optimized existing stored procedures to achieve improved performance.
• Developed advanced correlated and un-correlated sub-queries in T-SQL to develop complex reports.
• Developed logical and physical data models using data modeling tools such as Erwin and ER/Studio.
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services.
• Developed XML tags to structure data and improve the data migration process.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 9i/10g.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• Worked on SSIS performance tuning using counters, Error handling, Event handling, re-running of failed SSIS packages using Checkpoints.
• Worked wif Transactional and Snap-shot Fact-Tables.
• Created Sub-Reports, Drilldown-Reports, Drill through, Summary Reports, and Parameterized Reports in SSRS.
• Created region level security in reports to prevent users of one region from seeing data of a different region and implemented subscriptions for Reports using SSRS.
• Created and Configured OLAP Cubes (Star Schema and Snow Flake Schema) using SQLServer Analysis Services (SSAS).
• Expert in using tools likeMS SQL Profiler, Database Engine Tuning Wizard, Windows Performance Monitor and tuning SQL Server performance.

Environment: SQL Server 2008, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), VB, MS Access, Visual Studio, T-SQL, Windows XP.

Confidential, Dallas, TX

SQL/SSIS Developer

Roles & Responsibilities

• Create User Defined Functions, Stored Procedures, and Triggers.
• Performed data conversions from Flat files into a normalized database structure.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis
• Responsible for creating constraints, Indexes, and Views.
• Optimized the performance of queries wif modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Created triggers, views, user defined functions to incorporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Managed up gradation of DTS packages to SSIS packages.
• Identified and worked wif Parameters for parameterized reports in SSRS.
• Used Database Maintenance Wizard to make necessary changes and to keep the performance of the server at acceptable levels.
• Configured Server for sending automatic mails to the respective people when a SSIS process fails or succeeds.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Created SSRS Reports on daily, weekly and monthly basis for manger’s review.
• Responsible for MS SQL Server 2005 in Production, Test, Development and Replication & Cluster Server Environments
• Efficiently halped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation

Environment: SQL Server 2008, Windows 2005 Advance Server,SSIS, Windows 2008 Server, XML, T-SQL, MS Excel, MS Access, VB.NET 3.0 and DTS.

Confidential

SQL/SSIS Developer

Roles & Responsibilities

• Analyzed business requirements and build logical data models dat describe all the data and relationships between the data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules wifin development team.
• Modified database structures as directed by developers for test/develop environments and assist wif coding, design and performance tuning.
• Managed user access. Created and managed new security accounts.
• Backup and restore databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the SSIS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics info for both the old and new servers.
• Assisted wif various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2005, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS

Confidential

SQL Developer

Roles & Responsibilities

• Interacted wif end users to gather Requirements. Created technical, user documentation.
• Studied and designed the system.
• Install, Update, Configure and Maintain the MS SQL Server.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user define functions.
• T-SQL queries for the retrieval of the data.
• Created a report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filter reports.
• Tuning front-end applications like Visual Basic, which query the SQL Server databases.
• Written Various ASP codes for user interactions.
• Written Java Script for different validations
• Used SQL Statements to Present Query responses.

Environment: SQL Server 2005, T-SQL, UNIX, .NET, VB Script, JavaScript, ASP, Microsoft Excel, FrontPage 2005.