SUMMARY:

• Over Ten Years of experience as a MS - SQL Server Developer (2000/2005/2008/2012/2014/2016 ) .
• Experience in SQL Server Analysis Service 2005/2008 R 2/2012/2014/2016
• Experience in SQL Server Reporting Service
• Experience in create implement Data mining application
• Experience in SQL CDC using SSIS
• Experience in Always-on (SQL 2014)/ Data Mirroring (SQL 2005/2008)
• Experience in Team Foundation Sever & GIT for version control.
• Data modeling and Design with ER Win, ER Diagrams, MS Visio.
• Tuning and optimizing Analysis Server and MDX Quires.
• Proficiency in Excel Objects (Pivot tables, Chart, Graphs)
• Working knowledge in DB2, IBM iSeries, Informix, Oracle 8i and SAP R/3
• Experience with RedGate SQL Backup and Veritas NetBackup
• Working knowledge in .NET application (Development and Maintenance)
• Excellent Verbal & Written Communication skills and strong in Documentation.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Experience in Financial, Transportation, Healthcare and Retail trading domains.

TECHNICAL SKILLS:

Technology: SQL Server 2005 /2008 R 2 /2012 /2014/2016

Development: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) multidimensional / Tabular: SQL Server Reporting Services (SSRS)

T-SQL: Stored procedure / Functions / Triggers

MDX: DAX / Power BI

Version Control: Microsoft TFS, GIT

Cloud: Microsoft Azure / Amazon RedShift

MS Office Components: Excel, Pivot Table

Query Optimization and performance tuning: T SQL / MDX

Datamining: Time Series and Decision Tree

Visual Studio: 2010/ 2012 & 2015

Scripting: PowerShell, vb script, c#

Tools: Red Gate / TOAD

Markup Language: HTML / XML / JSON

Scheduling Tool: SSMS, Windows Scheduler and BMC Control-M

Database and connectivity: MDAC,ODBC,OLE DB, ADO & ADO.NET

PROFESSIONAL EXPERIENCE:

SQL Server Developer

Confidential, Warrenville, IL

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Functions, Triggers, Views and complex SQL statements for applications using SQL Server 2012/2014.
• Extensive Testing on the Performance of the Stored Procedures.
• Design and development of complex reports, business scorecards and management dashboards on relational and OLAP sources
• Create troubleshoot and maintain SSIS package.
• Optimization of slow performing SSIS packages
• Design and implement SSIS package to extract data from Zonar System (Real time fleet management system)
• Develop database structures/Data Modeling and design including stored procedures, views and functions
• Perform process/code review sessions with outsouce team and suggest improvements or alternate strategies when appropriate Verification of data accuracy and integrity through analysis, problem resolution, alert monitoring and process documentation
• Experience Microsoft Power BI, (creating dashboard and interactive reports)
• Working knowledge in MDX/DAX

SQL Server Developer

Confidential, Chicago, IL

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Functions, Triggers, Views and complex SQL statements for applications.
• Extensive Testing on the Performance of the Stored Procedures.
• Experience on implementing Column Stored index.
• Experience with Data Warehouse concepts, including the use of Extract, Transform, and Load (ETL) tools and creation of data marts.
• Experience in analysis, tracking and enforcing query optimization using Query Store (SQL Server 2016)
• Knowledge in Polybase (External Tables) and Azure Blob Storage
• Design and development of complex reports, business scorecards and management dashboards on relational and OLAP sources
• Create, troubleshoot and maintain SSIS package.
• Optimization of slow performing SSIS packages
• Extensive knowledge on oData Source to import data from Share point.
• Implemented event handler in SSIS for logging and also send alerts for failure.
• Working knowledge in parameterized SSIS packages.
• Experience with JSON data and extensively used in SSIS packages.
• Translate project requirements into business and functional specifications for BI reports and applications
• Developed complex T-SQL code for the application conversions.
• Wrote and integrated Stored Procedures to generate the Reports.
• Design and implementation of stored procedures and triggers for automating tasks.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, Triggers and problems related to the privileges.
• Experience in SQL Server Tabular and MDX Models
• Extensive experience and expertise in building/refactoring/optimizing parameterized SSIS packages
• Design and Create/ enhancement - SSIS package
• Working knowledge in implementing range partitioning on large tables for better performance.
• Set up event handler to notify package failure and catch exception data.
• Experience in using DMVs to Monitor and troubleshoot server and databases.
• Develop, maintain, and manage advanced reporting, analytics, dashboards and other BI solutions using SSRS and other reporting and visualization tools.
• Working knowledge of Business Intelligence warehouse modeling utilizing Kimball Methodology
• Advanced database design and SQL programing.
• Subscribe SQL Server Azure Cloud Services.
• Setting up SQL Azure Firewall
• Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS)
• Experience utilizing the SDLC (System Design Life Cycle)
• Experience with Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX/DAX Queries using SQL Server Analysis Services.
• Analysis, Implementation and Documentation of Mapping with different source data.
• Coordinates with DBAs to automation/job scheduling
• Act as primary technical point-of-contact for product support for installation, configuration, and implementation of the business intelligence platform.

SQL Server Developer

Confidential, Chicago, IL

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Functions, Triggers, Views and complex SQL statements for applications.
• Extensive Testing on the Performance of the Stored Procedures.
• Developed complex T-SQL code for the application conversions.
• Wrote and integrated Stored Procedures to generate the Reports.
• Create, troubleshoot and maintain SSIS package.
• Optimization of slow performing SSIS packages
• Implemented event handler in SSIS to logging and also send alerts for failure.
• Experience with Data Warehouse concepts, including the use of Extract, Transform, and Load (ETL) tools and creation of data marts.
• Design and implementation of stored procedures and triggers for automating tasks.
• Wrote complex stored procedures to process employee requirement and generating records between front End
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, Triggers and problems related to the privileges.
• Managed and resolved design issues during development.
• Design, Create and enhancement to existing SSIS package
• Working knowledge in implementing range partitioning on large tables for better performance.
• Set up event handler to notify package failure and catch exception data.
• Experience in using DMVs to Monitor and troubleshoot server and databases.
• Used Microsoft Team Foundation Server (TFS) source/version control
• Working knowledge on TFS for work item tracking, project management, and build management .
• Working knowledge in Slow Changing dimension
• Develop, maintain, and manage advanced reporting, analytics, dashboards and other BI solutions using SSRS and other reporting and visualization tools.
• Working knowledge of Business Intelligence warehouse modeling utilizing Kimball Methodology
• Advanced database design and SQL programing.
• Familiarity with job scheduling tools and concepts is required.

SQL Server Developer

Confidential, Chicago, IL

Responsibilities:

• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Involved in migration of data form SQL SERVER 2008 to SQL SERVER 2012.
• Designed dynamic DTS and SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Created cross reference tables and ETL routines to standardize the data coming from multiple sources
• Involved in ETL Architecture, Developing Source to target data mapping (STDM) document defining transformation logic
• Translated business logic to transformation logic to generate pseudo code for the ETL process
• Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL Tool.
• Worked on Visual Studio 2012 and Synced/loaded projects with TFS 2010.
• Used transformations like Lookup, Aggregator, Sort, Derived Column, Union All and OLE DB Command to implement the transformation Logic and load the target tables.
• Developed the logic to Capture the Error Rows in the data flow and populate them into an Excel file
• Performance Tuning the Stored Procedures used in SSIS Packages

SQL Server Developer

Confidential, Chicago, IL

Responsibilities:

• Develop and implement the business logic and the ETL mechanism to populate the dimensional structure. Program ETL tool with business rules to be applied to data from source input to target data repository, automating data extraction/load programs to run on regular schedule.
• Migrated SQL Server DTS to SSIS Packages(ETL)
• Data extraction and manipulation experience - ETL Tools (SSIS2008, DTS) - Strong understanding of ETL processes; ability to design and implement robust, scalable data integration solutions.
• Extensively used Script Component, Lookups, Fuzzy lookup, Derived columns etc.
• Test and deploying SSIS packages from Dev. - UAT - Production.
• Implemented Change data capture process with SSIS, to perform efficient incremental loads to a data warehouse
• Comfortable in configuring different external services that can be linked to the server such as mail notification, SSIS, SSAS and linked servers,
• Design SSIS package to implement business rules.
• Responsible for Monitoring and troubleshooting Log Shipping .
• Develop database objects, stored procedures and packages, views, tables, and triggers as needed
• Assist in developing detailed business and technical specifications based on project requirements and in converting business and technical specifications into data extraction/load programs.
• Develop and assist in implementing system and unit test programs ensuring correct application of transformation logic from source to target. Develop and implement automated test scripts to ensure that source system data is accurately represented in the final reporting objects of the Data Warehouse.
• Work with other application developers and computer operations to support test, QA and production reporting environments including daily administration, batch processing, configuration management, environment migration, and tool automation
• Document all phases of work including gathering requirements, joint relationship diagrams, database diagrams and other program technical specifications using current specified design standards for new or revised solution.
• Ensures the quality, consistency and security of company data and database systems. Performs database upgrades
• Involved in job maintenance and on call support, more 250 jobs running daily/week, extract data from multiple sources and processing cubes, rendering reports to client
• Design/development/implementation of SSAS 2008 cubes (MOLAP, ROLAP)
• Perform comprehensive analysis and performance tunings of cube processing and MDX
• Customizing cube result using MDX queries.
• Cube level, cell level security and user administration.
• Knowledge and experience in data Warehouse Life Cycles.
• Developed task to create dynamic partitions.
• Defining and creating dimensions natural and non-natural dimensions
• Designed an ETL process and created Slowly Changing Dimensions (SCD Type 2) using T-SQL stored procedure and SSIS SCD transform package.
• Established and Implemented Data Mining Algorithm
• Implement prediction query for data mining structure
• Identify rules and patterns for data mining
• Defining Drill-Through options
• Resolving user connectivity issues for both domain and non-domain account holder.
• Experience and strong knowledge of dimensional modeling principles (Ralph Kimball)
• Migration of SQL Server 2000 cube database to SSAS 2005
• Integrating KPI with reports
• Design and create drill through functionality in reports.
• Design and Develop Dashboard reports.
• Implemented client applications which make use of Reporting Services, Panorama and Pivot Table Service component to connect to local cubes
• Establish and maintain high-performance datawarehouse with various data reporting capabilities
• Handled dynamic customer requirements.
• Define and develop Report Structure with data definition, report layout and report definition language.
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS)

SQL Server Developer

Confidential, Chicago, IL

Responsibilities:

• Upgraded application running in SQL Server 2000 to SQL Server 2005/2008
• Migrated SQL Server DTS to SSIS Packages(ETL)
• Extensively used Script Component, Lookup, Fuzzy lookup, Pivot, Derived columns etc.
• Test and deploying SSIS packages from Dev. - UAT - Production.
• Set up event handler to notify package failure and catch exception data.
• Design SSIS package to implement business rules.
• Implement alert to notify on call support, in event of any failure
• Trouble shoot and fine tuning SSIS packages.
• Migrated SQL Server 2000 stored procedure to SQL Server 2005/2008.
• Configuration and Managing SQL Server Services.
• Creating of automated build, testing, integration and nightly data refresh/load processes.
• Managing and supporting complex, high volume BI environments 24/7 support.
• Used to DMV’s/DMF to monitor and troubleshoot server and databases.
• Troubleshooting SQL Jobs in SQL 2005/2008.
• Optimize and tuning slow running query
• Create and managing Schemas and Schema security based on application role.
• Implemented and managed Full-text search using by internet application for product search.
• Find and Optimize and tuning slow running query for better performance.
• Working knowledge of SQL Server Common Table Expressions
• Implemented log shipping and data mirroring for DR and report application.
• Architect, design, and develop multi-dimensional schemas and SSRS reporting systems for internal partners.
• Scripting of Database configurations, security, jobs
• Writing Stored Procedures, Functions, Triggers
• Creating and Maintaining Maintenance Jobs, alerts.
• Define Data Partition, provides a way to divide large tables and indexes into smaller parts.
• Worked on full lifecycle dataware house project.
• Design and populate Fact table and Dimension using SSIS (Nightly ETL process)
• Implemented data mining algorithms
• Create ROLAP/MOLAP cubes using SSAS 2005
• Reconcile / synchronization of data between OLTP and OLAP through ETL
• Test in UAT and deployment to production as per Change Control procedures.
• Develop reporting model in SSRS using SSAS cube and real time data (ODS)
• Developed on demand and scheduled report using SSRS
• Experience in Configuration of reporting server (SSRS2008R2)
• Expose cube data using MDX and Pivot table in EXCEL w/.Net) components of the tools.
• Design ETL process for data ware house cubes.