SUMMARY

• 7+ years of experience as a BI Developer of MS SQL Server suite of products like SSRS and SSIS of MS SQL Server 2008 R 2/2008/2005.
• Hands on experience in Data Analysis using SQL (2008, SSRS, SSIS), PL/SQL in Client/Server and Web applications.
• Experience with Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS).
• Excellent knowledge in creating Databases, Tables, Stored Procedure, SQL Joins, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T - SQL.
• Experience in providing Logging, Error Handling by using event handlers and custom logging for SSIS Packages.
• Expert in designing reports, generating on-demand and scheduled reports for Business Analysis or Management decisions using SQL Server Reporting Services (SSRS).
• Created, designed and deployed Tabular, Matrix, Chart, Drill-down, Drill through and Ad-Hoc reports on report server
• Good knowledge of logical and physical data models.
• Experience in Data Analysis including analysis of root cause for Incident and Problem Management.
• Experience in Reporting including System reporting through data transmission, validation and release, and manual reporting in MS Excel and MS Access database.
• Functional expertise in Crystal Reports and Microsoft Visio.
• Have a thorough knowledge of software development life cycle (SDLC).
• Have a good understanding of the system flows, the architecture of the systems, how to design new systems and ensure that new systems can be supported long term.
• Proficient in Microsoft Office applications Word, Power Point, Advanced Excel (including Pivot Tables) and Access skills, MS Project.
• Experienced in environments requiring direct customer interaction during design specification, development, and product implementation phases.
• Great learning skills to adapt the rapid changing technologies and implementing the same at work.
• Strong Analytical, Inter-personnel, Problem-solving and Proven ability to work under pressure.

TECHNICAL SKILLS

Databases: SQL Server 2008/2005/2000/7.0 , Oracle 9i/8.x, DB2 MS Access

Languages: SQL, T-SQL, PL/SQL.,C#, C, C++, VB 6.0,Perl,CSS, HTML, XML, MHTML

Reporting Tools: SQL Server Reporting Service (SSRS), Actuate BIRT, Maximo, Crystal Reports XI/10/9

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Other Software: MS Office- 2007/2003/2000 , Adobe Professional, Team Foundation Server, SharePoint2012

Operating Systems: Windows / 98/2000/2003/ XP/Vista, Unix.

Database Tools: SQL Query Analyzer, ERWIN, SQL Enterprise Manager, SQL Server Management Studio(SSMS), SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Business Intelligence Development Studio(BIDS), Source gear Vault

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Business Intelligence Developer

Responsibilities:

• Gathered requirements to understand the specifications of the client’s needs.
• Created various database objects such as tables, indexes and views based on the requirement.
• Wrote complex stored procedures, queries, triggers and implemented constraints on tables.
• Designed new SSIS packages and deployed them.
• Used various SSIS tasks such as Conditional Split, Derived Column, and Data validation checks during staging, and before loading the data into Data warehouse.
• Used ETL to implement slowly changing transformation to maintain historical data in Data warehouse.
• Used SQL Agent Jobs for scheduling SSIS package, SSRS reports and alerts.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Developed, deployed and monitored SSIS Packages.
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Configured and maintained Report Manager and Report Server for SSIS.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Generated Drill down, Drill through, Ad-hoc, Matrix Reports, and parameterized reports using SSRS.

Environment: MS SQL Server 2008 R2, SSIS, SSRS,SQL Server Management Studio, SQL Server Business Intelligence studio, SQL Profiler, VB 6, MS Excel 2010, Windows Server 2008/2005.

Confidential, Omaha, Nebraska

Business Intelligence Developer

Responsibilities:

• Gathered requirements to understand the specifications of the project.
• Involved in identifying various data sources, design and develop data models (logical/physical) based on the requirements.
• Worked extensively in writing and debugging stored procedures, triggers, Inner Joins, Outer Joins, views and User-defined functions.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server Databases and Flat Files.
• Used different Transformations in SSIS as per design specifications.
• Applied various data transformations like Aggregate, Sort, Conditional Split, Derived column in SSIS.
• Implemented Event Handler and Error Handling in SSIS packages.
• Created SQL Agent Jobs for scheduling SSIS package, SSRS reports and alerts.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Environment: MS SQL Server 2008 R2, SSIS, SSRS, SQL Server Business Intelligence studio, SQL Profiler, MS Excel 2007, Windows Server 2008/2005.

Confidential, Omaha, Nebraska

Business Intelligence Developer

Responsibilities:

• Work with different levels of management in performing research, based on the objectives of the required analysis report.
• Developed database for required analysis report using MS Excel, MS Access, MySQL Programs.
• Perform data compiling, mining and analysis required to evaluate the accuracy of the given data using different software.
• Used Query, SQL and ERWin to validate the accuracy of data.
• Gather required information from the business owners and prepare analysis reports based on their requirements.
• Analyze and develop analysis reports for the business process development using Crystal Reports.
• Follow processes and procedures to modify analysis reports and make proper evaluations.
• Manually review and validate data to ensure the quality, validity and accuracy of the data’s.
• Maintain the research database, update and upgrade on a timely manner to ensure the safe storage of data.
• Created daily, weekly, monthly and yearly reports on the transactional data.
• Created various temporary tables to analyze and fact finding of the data.
• Created MS-Excel Charts and Pivot tables on the resultant data set.
• Consulting with clients (Business analysts) to meet reporting needs for their specification.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
• Created customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Environment: MSSQL Server 2008, SSRS, Crystal Reports 8, VB 8, ERWin, MS Excel, MS Access, Windows Server 2008/2005.

Confidential, Cincinnati, OH

Business Intelligence Developer

Responsibilities:

• Gathered requirements and reviewed peer code and documentation.
• Used the Execution Plan to improve the optimization of the T-SQL code.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Resolved performance related issues to Blocking, Deadlocks and long running queries.
• Created and Modified T-SQL Stored Procedures, Triggers for validating the integrity.
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Deployed and scheduled report subscription using SSRS to generate daily, weekly, monthly and quarterly reports including current status.
• Created report models and configured the report builder for building Ad-hoc reports.

Environment: MSSQL Server 2008/2005, SSIS, SSRS, SQL Server Management Studio, SQL Server Business Intelligence studio, SQL Profiler, Windows Server 2008/2005.

Confidential, Austin, TX

Business Intelligence Developer

Responsibilities:

• Experience in SQL joins, sub queries.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts.
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages.
• Extracted data from sources and transformed the data using different transformations like data conversion, derived columns, look up, Conditional Split, Aggregate, Union all, merge join and multi cast transformations.
• As per requirements developed the reports in the form of Matrix, Table using SSRS.
• Developed parameterized reports including multi-parameters, Sub reports, and Navigation reports.
• Developed Cubes using SQL Analysis Services (SSAS).
• Extending OLAP Cubes, Dimensions and data source views.
• Involved in creation of named calculation the MDX queries.
• Involved in writing T-SQL stored procedures, Functions, and complex joins.
• Providing support and fixing issues related to Data on Reports, Dashboards etc.

Environment: MSSQL Server 2005, SSIS, SSRS, SSAS, MDX, SQL Server Management Studio, SQL Server Business Intelligence studio, Windows XP/Windows Server 2003.