SUMMARY

• 8 years of IT experience in the Analysis, Design, Development, Implementation and Testing Client/Server applications using Microsoft SQL Server 2012/2008R2/2008/2005 and Business Intelligence Suite.
• Involved in creating SSIS packages to transfer data between OLTP and OLAP Databases with different types of control flow tasks and data flow transformations, securing and deploying the packages.
• Experience in performance tuning, Query optimization and database consistency checks.
• Extensively used tools like SQL Profiler and Database Engine tuning wizard, Windows performance, experience in creating Jobs, SQL Mail Agent.
• Hands on Experience in installation, up gradation and configuration of Microsoft SQL Server and Databases.
• Expert in creating OLAP cubes and developing complex calculations, Aggregations, implementing dynamic security model using MDX functions in SSAS.
• Responsible for month end maintenance activities and large data pulls fromCOSMOSand CUBES using SSIS packages and scope scripts.
• Robust MS Access and Excel skills with PowerPivot, PivotTable, Pivot Chart, Power View, V - Lookup functions and formulas
• Worked on DAX (Data analysis expressions) to create custom calculations for excel and SQL server SSAS.
• AWSCloud Experience in optimization techniques.
• Provided Technical and Development Solutions for requirements raised by Clients. Used Backup/Restore and Normalization.
• Experience in monitoring file exchanges between the systems.
• Customized Web Parts, Event Handlers, Site definition, Site Templates, Content Types and Deploying Solution Packages, Document Libraries, Lists, Integrating InfoPath forms inSharePoint Designer.
• Configured Report Server andSharePoint, and Deployed SSRS Reports, Report Models, Shared Data Sources to the Document Library ofSharePoint.
• Expert skill in data migration from various data sources like Excel, SQL Server, Flat files using SSIS packages and SQL commands. Monitoring, debugging and tuning ETL jobs.
• Proficient understanding of each phase of software development life cycle(SDLC).
• Experienced in creating test data and unit test cases. Writing test cases and system plans to ensure successful data loading process.
• Experience inMicrosoft Visual C#in script component of SSIS.
• Designed and deployed direct and indirect customers reports for targeted segmentation of people and across different regions with Drill Down approach.
• Developed Drill-through reports to measure the performance detail of different distribution channels.
• Hands on Experience in implementing Data Warehousing solutions to large corporate clients.
• Good work experience on System analysis, Design, Development, testing and implementation of projects.
• Ability to profile and understand the different source systems. Very good skills of documenting different kinds of metadata.
• Experience and ability to coordinate/Communicate within team and outside team based on project requirements

TECHNICAL SKILLS

Languages: SQL, T-SQL, .Net.

Databases: MS SQL Server 2012/2008/2005, PL/SQL, MS Access, MS SQL

SQL Server Tools: SQL Server Management Studio(SSMS), Business Intelligence Development Studio(BIDS)

Business Intelligence Tools: SQL Server Integration Services (SSIS), Export & Import (DTS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Team Foundation Server (TFS), Power BI, Power Pivot.

Applications: MS Word, Excel, Power Point, Outlook, Visio, Cosmos, UC4Scheduling Tool.

Web: HTML, XML

IDE’S: SQL Server Management Studio, Eclipse, Visual Studio

Methodology: Agile, Object-Oriented Analysis/Design, Kimball& Inmon Methodologies.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr.MS SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Extensively used SSIS in designing and creating mappings using various SSIS transformations like OLEDB command, conditional split, lookup, aggregator, and multicast and derived column.
• Hands on experience in creating various kinds of joins and sub-queries to simplify complex queries involving multiple tables.
• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Extracted data from various sources like SQL Server 2012, .CSV, Excel and Text file sources, alongside from various other servers, creating a centralized data warehouse structure in their headquarters.
• Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2012.
• Created logging for ETL process at package level and task level to log the number of records processed by each package and each task in a package using SSIS
• Performed and fine-tuned stored procedures and SQL queries and User Defined Functions (UDF).
• Imported data from multiple data sources into Excel workbook, created relationships between heterogeneous data, created calculated columns and measures using V-Lookup and formulas, built PivotTables and Pivot Charts using PowerPivot skill.
• Worked with WindowsSharePointServices and Team to build Document libraries, lists, CSS, Templates inSharePoint.
• Designed Websites, Views, Lists, Automatic alerts notification, Email Send on Event in the portal.
• Analyze large data sets and patterns using TSQL,PowerBI, advanced Excel models likePowerPivot andPowerQuery to identify opportunities and risks in current operations and define solutions in daily business
• Created and maintained the site collections and provided the administrative support for the application.
• Created different user groups and assigned permissions.
• CreatedSSISpackages for File Transfer from one location to the other using FTP task.
• Ensure appropriate auditing, quotas and usage information and search settings are consistently maintained throughout the farm.
• Wrote SQL queries using Joins and Sub queries and Functions to retrieve data from data sources.
• Familiar with OLAP cubes and fact table, star and snowflake schemas, building multi-dimensional cubes and KPIs for decision makers using SQL Server Analysis services (SSAS).
• Developed different types of Tabular, Matrix (Cross Tab or Pivot) Reports, Chart and Graphs, reports that aggregate data, reports that contain parameters and group, reports containing totals and subtotals, drill-down reports and ad-hoc reports using SQL Server Reporting Services (SSRS) and Tableau in certain instances.

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Microsoft Visual Studio, SharePoint services, Power BI.

Confidential, Chicago, IL

Sr.MS SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Import and Extract data from different sources such as flat file, access, SQL server and loaded those data into SQL server to build various reports.
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting). Created SQL server configurations for SSIS packages and XML & Windows event logs.
• Hands on Experience in Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Built multiple SSAS cubes based on business requirements.
• Developed Aggregations, calculated members for the cube and generated daily reports to measure the sales of the segmented people across different regions for different campaigns.
• Filtered bad data from legacy system using T-SQL and implemented constraints and triggers into new system for data consistency.
• Involved inversioncontrolling of packages, database objects in TFS.
• Experience inCOSMOSand SCOPE scripting.
• Worked onCosmosLike Downloading the data fromCosmosto SQL Database using Metric Explorer Tool.
• Prepare the detailed level ETL specification documents describing the algorithms and flowchart and mentioning the source systems, change data capture logic, transformation logic involved in each field, the lookup tables, lookup logic used and also the target systems per each individual package involved with the DataMart. Also, document the important SSIS session properties that should be used for executing SSIS Packages.
• Created DAX formulas which include functions, operators, and values to perform advanced calculations on relational tables and columns, including lookups to related values and related tables.
• Generated reports using SQL server Reporting services, OLTP and OLAP data sources and Created Various Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Developed Complex Queries using different SQL joins and T-SQL Queries.
• Responsible for meeting with business analysts, end-users for gathering requirements resolving the issues.
• Reviewed various existing and future reports needed and came up with necessary dimensions and facts needed for new data mart.
• Elicit requirements using interviews, document analysis, business process descriptions, use cases, scenarios, business analysis, task and workflow analysis.
• Designing and documenting the error-handling strategy in the ETL load process using Event handlers.
• Involved in performing Audits and recovery operations of SSAS objects.
• In-depth knowledge of Relational Data Modeling, Dimensional data modeling and design. Extensive experience in data analysis using SQL and MS-Excel.
• Created report snapshots to improve performance of SSRS.
• Involved in Unit and Functional Testing.

Environment: SQL Server 2012, SSAS 2012, SSRS 2012, SSIS 2012, Cosmos, UNIX Shell Scripting.

Confidential, Lenexa, KS

Sr.MS SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Experience in Validating and testing the SSIS packages on the development server.
• Created an ETL/SSIS package and scheduled it on daily basis to load the fact and dimension tables
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Developed the SQL Server Integration Services (SSIS) packages for various facts and dimensions to transform data between different servers.
• Worked on various DBA activities like backups, recovery models and various high availability options Worked with Database Tuning Advisor to tune the slow running queries.
• Guide historical data loads and on-going loads and identifying root cause analysis of data warehouse production issues.
• Created in Extracting and Transforming data (ETL) fromAzureDatabase and creating packages using SSIS, Import, Export Data, Bulk Insert and BCP Utilities.
• ProvidingAWScost optimization techniques based onAWSpricing model.
• Demo to management cost effectiveAWSDR/HA solution architecture.
• Scheduling and monitoring ETL packages daily load. Developed Exception handling process for each SSIS package. Tested the data with complex queries, joins and sub queries.
• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Used DTS, SSIS and T-SQL store procedures to transfer data from OLTP databases to staging area and finally transfer data marts and performed action in XML.
• Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas.
• Expert in creating SQL Server Reports using SSRS 2008/2005 in designing stylish report layout parameterized, performance, Chart Reports.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Co-ordinated with business users to perform the User Acceptance Test (UAT).
• Created quarterly sales reports with Chart controls to measure the progress of sales every quarter for different distribution channels.
• Involved in Unit and Functional Testing.
• Production support enhancements and maintenance.

Environment: SSIS 2008 R2, SSRS 2008 R2, SSAS 2008 R2, SQL Server 2012, Crystal Reports, Management Studio, SQL Server Business Intelligence studio, Microsoft Excel and Access.

Confidential, Phoenix, AZ

Sr.MS SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Used Query Analyzer to optimize SQL Queries.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Worked on Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Report Design.
• Developing the Stored Procedures in SQL server for various SQL Jobs and SSIS packages
• DB modeling of Data Warehouse and DataMart
• Involved in writing various Views and Stored Procedures for SSRS reports Involved in testing ofBusiness Objects Reportsand Fix any ETL issues if exists.

Environment: SQL Server 2008 SSIS 2008, SSAS 2008, SSRS 2008, Windows Professional Server, MS Visio, Report Builder 3.0, SQL Profiler, Azure, Enterprise Manager.

Confidential, Chicago, IL

MS SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.
• Migrated data from heterogeneous data Sources (Oracle, SQL Server, Excel, Flat file) to centralized SQL Server databases using SQL Server Integration Services.
• Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using for Each Loop).
• Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package task etc. to load underlying data in to the tables from Excel file and CSV file.
• Created an ETL/SSIS package and scheduled it on daily basis to load the fact and dimension tables.
• Designed and implemented Data Marts, facts, dimensions and OLAP cubes having star schemas using dimensional modeling principles in SSAS.
• Generated Sub-Reports, Drill down reports, Tabular Report and list reports using SSRS and published as PDF, Excel formats.
• Created Views to reduce complexity of business user.
• Developing the Stored Procedures in SQL server 2005 for various SSIS packages.
• Involved in writing various Views and Stored Procedures for SSRS reports.
• Involved to planning and designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations using MDX.

Environment: SQL Server 2008, SSIS 2008, SSRS 2008, SSAS 2008, Microsoft Office 2010.

Confidential

MS SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Collected all the requirement specifications of input data.
• Creating SSRS reports for the end user.
• Analyzing and understanding the Crystal report functionality.
• Analyzing the approach in which SSRS report should be developed.
• Implementing the same functionalities in SSRS reports which is there in crystal reports.
• Achieving things through work around which are not directly supported in SSRS.
• Analyzing and understanding the Excel Data and Creating SSIS Packages accordingly to dump the data in to SQL Database.
• Created reports with different types of properties like Chart controls, Filters, Interactive Sorting.
• Applied conditional formatting in the reports using SSRS to highlight key areas in the report data.
• Analyzing the approach in which SSIS package should be developed.
• Involved in preparation of User Interface Specification document.
• Fixed all the issues provided by the end users.
• Involved in performing Audits and recovery operations of SSAS objects.
• Involved in the design of functional specifications and technical design documents of module.
• Involved in Unit and Functional Testing.
• Production support enhancements and maintenance.
• Interactions with clients on daily basis to discuss any issues.
• Worked on various performance issues.

Environment: SQL Server 2000/2005, SSIS 2005, SSRS 2005, Windows 2003.