SUMMARY

• Over 8 years of experience in the field of Information Technologyas a SQL Server Developer with proficiency inSSIS design/development and Data Warehouse Implementation/development forBanking, Finance, Health Care, Pharmaceutical, Telecommunications, B2B and Sales (POS) business sectors.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Strong working experience in SQL Server and T - SQL in constructing triggers, tables(DDL), Joins, cursors, user functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity.
• Written Complex Stored procedures as well as analyzing and debugging existing complex stored procedures, suggested creating Clustered and Non Clusteredindexes on tables.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Created new cubes and modified existing cubes using SSAS 2012 to make data available for the decision makers.
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, ConditionalSplit, Bulk Insert, merge and union all.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Very well aware of the changes made to Configurationfiles and deploymentmodels and other changes in SQL Server 2012.
• Experience in deploying packages to Integration Services Catalog in SQL Server 2012.
• Experience in Performance Tuning in SSIS packages by using Row Transformations,Block and Un-Block Transformations.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Created various SSRS Reports involving variety of features like Charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters, and also understandingofthetablixcontrol and Dashboard reporting, Share Point with Power View tool etc.
• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
• Work with DBA’s on Production issues and provide resolution.
• A thorough professional with proactive attitude, out of the box thinking and generating new ideas.
• A keen communicator with the ability to relate to people across all levels in the organization.
• Have worked in rapid development/ agile model.

TECHNICAL SKILLS

Operating Systems: Windows 2008, 2003R2, 2003, 2000 Advanced Server, Windows NT, Windows 95/98/2000 XP/Unix

Databases: MYSQL Server 2000/2005/2008/2008 R2/2012, MS Excel/MSWord/MS Access

Database Tools: SQL Enterprise Manager, SQL Profiler, Power Shell, DTS Import/Export, SQL Client Configuration utility, MS OLAP Services, SSMS, SQL Server BIDS/SSDT(SQL Server 2012)

Modeling Techniques/Tools: Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, Data Modeling, ER Diagrams,MS Visio, Rational Rose

ETL Tools: Experienced working with SSDT/BIDS-DTS, SQL Server Integration Services (SSIS), SQL Server Reporting (SSRS).

Source control: Apache Subversion (SVN)

Development skills: Transact SQL (T-SQL)

Languages: C, C++, HTML, XML/XSLT/.Net/C#,core java

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

SQL Developer/SSIS Developer

Responsibilities:

• The Database Developer, Level III,I will be responsible for building and maintaining database systems and data integrations that are utilized for supporting business application services and BI efforts
• Involved in development and implementation of SSIS, SSRS application solutions for various business units across the organization
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages
• Highly skilled in T-SQL - simple and complex joins, sub-queries, stored procedures, triggers, cursors, functions, views, CTE, DDL, DML
• Thorough analysis and testing of database objects &T-SQL statements before deployment to the production server.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Automation of monitoring all the failed jobs in the database using DTS (SSIS) and SQL mail.
• Designs, develops, and unit tests database solutions that capture, stage, integrate, clean, enrich, and load data from source to target.
• Identifies, analyzes, formulates, documents, and communicates the data integration design for the following:
• Effective change data capture and movement to a staging area
• Effective extract, transform, and load processing from production or staging into a target application database, data warehouse and / or data mart(s)
• Exception handling and activity monitoring
• Processing recovery and restart including proper sequencing and job / event dependency setup
• High performance (throughput) design including parallel processing and load
• ETL application connectivity to dependent software / applications / databases
• Properly addresses and balances long-term needs with near-term project iteration requirements and timing.
• Effectively collaborates with subject matter experts, project lead, analysts, and other developers to understand needs and to communicate detailed requirements and specifications and their benefits.
• Works closely with project lead to map out assigned activities to a well-thought out level of effort, plan, and schedule.

Environment: SQL Server 2012,SQL Server 2014,SQL Server R2 2012,SSIS,SVN, DBAmp,SOQL,MS Excel 2007, C#,, Windows Server 2010.

Confidential, Nashville, TN

SQL Developer/SSIS Developer/SSRS Developer

Responsibilities:

• Created SSIS packages for importing the Excel layouts into the database using SSIS.
• Used BIDS to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.
• Loaded data from ODS to Data Warehouse using SSIS packages.
• Experience in SSIS script tasks, Look up transformations and Data flow tasks using T- SQL, C# and Visual Basic scripts.
• Using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
• Designed and Developed matrix, tabular and parametric Reports using SSRS 2012.
• Designed and developed Drill down and Drill Through reports with Drop down menu option using SSRS.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server.
• Developed packages using various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Improved data load performance by analyzing database design and query plans.
• Modified and Create Joins to Improve the Database and execution speed.
• Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views.
• Involved in Performance Tuning using SQL Server Profiler and SQL server Hints. Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2012.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SSIS.

Environment: SQL Server 2012,SQL Server R2 2012,SSIS, SSRS, SSAS, Visual Source Safe 2012, Erwin 4.0,MS Excel 2007, C#, VB.Net, Windows Server 2010.

Confidential, CA

SQL Developer/SSIS Developer

Responsibilities:

• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2008.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Data transfers between various servers using BCP and SSIS.
• Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.
• Designed slowly changing dimension transformations (SCD) and customized the existing mappings.
• Scheduled SSIS packages through SQL Agent Jobs.
• Created a number of cubes, dimensions and business critical KPIs using SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Experience in Designing and Building the Dimensions and cubes with star schema using SSAS.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008.
• Creating Advanced KPI’s for the cubes using ProClarity.
• Responsible for report generation using SSRS and Crystal Reports based on business requirements.
• Worked with T-SQL development and performance tuning in T-SQL code. Participated in Performance Tuning of Code using execution plan and SQL profiler.
• Added Indexes to improve performance on tables. Used multiple join statements to retrieve data from multiple tables.
• Wrote custom T-SQL stored procedures and triggers to improve performance, reduce latency, preserve referential integrity, and provide additional application functionality.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database.

Environment: SSIS, SSRS, SSAS, Erwin 4.0,SQL Server 2008, ProClarity 6.0,MS Excel 2007, Crystal Reports 10.0, Windows Server 2008.

Confidential

BI Developer

Responsibilities:

• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created checkpoints and configuration files in SSIS packages
• Implemented slowly changing dimensions in SSIS packages.
• Performed incremental data load in BIDS using Lookup Transform, Cache Transform, and Merge Join Transform and worked on Change Data Capture.
• Automated execution process of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent and SMTP.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis serverfrom SSRS.
• Created data sources, connection strings and defined the datasets for generating the report.
• Designed and written the queries in the query builder for retrieving the data.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc
• Created subscriptions to provide a daily basis reports.
• Managed and troubleshoot report server related issues.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and Named 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.
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.

Environment: SQL Server 2008, SQL Server 2008R2, SSIS, SSRS, SSAS, BIDS, SSDT, Hadoop, Hive, MapReduce

Confidential, Minneapolis, MN

SQL Server Developer/SSIS Developer

Responsibilities:

• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Used to work on Installation, Configuring, Managing, Monitoring, Troubleshooting SQL Server 2008R2/2008/2005 on VM Ware Clustered and Standalone Environments
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Used ASP.Net coding and C#to call the Stored Procedures created with T-SQL
• Used XML and XSLT
• Extracted data from Txt/CSV/XML/Oracle/Sybase/DB2 to SQL server.
• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• Created SSIS packages for data Importing, Cleansing, and Parsing. Extracted, cleaned and validated.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data FlowTask, and Execute Package Tasketc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house by using BIDS.
• Built Cubes with Multi Dimensions and made proper Hierarchy Relationships on Attributes. Made Partitions on Cubes with Aggregates for better Performance.
• Worked inDevelopingandExtending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Modelsand Deploying and Processing SSAS objects.
• Prepared various Reports by using Queries and the Data existed in the Cube for Analysis Purposes of the Organization.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Extensively worked on Dimensional Modeling.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports in BIDS. Deploying and scheduling Reportsusing SSRS/Crystal to generate all daily, weekly, monthly and quarterly Reports including current status.
• Expert in automating process by Using SQL Server Agent in creating jobs and error report using Alerts, SQL Mail Agent and SMTP.
• Handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs, Backups and restores.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Environment: Windows 2005R2, 2007, 2008 MS SQL Server 2003/2005/2005 R2, BIDS, Oracle, .net, Power Designer, Microsoft Outlook, Red Gate, Team Foundation Server

Confidential

SQL Developer

Responsibilities:

• Performed extensive data extraction from web and other sources and handled data preparation - missing values, formatting, transformations using SSIS.
• Handled migrations from DTS to SSIS 2005 and .
• Written Stored Procedures and SQL scripts both in SQL Server and Oracle to implement business rules for various clients.
• Designed T-SQL scripts to identify long running queries and blocking sessions.
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
• Data migration (import & export - BCP) from Text to SQL Server
• Error handling using Try-Catch Block
• Normalization and De-Normalization of tables
• Developed Backup and Restore scripts for SQL Server 2005
• Installed and Configured SQL Server 2005 with latest service packs.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions
• Written T-SQL queries for the retrieval of the data.
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.
• Prepared daily and weekly status reports and collaborated with other team members
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Implemented indexes for performance tuning.
• Data loaded into the database using SSIS 2005 from flat files.
• Environment:SQL Server 2005, SQL Server 2000, Oracle 9i, Visual Basic, Excel, R, Tableau, SPSS