SUMMARY

• Over 6+ years of IT Experience in Analysis, Database Design, development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives.
• Extensive programming, installing, configuring, managing, monitoring and troubleshooting experience in MS SQL Server 2000/ 2005/2008/2012 R2 and Business Intelligence in SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services.
• Experience in Error handling and debugging, normalizing the database schema.
• Strong experience in creating complex Stored Procedures, Replication, Index, Functions, DTS packages, triggers, cursors, tables, views and other SQL joins and statements.
• Expertise in Analyzing Query Plans using execution plans and SQL Profiler to build Indexes and resolve locks and troubleshooting Deadlocks.
• Expertise in creating Reports with complex formulas and to query the database for business Intelligence using SSRS.
• Proficiency in creating different types of reports such as Table Reports, Cross - Tab, List Reports, Conditional, Pie Chart Reports, Drill-down, Drill through reports, Group reports, sub-group reports, Adjacent group reports, Total Reports, Sub-total Reports, Grand Total Reports.
• Experienced in Data Extraction Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages
• Experience in MS SQL Server configuration, performance tuning, query optimization, backup/recovery, running Database Consistency Checks using DBCC. Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Experienced in working with project manager, development team, business analyst and end-users.
• Experienced in SQL Server Analysis Services OLAP Cubes and Data Mining.
• Extensive knowledge of designing, developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Experience in Database Backup, Recovery and Disaster Recovery procedure
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.

TECHNICAL SKILLS

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

Languages: T-SQL, PL/SQL, C#, JAVA, XML, HTML, JavaScript.

Tools: /Utilities: SQL Server Management Studio (SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2005/2008,2012, SQL Plus

Databases: MS SQL Server 2005/2008/2012 R2, Oracle 10g/9i, MS Access, IBM Netezza.

Data Modeling Tools: Microsoft Visio, UML

Software: MS Office, Adobe Dreamweaver, Adobe Photoshop, Microsoft Excel, MS-Project 2000

Reporting Services: Excel, SQL Server Reporting Services, Business Objects

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

MSBI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Created complex SQL stored procedures using Microsoft SQL Server 2008 and 2008 R2
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Involved in workflow and process flow management.
• Supported the team in resolving in DTS and T-SQL related issues.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Performing the tasks of data conversions, adding derived columns, sending results in mails is done by making use of various tasks in SSIS.
• Deployed SSIS packages and Reports to Production Servers.
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Experience in Automate process which executes the SQL jobs daily/weekly/monthly.
• Built various packages in SSIS to load the data and used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Using Checkpoints in packages to enable the package to run from the point of failure.
• Developed SSIS using different ETL transformations like Derived Column, Data Conversion, Lookup, Merge, Slowly Changing Dimension, Union All and Conditional Split.
• Expertise in handling Errors by using Event Handler and can provide Logging, Custom Logging for SSIS Packages.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Modification of database object such as addition of Triggers, modification of table, stored procedure to meet customer's requirements on SQL server Management Studio (SSMS)
• Migrated all existing DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Monitoring execution plans to enhance the performance of the queries.
• Involved in creating ad hoc reports and data driven subscription reports by using Report Builder in SSRS.

Environment: MS SQL Server 2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), DTS, T-SQL, ETL, Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Visual Studio 2010.

Confidential, TX

MSBI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Involved in translating business requirements into technical design specifications.
• Used Query Profiler to optimize SQL queries.
• Managing the Clustered environment databases and was fixing the errors when they arose.
• Performed ETL operations to support the data loads and transformations.
• Developed and designed DTS packages for importing the data from MS Access and MS Excel.
• Created complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various Web applications, maintained referential integrity and implemented complex business logic.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• Designed and developed OLAP using MS SQL Server Analysis Services
• Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2000 and SQL Server 2005
• Developed and executed several optimized queries in SQL.
• Setup and installation of databases including test, development environments.
• Involved in DBA activities such as Backup, Recovery, Performance tuning and User administration
• Fine tuning of database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2005, Windows 2000/2003/NT/XP, ETL, SQL Server Integration Services (SSIS), T-SQL, Enterprise Manager, Query Analyzer, MS Access 2003, MS Excel 2003, Visual Source Safe 2005 and MS Reporting Services.

Confidential, CA

Sr. SQL, BI Developer

Responsibilities:

• Involved in developing Packages for implementing Business logic through Stored Procedures and Functions.
• Understanding business requirements and conduct follow-up meetings, if necessary, with end-users.
• Developed new process for the new Implementations, support activities and Change requests and to update the Business Process Management (BPM) document accordingly.
• Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
• Exported reports to various formats like PDF, Word and Excel.
• Performing Code reviews, code refactoring as perGuide wireStandards.
• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Excel and Flat Files.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load and extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, and data integrity.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data in Database Tables.
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Used various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Involved in writing Transact SQL utilities to generate table insert and update statements.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Experience working in agile environment and supported iterative testing methodology.

Environment: MS SQL Server 2008, C#, SSIS 2008, SSRS 2008, SSAS 2008, DTS, T-SQL, OLAP Service, Visual Studio 2005, SQL Server Profiler, Erwin Data Modeler 7.2, Windows Server 2000/2003/2008 R2, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS).

Confidential

SQL SSIS/SSRS Developer.

Responsibilities:

• Requirement gathering - Solution design.
• Involved in installing and configuring SQL Server Management Studio 2000 on development server for designing and testing.
• Documented Business Requirement Documents (BRD) from essential Business Process, Business Rules.
• Assisted with the analysis and management of critical storage and data protection capacities. Improved reporting by producing business requirements documents to capture metrics, and by creating resulting charts and graphs to provide rapid understanding of issue management.
• Gathered requirements for the creation of Data Flow processes for the SSIS packages.
• Created database objects like Tables, Indexes, Stored Procedure, Triggers, Functions, Constraints and Views.
• Created tables, Views, Indexes, Clustered Indexes & non-Clustered Indexes, user defined data types, and user defined functions, Triggers, Stored Procedures for the data consistency and to avoid duplication.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Creating theSSISpackages to load data from multiple sources into relational databases.
• Good at the using variousSSIScomponents or tasks to create a package to handle data flow.
• Created Tabular, Matrix, Pie chart, Drill down, Drill through reports, parametric, cascaded reports and dashboards and score cards report (SSRS) as per business requirement.
• Agile Methodology has been used.
• Perform daily database backup and restoration and monitor the performance of Database Server.
• CreatedSQLServerjobs and scheduled them to load data periodically usingSQLserverAgent.

Environment: MS SQL 2005, T-SQL, Excel, Flat File, Data Import, DBMS, SQL Server Management Studio (SSMS), SQL Server Integration Service (SSIS), SQL Server Reporting Services (SSRS), SQL Server Data Tool (SSDT).