OBJECTIVE:

I wish to be part of a prospective organization which provides a professional and challenging environment for strengthening my technical and interpersonal skills and strive towards the development of organization and will use my expertise in this field with hard work, perseverance and dedication.

SUMMARY:

• Having 6+ years of Experience, knowledge and understanding of MS SQL and BI - SSIS/SSRS/SSAS Products.
• Involved in all the phases of software development life cycle (SDLC) process.
• Ability to write complex stored procedures/Cursors/Queries/views with complex joins and Functions.
• Triggers to facilitate efficient data manipulation, data integrity and other T- SQL (DDL, DML) statements.
• Performance tuning of Stored Procedures/T-SQL Queries using Clustered/Non-Clustered Indexes and efficient coding standards and using performance monitor/SQL Profiler to resolve Dead Locks/Long running queries.
• Demonstrated expertise in designing, developing and deploying BI solutions using SSIS, SSRS and SSAS.
• Highly experienced in whole cycle of SSIS using Visual Studio-2008/2010Developing, Deploying, Scheduling, Troubleshooting and monitoring for performing Data transfers/ETL Purposes across different servers.
• Experience in creating hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts.
• Experience on publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in power BI server.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.
• Developed complex SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Developed SSIS Packages for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) using Various Control Flow, Data Flow tasks, and Store Procedures .
• Good knowledge on Informatica .
• Excellent understanding of RDBs, Normalization, logical and physical data modeling for OLTP and OLAP.
• Experience in ER Modeling, Star/Snowflake Schema, Fact /Dimensional tables.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2008/2010 Analysis Services.
• Extensive experience in report generation using SSRS from both relational databases and OLAP cubes using Report Designer as well as Report Builder.
• Experience in generating Drill down reports, crystal Reports, Parameterized reports, Linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2008/2010.
• Worked on administration tasks such as data loading, batch jobs, data uploading, backup & recovery, Database mirroring, DB Normalization, Log shipping, Replication Services etc.,
• Experience in implementing SQL Server Security/DB permissions, creating roles& managing user permissions.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS:

Operating Systems: Windows XP, Windows Server 2008 R2/2012, Windows 2007/2010

Databases: SQL Server 2008R2/2012, Oracle 11g.

Languages: SQL, T-SQL, PL/SQL, XML, HTML.

ETL Tools: SQL Server 2008R2/2012 Integration Services (SSIS), Informatica Power Center, Power BI.

Reporting Tools: SQL Server 2008R2/2012 Reporting Services (SSRS).

Utilities: MS Office Suite

PROFESSIONAL EXPERIENCE:

Confidential,ANN ARBOR, Michigan

SQL Server Developer

• Involve in complete Software Development Lifecycle (SDLC).
• Analyze user requirements, functional and technical specifications, preparing test plans and write test cases.
• Create complex SQL stored procedures, Triggers, Functions, Views, Indexes in Microsoft SQL Server 2008 and 2012.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Creates appropriate documentation in work assignments such as technical documentation.
• Expertise in DW applications, directly responsible for the Extraction, Transformation and Loading of data directly from different heterogeneous source systems like flat files, Excel, Oracle, SQL Server, Sybase and SAP BW.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, and process SSAS cubes to store data to OLAP databases.
• Created Matrix, Drill-down and Sub-Reports in SSRS using different types of properties like Chart controls, filters, Interactive Sorting, SQL parameters etc. Deployed RDLs to Report Server (Share Point).
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Interacted with business users in collecting the requirements, solving issues and making changes as required.
• Managed indexes and optimized queries using execution plan.
• Involved in performance tuning of queries and SSIS packages which increases the performance and runs faster.
• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created ETL packages to get the data from XML raw files and used XSD files to convert the raw file to desired format.
• Created complex packages and performed the ETL to load the Dimension Tables in using SSIS.
• Implemented the concepts of incremental data load, Slowly Changing Dimensions for updating and maintaining the history of the records.
• Upgraded SSIS 2005 packages to 2008 packages.
• Involved in testing the performance of SSIS packages over different servers in collaboration with platform labs.
• Used Event Handlers to handle errors in the packages.
• Deployed the SSIS Packages from development server to production server.
• Used script task to produce HTML reports and mail using SSIS.
• Created SSRS reports by Report designer for the users and deployed onto the report server.
• Parameterized and cascaded reports are also used to make the reports interactive with the users.
• Supported multiple projects at a time.

Environment: Microsoft SQL Server- 2008/2010/2012, Visual Studio-2008/2010, T-SQL, Team Foundation Server, SQL Server Analysis/Integration and Reporting Services, Share Point 2010/2013.

Confidential, Los Angeles, CA

BI Developer

• Developed and Optimized Stored Procedures, Views, and User-Defined Functions, custom scripts and stored procedures for data import and manipulation.
• Developed Physical data models and created DML scripts to create database schema and database objects.
• Well versed with database concepts as well database design, writing SQL queries.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005 and latest 2012.
• Designing the efficient ETL process to transform and load data from various sources across the enterprise.
• Extracting, Transforming and Loading source data into respective target tables to build the required data marts.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Developing efficient SSIS packages for processing fact and dimension tables with efficient transformations.
• Responsible for Converting DTS Packages to SSIS-2008 Package
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects, and Implemented Incremental load, used Event Handlers to clean the data from different data sources.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Developed different kind of reports such a Drill-through and Drill-down, Sub Reports, Charts, Matrix reports, Linked reports.
• Migrated all SSRS Reports from Visual Studio 2005 to 2008/2010/2012 .
• BI Integration with SharePoint like Power View, Power Pivot and Power Query, Excel Service and Reporting service.
• Worked on Excel Sheet Macros, gave connections for MDX to create Power Pivot Reports.
• Creating and executing unit, functional and integrated testing.
• Good knowledge in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Good Knowledge on SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
• Configured replication servers and transactional replication between production & standby server for disaster recovery
• Good knowledge in calculating measures and dimension members using multi-dimensional expression (MDX).

Environment: MS SQL Server 2012/2008/2005/2000, DTS, Windows Server 2008, SSMS, SSRS, SSIS, SSAS, Report Builder 3.0, Report Model, Performance Point Server, MS-Visual Studio, XML.

Confidential

Senior Developer

• Extensively working in data Extraction, Transformation and Loading from source to target system using SQL Server 2012 Integration Services.
• Importing Source/Target tables from the respective databases by using Execute Package Task using Control Tasks in SQL Server 2012 Integration services.
• Created Transformations and Mappings using Data Flow Tasks.
• Used Control Flow Tasks like For Loop Container, Sequential Container, Execute Task, and Data Flow Task.
• Scheduled the ETL Package (Monthly) Using SQL Server 2012 Management Studio.
• Prepared Unit Test Specification Requirements.

Environment: SQL Server 2012 Integration Services, and Windows’ NT Server.

Confidential

Developer

• Identifying the business process requirements
• Creation of packages by using required transformations.
• Created and Deployed package successfully.
• Creation of reports in SSRS and scheduling Reports.
• Creation of Parameterized Reports in SSRS.
• Creation of Tabular, Matrix, and Chart type of Reports using SSRS.
• Creation of drill down, drill through reports in SSRS.
• Creation of database procedures to get the data for reports.
• Creation of Subscriptions, securities to the reports as per User Requirements.

Environment: SQL Server 2008 R2/2012, Active Reports, SSIS, SSRS, SSAS.

Confidential

Developer

• Understanding the traditional database of the client, creating appropriate dimensional tables and Fact tables for constructing Data warehouse.
• Creation of packages by using required transformations in SSIS.
• Created the mappings using transformations such as the Derived Column, Aggregate, Merge joins, Conditional Split, Lookup and Audit transformation.
• Managing SSIS applications deployment.
• Involved in creation of package configurations, check points and logging.
• Implemented SCD Type1 and Type2.
• Involved in creation of cube.
• Loading data into dimension tables and fact tables using SSIS packages.
• Used MDX queries getting the data from cube.
• Created Sub Reports, drill down reports based on the requirement.

Environment: SSIS, SSRS s& SSAS SQL SERVER 2008, Windows XP

Confidential

BI Developer

• Installation and configuration of SQL Server Reporting Services 2008.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.
• Involved in creating report models and applying row level security filters for report model.
• Developed Stored Procedures and Views to be used to supply the data to the reports.
• Complex formulas were implemented to get derived fields and format the data based on specific conditions.
• Experience in building reports through Report Builder and Report Designer.
• Experience in creating reports using Report Model and applying row level security filters.

Environment: SQL Server 2008, SSRS