SUMMARY

• Over 8 years of extensive experience in database development and IT Solutions that include experience in design, development and implementation of complex data delivery systems using MS SQL Server technology
• Experience in MS SQL Server 2012/2008R2/2008/2005 with OLTP/OLAP and Business Intelligence delivery using SQL Server Integration Services and SQL Server Reporting Services.
• Hands on experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing of projects before moving to production.
• Worked on Normalization and De - Normalization techniques for both OLTP and OLAP systems.
• Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).
• Extensive knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors.
• Strong experience with ETL tool in Mapping, Transformations, Expressions, lookups and Aggregations.
• Excellent in High Level Design of ETL DTS Packages& SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
• Good Experience in creating Master Child Packages in SSIS and in generating on-demand and scheduled reports for business analysis using SSRS.
• Skillful in Creating, Managing, Delivering SQL Server Reports using SSRS 2005/2008/2008 R2.
• Experience in Migration of SSRS reports from SQL 2005 to SQL 2008.
• Adept in designing Stylish Report layout and having Proficiency with drill down reports in SSRS 2008R 2/2008/2005.
• Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2005/2008/2008 R2.
• Developed Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder.
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS).
• Experience in writing sub reports and parameterized Queries for generating reports in SSRS 2008.
• Versatile in BIDS (Business Intelligence Development Studio), Query Analyzer, Profiler, SQL Server Management Studio, SQL Server Integration/Analysis/ Reporting Services etc.
• As a key player in the team with strong interpersonal and communication skills, explored and contributed the technical expertise as and when needed by the team.

TECHNICAL SKILLS

RDBMS: SQL Server 2012/2008R2/2008/2005, Oracle 11g/10g/9i/8i, Sybase Server, IBM DB2 UDB 8.2/8.0, MS Visual Source Safe 2005, and MS Access 2003/2000/97

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling and De-normalization

DWH / BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio.

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Web Services, SOAP.

Operating Systems: Windows 7/XP/2003/2000, NT & Windows 9x and MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

SQL Server/BI Developer

Responsibilities:

• Actively participated in interactions with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Generated matrix reports, drill down, drill through, sub reports and multi parameterized reports.
• Formatted the reports using the Global variables and expressions.
• Created reports to retrieve data using Stored Procedures that accept multi valued parameters and range parameter implementation.
• Improved performance of SSIS packages from few hours to minutes and also meeting SLA’s.
• Worked on the performance tuning of SSRS reports.
• Migrated business reports from crystal reports in to Microsoft report builder.
• Deployed and managed reports on Share point server.
• Used SharePoint to assign permissions and to create report schedules based on a particular Day and sent them through Email in required format.
• Actively participated and provided inputs on DW design and implementation technical discussions.
• Good understanding of Oracle Apps e-suite ERP modules such as iExpense, General Ledger and solid understanding of business behind code.
• Created Project parameters in SQL Server Data tools 2012 and referenced them in the packages of the project
• Used expression task to validate conditions in control flow and to assign value to variable
• Worked with the DBA to create environmentsin SSIS
• Developed SSIS Packages to validate on row counts, identity value and column counts after data transfer.
• Designed and created different ETL packages using SSIS from Oracle source to SQL Server as destination.
• Created functions and procedures in T-SQL involving complex joins, CTE and sub queries to check the integrity and consistency of data, for scrubbing of data to enable populating data intoReporting tables.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different Sources for different reports.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and Statements for applications.
• Used Joins, correlated and non-correlatedsub-queries for complex business queries involving multiple tables & calculations from different databases.
• Worked on OLAP Data warehouse Implementation.
• Designed SSIS packages using different transformations like Conditional Split, Multicast, Union-All, Merge, Merge Join and Derived Column.
• Created packages using SSIS for data extraction from Flat files, Excel files, OLE DB to SQL Server and using expressions.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.

Environment: MS SQL Server 2012, (SSIS) SQL Server Integration Services, T-SQL, (SSRS) SQL Server Reporting Services, SQL Developer,Report Builder, Crystal Reports 2008, SharePoint 2012, Oracle e-business suite, Oracle R12

Confidential, Richmond, VA

SQL Server/SSIS Developer

Responsibilities:

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables
• Designed and developed efficient SSIS packages for processing fact and dimension tables
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
• Developed Query for generating Drill Down and Drill Through reports in SSRS 2008
• Generated Tabular, Sub reports and Parameterized reports for the Business users
• Formatted the reports using the Global variables and expressions
• Created SSIS packages for Uploading of different formats of files (Excel, Access) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Used Script task in SSIS to write custom code using VB.net and C#
• Enhancing and deploying the SSIS Packages from development server to production server.
• Experience in ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.
• Developed various workflows of several SSIS Packages and scheduled them to run Weekly and monthly basis.
• Participated in daily scrums and sprint planning meetings and retrospectives.
• UsedSQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Moved objects from SQL Server to DB2(iSeries).
• Experience working on iSeries for Windows Navigator
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Worked with different methods of logging in SSIS.
• Retrieved data from Teradata tables and populated in staging tables of DBMS using SSIS packages.
• Actively participated in Testing of various SSIS Packages.

Environment: MS SQL Server 2008/2008R2, (SSIS) SQL Server Integration Services, T-SQL, (SSRS) SQL Server Reporting Services, Teradata SQL Assistant, DB2 iSeries, automate BPA Server 9, Agile Scrum, iSeries Windows Navigator

Confidential, Dallas, TX

SQL Server/BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Reviewed and optimized SQL queries, stored procedures, views & triggers from other developers to achieve maximum efficiency and scalability.
• Participated in developing Logical design of database incorporating business logic and building entity relationship (ER) diagrams.
• Experienced in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS) 2008/2008R2.
• Written DDL / DML Triggers as per the requirements.
• Experienced in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Responsible for backups/restores, designing SSIS packages and maintenance and performed Data transfer (using SSIS) from Development to Testing and then onto Production Servers.
• Responsible in Performance Tuning for queries and indexes using SQL Profiler.
• Migrated data from DB2 to SQL Server using SSIS
• Involved in data migration and used SSIS to import and export data into tables using SQL Server 2005, creating tables, views and Store Procedures using SQL server.
• Involved in cube creation, and Browsing cube data using SSAS.
• Fine tuned Queries for the performance of reports developed in SSRS and generated specifications for analysis reports by using SQL Server Reporting Services 2008/2008R2.
• Created report models for ad-hoc reports using SSRS 2008/2008R2
• Developed reports from OLAP cubes using ProClarity and SSRS 2008/2008R2.
• Wrote Stored Procedures for Reporting purpose. Also developed various reports using SQL Server Reporting Services.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes in SQL Server Analysis Services (SSAS) .
• Created Data marts for Staging and Production databases for Operational Data Stores (ODS).
• Used data profiling task in SSIS 2008 to identify poor data and repair it. Transformation etc. using SSIS.
• Involved in implementation and scheduling of the backup and maintenance strategy on the development server.

Environment: SQL Server 2008/2008R2, Microsoft SharePoint Server (MOSS), T-SQL, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, ETL, MDX, Erwin, SQL Profiler,DB2

Confidential, Dallas, TX

SQL Server Developer

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Created database logical and physical design to fit new business requirement and implemented new design into SQL Server 2008.
• Made changes to the existing data flows and redesigned the system.
• Creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Created and scheduled jobs to run on a daily and weekly basis including the maintenance of the jobs.
• Involved in taking backups and restoring of crucial databases involved in the business.
• Writing queries which involve various joins in order to perform a thorough analysis on the missing sales on a daily and cumulative basis.
• Multidimensional Expressions (MDX) is to make accessing data from multiple dimensions.
• Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.
• Used link servers in cases where data is to be pulled form a different database like oracle.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Fixing bugs in scorecards which pertain to the pivot tables and formulas.
• Worked on advanced dimension Design and Cube design.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• 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.
• Filtered bad data by using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Used Report Generator (Report Writer) which is a program to extract information from one or more files and is presented in a specific format.
• Data generated through is presented in the form of pie charts, bar charts.
• Wrote stored procedures and functions to be called from front-end developers.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created and managed users, roles and groups to handle database security.
• Tuned database by creating proper indexes.
• Created data dictionary for all columns and documented all the processes involved in maintaining the database for future reference.

Environment: SQLServer 2005 Management studio, T-SQL, Excel, Windows 2000/XP, SSIS, SSAS.

Confidential

SQL Server BI Developer (SSIS/SSRS)

Responsibilities:

• Written stored procedures to populate final database tables from staging tables and clean inaccurate data.
• Written complex queries using Merge and Analytical functions of Sql Server 2005,2008
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables
• Providing solutions to improve the existing processes and production support for various batch processes and also created the schedule for newly incorporated batch programs and processes.
• Designed and developed efficient SSIS packages for processing fact and dimension tables
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Used Script task in SSIS to write custom code using Vb.net
• Experience in ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.
• Created SQL Jobs to schedule SSIS Packages
• Wrote DDL, DML scripts for Schema, Table space and Cluster creation and alteration.
• Worked with the Program Architect and Technical Architect in design sessions to develop high-level solutions architecture for SQL Server Reporting Services solution.
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2005.
• Designed different kinds of reports like cascading parameterized reports and worked on Drill Down and Drill-through Reports.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Performed performance tuning using Execution Plan, Analyzing Indexes.
• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
• Created Technical Documentation for reports and maintenance/enhancements of existing Reports.
• Actively participated in User Acceptance Testing and Debugging of the system.

Environment: MS SQL Server 2005, MS SQL Server 2008,Team Foundation Server, Microsoft SharePoint Server(MOSS 2007), Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, T-SQL.