SUMMARY

• 8 years of IT experience as a SQL BI developer that includes migration of data and reports using SQL server 2014/2012/2008 R2/2008/2005 and Visual studio 2010/2008.
• Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2005/2008/2008 R2/2012/2014 with expertise on data normalization.
• Conversant with all phases of the Software Development Life Cycle (SDLC) specially Agile, Scrum, involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support.
• Strong knowledge of Data Warehouse concepts and technologies such as ETL processes, dimensional modeling, Star and Snowflake Schemas, reporting tools etc.
• Highly proficient in creating database objects like tables, indexes, views, user defined functions, stored procedures, triggers, cursors, data integrity and constraints.
• Good knowledge of Normalization/De - normalization, data design methodology and building Referential Integrity.
• Extensive experience in .NET Framework 1.1, 2.0, 3.5, 4.0 involved in C#, ASP.NET, ADO.NET and Web Services.
• Ability to work in all stages of System Development Life Cycle.
• Experience in developing applications using ASP.NET MVC 5/4/3 framework.
• Good understanding in Database and Data warehousing concepts (OLTP & OLAP).
• Highly skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Analysis Services (SSAS).
• Extensive experience in Data Extraction, Transformation and Loading (ETL) using DTS package in MS SQL Server 2005/2008/2008 R2/2012/2014 SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP.
• Widely used VB scripts in the script task in SSIS packages.
• Expertise in using Business Intelligence Development Studio (BIDS) Graphical User Interface (GUI) to design SSIS packages for Data Management applications.
• Highly knowledgeable in Designing, Developing and deploying various kinds of reports using SSRS using relational data.
• Scheduled & distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio.
• Experienced in designing and developing large number of reports in SSRS using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Expertise in SQL Server Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services (2012/2008/2005 ), MS Access, MS Excel, Crystal Reports, Business Objects4.0

Database: MS SQL Server 2014/2012/2008, MS Access, Oracle 9i/8i

Programming: T-SQL, PL-SQL, C

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS

Operating Systems: Windows (95/98/2000), Windows 2003/2008 Server, Windows XP, Windows Vista

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash.

PROFESSIONAL EXPERIENCE

Confidential, Franklin, TN

ETL/Data Engineer

Responsibilities:

• Created/modified SQL Joins, subqueries, and other T-SQL implement business rules.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Planned, designed and documented the optimum usage of space requirements and distribution of space for the Data Warehouse
• Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO)
• Test backups to ensure we can meet the business' Recovery Time Objectives (RTO)
• Install and configure new SQL Servers
• Designed SSIS Packages to concentrate, exchange, load (ETL) existing information into SQL Server 2014.
• When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
• Document the company's database environment

Environment: MS SQL Server 2014, SSRS 2012, SSIS 2012, SSMS, T-SQ, SQL Azure, Azure storage explorer.

Confidential, Bothell, WA

SQL BI Developer

Responsibilities:

• Created tables with Cluster/Non-Cluster Index, Stored Procedures, and Triggers; programmed and designed reports off transactional databases
• Monitored performance and optimized SQL queries; and created and modified T-SQL stored procedures.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults user defined data types and functions
• Scheduled batch jobs; ran daily SSRS reports
• Designed Reports that had complex SQL, PL/SQL code and stored procedures using Reports 10g.
• Tracked and resolved issues of JIRA Issue Tracking System application with multiple features and capability like data upload, work flow, various reports, dashboards and filters that enable to get data for required criteria.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• Designed Forms that had complex stored procedures and PL/SQL code using Forms 10g and did some personalization.
• Tuned PL/SQL Stored Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, Explain plan and analyzing the tables.
• Involved in creating DYNAMIC SQL that will update or insert data into the tables on the run.
• Exporting and importing the data into the database as and when user provided the data and do analysis.
• Configuring SSIS packages using package configuration wizard to allow packages run on different environments.
• Developed and Maintained MS Access Database.
• Created views, SQL joins DTS packages and statements for applications
• Develop SSIS packages to load the data into data marts.
• Extensively using SSIS for Transformations, Aggregations and Lookups.

Environment: SQL Server 2008/2012, T-SQL, Windows XP, Visual Studio, Report Builder, SQL Profiler, SSIS, SSRS.

Confidential, Virginia Beach, VA

SQL/ BI Developer

Responsibilities:

• 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.
• 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) 2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Have deployed packages on different servers by configuring it.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in integrating SharePoint Server with SSRS and deploying SSRS reports on to SharePoint Server.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Create and edit alerts on Reports, as per User request
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically
• Migrate reports from Dev to Production
• Provide on call support after reports are deployed to production
• Export 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)
• Experience in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.

Environment: SQL Server R2, SSIS, SSRS, OLAP, OLTP Performance Point Server, SQL Server Business intelligence Development Studio(BIDS), T-SQL, C#, MS Excel, Windows 2000 Server, T-SQL.

Confidential, New York, NY

SQL Developer

Responsibilities:

• Converted Data Transformation Services (DTS) application to SQL Server Integration Services (SSIS) as assigned.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Perform unit testing Confidential various levels of the ETL.
• Worked on Migration of packages from DTS using SQL Server Integration Service (SSRS).
• Generating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Involved in Report writing according to business requirement using SSRS.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.
• Designed and created the table schema and stored procedures that will be used in Data QC.

Environment: SQL Server 2008 Enterprise Edition, SQL, Enterprise manager, SSRS, SSIS, Crystal Reports, UML, VB.NET, MS PowerPoint, MS Project, Oracle.

Confidential 

SQL Developer

Responsibilities:

• Provided backend support for customer complaints municipality database.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts and Decision Support Systems (DSS) using Multidimensional and Dimensional modeling (Star and Snowflake schema) Concepts.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Developed SSIS packages with various tasks like - FTP, file system, for-each-loop, execute package, data flow task, executeSQLtask, custom script task, analysis services task, data mining task.
• Database Maintenance, Replication, Tuning, System Database Migrations and Maintenance
• Perform database administration tasks including; Installation, Configuration, Upgrades, Capacity Planning, Performance Tuning, Backup and Recovery.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL to MS SQL as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Identified and worked with Parameters (e.g. cascading parameters) for parameterized reports in SSRS.
• Create Stored Procedures, Triggers, Tables and Indexes for MSSQL 2005
• Perform database maintenance tasks which includes Rebuilding and Reorganizing Indexes, Updating Statistics as well as running Integrity Checks (DBCC)
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Developed various T-SQL stored procedures, triggers based on the requirement.
• Defined Check constraints, Business Rules, Indexes and Views.
• Involved in tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Environment: T-SQL, SSIS, SSRS, SSAS, ODS, SQL Server and Microsoft Visual Studio, Data Marts, XML, EDW, Windows XP