SUMMARY

• Over 7 years of IT experience in Database Design and Development of SQLSERVER 2012/2008R2/2008 and providing ETL/Business Intelligence solutions using Microsoft components.
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, specification writing, development, testing, and implementation.
• Experience in design of Logical and Physical Data Modeling using Erwin.
• Experience in Normalization /De - normalization and Normal Forms.
• Expertise in T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, cursors and user defined functions.
• Strong experience in creating SSIS packages using different control flow tasks, and data flow transformations in BIDS.
• Experience in developing packages and deploying them to file system and SQL server.
• Experience in Error handling by using Event handlers and also provide custom logging for SSIS packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in scheduling the jobs for SSIS packages, Sending Alerts using SQL Mail.
• Worked on MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, reporting and Designing logical/physical databases and Troubleshooting.
• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, BI suite.
• Expertise in report writing according to the business requirement in SSRS.
• Experience in Developing and delivering dynamic reporting solutions using SQL Server Reporting Services (SSRS)
• Expert in creating SQL Server Reports using SSRS in designing stylish report layout parameterized performance, Chart Reports and ad-hoc reports.
• Experience in developing different types of reports including Tabular forms, Matrix (Cross /tab Report) form, Conditional, Drill down, Top N, Summary, List items and Sub Reports.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Extensive working knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects.
• Experience in developing SSAS & SSRS reports on SQL Server ( 2005/2008/2012 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema. Experience in creating multidimensional cubes using SSAS (SQL Server Analytical Services) and OLAP (Creating Cubes) including interfaces with BIDS.
• Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Strong analytical, administration and problem solving skills dedicated to maintain the high quality standards. Good communication skills, ability to work independently.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio (SSMS), Enterprise Manager, SQL Profiler, Query Analyzer, Bulk Copy Program (BCP), Database Engine Tuning Advisor

Languages: C, C++, T-SQL, PL/SQL, Unix Shell scripting, HTML, XML, VB script

RDBMS: MS SQL Server 2005/2008/2012 , Oracle 8i/9i/10g, MS Access

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS)

Reporting Tools: SQL Server Reporting Services (SSRS), Excel

Operating systems: Windows 2003/XP/NT/Vista, Windows Server 2003/2008, Red Hat Linux 4.0 and DOS

Data Modeling Tool: ERWIN, Visio

Other Tools: MS Visual Studio 2008, MS Office, MS Visual SourceSafe

PROFESSIONAL EXPERIENCE

Confidential, NE

SQL BI Developer

Responsibilities:

• Worked with Enterprise Architect/Business Analyst in requirement gathering, analysis, testing and project coordination.
• Analyze source systems and prepare technical specifications for ETL mappings to migrate data confining to the business rules.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from heterogeneous data sources like Excel Spreadsheets, Text file, XML files, CSV files and Oracle database.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
• Advanced extensible reporting skills using SQL Server 2012 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
• Involved in designingParameterized Reportsfor generatingAd-Hocreports as per the client requirements.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2012/2008 Enterprise Edition, SQL Server Data Tools (SSIS, SSRS), Oracle 11g, T-SQL, XML, MS Visual SourceSafe and Windows Server 2008.

Confidential, IL

SQL BI Developer

Responsibilities:

• Involved in designing the procedures for getting the data from all the source systems to ODS.
• Created technical specification document by analyzing the functional specification document provided by the data analyst.
• Designed and documented the data flow diagrams as per business requirement.
• Performed Server installation and configuration using SQL Server 2008 R2.
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database as per business requirements using Erwin.
• Created connection managers like OLE DB connection and ADO.NET connection available in SSIS to extract and load the data from AS400 and Postgres databases to SQL Server.
• The packages created included a variety of transformations like Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.
• Worked on Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Report Design.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Extensively involved in Unit testing, System testing and troubleshoot defects.

Environment: SQL server 2008 Enterprise edition, DTS, SSIS, SSAS, Import/Export tools, SQL Server Agent, MS Access, T-SQL, ERWIN, AS400, Postgres

Confidential, MA

SQL BI Developer

Responsibilities:

• Tested and created Views, User Defined Functions and Stored Procedures for new and modified business requirements.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Worked effectively on SQL Profiler, Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries and Stored Procedures.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005/2008 using SSIS, BCP and Bulk Insert.
• Created, tested, modified and scheduled SSIS packages to update the tables on a day to day basis.
• Developed SSIS Packages using fuzzy lookup, xml, web services, ADO.NET, OLEDB, file system task.
• Experience in troubleshooting and tuning the performance of long running SSIS packages.
• Implemented logging for Audit purposes.
• Experience in data cleansing before loading data warehouse.
• Created SSIS packages to incrementally load the data into ODS and Enterprise data warehouse.
• Involved in generating Matrix reports, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Created Drill reports which give all the details of various transactions like closed transactions, pending approvals and summary of transactions and scheduled this report to run on quarterly basis using SSRS (Reporting services).
• Develop and deliver dynamic reporting solutions using SQL Server 2005/2008 Reporting Services (SSRS).
• Deployed, scheduled reports and added users to the data base.
• Created ad-hoc Reports using OLAP Cubes.
• Documented reports and packages created.

Environment: SQL Server 2008 R2 /2005, Microsoft Business Intelligence Development Studio, T-SQL, SSIS, SSAS, SSRS, Erwin, VSS.

Confidential, CT

SQL BI Developer (SSIS)

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system
• Tested and created Views, User Defined Functions and Stored Procedures for new and modified business requirements.
• Worked effectively on SQL Profiler, Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries and Stored Procedures
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005/2008 using SSIS, BCP and Bulk Insert.
• Created, tested, modified and scheduled SSIS packages to update the tables on a day to day basis.
• Developed SSIS Packages using fuzzy lookup, xml, web services, ADO.NET, OLEDB, file system task.
• Experience in troubleshooting and tuning the performance of long running SSIS packages.
• Implemented logging for Audit purposes.
• Experience in data cleansing before loading data warehouse.
• Created SSIS packages to incrementally load the data into ODS and Enterprise data warehouse.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Created views and restrict access to data in a table for security.
• Involved in generating Matrix reports, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Created Drill reports which give all the details of various transactions like closed transactions, pending approvals, and summary of transactions and scheduled this report to run on quarterly basis using SSRS (Reporting services).
• Develop and deliver dynamic reporting solutions using SQL Server 2005/2008 Reporting Services (SSRS).
• Deployed, scheduled reports and added users to the data base.
• Built cubes from data warehouse and deployed on to analysis server.
• Created ad-hoc Reports using OLAP Cubes.
• Used Cube partitions to improve query performance and reduce downtime associated with the cube processing.
• Documented reports and packages created.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 10g, Performance Point Server 2007.

Confidential

SQL Server Developer

Responsibilities:

• Involved in designing and writing Stored Procedures, Triggers, Cursors, functions and maintained referential integrity and implemented complex business logic using T-SQL for SQL Server 2000.
• Creating new Database with objects such as tables, views, indexes, triggers etc.
• Complex queries and stored procedures to get the updates data from other servers.
• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Performing query plans and making sure every query is using appropriate useful indexes.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Backup and restore databases.
• Used Microsoft SQL server 2005 Integration Services to extract data from Flat file, to transform data using data conversion transformation, aggregate transformation and to load the result into fact table dimension.
• Designed and created packages using Business Intelligence Design Studio, organized them in Solutions and Project
• Analyzed the existing data mart in SQL 2000, planned and performed the migration from SQL server 2000 to SQL Server 2005 following the Normalization standards to maintain data consistency.
• Created logging for the package to record the inserted rows, error rows, and updated rows in the data pipeline
• Worked with report parameters and performed multi valued Parameterized and cascading parameterized reports using SSRS in Visual Studio.
• Created Ad hoc reports, Drill down and drill through reports, sub reports using SSRS.
• Experience in securing the reports.

Environment: SQL Server 2005/2000, Microsoft Business Intelligence Development Studio, T-SQL, SSIS, SSRS, Windows Server 2003