SUMMARY

• A SQL Developer with 8 years of IT experience in database design, development and administration with MSSQL Server 2014/2012/2008/2005 using SQL Server Integration Service (SSIS), SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS) in Finance, Banking and Healthcare industries.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving System Requirements, Analysis, Design, Development, Implementation, Integration, Testing, Deployment and Maintenance.
• Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Experience in creating OLAP cubes using SQL Server analysis services (SSAS). Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS ), Data Transformation Services (DTS), Bulk Copy Program (BCP)
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup, Disaster Recovery procedure and Replication.
• Experienced in ETL processes, Data warehousing methodologies and concepts including Star schemas, Snowflake schemas, Dimensional modeling, Reporting tools, Operations Data Store Concepts, Data Marts and OLAP technologies.
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models, data integrity, SQL joins and query writing.
• Efficient in up-gradation and migration from MS SQL Server 2008 to MS SQL Server 2014/2012/2008/2005.
• Extensively worked with third party tools like SQL Lite Speed, Spotlight, SQL Watch, Red-Gate, Erwin, Toad, and DB Artisan.
• Experience in creating reports through PROCLARITY. Used PROCLARITY for accessing and analyzing cubes and dimensions.
• Experience in developing Custom Report, different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column and Data Conversion Transformations
• Experience in using Audit functions and extensively used Exception Handling for catching and reporting errors.
• Extensive experience in creating enterprise reports using SSRS 2008/2012 using Report Manager, Report Builder, and BIDS
• Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Created many Drill Through, Drill Down, Parameterized reports using SSRS 2008/2012.
• Excellent knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models for developing SSAS Cubes using MDX
• Have hands on experience in Performance Tuning and Query Optimization. Worked on identifying and resolving blocking and deadlocks
• Self-motivated and possesses ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

TECHNICAL SKILLS

Databases: MS SQL server 2005/2008/2012/2014 , Oracle, Teradata, MS Access.

Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS, Business Intelligence Development Studio, Data Transformation Services, Version Control Tools.

Languages: Transact- SQL, SQL,HTML, XHTML, C, XML,.NET frame work, Java

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS.

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports, Business Objects, Tableau, Power BI 2013.

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler.

Data Modeling Tools: Erwin tool, Microsoft Visio 2000/2003

Source Control: TFS 2010/2008, VSS, SVN, Bitbucket.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles CA

Sr ETL/SQL Developer

Responsibilities:

• Key role in team of 4 in brining 2012SQL database environment to SQL 2014by migrating, converting and re-writing DTS packages and updating them to SSIS packages.
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows
• Extensively worked on Data Flow tasks like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAScubes
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Used Text Files/ SQL Server Logging for all SSIS packages.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS). Worked on managing Tableau driven dashboards.
• Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
• Deployed and configured the reports in the Report Server and creating the data repository.
• Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL server 2012using SSIS.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked with various SSIS packages which involve Transactions, Restartability and roll back techniques.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Deployed the packages to production using XML package configuration

Environment: SQL Server 2012/2008R2/2008/2005, SSRS 2012, DB2, Oracle 9i/10g, Visual Studio 2005, XML,XSLT, MS Office, MS Excel PowerPivot and Visual source safe

Confidential, Boston MA

MSBI /SSIS/SSRS/SSAS Developer

Responsibilities:

• Responsible for creating and designing SSIS packages.
• Created partitions, KPIs, calculated members, schema and file groups for fact tables and cubes integrating SSAS.
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
• Used different transformation controls like Look up, Conditional split, data conversion, Unpivot, Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command etc.
• Use event handing to send e-mail on error events at the time of transformation
• Use login feature for analysis purpose
• Added intelligent system in SSIS to identify actual change and new change in dimension
• Design SSRS and excel reports, expense analysis, and balance sheet analysis.
• Deployed reports onto the production report server through various ways
• Worked on managing Tableau driven dashboards and reports
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Prepared the data mapping for all the migrated jobs using SSIS
• Set up SQL Profiler to trace various Database activities, Application Responses and their Performance in order to tune them
• Created ETL process usingSSISto transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package usingSSIS.
• Created script to migrate SQL server object from one environment to other environment
• Used the SQL Server profiler to capture and store the execution plan. Created necessary indexes
• Modified the queries to achieve better performance
• Designed ETL process using SSIS to extracted data from flat files, excel files and SQL server database
• Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
• Worked on migration of SSIS 2012 packages to SSIS 2014
• Based on the requirements developed and provided weekly, monthly, yearly quality control reports for work orders, service requests etc
• Involved inTabular Data warehouseandDAXoperations for SSAS 2014 and 2012 OLAP databases.
• Represented reports in different forms using graphs, charts, tabular, area and pie charts as required
• Responsible for uploading and organizing the reports in report manager folders. Also, providing security and roles for those reports.
• Experience in working on different kinds of reports Parameterized Reports, Linked Reports, and Drill-through reports.

Environment: MS SQL 2008 R2/2012/2014, SSIS, SSRS XML, T-SQL, DAX, MS Access 2010, MS Word, MS Excel, VBA (Visual Basic for Applications), Share point, DTS, C#, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server.

Confidential, Plano, TX

SQL/SSIS/SSAS/SSRS Developer

Responsibilities:

• Installed SQL Server 2008R2 with the latest service packs.
• Migrated Database from SQL Server R2 by using side by side migration.
• Created tables, indexes and designing constraints.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Enhanced and deploying the SSIS Packages from development server to production server.
• Wrote stored procedures for report generation in SQL Server2008R2.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Developed and designed cubes with calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions and KPI.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Involved in Designing and deploying cubes in SSASenvironment using Snowflake and Star Schema Designs for the operational data
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Rendered reports, managed subscriptions, created reports with report builder, report snapshot and report Cache.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Created and Maintained Database Maintenance Plans.
• Strong team player and self-motivated

Confidential, Birmingham, AL

SQL Server/SSIS Developer

Responsibilities:

• Responsible for conceptual, logical and physical design with a significant effort towards application using Erwin.
• Written T-SQL Stored Procedures and queries for accessing Data from Teradata Database.
• Used advance features of T-SQL to design and tune T-SQL to interface with the databases and other applications in the most efficient manner.
• Created Stored Procedures for package Initialization and end package information to update the package log table.
• Designed & Developed Type 2 Slowly Changing Dimensions in order to maintain the historical changes for the business purposes.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data from various Databases and into Siemens servers using SQL Server Integration Services (SSIS).
• Used Script task component and established iterative load for faster retrieval & to improve performance.
• Used different transformations like lookup, condition split, and row count Transformation, Derived Column, Data Conversion etc.
• Worked on the Existing (legacy) SSIS packages and modified the same packages to match it for different sources for integration.
• Experience in managing and automating control flow, data flow, events and logging programmatically using Microsoft .NET framework for SSIS packages.
• Advanced extensible reporting skills using SQL Server 2012 Reporting Services (SSRS).
• Developed Drill Down, Drill through, Cross tab reports, Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake Schema.
• Prepared technical documentation for every stored procedure and updated those stored procedures with new data elements.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.

Environment: Microsoft SQL Server 2012, SSIS, SSRS, Visual Studio 2010, SSMS (Sql Server Management Studio),T- SQL, Oracle 10g,Windows 7,Siebel,SAP, .NET Framework, C#2008, Erwin.

Confidential, Chicago, IL

SSIS/SSRS/TSQL Developer

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008/2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Worked on SSIS Script component using Visual Basic Applications, VB.NET and C#.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Use SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Created Dashboards and reporting services web parts using Moss 2007.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Data Migration - Migrated and converted data to be sent across different servers and databases to accomplish database mirroring. This involved setting up automated Unix Shell Scripts to extract and massage data from Informix and Oracle databases into text files. These text files were then FTP’ed to destination servers where another automated process was executed to load the text files into the desired target tables.
• Created different reports like sub reports, bar charts and matrix reports using SSRS.
• Created datasets using stored procedures and reports using multi value parameters
• Deployed the SSRS reports in Microsoft office share point portal server MOSS 2007.
• Worked on SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.

Environment: SQL Server 2005/2008, T-SQL, SQL Server Integration Services, CrystalReports8.5, Business objects, VB.NET, ASP.NET, .NETFramework2.0, C#, SQLProfiler, Access 2003, Agile methodologies, Business Objects X1, Visual Studio 2005, Microsoft office 2007 Visual Team Foundation Server (TFS).

Confidential

SQL Server/BI Developer (SSIS)

Responsibilities:

• Gathered functional requirements and written the technical specifications
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Created complex stored procedures, triggers and cursors in SQL Server.
• Developed source to target specifications.
• Generated stored procedures, functions, views and triggers.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects.