SUMMARY

• Over 7 years of IT experience in design, development, testing, support and migration of Microsoft SQL Server 2012/2008R2/2008/2005 database.
• Experience in Requirement gathering, Functional, Technical specifications, System analysis, Design, Development, Testing and Implementation of client/server and web - based applications.
• Extensive experience in T-SQL to write: stored procedures, triggers, functions, CTE’s, Cursors, Indexes and relational database models.
• Expertise in Extracting, Transformation and Loading (ETL) data using Bulk Copy Program (BCP), Import/Export data, DTS packages and SQL server Integration (SSIS).
• Experienced in managing and automating Control flow, Data flow, Events and Logging programmatically for SSIS packages.
• Expertise in creating and managing Event Handlers, Package Configurations, Error Handling, Logging and User-defined Variables for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in developing and deploying complex Drill-Down reports, parameterized reports, Cascaded reports, Dynamic Reports using SQL Server Reporting Services (SSRS).
• Proficiency in creating different types of Ad-hoc reports, Parameterized, Linked, Drill-through, Drill-down reports, Matrix reports, Sub reports, and formatting them using SSRS.
• Experience in using Pentaho report Designer to create pixel-perfect reports of data in PDF, Excel, HTML, Text, Rich-Text-File, XML and CSV.
• Hands on experience in creating OLAP cubes using SQL Server analysis services (SSAS).
• Good knowledge of Data Marts, Data warehousing, OLTP, OLAP, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
• Experienced in working on different data bases like Oracle, MS SQL Server & Amazon Redshift.
• Proficient in monitoring SQL Server Performance using SQL Profiler, Query analyzer, Index Tuning Wizard and Windows Performance Monitor.
• Experience in creating the unit and functional test cases by using Python test scripts.
• Good knowledge on relational database management (RDBMS) concepts and experience in creating XML files and XSD schema files.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys.
• Expertise in using TFS, Visual source safe (VSS) and GIT source control system as a tool for repository of codes and version control, branching and merging into production.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2012/2008R2/2008/2005, Oracle 12c/11g/10g, MS-Access., Amazon Redshift.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),SQL Server Integration Services (SSIS).

Operating Systems: Windows 8/7/Vista/XP/2003/2000/NT/98.

Data Modeling: Erwin, Microsoft Visio.

ETL Tools: SSIS, Data Transformation Services (DTS).

Reporting Tools: Reporting Service (SSRS), MS Excel, Pentaho Report Designer.

Designing Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), Visual Studio 2012/2008/2005.

Languages: C, C++, SQL, Transact SQL, PL/SQL, XML, PostgreSQL.

Web Technologies: ASP.NET, VB.NET, C#.NET, JavaScript, HTML, Python.

Version Tool: Team Foundation Server (TFS), MS Visual Source Safe (VSS) and GIT source control system.

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

SQL/Pentaho Report Developer

Responsibilities:

• Analyzing and understanding the existing reporting environment.
• Interacting with business users to better understand the requirements and how the date warehouse can be leveraged for reporting requirements.
• Based on business requirement, developed the Complex SQL queries involving multiple tables using joins for implementing the business rules and transformations.
• Developed and implemented the application code in Oracle PL/SQL and Postgre SQL.
• Created temporary tables to speed up queries and assist in debugging the complex queries.
• Imported data into the database using Pentaho Data Integration.
• Designed stylish report layouts and created core reports from reporting database.
• Identified the database tables for defining the queries for the reports.
• Designed stylish report layouts and created core reports from reporting database, using proper text formatting, report headers and footers, and page size to allow for printable reports.
• Designed and maintained a wide variety of reports include Finance, Financial Aid, Student, Human Resources, Advancement, Accounts Receivable reports used by different departments within the College using Pentaho Report Designer.
• Designed and produced reports in various formats such as HTML, CSV, PDF and Excel using delivery mechanisms such as e-mail, E-mail and web.
• Published reports are delivered via Pentaho BI-Server for end users access.
• Ensure all code and versions are properly maintained in GIT source control system.
• Installed and used Python to validate the data set by verifying that the expected record granularity is achieved and also used other validation tools to verify expected results are accurate.
• Prepare of test plans and unit test cases. Perform all relevant testing before promoting code to next environment.
• Monitoring and supporting the existing reporting environment.
• Actively participated in meetings with end users in the development and training on the new user interface for retrieving reports and data.
• Documented all work so that the end user can easily understand the flow of the process.

Environment: Pentaho reporting Designer 5.4, PL/SQL, Postgres SQL, Amazon Redshift, Oracle 12c, Navicat, GIT source control system, Pentaho Data Integration, MS Excel, HTML, CSV, PDF, Python 3.4, Sublime Text, Windows Server 2007.

Confidential, Greensboro, NC

SQL BI Developer (SSIS/SSRS)

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Designed SSIS package to load data from different sources (SQL Server, Flat Files, Excel source files, XML files etc.,) to SQL Server database using SQL Server Integration services (SSIS).
• Set up different kinds of transformations like Derived Column, Conditional Split, Lookup, Merge, Row Count, Data Conversion etc., in all the SSIS Packages.
• Defined parameters, variables and run time parameters within the SSIS package Execute SQL task and executed stored procedures within the packages by passing parameters and loaded the data into the tables.
• Configured with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Initially loaded data into staging tables using different transformations, control flow tasks, loop containers and data flow tasks, then moved the data into Archive tables.
• Created SQL Agent Jobs to schedule jobs for extracting data from different source systems using SSIS packages. Stored Procedures are used within these packages to aggregate the data.
• Optimizing the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, established joins and created indexes whenever necessary.
• Migrated data from different source locations to Dev / QA environment using SSIS packages.
• Worked on several complex Drilldown, Parameterized reports and on reports that call sub reports using SSRS 2008R2.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created ClusteredandNon Clustered Indexeson tables for performance optimization of complex stored procedures.
• Performance tuning of SQL queries/stored procedures using SQL Profiler and Index Tuning Wizard.
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Ensure all code and versions are properly maintained in VSS while migration is in progress.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
• Documented of all processes involved in maintaining the database for future reference.

Environment: MS SQL Server 2008/2008R2, T-SQL, MS Excel, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio, Visual Source Safe (VSS), Windows Server 2007.

Confidential, Warminster, PA

MS SQL Server BI Developer

Responsibilities:

• Worked as part of a team for gathering and analyzing Business Requirements.
• Analyze the business requirements and develop the process to ensure all components of the application work correctly.
• Involved in performance tuning ofT-SQL queries, Stored Procedures, scripts, and code for high performance.
• ImplementedExtractionTransformationandLoading (ETL) processby pulling large volume of data from various data sources using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between differentheterogeneous sourcessuch as Flat file, Excel 2007 using SSIS.
• Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
• Used different data flow elements likeFlat File,OLEDB,Excel Sources,DestinationsandData FlowTransformations like Data Conversion, Conditional Split, Derived Column etc.
• ImplementedEvent HandlersandError Handlingin SSIS packages and notified process results to various user environments.
• Used TFS for version controlling and ensured that TFS was part of any development.
• Upgraded existing packages developed usingSSIS 2008 R2 toSSIS 2012packages.
• Developed various types of reportslike Drill down, Drill throughandparameterizedreports using SQL Server Reporting Services 2012.
• UsedSQL Analyzerand Profiler for monitoring the SQL statements and procedures.
• Created Joins and Sub-Queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers,functions, stored procedures,anddata manipulation.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Optimized theT-SQL query performancewith modifications in T-SQL queries, removing unnecessary columns, establishing necessary joins.
• Involved in preparing detailed technical documents.

Environment: MS SQL Server 2008R2 & 2012, T-SQL, MS Excel, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual studio, Query Analyzer, Windows Server 2007.

Confidential, Minneapolis, MN

SQL Server Developer/ETL Developer

Responsibilities:

• Involved in gathering User Requirements and converting them to Design documents.
• Convert business requirements into actionable technical requirements for the project.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages.
• Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different sources into company's format.
• Created Packages using Complex Store Procedures and T-SQL queries.
• Created Package Configurations, Event Handlers for On Error, On Warning, On Task Failed Event Types.
• Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.
• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler.
• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Report Models Drill-Down Reports using SSRS 2008R2/2012.
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.
• Developed reports using complex T-SQL queries, User Defined Functions, stored procedures and Views.
• 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 Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Used SQL Profiler and Query Analyzer to optimize SSIS package queries and stored procedures.
• Documented of all processes involved in maintaining the database for future reference.

Environment: Windows 2007 enterprise, SQL Server 2012/2008R2, SQL Integration Services(SSIS), Business Intelligence Development Studio, Visual Studio, OLE DB, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS).

Confidential, Knoxville, TN

MS SQL Developer/ ETL Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, Oracle, DB2 etc. to SQL Server using SSIS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS packages and scheduled them as jobs to run automatically to Process the load data.
• 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 using SSIS.
• Developed, monitored and deployed SSIS packages.
• Created checkpoints and configuration files in SSIS packages and Performed incremental data load packages in SSIS.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created different Parameterized Reports (SSRS 2008R2) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports and etc., based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.

Environment: MS SQL Server 2008/2008R2, T-SQL, MS Excel, Management Studio, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and Visual Studio.

Confidential

SQL Server Developer

Responsibilities:

• Created databases for MS SQL Server 2008, MS Access.
• Created Database Objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Imported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.
• Created T-SQL triggers and Stored procedures encompassing business rules.
• Created ad-hoc reports, drill down, and drill through reports using SSRS 2005/2008.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Involved in migration of SSRS from SQL 2005 to SQL 2008.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Monitored performance and optimized SQL queries for maximum efficiency.

Environment: SQL Server 2008/2005, SQL Management Studio, MS Visual Studio, MS Office 2007, Windows Server 2003 enterprise, SSRS, SSIS.

Confidential

SQL Server Developer

Responsibilities:

• Implemented a well-planned backup and restore strategy that protects databases against data loss.
• Responsible for design, development and implementation of mappings/transformations based in source-to-target specifications, defining ETL (extract transform, load).
• Developed complex SQL queries, stored procedures, and SSIS packages.
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation.
• Involved in designing and writing Stored Procedures, functions and packages using T-SQL for SQL Server 2005.
• Used DBCC utilities to fix data corruption in application databases.
• Development of Business rules implemented as Constraints, Triggers and or Stored Procedures.
• Developed reports using Crystal reports.

Environment: SQL Server 2005, T SQL, Windows Enterprise Server 2003, SSIS, Crystal reports, SQL Profiler, Query Analyzer.