SUMMARY

• Around 8 years of IT experience in Database Design, Development, Implementation and Administration in SQL Server 2012/2008R2/2005/2000 and providing ETL/Business Intelligence solutions using Microsoft components.
• Experience using highly complex TSQL queries and SQL Scripts to perform efficient data load based on complex business rules and produced results for users.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
• Strong technical knowledge in MS SQL Server development including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Expert in Data Modeling, defining the relationships between fact table and entities by using ERwin
• Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow - Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Maintained and configured SQL Server Report Server, and developed & migrated from Crystal Reports.
• Extensive experience with different phases of project life cycle (Design, Implementation, Testing and debugging new and existing database systems).
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Strong understanding of RDBMS concepts and Data Modeling Concepts.
• Experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data management, data dictionaries, and data integrity.
• Experience with production, development, and test databases including access controlling, performance monitoring and tuning, capacity planning.
• Extensive experience in ETL design/development using MS DTS and SSIS including data extraction and transformation between multiple data sources (Oracle, MS Access, and MS Excel).
• Possessed excellent skills in Data Modeling to create Star and Snowflake Schemas for Data Warehousing developments, Data Migration and Application services. Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse and Data Mart databases.
• Experience in Creating and Deployment and Administration of SSIS and SSRS packages.
• Experienced in report generation using SQL Server Reporting Services (SSRS) and Excel spreadsheet lately using SQL Server 2012.
• Experience in generating drill down Reports, handling parametrized Reports in SSRS 2005.
• SQL Server 2005 OLAP Database Development including KPIs, Data mining, working with changing dimensions.
• Experience of Bulk Insert, BCP utilities and scripts for data transforming and loading.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Data Modeler with strong Conceptual and Logical Data Modeling skills, has experience with JAD sessions for requirements gathering, creating data mapping documents and queries.
• Experience with software development life cycle (SDLC) and project management methodologies.
• Excellent communication and interpersonal skills, self motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL,.Net(C#,VB)

SQL Server Tools: BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS, SSAS, Index Analyzer

Databases: SQL Server 2012/2008R 2/2008/2005/2000 , Crystal Reports, MS Access

Operating Systems: Windows Server 2008/2003/2000

ETL Tools: DTS, SSIS, BCP, Import/Export Wizard, BI Studio

OLAP Tools: SSAS, MS Excel

Reporting Tools: SSRS, MS Excel

Business Tools: Word, Excel, PowerPoint, Access, Outlook.

PROFESSIONAL EXPERIENCE

Confidential, Rhode Island

SQL Server SSIS/BI Developer

Responsibilities:

• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Access, MS Excel and Flat Files and Oracle databases.
• Designed and developed Complex SSIS packages for auditing using SQL SERVER 2008 Integration Services (SSIS 2012).
• Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit, and Data Conversion etc.
• Worked with different Control Flow elements like For Loop Container, For each Loop Container etc.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on the fly.
• Involved in Maintenance and Deployment of SSIS Packages.
• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).
• Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2008R2/2012
• Developing logical data models and physical database design and generating database schemas using Erwin 7.2.
• Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS 2012.
• Used Query Analyzer, Index Wizard, DB Engine Tuning and SQL Profiler for performance tuning.
• Excellent experience of managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
• Created Complex Stored Procedures and automated them using SQL Server Agent.
• Created Triggers (Instead Of and After) for Auditing Purpose.
• Created Views and Indexed Views for the Performance Tuning.
• Created automated T-SQL scripts to process summary database transactions that run off-hours.
• Involved in Creation of Crystal Reports, Created ODBC Connections and database Connections.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse. Developed data access layer using C# classes and ADO.NET.
• Created Linked Servers to retrieve data from other databases.
• Monitored and modified Performance using execution plans and Index Tuning.
• Involved in preparing detailed technical documents.
• Involved in code review and preparing unit test cases.

Environment: MS SQL Server Management Studio 2005/2008/2008 R2/2012, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS),MS SQL Server Reporting Services (SSRS), Crystal Reports, Microsoft Visual source Safe, SharePoint MOSS, Oracle9i, XML, ASP.Net, Windows 2003/2000.

Confidential, Charlotte, North Carolina

SQL Server SSRS/BI/ETL Developer

Responsibilities:

• Developed indexed views, complex stored procedures, CTE’s, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Monitoring execution plans to enhance the performance of the queries.
• Created complex SQL codes using Views, temporary tables, triggers and stored Procedures.
• Experience in Data warehouse such as dimensional modeling, Star/Snowflake schemas, Data marts, fact and dimension tables identification and OLAP.
• Heavily involved in developing logical data models and physical database design and generating database schemas using ER/Studio.
• Performed tuning of T-SQL procedures, triggers and other database objects.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Reviewed logical data model, physical data model, data mapping and ETL design
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Performed “pivot” operations on relational and data warehouse, dimensional and fact table for Business analyst.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2005 and develops unit test SSIS load processes for performance check.
• Writing SQL stored procedure in order to normalize the data & using within report application like SSRS, Crystal reports.
• Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2008/2005)
• Involved in migration and Conversion of Reports from SSRS 2005 to 2008.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.

Environment: SQL Server 2005/2008 Enterprise Edition, SQL BI Suite (SSIS, SSAS, SSRS), Enterprise manager, PPS, XML, MS PowerPoint, Crystal Reports, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Business Objects, SharePoint, MOSS 2007

Confidential, Newark, NJ

SQL Server SSIS/SSRS Developer

Responsibilities:

• Used highly complex TSQL queries and SQL Scripts to perform efficient data load based on complex business rules and produced results for users.
• Used SQL profiler and Execution Plan to view index performance and thereby eliminate table scan.
• Created stored procedures, views, triggers, user defined functions to incorporate the flow of business.
• Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on the fly
• Assisted project manager in project planning schedule for database module.
• Involved in upgrading the instance of development environment of SQL Server 2000 service to SQL Server 2005 with latest service pack.
• Extracted data fromOLTPtoOLAPusingSSISusing complex data transformations.
• Developed packages for getting data from SQL Server, Flat files and MS Access data of Sales, Returns and Employee.
• Developed the SQL Server Integration Services (SSIS) packages to transform data fromSQL 2000toMS SQL Server 2005as well as created interface stored procedures used inSSISto load/transform data to the database.
• Successfully created Snapshots Report, Report Subscription, Data Driven Subscription and Report caching using Report Manager
• DTS used to load data from extracts coming from Mainframe systems
• Worked with Dynamic SQL, and developed procedures utilizing the functionality.

Environment: MS SQL Server 2000/2005, DTS, MS Access, SQL Query Analyzer, MS SQL ServerIntegrated Services and MS SQL Server Reporting Services, Crystal Reports, TSQL, PL/SQL,SQL Profiler, Windows XP/ NT / 2000/2003, Microsoft Excel.

Confidential, San Antonio, TX

SQL Server Developer/SSAS/SSRS

Responsibilities:

• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008
• Involved in Performance tuning of ETL transformations, data validations and stored procedures
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, 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 cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS)
• Scheduled tasks to run every day to update changes in the base tables
• Designed and developed various types of reports using SSRS
• Responsible for Relational data modeling(OLTP) using MS Visio (Logical, Physical and Conceptual)
• Worked on formatting SSRS reports using the Global variables and expressions
• Created parameterized reports, Drill down and Drill through reports using SSRS
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications
• Published reports on to Share-Pointandcreated Web Parts in Share-Pointto show various reports generated fromExcel andSSRSin one Page.

Environment: Microsoft SQL Server 2005/2008, Windows Server 2003, Windows XP, Microsoft Visio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS).

Confidential, Chicago, IL

Database Developer/BI/ETL Developer

Responsibilities:

• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Migration of databases from MS SQL Server 7.0 to MS SQL Server 2000.
• Involved in Data modeling to develop the database design using Erwin 4.0
• Installation and configuration of MS SQL Server on Windows 2000/2003 Server.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Develop and maintain information systems using Microsoft SQL Server, SQL Reporting Services (SSRS), crystal Reports.
• Responsible for Relational data modeling(OLTP) using MS Visio (Logical, Physical and Conceptual)
• Scheduling transfer of backups and log files to different servers.
• Creation of schema objects, rules and granting of roles to the users.
• Testing and implementing Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans.

Environment: SQL Server 2000/2005, Oracle 9i, Query Analyzer, SQL Profiler, DTS, HTML, T-SQL, PL/SQL, Erwin 4.0, Windows Server 2000/2003, UNIX.