SUMMARY

• Over 8 years of IT Experience in analyzing, database designing, tuning, and developing Client/Server, Business Intelligence (BI)database applications and various segments ofSoftware Development Life Cycle (SDLC), usingMS SQL Server 2016/2012/2008/2005 SQL Server Integration, Reporting & Analysis Services.
• Extensive experience in Database design and development of applications using SQL Server 2005/2008/2012 , 2016, Integration Services (SSIS), Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MDXqueries, OLAPCubes, Star schema and Snowflake schema.
• Experience in Huge Data Migrations, Transfers using utilities likeData Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in integration of various data sources like SQL Server, Oracle, DB2 UDB and Flat Files. Expertise in Unit Testing, Functional Testing, System Integration Testing, Review Test Cases and Test Results.
• Knowledge inJob Scheduling,Replication,Performance Tuning,Normalization/De - normalizationconcepts, database design methodology.
• Extensive experience in writing and debugging stored procedures, cursors, triggers, Inner Joins& Outer Joins, views and user-defined functions.
• Ability to define and develop Report Structure withData Definition, Report Layout and Report Definition Language.
• Extensive experience in creating several reports such asDrill Down Reports, Parameterized Reports, Linked Reports, Sub Reports, Matrix Reports and Chart reportsusingSQL Server Reporting Services.
• Experience in providingLogging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
• Extensive experience inDeployingandConsolidatingMultiple Instances overClustering Environment and Remote Installations.
• Extensive experience in controlling theUser Privileges,MonitoringtheSecurity andAuditIssues as perStandards.
• Excellent inrendering reports, managing subscriptions,creating reports with report builder, report snapshot and report cache.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data.
• Involved in the complete Data Warehouse Development Life Cycle. Actively supported business users for change requests.
• Excellent in High Level Design of ETL - DTS Packages & SSIS Packages - for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Experience in generating On-demand and Scheduled Reports for Business Analysis or Management Decision using SQL Server Reporting Services.
• Excellent hands on experience Scheduling and the Deployment of the reports and uploading files to a Report Server Catalog from the Report Manger.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages. Good experience in Designing Aggregations and pre-calculating the same in SSAS 2005.
• Awell-organized, goal-oriented, highly motivatedandeffective team leader/member with excellent analytical, troubleshooting, and problem-solving Skill and project oriented team player.

TECHNICAL SKILLS

Operating Systems: Windows vista/XP/2003/2000, Windows Server 2003/2008/2012.

Languages: T-SQL, PL/SQL, MDX, VB.net, C#

Tools: /Utilities SQL Server Management studio, Enterprise Manager, Profiler, MS Visio, Ervin, Query Analyzer, SSIS, SSRS, SSAS, SQL Server DTS, Visual Studio .NET, ETL, Spotlight, Business Intelligent studio.

Databases: MS SQL Server 2005/20, MS Access 2003/2005/2008.

Web Technologies: XML, HTML

Application Packages: MS Office, MS Excel, MS-Project

Reporting Services: Excel, SQL Server Reporting Services, Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

SQL Server ETL Developer

Responsibilities:

• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing various kinds of transformations using SQL Server Integration Services (SSIS).
• Created SSIS package to load data from XML Files and SQL Server 2008 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in Database design including optimizing the database schema, creating database indexes and coding database procedures/queries.
• Migrated Pervasive ETL logics to SSIS replicating same business logics for better performance and efficiency.
• Developed Stored Procedures, Functions and Database Triggers.
• Designing and building data load procedures, using MS SQL Server SSIS.
• Created and Updated Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Performance Tuning and Query Optimization.
• Extracted data from various sources like DB2, Oracle, Flat files, and XML files and Loaded in to Fact and Dimension tables of data warehouse.
• Created datasets using stored procedures and reports using multi value parameters.
• Interfaced with the end users as part of the Requirements engineering team to finalize the project scope.
• Provided on call support for Production jobs.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.
• Interfaced with Business users for better understanding the business requirements.

Environment: MS SQL Server 2012/2016, Windows 2007, MS Excel, TSQL, Microsoft Visual Studio 2010, SQL Reporting Services, SQL integration services, Pervasive ETL tool

Confidential, San Antonio, Texas

SQL Server/BI Developer (SSIS/SSRS)

Responsibilities:

• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Created packages in SSIS with error handling and Worked with different methods of logging in SSIS.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2012.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with VB.NET in SSIS.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.
• Exported reports in various formats like MS Excel, PDF, MS Word, Text and CSV.
• Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports.
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS).
• Worked with development teams in the design of physical databases and in modification.
• Experience in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.

Environment: SQL Server 2012/2014, TSQL, Crystal Reports, TFS, VB.NET, SharePoint, Visual Studio 2010MS PowerPoint, Oracle.

Confidential, Indianapolis, Indiana

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Gathered requirements and design of data warehouse entities.
• Conduct code walkthroughs and review peer code and documentation.
• Created and maintained the Data Mart for different LOB.
• Fine-tuned of database objects and server to ensure efficient data retrieval.
• Developed complex programs using T-SQL queries, including Procedures, Triggers, and Functions.
• Used Visio for diagramming in the design phases.
• Build efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1 and type 2 changes.
• Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
• Designed and developed SSIS packages, designed stored procedures, configuration files, tables, views, and functions.
• Created SSIS log files and configuration files to store configuration and to log execution of packages.
• Implemented complex transformations by creating custom transformations in addition to using built-in ones.
• Performed Data Migration from SQL Server 2008 to SQL Server 2012.
• Assisted in defining Query for generating Drill Down reports in SSRS.
• Developed SQL Server Integration Services (SSIS) packages to transform data from various data sources to MS SQL 2012.
• Experience in handling parameterized reports in SSRS.
• Deployed packages from one environment to another (Development to testing to production).
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries. Oversaw unit and system tests and assisted users with acceptance testing.
• Implemented best practices to maintain optimal performance and optimized SQL queries for maximum efficiency.
• Performed documentation of standards, best practices, and ETL procedures
• Work with developers, DBA, and systems support personnel in elevating and automating successful code to production.
• Provided on-call support to production system to resolve any issues.

Environment: SQL Server 2008/2012, Visual Studio 2010, T-SQL, PL/SQL, SQL, Erwin 4.2, SSIS, SSRS

Confidential, Wilmington, DE

SQL Server BI Developer

Responsibilities:

• Interfaced with Business users for better understanding the reporting requirements.
• Interfaced with the client as part of the Requirements engineering team to finalize the project scope.
• Involved in Database design including optimizing the database schema, creating database indexes and coding database procedures/queries.
• Implemented SSIS for data transformation logic process.
• Designing and building data load procedures, using MS SQL Server SSIS.
• Extracted data from various sources like DB2, Oracle, Flat files, and XML files and Loaded in to Fact and Dimension tables of data warehouse.
• Extracted Data from Various OLTP Databases to OLAP Database.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Developed Stored Procedures, Functions and Database Triggers.
• Developed reports using SQL Server Reporting Services (SSRS).
• Developed reports and Landscape reports.
• Developed Complex reports using SSRS and created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Created datasets using stored procedures and reports using multi value parameters.
• Created sub reports, bar charts and matrix reports.
• Developing a Report as per user requirement using MS Reporting Services.
• Published reports as PDF formats.

Environment: MS SQL Server 2005/2008, Windows 2007, MS Excel, TSQL, Microsoft Visual Studio 2008, SQL Reporting Services, SQL integration services.

Confidential

Jr.Sql Server Developer

Responsibilities:

• Normalized and De-normalized the tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys.
• Created complex Stored Procedures, functions, triggers, cursors, tables, views, indexes, SQL joins and statements for applications by using T-SQL.
• Involved in database design, development of database Tables, Roles, and Users in SQL Server.
• Design and Creation of logical storage (Table spaces, Segments etc.).
• Designed E-R Diagrams, logical and physical data modelling.
• Interacting with business users in gathering the reporting requirements.
• Hands on experience in Importing and Exporting Data from/to Oracle to SQL Server and other database servers.
• Experience in Configuring Linked Servers.
• Experience with index Analyzer and Query analyzer for SQL 2008. Involved in Backup and Recovery Strategies and Point in Time Recovery.
• Developed and integrated code for enhancement of the application.
• Extracted and transformed Data from OLTP databases to the specific database designed for OLAP services (was involved in the creation of all objects for that database) on off-peak hours.
• Experience in writing Stored Procedures in DW environment and then created packages in SSIS to load the data into Data Warehouse. SSIS package calls these stored procedures for loading the data.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Created number of jobs, alerts and operators to be paged or emailed in case of failure for SQL 2005.

Environment: MS SQL server 2005/2008, T-SQL, Query Analyzer, Visual Studio 2005.