SUMMARY

• About 9 years of SQL experience with in SQL Server Suite of products (SSRS/SSIS/SSAS) and involved in all phases of Software Development Life Cycle from gathering requirement, development, implementation, testing and support.
• Experience in MS - SSRS, SSIS, SSAS, OLTP, OLAP, Slowly Changing Dimensions, Data Cleansing and Data Migration.
• Good Knowledge of data warehousingtechniques and standards.
• Extensively worked on Erwin Data Model Tool and good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts.
• Experience in High Level Design of ETL Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations.
• Proficient in Data migration between homogeneous/heterogeneous systems and SQL Server using Integration Service (SSIS), BULK INSERT, DTS Import/Export utility, and Bulk Copy Program (BCP).
• Experience in Data Modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs.
• Scheduling the SSIS packages and Jobs using BMC Control-M Scheduler.
• Specialized in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports, Charts using SQL Server Reporting Services.
• Created email subscriptions for data driven reports by using Report Manager.
• Experience in generating on-demand and scheduled reports for business analysis or management Decision using SQL Server Reporting Services.
• Used Report Manager to assign roles, permissions and to create report schedules.
• Experience with Ad-Hoc reporting using Report Builder in SSRS for daily reports.
• Expertise in designing/creating several reporting services reports that have been formatted specifically for dashboard displays, i.e. with charts, KPIS, tables, etc
• Used Performance Monitor/Profiler to solve dead locks/long running queries.
• Worked on analyzing and performance tuning queries by looking at Query Statistics and Execution plans.
• Experienced in managing Alerts, Operators and Jobs through BMC Control-M Scheduler.
• Experience in writing complex SQL queries involving multiple table inner and outer joins, temporary tables, table variables.
• Experience in Designing, Developing and Maintaining Web Applications using Visual Studio .NET, ASP.NET, C#, VB.NET, ADO.NET.
• Experienced in Visual SourceSafe version, TFS, control system product that delivers restore point and parallel collaboration capabilities, thus allowing application development organizations to work on several versions of software simultaneously
• Strong technical knowledge in Troubleshooting and Performance tuning.
• Created views to facilitate easy viewing implementation.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience of working with huge databases (size>5 M rows).
• Hands-on experience in debugging stored procedures to optimize performance.
• Assisted in restoring and updating the production database into development and QA environment for testing various stages of monitoring the queries.
• Experienced in creating front end application bridge to ASP.NET based applications
• Experience in using variables, expressions and functions for the reports.
• Dealt with huge amount of data and used SSAS in order to retrieve the data.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2012, 2008, 2005, 2000, DB2, Azure SQL, Oracle 9i/10g

Database Tools: T-SQL, PL/SQL, DTS, OLTP, BCP, SSIS, OLAP

Reporting Tools: Microsoft SQL Server Reporting Services, Crystal reports, Cognos

Operating Systems: Windows XP/2008/2012, UNIX, Windows 9x

Programming Languages: T-SQL, HTML, Visual Studio, C#.Net

Data Warehouse/BI Tools: SQL Server Analysis Services, Business Intelligence Development Studio

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

SQL Server BI Developer

Responsibilities:

• Worked with creating custom script in C# and VB.net to work with Error handling and replacing special characters for DB2 and then loading in SQL server 2012.
• Involved in data warehouse development environment using Microsoft DTS, SSIS technologies and developing system Entity Relational (ER) diagrams and also create logical and physical models.
• Involved in creating test cases from source to target and analyze the data and work on creating fix scripts for the historic attributes like Account, Bills for GAS and Electric and Address loading into facts and dimensions.
• Involved in analyzing the data for Meter Reads, Collections, Service Address that has issues for different Accounts of the Customers to verify how the readings are been performed for them for all Divisions.
• Worked with creating the scripts to populate the data between the different environments like DEV/TEST.
• Worked with loading data from different source like DB2, SQL server, XML, flat files and Excel using SSIS and worked with better error handling and logging with stored procedure.
• CreatedSQLserver configurations for SSIS packages.Used SSIS transformations to implement the Slowly Changing Transformation, to maintain HistoricalDatainDatawarehouse.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for complex Databases and Worked with error handling and logging on SSIS packages.
• Created various staging tables forconversionpurpose to cleaning thedatawhile converting from old system to new system.
• Worked Optimized the performance of queries with modification in T-SQL queries, stored procedures, functions removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes
• Worked with handling the Data warehouse audits and error handling with rejects records, total counts of records based on the update, delete and insert and Power pivot.
• Worked on SSIS 2012 project deployment, configuration to different environment and monitoring SSIS packages in SSIS Catalog and created custom error handling, logging on SSIS packages.
• Created and modified stored-procedures, triggers, cursors, and views in support of DBA day to day duties or reports like Drilldown, Cross tab reports, Tabular reports.
• Created complex stored procedures for about twenty searching criteria which are used in the report to customize the report data and to make data analysis efficient.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Build database queries and test cases for the testing team to test the reports.
• Prepared the reports for the day-to- day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: Windows XP, Microsoft SQL Server 2005/2008/2012 , Azure, SQL Enterprise Manager, DB2, VB.net, SQL Server Reporting, Amazon Web Services, Visual Source Safe, TFS and SSRS 2005/2008, SSIS/DTS,SSAS 2000/2005.

Confidential, New Jersey, NJ

SQL Server BI Developer

Responsibilities:

• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Involved inMigrationof Databases fromSQL Server 2008 to SQL Server 2012 using SSIS and third party tools of Pragmatic work DTSXchange.
• Worked on SSIS 2012 project deployment, configuration to different environment and monitoring SSIS packages in SSIS Catalog and created custom error handling, logging on SSIS packages.
• Resolved complex issues and Error Handling in SSIS.
• Worked with loading data from different source like DB2, SQL server, XML, flat files and Excel using SSIS and worked with better error handling and logging with stored procedure.
• Involved in creatingSSISpackages to migrate large amounts of data.
• Involved in migrating all the SQL Agent Jobs to BMC Control-M Scheduler to maintain and run various SSIS packages periodically or as scheduled.
• Extensively performed Data processes, Data Mappings, Data dictionaries, Data pulls and Reporting solutions.
• Worked Optimized the performance of queries with modification in T-SQL queries, stored procedures, Functions removed unnecessary columns, eliminated redundant and inconsistent data, normalized tablesEstablished joinsand created indexes.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for complex Databases and Worked with error handling and logging on SSIS packages.
• Created cubes to support specific analysis conducted by upper management, the cube included few materialized views as well as fact arranged by topic.
• Worked with Quest SQL Compare table and the data compare between Dev to Test and Test to Prod environment.
• Created and modified stored-procedures, triggers, cursors, and views in support of DBA day to day duties or reports like Drilldown, Cross tab reports, Tabular reports.
• Worked in migration of Cognos report to SQL server reporting service.
• Implemented batch processing for approval using SSIS and later schedule them with SQL Server Agent.
• Worked with handling the Data warehouse audits and error handling with rejects records, total counts of records based on the update, delete and insert and Power pivot.
• Responsible for developing various reports like Drilldown, Cross tab, Sub-reports, Matrix, Tabular reports.
• Performing Data source investigation, developed source to destination mappings and data cleansing while loading the data into staging/ODS regions.
• Involved in designing reports and delivering them by any of the delivery methods like standard subscriptions, data-driven subscription, URL access etc.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Analyze user requirements, functional and technical specifications, preparing test plans.
• Used TFS (Team foundation server) source control tool to check in all of the codes in daily basis.

Environment: Windows XP, Microsoft SQL Server 2005/2008/2012 , SQL Enterprise Manager, DB2, VB.net, SQL Server Reporting, Microsoft Excel, TFS, Visual Source Safe, and SSRS 2005/2008, SSIS/DTS,SSAS 2000/2005,Tidal Automation.

Confidential, Birmingham, AL

SQL Developer/Business Intelligence Developer

Responsibilities:

• Good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts.
• Migration ofDTSpackages toSSISpackages and individually designed MS SQL Server 2008 database, coded stored procedures (T-SQL).
• Utilized T-SQL on a daily basis in creating customs view for data and business analysis.
• Worked with various XML data and worked on creating ETL packages with loading all package in loop and loading them in SQL server
• Created package with different data sources (SQL Server, Flat Files, Excel files, etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Experience with writing T-SQL, PL/SQL code and working on Dashboard and crystal reports
• Worked with Quest SQL Compare table and the data compare between Dev to Test and Test to Prod environment.
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Developed Scheduled Jobs from SQL Agent to automate the packages.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked with creating mapping document with business requirements, source to destination schema mapping along with the ETL logic and created design documents.
• Created temporary tables and table variables while creating complex queries in SQL Server 2005/2008/2012 .
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Writing complex SQL queries using table joins (inner and outer), temporary tables, and table variables.
• Interacted with Business user for requirement gathering and write traceability mapping documents.
• Running DBCC consistency checks, and fixing data corruption in databases.
• Monitoring execution plans to enhance the performance of the queries.
• Ensuring database integrity, indexing, segmentation and recovery and update database design over time.
• Troubleshooting and Performance tuning using Quest Performance Analyzer to diagnose historic data as well as current ones.
• Designing, developing, implementing, and maintaining reporting frameworks..
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Performed Tableau type conversion functions when connected to relational data sources.
• Merging data into a single server environment to have better control, consistency and security of data.
• Worked with developing .NET application using ASP.NET, ADO.NET.
• Performance Monitoring with SQL Profiler and Windows System Monitor.
• Adept at rebuilding indexes on various tables.
• Optimized the SQLs and Informatica mappings which handled millions of records
• Adept at debugging stored procedures using SQL Server Profiler.
• Restored QA server from development periodically to test the queries on the QA server.
• Developed OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting Services (SSRS), Dashboards.
• Built SSRS reports from various heterogeneous sources like SQL Server, Oracle.
• Creating Parameterized Reports, Drill down, Sub-reports using SQL Server Reporting Services 2008/2012.
• Created reports from various migrated data sources into simple dashboards for easy reviewing.
• Creating Ad hoc reports using Report Builder.
• Configured SQL mail agent for sending automatic emails when a SSIS process failed, succeed or completed
• Done front end ASP.Net application bridging to the back-end Database systems.

Environment: SQL Server 2005/2008/2012 Enterprise Edition, SSIS, T-SQL, SSRS, Dashboards, SSAS, Windows Server 2012, C#, ASP.Net, Oracle 9i, Erwin 7x,Visual Basic 6, BMC Control-M Workload Automation.

Confidential, Columbus, OH

SQL Server & SSRS/SSIS Developer

Responsibilities:

• Extensively worked on MS-SSRS, SSIS and Slowly Changing Dimensions.
• Adept at rebuilding indexes on various tables.
• Worked with Database size exceeded 4 million rows and Developed Excel web parts for reports, KPIs and connected to dashboards on MOSS 2007
• Worked with latest technology in MS SQL Server 2008 like the MERGE statements and better error handling techniques.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Created temporary tables and table variables while creating complex queries in SQL Server 2005/2008.
• Developed indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Running DBCC consistency checks, and fixing data corruption in databases.
• Monitoring execution plans to enhance the performance of the queries.
• Ensuring database integrity, indexing, segmentation and recovery and update database design over time.
• Troubleshooting and Performance tuning using Quest Performance Analyzer to diagnose historic data as well as current ones.
• Writing complex SQL queries using table joins (inner and outer), temporary tables, and table variables and Designing, developing, implementing, and maintaining reporting frameworks.
• Developed/Monitored ETL packages with different data sources (SQL Server, Flat Files, Excel files, etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Developed Scheduled Jobs to automate the packages.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Involved in creation of dimensions using Star, Snow Flake schemas.
• Involved in strategic, planning and budgetary responsibilities.
• Created several MDX queries according to Business requirements.
• WroteMDXqueries and expressions for use in Front End BI Applications
• Built SSRS reports from various heterogeneous sources like SQL Server, Oracle.
• Created ad-hoc queries from DB2 database for custom reporting needs.
• Created Drill Down, Drill through, linked and sub reports using SSRS 2005.
• Created reports from various migrated data sources into simple dashboards for easy reviewing.
• Build parameterized reports and returning subsets of data with query parameters, mapping reports Parameters.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, T-SQL, SSRS, Dashboards, SSAS, Windows Server 2003, C#, ASP.Net, Oracle 9i, Erwin 7x,Visual Basic 6

Confidential, Minneapolis, MN

SQL Server BI Developer

Responsibilities:

• Designed SSIS packages to migrate the data from DB2, oracle, flat files, excel documents and CVS files to the Staging Area in SQL server 2005.
• Implemented the Master Child Package Model for easier maintenance and better performance.
• Managed Package Configurations in XML Files to efficiently Promote Unit Tested Packages to Live Environment from Development Environment.
• Scheduled Packages using SQL Server Agent Jobs.
• Created and maintained Roles and database users.
• Responsible in various reports like drilldown, cross tab reports and tabular reports
• Administered MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creating roles, granting privileges to the roles and groups.
• Participated in implementing the logical design to the physical design by creating tables.
• Transferred flat files from different sources to the Staging Area by using SSIS and executed BCP from a package to import all files to pre-staging database.
• Enforced the Business Rules by creating multiple constraints like check constraints and triggers as well as automated the update of the database statistics.
• Optimized the performance of various SQL stored procedures using SQL profiler to improve the latency of reports pushed daily to management.
• Created linked servers for data retrieval using OLE DB data source and providers.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Created DTS Packages using ActiveX Scripts to extract, transform/modify and load data from database files to other type files.
• Report Generation for daily job status in Microsoft Reporting Services.
• Created cubes to support specific financial analysis conducted by upper management, the cube included few materialized views as well as fact arranged by topic.
• Created complex views and scripts to convert business logic for different reports.
• Build parameterized reports and returning subsets of data with query parameters, mapping reports parameters.
• Designed new Aggregations by creating Hierarchies and then pre calculating the Aggregations using Aggregation Wizard in SSAS.
• Weekly basis update statistics & DBCC checks.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specification
• Created ad-hoc queries from DB2 database for custom reporting needs.
• Created Drill through, linked and sub reports using SSRS 2005.

Environment: Microsoft Windows Server 2003 Enterprise Edition, DB2, Sharepoint, Microsoft SQL Server 2005, Microsoft SQL Server Reporting Services, Microsoft SQL Server Analysis Services.

Confidential, Minneapolis, MN

SQL Server Developer/ BI Developer

Responsibilities:

• Created complex SQL codes using Views, temporary tables, triggers and stored Procedures.
• Expertise in tuning T-SQL procedures, triggers and other database objects.
• Expertise in designing DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Designed and developed DTS packages for transferring data from flat files and Access files.
• Experienced in various stages of SDLC, which includes requirement gathering, analysis, design, development, Implementation.
• Upgrade enhancements, maintenance, support and bug fixing for the product.
• Involved in converting SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages.
• Created various packages for performing ETL process using SSIS.
• Programmed SQL Server 2000 Reporting Services using Microsoft Visual Studio 2003.
• Uploaded SQL Server 2000 Reporting Services RDL files to SQL Server 2005.
• Created database objects for improving the performance.
• Fine-tuned Procedures, Functions and Triggers for optimum performance.
• Created cubes and dimensions using SSAS.
• Maintained all SQL documents including installation and data conversion Procedures, standard security documents, etc.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.

Environment: T-SQL, SQL Server 2000, Windows 2000 Server, Query Analyzer, MS Access 2000, Oracle, DTS, OLAP Services, Erwin Data Modeler.