PROFESSIONAL SUMMARY:

• Over 5+ years of professional experience in the IT industry as a MS SQL Developer using MS SQL Server 2014/2012/2008 R2/2005, Business Intelligence through SQL Server Integration, Analysis and Reporting Services (SSIS,SSAS.SSRS).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Vast experience in extracting, transforming and loading (ETL) data from OLTP (transactional) database and other data sources, including heterogeneous and homogeneous sources into Data Warehouse, In SSIS using various tasks and transformations.
• Expert in developing T - SQL (DDL,DML) statements, Data Integrity (constraints), Rules and Validation issues including complicated joins and cursor loops, creating indexes for fast retrieval of data, creating views, Indexes, triggers, cursors, stored procedures and functions.
• Experienced with deployments, maintenance, and troubleshooting of applications on Microsoft Azure Cloud.
• Created Customized and interactive dashboards using multiple data sources.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling for FACT and Dimension Table using Analysis services.
• Strong experience in writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Strong experience in data retrieval using ADO.NET data objects such as Dataset, Data Reader, Data list, Data Adaptor.
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS packages. Experience in transformation data from DB2 to SQL Server.
• Experience in creating ETL mapping in SSIS to load data from different sources to different target databases and data analysis, data profiling, data transformation, data mapping, data cleansing and data quality.
• Experience with Data flow diagrams, data dictionary, database normalization theory techniques, Entity relation modeling and design techniques.
• Worked in dimensional modeling with Star & Snowflake schemas and created the Data Source Views (DSV) and SSAS Cubes using the identified Fact and Dimensional Tables.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Expertise in Data Transformation and Data migration.
• Strong experience in Data warehouse concepts, ETL.
• Solid experience in performance tuning and Query tuning (Generating Plan table, Explain Plan, Optimizer with hints, Analyze, Indexing strategy, SQL Trace).
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Good Working experience with UNIX shells scripting.
• Working knowledge in Agile/Scrum Environment and used TFS (Team Foundation Server).
• Extensive experience in using Build Automation Tools and Continuous Integration concepts by using tools like MSBUILD, Visual Studio and ANT.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS:

SQL Server/BI Tools: SQL Profiler, Query Analyzer, BIDS, Export & Import (DTS), SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analysis Services (SSAS).

Databases: MS SQL Server 2012/2008R2/2008/2005, MS Access, Oracle 10g.

Languages: C, JAVA, Dot Net, T-SQL, BI, Power Shell. QA Selenium.

Tools: Visual Studio 2008/2010/2013/2015, Talend 5.6, Crystal Reports 8.5/9/10, Electric Commander, Flex Installer. Team Foundation Server (TFS). MS-Office, Selenium and Load Runner.

Operating Systems: Windows 7/8/10, Unix.

Architecture: RDBMS, OLAP, OLTP

Web Technologies: HTML, XML and VB Script

Web Application Servers: IIS, Apache Tomcat, Web Logic.

PROFESSIONAL EXPERIENCE:

Confidential, DETROIT, MI

SQL/BI Consultant

Responsibilities:

• Created/Updated database objects like tables, views, stored procedures, function, packages,
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Designed and developed packages for data warehouse using Integration Services (SSIS) SQL Server 2008/2008R2.
• Involved in providing ETL support for the production server.
• Deployed SSIS package into production environment and used package configuration to export various package properties to make package environment independent.
• Migrated DTS packages from SQL Server 2008 to SQL Server 2012 as SSIS Packages.
• Involved in creating SSIS jobs to automate the reports generation and cube refresh packages.
• Querying and manipulating multidimensional cube data through MDX Scripting (SSAS).
• Enhanced the functionality of OLAP cube by creating actions and perspectives from huge dataset using SQL Server 2008 Analysis Services.
• Created logical and physical database design, data structures and maintained it by writing stored procedures, user defined functions, views, T-SQL script.
• Expertise in Understanding and Analyzing Test Requirements, Tracking changes and maintenance of Test Requirements.
• Experience in Data driven Testing, Cross browser testing and parallel test execution using Selenium WebDriver and Selenium Grid.
• Expertise in implementing of Automation framework using Selenium.
• Proficient in devising all the artifacts of testing such as test Scenarios, Test Cases, Defect Reports and Test Summary Report.
• Installed and Configured MSBuild build Server, Created build agents and build Controllers.
• Created Build definition using Build template in TFS 2013 and TFS 2015. Customizing MSBuild build templates to meet the team requirement.
• Setting up build automation for gated check-in and CI builds. Configuring SQL Server scheduled backups for TFS data tier.
• Setting up build process for projects and deploying to IIS web servers.
• Providing support to new users and administrative support for team projects.
• Modified build scripts according to various build project requests and deployment of .net source code.

Environment: SQL Server 2008/2012/2014 Enterprise Edition, BIDS, SSAS, SSIS, SSRS, T-SQL, MDX, ETL, VB.Net, ASP.Net, C#, Talend 5.6, Electric Commander, TFS Builds, QA Selenium.

Confidential

SQL Server Developer

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications.
• Created database objects like tables, indexed views, indexes, stored-procedures, triggers and cursors using DDL, DML statements.
• Developed stored procedures and views for managing efficient data retrieval and application development.
• Wrote stored procedures for querying the data dynamically by defining parameters.
• Used reporting tool (Web focus) to create reports as per user requirements.
• Created reports out of the views and developed OLAP cubes.
• Optimized queries using SQL Profiler and performance monitors to enhance the performance of database servers.
• Used DTS Packages for data import and export data from SQL Server to MS Access, flat files and EXCEL files.
• Performed some DBA Tasks like checking the jobs, data consistency and troubleshooting the issues.
• Worked closely with developers, end users and Administrator in designing and developing database.
• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• Responsible for enhancements and Maintenance of the product.
• Optimized SQL statements for customer summary reports.
• Prepared the detailed project layout, analyzed existing technology involved, and documented work performed and stored in VSS.

Environment: SQL Server 2000/2005 Enterprise Edition, Microsoft Analysis Services, SQL Server Reporting Services, SQL Enterprise Manager, DTS, Erwin 4.1, Windows XP, MS Access, MS Excel, HTML.