SUMMARY:

• 7+ years of strong IT experience in SQL Server 2012/2008 R 2/2008/2005/2000 development & support;
• Strong experience in preparing dashboards and delivering drill down, slice and dice reports, parameterized reports, linked reports, and Snapshots using SQL Server Reporting services (SSRS) using 2008 R 2/2008/2005/2000 ;
• Excellent in creating Data visualization Reports ( Corporate reports) for CEO and Directors of the company
• Strong Experience in creating report server model designer;
• Extract Transform load (ETL) using SQL Server Integration Services (SSIS) 2012/ 2008 R2 / 2008 /2005
• Experienced in installing, configuring and deploying MS SQL Server suite of products that includes SQL Server Integration Services, SSRS, SSAS;
• Experience in migration of Data from Excel, Flat file, Oracle9i/10i to MS SQL Server by using SSIS, BCP and DTS utility. Extracting, Transforming and loading of data using SSIS and DTS;
• Dimensional Data Modeling and Cube Development in SQL Server in SQL Server 2012/ 2008 R2/ 2008/ 2005;
• Experience in data normalization and data modeling using Erwin;
• Working Experience in documenting complex database applications, and data;
• Strong knowledge in SQL Server disaster recovery, backup/restore, migration and upgrade participated in disaster recovery drills;
• Hands - on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and troubleshooting deadlocks in SQL Server 2012/ 2008 R2/2008
• Database consistency checks using DBCC Utilities;
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, Job Scheduling and SSIS Package Designer;
• Transformed data from one server to another using Conversion, Audit, Derived Columns, Lookups, Merge, Merge Joins, Slowly Changing Dimension;
• Experience in defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services. SSAS (Tabular and multidimensional modes) and Tableau
• Excellent multi-tasking capabilities including multiple client interaction; and
• Excellent communication, analytical, interpersonal, presentation, project management skills and ability to work with minimum supervision in large and small teams.

AREAS OF EXPERTISE:

• Data Modeling with Erwin
• Designed complex T-SQL queries, User Defined Functions; Stored Procedures
• Extract Transform load (ETL) using SQL Server Integration Services (SSIS) 2012/2008 R2/2008/2005
• SQL Server Reporting services (SSRS) 2012/2008 R2/2008 with Microstrategy Business Intelligence (BI) reporting experience in defining data with custom reports using SQL tools or other BI tools like Business Objects, Power BI, Tableau, etc.
• Using CSharp (C#) in Script Task
• SQL Server database performance monitoring
• Project Management including requirement gathering in SDLC and Agile / TFS environments
• Having Expertise in supporting team offshore model using VPN (Nortel Networks.)

TECHNICAL SKILLS:

Operating Systems: Windows 2008 Server/7/ Vista/XP/2003 Server/2000

RDBMS: MS SQL SERVER 2012,2008 R2/2005/2000, MS Access, DB2, Oracle10g/9i/8i

Database Tools: Management Studio, Business Intelligence Development Studio, SQL Enterprise Manager, SQL Server 2005, Query Editor, Reporting Server, SQL Query Analyzer, and MS-Access

ETL Tools: Data Transformation Services (DTS), and MS SQL Server Integration Services (SSIS) 2008 R2/2005

Reporting Tools: MS SQL Server Reporting Services (SSRS) 2008 R2/2005

Data Modeling: MS Visio 5.0, ER-Win

BI Tools: MS SQL Business Intelligence 2008 R2, 2012

Languages: SQL, T-SQL, and PL/SQL

Agile & PM: Rally for Agile Development

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2008\r2 and 2012.
• Initially loaded data into staging tables from Facets using different transformations, control flow tasks, loop containers and data flow tasks, then moved the data into different Schema's.
• Investigated Data Discrepancies between Various Source Systems and the Data Warehouse that affect the flow of data through EDI for Government Compliance.
• Performed backups with online full and incremental backups
• Written several SQL queries and analyzed them to validate the business rules in Oracle
• Created Master Story List and prioritized product backlog.
• Worked as a developer in creating complex Stored Procedures, Functions, Triggers, Views and complex SQL statements for applications.
• Responsible for monitoring and making recommendations for Performance improvement in hosted databases
• To analyze long running slow queries and tune them to optimize application and system Performance.
• Use tools like SQL Profiler for database tuning. Generate traces, execution plans identify Performance issues, deadlocks/contention and resolve them.
• Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.
• Extensive Testing on the Performance of the Stored Procedures.
• Developed complex T-SQL code for the application conversions.
• Wrote and integrated Stored Procedures to generate the Reports.
• 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)
• Responsible for coding SSIS processes to import data into the Data Warehousing from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Developed SQL queries, functions, stored procedures and triggers to perform the backend testing Of data
• Migrated data from various sources (text-based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS)
• Writing PL/SQL Procedures & Batch Processes.
• Created and automated regular Jobs such as Daily/Weekly Report Generations in Crystal Reports.
• Configured and maintained of Facets and other application software products, such as Claim check, Facets.
• Integrated TFS with SQL data tools to manage MSBI stack packages properly in DEV, QA and PROD environments using check in and checkout and have maintained history for every minor change.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Scheduled, maintained, and supported the distribution and access to reports through Crystal Reports
• Optimized the performance of complex source queries and stored procs with the help of execution plan and Database Engine Tuning Advisor to fetch data fast from source systems.
• Using Excel Pivot table to manipulate large amount of data to perform data analysis, operation reporting, ad hoc queries and analysis.
• Creating Excel Templates and Provide timely status reports and metric.
• Used Oracle SQL Developers and SQL Plus tool to work with the data from Facets -Oracle.
• Migrating hundreds of complex Crystal reports to SSRS reports using SSRS 2008R2.
• Analyzing cube data by dragging and dropping fields in OLAP browser.

Environment: MS SQL Server 2014, SSRS, SSIS, SSAS, Tableau, Facets, Crystal Reports, Windows 8/7

Confidential, Carpentersville, IL

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Gather and analyzed business requirements and translate business data for needs.
• Created Power Pivot. Reports and Integrated with Excel and Sharepoint data migration components, and work in collaboration with the data warehouse environment and team
• Define Business intelligence framework and data model, semantic layers and BI Metadata repositories to support reporting and administration
• Demonstrated with SSRS to include report front-end development, report deployment and management and executing SSIS programs.
• Worked with team members using visual studio 2010 / TFS to synchronize with servers
• Designed complex T-SQL queries, User Defined Functions; Stored Procedures and Triggers in SQL Server 2008 R2/2012 followed by analysis and testing of those database objects before deployment to the production server;
• Writing complex stored procedures and User defined functions and enforced business rules via Checks and Constraints;
• Maintained Change Control and Release Management process for all database objects like Tables, Views, Procedures and Triggers;
• Identified, tested, and resolved performance issues of poorly running queries and performance of database itself by using Index Tuning Wizard, SQL Profiler, and Query Analyzer. Also monitored Deadlocks in SQL server using SQL Server Profile in SQL Server 2008 R2/2012;
• Updated the statistics info and managed Clustered and Non-Clustered Indices for improved database performance;
• Improved the Scalability and Manageability of large tables by creating Table Partitions and maintained Data Consistency and Data Integrity by applying various constraints like Primary Key, Foreign Key, Unique, Check, and Default;
• Designed and developed Data Warehouse processes. Mapped disparate data sources - flat files, Excel spreadsheets, Comma Separated Value files and Tab delimited text files using various transformations to target schema;
• Designed Extraction Transformation and Loading (ETL) process to source and scrub data in a landing temporary table as well as legacy data sources using SSIS in SQL server 2012 / 2008 R2;
• Well versed with different components of SSIS (Control Flow, Data Flow and Connection Manager) while extensively using various kinds of Containers, Control Flow Tasks and various Transformations under data flow tasks;
• Highly experienced in developing SSIS complex and multistage SSIS packages using various tasks such as For-each-loop, Execute Process Task, Data Flow task, Execute SQL task, Custom Script Task, Analysis Services Task, Data Mining Task, FTP Task, File System Task, Send Mail Task, Bulk Insert Task;
• Created Master SSIS packages to execute a set of packages on a timely basis and deployed those packages using Manifest Files and Import/Export Wizard so that the packages were available for use to other team members;
• Implemented data warehouse design principles and Best Practices for maintaining dimension and fact tables;
• Set Physical Security of SQL Server, to prevent unauthorized users from accessing the servers;
• Developed analytical and transactional reports using SSRS 2008 R2/2012 such as open rates, bounce rates, click rates, invalid rates, duplicate rate, opt out rate. Developed reports based on OLAP cubes. Developed ETL process monitoring reports. Used Report Builder to develop ad-hoc reporting;
• Used SSRS Reporting services (SSRS 2008 R2/2012) to write complex formulas and to query database to generate diverse types of reports (Drill Down, Drill Through, Linked, Sub-reports, and Parameterized) for Business Intelligence;
• Developed MicroStrategy reports and dashboards for distinct roles and users.
• Created views as required by front-end developer for easier implementation on Java Server Pages and wrote instead-Of Triggers on those views to provide efficient Data Manipulation;
• Worked with SQL Server Agent to create the job and monitor closely for job run; and Worked in a team of 6 which includes Business Analysts, Data Architect, Database Developers, J2EE Developers, and Project manager.

Environment: MS SQL Server 2008 R2 / 2012, SSIS, SSRS, T-SQL, ER Win, J2EE, Windows XP, and Rally.

Confidential, Des Moines, IA

SQL Server ETL Developer

Responsibilities:

• Analyzed requirements and designed normalized and de-normalized tables and relationships using SDLC methodology including Data Modeling with Erwin;
• Designed complex T-SQL queries, User Defined Functions; Stored Procedures and Triggers in SQL Server 2008 R2/2012 followed by analysis and testing of those database objects before deployment to the production server;
• Created complex correlated subqueries, recursive queries, stored procedures to support the data mart
• Developed and maintain management reporting dashboards
• Wrote SQL queries to generate the output for the reporting dashboards
• Performed data analysis, data profiling and research to support business initiatives or solve data issues
• Performed root cause analysis of errors and recommend solutions
• Manipulate large data sets and interpret results using data aggregation functions
• Validate data to ensure accuracy, quality and integrity
• Collaborated with internal and external partners in establishment, design and execution of business rules
• Demonstrate ownership and accountability on assigned projects and Worked with minimal supervision
• Writing complex stored procedures and User defined functions and enforced business rules via Checks and Constraints;
• Maintained Change Control and Release Management process for all database objects like Tables, Views, Procedures and Triggers;
• Updated the statistics info and managed Clustered and Non-Clustered Indices for improved database performance; Designed and developed Data Warehouse processes. Designed and developed stage data model and dimensional data model for data warehouse. Mapped disparate data sources - relational Databases and text files onto target schema;
• Designed Extraction Transformation and Loading (ETL) process to source from Oracle applications as well as legacy data sources. Developed ETL processes to source data from flat files using SSIS 2008. Designed ETL processes to load fact and dimension tables in data warehouse;
• Developed T-SQL functions and stored procedures. Developed SSIS complex and multistage SSIS packages using For-each-loop, Execute Package, Data Flow task, Execute SQL task, Custom Script Task, Analysis Services Task, Data Mining Task;
• Developed Transformations using Data Conversion, Audit, Derived Columns, Lookups, Merge, Merge Joins, Slowly Changing Dimension transformation. Scheduled the ETL processes on SSIS server and managed integration server;
• Designed indexes to tune the ETL process performance. Developed, modified, and optimized complex queries and stored procedures to data retrieval and modification. Developed ETL auditing system using SSIS Event Handler and Custom Scripts;
• Developed analytical and transactional reports using SSRS 2008. Developed reports based on OLAP cubes. Developed ETL process monitoring reports. Used Report Builder to develop ad-hoc reporting for ETL QA as well as for DW UAT process;
• Created, updated and maintained ETL Technical Documentation for future reference by other team members;
• Worked in a team of 5 which includes Business Analysts, Data Architect, Database Developers, and Project manager.

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

Confidential, Plano TX

SQL Server/SSIS / ETL Developer

Responsibilities:

• Expertise in performance tuning of T-SQL queries and Stored Procedures.
• Worked with Excel Power Pivot reports and Pivot charts for analyzing the data from various systems for business needs.
• Collaborated with Integration of different systems involved in the business flow and building reports on top of it for analysis purpose and Involved in manual data validation after ETL runs.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, OLEDB to SQL Server and Implemented error handling and rollback process in ETL load.
• Used expressions and variables in SSIS to make load dynamic.
• Gathered requirements and designed normalized and de-normalized tables and relationships using agile methodology including Data Modeling with Erwin;
• Updated the statistics info and managed Clustered and Non-Clustered Indices for improved database performance; Designed and developed Data Warehouse processes. Designed and developed stage data model and dimensional data model for data warehouse. Mapped disparate data sources - relational Databases and text files onto target schema;
• Developed T-SQL functions and stored procedures. Developed SSIS complex and multistage SSIS packages using For-each-loop, Execute Package, Data Flow task, Execute SQL task, Custom Script Task, Analysis Services Task, Data Mining Task
• Developed Transformations using Data Conversion, Audit, Derived Columns, Lookups, Merge, Merge Joins, Slowly Changing Dimension transformation. Scheduled the ETL processes on SSIS server and managed integration server;
• Designed complex T-SQL queries, User Defined Functions; Stored Procedures and Triggers in SQL Server 2008 R2/2008/2005 followed by analysis and testing of those database objects before deployment to the production server;
• Writing complex stored procedures and User defined functions and enforced business rules via Checks and Constraints;
• Designed indexes to tune the ETL process performance. Developed, modified, and optimized complex queries and stored procedures to data retrieval and modification. Developed ETL auditing system using SSIS Event Handler and Custom Scripts;
• Maintained Change Control and Release Management process for all database objects like Tables, Views, Procedures and Triggers;
• Developed analytical and transactional reports using SSRS 2008. Developed reports based on OLAP cubes. Developed ETL process monitoring reports. Used Report Builder to develop ad-hoc reporting for ETL QA as well as for DW UAT process;
• Analyzed requirements and designed normalized and de-normalized tables and relationships using SDLC methodology including Data Modeling with Erwin;
• Created, updated and maintained ETL Technical Documentation for future reference by other team members;
• Designed Extraction Transformation and Loading (ETL) process to source from Oracle applications as well as legacy data sources. Developed ETL processes to source data from flat files using SSIS 2008. Designed ETL processes to load fact and dimension tables in data warehouse;
• Worked in a team of 5 which includes Business Analysts, Data Architect, Database Developers, and Project manager.

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