Motilal

acw9qh@r.postjobfree.com

803-***-****

Professional Summary:

•Over 7+ years of experience as Microsoft SQL Server developer using Microsoft Business Intelligence (MSBI) tools such as SSIS, SSRS, SSAS and SQL Server data tools (SSDT).

•Good hands on experience in writing complex SQL Server procedures, functions, views, triggers etc. and several advanced features.

•Involved in performance tuning of complex SQL queries and their optimization techniques.

•Experience in gathering requirements, design, development and deployment of SSIS (SSIS 2008R2 and SSIS 2012) packages.

•Highly proficient in integration of data from different sources like SQL Server, Oracle, DB2 and Flat Files into Enterprise Data Warehouse (EDW).

•Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

•Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

•Experience in deploying SSIS packages to multiple environments using different methodologies and performing Automation of SSIS Packages using SQL Server Agent

•Experience in SQL Server Analysis Services OLAP Cubes.

•Expertise in writing MDX queries and building Key Performance Indicators (KPI) in cubes.

•Experience in creation of Tabular model in SSAS for creating Power pivots, Power View reports and Dashboards.

•Good knowledge of SSRS architecture. Involved in testing of Web services using WSDL files.

•Validated the SOAP requests and responses using the tool called SOAPUI.

•Involved in creation of mock responses using SOAPUI tool.

•Inserted assertions in SOAPUI to validate the expected response from the Web services.

•Configured and installed various software and Add-Ins on Windows, as well as conducted all upgrades

•Hands on experience in developing, deploying and managing Parameterized reports and Linked reports, Sub reports, drilldown reports, drill through reports and Crystal Reports.

•Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2008 R2/2012) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2008 R2/2012.

•Expert in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.

•Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.

•Experience in Data Warehouse concepts and on different schemas like Star Schema and Snow Flake Schema.

•Involved in designing of a Data Warehouse from the requirements phase.

•Good knowledge in Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.

•Experience working in Agile and Waterfall model working methodologies.

•Knowledge on Health Care, Finance, Banking and Energy Domain.

•BI Integration with SharePoint like Power View, Power Pivot and Power Query, Excel Service, and Reporting service.

•Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP

•Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.

•Quick learner and proactive team member with good Communication skills and Leadership capabilities.

Professional Skills:

Databases Tools

SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Reporting Services. SQL Server Integration Services, SQL Server Analysis Service (SSAS)

ETL Tools

Data Transformation Services (DTS) – Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools

SQL Server Reporting Services (2012/2008/2005), Microsoft Access 2013, MS Excel, Microsoft-Access, Excel

Database

MS SQL Server 2014/2012/2008/2005/2000, MS Access,

Oracle 11g/10g/9i/8i

Programming

T-SQL, PL-SQL, C

Web Technologies

HTML, DHTML, XML, XSL

Operating Systems

Windows 2008, 2003R2, 2003, 2000 Advanced Server, Windows XP, Windows Vista, Windows 7

Other Tools

MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash

Experience:

Echo Global Logistics, Inc., Chicago SEP 2014 – till date

MS SQL/MSBI Developer

The company provides a wide range of transportation and logistics services, such as carrier management, rate negotiation, freight bill audit and payment, routing compliance, and shipment execution and tracking. In addition, its Evolved Transportation Manager (ETM) software analyzes clients' transportation needs and helps reduce costs, as well as manages all procedures in shipping. Established in 2005, Echo Global Logistics customer base are primarily companies in the manufacturing and consumer products industries.

Responsibilities:

•Involved in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

•Worked with SSIS for transferring and reviewing data from heterogeneous sources like (Oracle, Excel, CSV, flat file, XML, Text Format Data).

•Prepared technical design/specifications for data Extraction, Transformation and Loading.

•Used SSIS and T-SQL, PL/SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.

•Prepared the complete data mapping for all the migrated jobs using SSIS

•Involved in building and maintaining SSIS Packages to import and export the data from various data sources (Oracle, Excel etc.) using BIDS based on the design data models.

•Used ETL (SSIS) to develop jobs for extracting, transforming and loading data into data warehouse.

•Created SSIS packages for File Transfer from one location to the other using FTP task.

•Created and Managed OLAP Cubes using SSAS.

•Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes

•Participated actively in client meetings daily and produced detailed level design document for the customer portals.

•Created parameterized reports, drill down, drill through, Sub reports, linked reports, Snapshot, Adhoc reports using SSRS2008 R2.

•Generated SSRS Reports using Global Variables, Expressions and Functions for the reports.

•Extensively used joins and sub-queries for complex queries involving multiple tables from different databases.

•Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.

•Performance tuning and optimization of stored procedures Designed and written the queries in the query builder for retrieving the data.

•Involved in testing of Web services using WSDL files.

•Validated the SOAP requests and responses using the tool called SOAPUI.

•Involved in creation of mock responses using SOAPUI tool.

•Inserted assertions in SOAPUI to validate the expected response from the Web services.

•Configured and installed various software and Add-Ins on Windows, as well as conducted all upgrades.

•Used report items like tables, sub report and charts to develop reports in SSRS.

•Worked with various delivery mechanisms of reports including Email /PDF/Schedules

•Managed and troubleshoot report server related issues.

•Created dimensions with the cube wizard and generated named calculations /queries.

•Involved in defining referenced relationships with measure group and fact tables.

•Defined Granularity with in a measure group and drill through actions.

•Implemented the calculations to aggregate physical measures.

Environment: SQL Server 2012, SQL Server 2008R2, SSIS, SSRS, SSRS, BIDS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, MS-Excel.

PNC Bank - Cleveland, OH MAR 2012-SEP2014

MS SQL/MSBI Developer

PNC offers a wide range of services for all our customers, from individuals and small businesses, to corporations and government entities, we provide deposit, lending, cash management and investment services to more than 6 million consumer and small business customers across 19 states. Customers can bank whenever and wherever they want via more than 2,600 branches, online and mobile services along with 9,000 ATM machines, many of which can be used to make deposits and cash checks.

Responsibilities

•Involve in complete Software Development Lifecycle (SDLC).

•Analyze user requirements, functional and technical specifications, preparing test plans and write test cases.

•Create complex SQL stored procedures, Triggers, Functions, Views, Indexes in Microsoft SQL Server 2008 and 2012.

•Configured SSIS packages using Package configuration wizard to allow packages run on different environments.

•Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, and process SSAS cubes to store data to OLAP databases.

•Created Matrix, Drill-down and Sub-Reports in SSRS using different types of properties like Chart controls, filters, Interactive Sorting, SQL parameters etc. Deployed RDLs to Report Server (Share Point).

•Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.

•Interacted with business users in collecting the requirements, solving issues and making changes as required.

•Managed indexes and optimized queries using execution plan.

•Used temporary tables, table variables and common table expressions (CTE) for the better performance of the queries according to the requirement.

•Involved in performance tuning of queries and SSIS packages which increases the performance and runs faster.

•Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

•Created ETL packages to get the data from XML raw files and used XSD files to convert the raw file to desired format.

•Created complex packages and performed the ETL to load the Dimension Tables in using SSIS.

•Used C#.Net and Vb.Net in Script tasks in order to validate the files and to get the latest files.

•Used Script component using C#.Net to perform row by row transformations in data flow tasks.

•Implemented the concepts of incremental data load, Slowly Changing Dimensions for updating and maintaining the history of the records.

•Upgraded SSIS 2005 packages to 2008 packages.

•Involved in testing the performance of SSIS packages over different servers in collaboration with platform labs.

•Used Event Handlers to handle errors in the packages.

•Deployed the SSIS Packages from development server to production server.

•Used script task to produce HTML reports and mail using SSIS.

•Created SSRS reports by Report designer for the users and deployed onto the report server.

•Parameterized and cascaded reports are also used to make the reports interactive with the users.

•Supported multiple projects at a time.

Environment: Microsoft SQL Server 2008 R2/08, BIDS, SSIS, SSAS, SSRS, SQL Profiler, DTA, Erwin, Windows

Servers.

USG Corporation, Chicago, IL JUN 2011 – MAR2012

SQL/MSBI DEVELOPER

USG is North America's leading producer and distributor of gypsum wallboard, joint compound and a vast array of related products for the construction and remodeling industries. They are also the global leader in the manufacture of ceiling suspension systems and are recognized as the premier acoustical panel and specialty ceiling systems innovation.

Responsibilities:

•Understanding the report design Requirements and Constraints.

•Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.

• Design and implementation of Security Model, Policies and Procedures.

•Performing query plans and making sure each and every query is using appropriate useful Indexes

•Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity

•Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.

• Rebuilding Indexes and Tables as part of performance tuning exercise.

•Deployed the created SSIS packages in Development and Testing environments.

• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.

•Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.

•Performance tuning of Stored Procedures and T-SQL Queries

•Designed and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.

• Writing heavy stored procedures, Audit triggers views, creating SQL scripts for data loads and Upgrades for data migrations and data validations.

•Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart database.

• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.

•Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

•Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

•Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).

• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

• Created Drill-down, Parameterized and Sub-Reports using RDL.

•Promoted RDLs to Reporting Service Server (SSRS).

•Modified report content and exported reports in multiple formats based on user input.

• Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.

• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008.

•Created Calculated members in MOLAP cube using MDX in SSAS 2008.

•Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs

•Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.

Environment: Microsoft SQL Server 2005/2008/2012, T-SQL, SSIS, SSRS, MS Excel, Word

UnitedHealth Group Information Services, Hyd, India JAN2010-JUN2011

ETL & SQL Developer

Optum’s Edge solution is a Multi-Tenant Data acquisition & management platform which provides aggregated data to the CMS’s Edge Server for calculating Reinsurance & Risk Adjustment. The solution is built to provide high data quality and integrity before submissions to CMS’s EDGE server to ensure meaningful error correction and support with resubmissions. It comes with 200+ business data validation pre-filtering to minimize CMS rejections and risk scoring accuracy.

Responsibilities:

•Design & Develop ETL packages at different Stages (Acquire, Stage, ODS).

•Contribution in the Design & Development of Audit Balance control frame for ETL.

•Design & Develop Error handling & Email notification components.

•Involved in Enhancements and Fixing Issues.

• Experienced in identifying detailed analysis of data sources.

• Experienced in preparing data mapping document from source to target.

•Involved in preparing business transformation rules that should be applied to source data.

• Designed Data Migration Logic between source and Target Systems.

• Experience in Identifying data issues with data in the source systems.

•Loading data from the various data sources like Flat files, CSV's, SQL Server, MySQL etc.

•Created SSIS Packages by using different data Transformations like Derived Column, Lookup, Conditional Split, data conversion and Execute SQL Task to load data into Database.

• Extensive experience in performance tuning of SSIS packages.

• Implementing new functionality in the existing ETL packages.

•Monitoring the jobs and providing production support.

• Communicate effectively to management, business and technical roles to meet the deliverables and schedule

• Created Functional and Technical Specification document.

Environment: Windows 2008 R2, SQL Server 2008 R2, SSIS

Honeywell Technology Solutions, Bangalore, India AUG2008- DEC2009 MS SQL/MSBI developer

The Honeywell Attune™ Advisory Services is a complete suite of building management services and cloud-based resources from Honeywell. It’s designed to monitor energy and operational efficiency and put the facility on a path to optimization. Attune Advisory Services is comprised of three levels of services - Awareness, Improvement and Optimization. This allows us to make more informed observations, process this information and give appropriate recommendations. It not only gives you the raw data from your building management systems, it will also show you how it affects your operation.

Responsibilities:

•Analyze the functional specification and prepare the technical specification.

•Understanding business requirements and mapping with SSRS tool

•Creating stored procedures, user defined functions, SQL queries and views.

•Involved in performance tuning and re-factoring of the SQL scripts.

•Optimize T-SQL queries and stored procedures for logical accuracy and faster execution.

•Design, develop and unit test SSIS packages as per requirements.

•Design, develop and execute unit test cases for reports.

Environment: Windows 2003, 2008 R2, SQL Server 2005, 2008 R2, SSIS, SSRS

Contact this candidate