SUMMARY

• Over 8 years of in - depth experience in database design, development, administration and maintenance of SQL Server 2014/2012/2008 R large scale databases for both OLTP and Data Warehousing Systems applications like SSIS, SSAS, and SSRS in Finance, Banking, Education and Health Insurance domains.
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server and MS SQL Server 2005/2008/2012/2014 respectively.
• Hands on experience in developing and writing T-SQL queries, store procedures, triggers, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experience in developing reports using OBIEE.
• Proficiency in Developing and Extending MS SQL Server Analysis Services (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Good command in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2012/2008R2 (SSRS).
• Accomplished in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Strong experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
• Experienced in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Strong Knowledge of migrating SSIS packages, reports and analysis services projects from SQL Server 2008 to SQL Server 2012.
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS.
• Highly experienced in database server performance tuning and optimization of Complex SQL queries.
• Experience of Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Excellent experience in Designing, Maintaining & Tuning various RDBMS like T-SQL & MS SQL Server, MS Access databases and strong knowledge of SDLC principles.
• Expert in using tools like MS SQL Profiler, Database Engine Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using Agile methodologies.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member

TECHNICAL SKILLS

Languages: C,C++,T-SQL:

Databases & Business Intelligence Tools: MS SQL Server 2014/2 /2000, SQL Server Management Studio(SSMS), MS SQL Server Integration Services(SSIS) 2012/2008/2005/2000 , MS Access:

Web Technologies: XML Web Services, Microsoft Office SharePoint Server (MOSS) 2007,.NET:

Reporting Tools: SQL Server Reporting services 2012/2008/2005/2000 , Tableau 7.0/8.0/8.1 server and desktop, QlikView, OBIEE, Crystal Reports:

Web Server Technologies: Data Modeling Tool, ETL, Microsoft Visio:

Operating System: Windows 2008, Windows 2000/2003 Server, data center, Windows NT, Windows 95/98/2000 XP, UNIX:

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

ETL Developer

Responsibilities:

• Designed and coded application components in an Agile environment utilizing a test driven development approach.
• Developed and deployed ETL jobs that include error/exception handling.
• Modified ETL code to account for changes in source data and business requirements.
• Performed migrations of data from various sources such as CSV files, Excel, flat files to OLEDB destination.
• Developed Pre and Post Execution logic for a task and provided event handlers using Execute SQL task.
• Participated in Daily Scrum Meetings and Sprint Retrospective and sprint planning for on time delivery of Business Needs.
• Used various transformations like Derived Column, Look Up, Sequence Container, Slowly changing dimension (SCD’s), conditional split, sorting, audit transformation and Data Conversion.
• Provided programming estimates, identified potential problems and recommended alternative solutions.
• Developed reports using OBIEE.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Created consolidated mapping of adjustment interfaces.
• Used various project parameters, package parameters, precedence constraints and variables to meet business requirements.
• Added each individual package to master package using Execute Package Task.
• Updated Connection Managers as per the business requirement.
• Collaborated with DMO (Data Management Office) to define and execute data movement between business systems and databases.

Environment: MSSQLServer 2014, SSIS, SSAS, SSRS, ETL, T-SQL, System Monitor / Performance Monitor, Visual Studio2013/2015, SQL Server Profiler, Dashboard, SQL Server Management Studio, Azure Crystal Reports, Visual Studio, Tableau 9.1, MS Excel, MS Project, Windows server 2008 R2.

Confidential, CO

DB Developer

Responsibilities:

• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Created and maintained project tasks and schedules.
• Responsible and active in the analysis, design, implementation and deployment of full software development life-cycle (SDLC) of the project.
• Involved in data mappings.
• Experience in writing Row Count Validation Queries for different kinds of data.
• Used SSIS transformations such as, For-Each Loop Container, Sequence Container, Expressions, Execute SQL task and Providing Error Handling
• Collaborated with other members of the product development team.
• Defined the search criteria and pulled out the record of the customer from the database. Make the required changes to the record and save the updated information back to the database.
• Worked in close cooperation with project managers and other functional team members to form a team effort in development.
• Worked extensively in migrating data from various sources such as Excel, Oracle, MS Access, MySQL, OLE DB, and flat files to different destinations using SSIS.
• Developed user defined functions based on requirements.
• Involved in handling the changes in compiling scripts according to the database changes
• Used joins, indexes effectively in where clauses for Query optimization
• Engaged in new development as well as support maintenance or enhancement of existing applications. Projects will entail complex business requirements and processes.
• Responsible for detailed analysis and design using Microsoft Technologies for services that will support internal and external clients facilitate and deliver on business needs for functional and business mapping.

Environment: Microsoft Visual Studio, Team Foundation Server (TFS), Code Collaborator, SSRS, SSIS,MS SQL Server 2012/2008 R2, T-SQL.

Confidential, Columbus, OH

SSRS/SSAS/SQL Developer

Responsibilities:

• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Extracting and Loading data into SQL Server Database using SSIS.
• Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Highly responsible for development and management of SSAS, SSRS and SSIS projects.
• Created SQL Server Reports based on the requirements using SSRS 2008 R2.
• Created complex reports which involve more number of groupings and multi-value parameters
• Using Sql server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Rendered the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Configured the report viewing security for various users at various levels using Report Manager
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.

Environment: MS SQL Server 2008 R2, SSRS, T-SQL, SSIS, (TFS).

Confidential, Rochester, NY

SSIS/SSRS/SSAS Developer

Responsibilities:

• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task,
• Variables, Send Mail Task, FTP Task, Package Execution task to achieve business needs.
• Created SQL Server Reports based on the requirements using SSRS 2012.
• Migrated DTS packages from SQL Server 2008 to SQL Server 2012 as SSIS packages.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Worked on different kinds of Transformations in SSIS like Slowly changing dimension (SCD’s), Lookup, Merge, Derived column, Multicast, Conditional split, Aggregate, Fuzzy lookup, Pivot and Un Pivot as per the client requirement.
• Implemented Logging and Event Handlers on SSIS packages for trouble shooting.
• Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Created complex reports which involve more number of groupings and multi-value parameters.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for monthly Statements.
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Generated matrix reports, cascaded reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services (SSAS)
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: MS SQL Server- 2012/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C#.NET, ProClarity Analysis.

Confidential, Charlotte, NC

MS SQL Server Developer/SSIS/SSAS Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle db).
• Extracted and Transformed data into Staging Servers named as PStaging Server for historical data and TStaging Server for load increment.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• 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.
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.
• Filtered data from Transient Stage to EDW by using Complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
• Used For-Each Loop Container, Sequence Container, Script task, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS packages.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.
• Created Project Expense Statements in all Data marts and other Financial Reports using SSRS. Developed yearly and quarterly company expense reports.
• Responsible for Deployment of the report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Tuned SQL query for better performance using SQL Profiler.
• Documented all work, so user can easily understand the flow of process.

Environment: MS SQL Server 2008 R2/2005, SSRS, T-SQL, SSIS.

Confidential

MS SQL Server (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Involved in development, integration, testing, bug fixing and documentation of application.
• Created a scheduling process to extract and import data from text files using SSIS packages and BCP utility.
• Responsible for Migration\Transforming data by designing robust SSIS (ETL) packages using Lookup, fuzzy lookup, conditional split, Data Flow, multi cast, Data conversion, Script task and many more.
• Used Expressions, For-Each Loop Container, Sequence Container, Script task, Execute SQL task,
• Variables, Send Mail Task, FTP Task, Package Execution task to achieve business needs
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Requirements gathering, Analysis and Design of all the client requirements.
• Performed Data Modeling and Developed logical and physical model using Erwin and implementing them to sql server.
• Wrote custom T-SQL stored procedures andtriggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Used SSIS to upload amortization schedules sent by the client in .CSV format on to the staging tables, which were used for doing all the calculation. Then the data was moved to the core tables and the staging tables were deleted.
• Effectively worked on Facts, Dimensions, and Cubes and wrote MDX queries using MS Analysis Services (SSAS).
• Worked on creating cubes, calculations, KPI’s, deploy of cubes using SSAS.
• Designed, coded and implemented ad hoc reports using existing report models in SSRS.
• Identified the Data Source and defined them to build the Data Source Views.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions and Functions for the reports.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Optimized Queries and did performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Environment: SQL Server 2008/2005, BIDS, SSRS, SSIS, SSAS, Crystal Reports.