SUMMARY

• Having more than 8 years of extensive IT experience in Data warehousing and worked on data warehousing tools Microsoft Business Intelligence (SSIS, SSRS, and SSAS). Mostly involving in Data Warehousing, which includes my contribution in the phases of Understanding the business requirement, and developing the ETL Process.
• One year experience in POWER BI.
• Good Experience on AGILE and SDLC Methodologies.
• Responsible for all activities related to the development, implementation, Conversion and Testing of ETL Process for large - scale data warehousing projects.
• Well equipped in performing ETL operations with DTS 2000, SSIS, SAP BODS, PDI,SAS DI.
• Good knowledge on SAS Data integration (ETL transformations, Change Management, Libraries).
• Worked with different data bases like Oracle, MYSQL, SQL Server, Cosmos DB & SAP HANA/BW.
• Involved in Administration tasks like Installation / Configuration / Up-gradation of versions of ETL components, User / User Groups, Data Profiling and Data Cleansing, Code Promotion / Version Management and usage of Metadata Reports to Document current data flows, design mappings for various sources/destinations of the data including data distribution and replication.
• Developed Slowly Changing Dimensions 1,2 to update and maintain history wherever necessary
• Well experienced in working on developing SSIS packages, SSRS Repots and SSAS Cubes on large-scale Data Warehouses.
• Excellent in designing SSIS packages and SSRS reports and Cube design in SSAS (also involved in security levels for SSIS packages, SSRS reports, Cube designs and also implemented logging).
• Experience on Creating stored procedures and views and CDC and TDE.
• Good at Developing SQL Server Integration service (SSIS) packages with all the Data flow, control flow tasks.
• Developed various packages using AGGREGATE, MERGE JOIN, PIVOT, DERIVED COLUMN, DATA CONVERSION, LOOKUP, MERGE, SORT, MULTICAST, UNION, CONDITIONAL SPLIT, SCD (Slowly Changing Dimension).
• Created Event Handlers to Handling Errors and Debugging for the Packages.
• Creating jobs for scheduling the SSIS catalogs.
• Using SQL Server Reporting Services (SSRS) developed Custom Reports, Tabular, Matrix, indicator, Ad hoc reports, distributed reports in multiple formats, drill down reports, parameterized reports, Matrix report, Cascaded reports and creating stylish report layouts.
• Expert in identifying KPIs and defining referenced relationships, analyzing data intensively, creating and modifying Cubes, Dimensions, Designing, Building the Dimensions, Cubes with Star Schema / Snow Flake Schemas, writing MDX Query, Calculated members and KPI’s using SQL Server analytical services (SSAS).
• Experienced in writing SQL query/Stored Procedure/ user defined functions and involved in query fine tuning for performance improvements.
• Expert in designing, migration, maintenance & tuning various RDBMS such as SQL Server. Proficient at Performance Tuning with a solid knowledge of Optimizing Code.
• Having working knowledge ETL Testing.
• Good knowledge on Data modeling (dimensional & Relational) concepts like Star-Schema modeling, Snow Flake modeling, fact and dimensional tables
• Very good Team player with interpersonal communication skills
• Good academic and professional career.
• Experience in various domains (Sales, Insurance, research, Survey Programming, Auto Mobile, Banking).
• Experience in Research and Insurance domain (Automobile survey for Confidential, CATI and mystery surveys) with Confidential client.
• As a Production Support Analyst worked in the team to handle Operations task like taking backups, managing password changes, handling alerts, managing Services and SQL jobs and deployment of applications
• Have been part of modules related to Manual Testing of applications after deployment and patching of applications. Primary tasks included Smoke testing the application and check for issues like connectivity and integrity of the applications. It included reporting Bugs and defects based on their priority and severity which might be taken up in the next releases.
• Involved in POC for new clients Confidential, Shoppers Stop, and Invendis using SSIS, 1 Key Agile.
• Attended various trainings (Informatica, Cognos 10,1 Key Agile, Informatica ILM,SAP BODS,SAS DI)

TECHNICAL SKILLS

ETL Technologies: SSIS 2000,2008 R2,2012,DTS and Pentao Data integration, SAP BODS 4.0,4.2

BI: SSRS,SAP BO,Cognos,1 Key Agile

Programming: JavaScript, SQL, HTML, UNIX

Architecture & Design: Star Schema, Snowflake schema, Dimensional Modeling

Databases: SQL Server 2005, 2008 R2, 2012, MS Access, MYSQL, Oracle 10G

Tools: Tortoises, Subversion, Microsoft Visio, Microsoft Visual Studio.NET, SQL Workbench, Third Party tools for SQL Server,Team foundation server, Quality Center, Microsoft Lync, Toad, SSMS

Scheduling Tools: Autosys, SQL Agent, TWS( Tivoli Work Scheduler),TIDAL

Operating System: Windows XP/7

PROFESSIONAL EXPERIENCE

Requirement Gathering, Design, Develop - Senior MSBI Developer

Confidential, Illinois Chicago

Responsibilities:

• Involved in various stages ofagile methodologies like gathering User requirement and System Specification. System Analysis, Design, Development, Testing and Implementation
• Designed the ETL processes using Data Integrator to load data from multiple databases like SQL Server, and Flat Files (Fixed Width) to staging database and from staging to the target Data Warehouse.
• Created metadata driven solution for ETL.
• Developed Source to Target Mapping as per the requirements
• Installed SQL Server 2008R2 with the latest service packs.
• Migrated Database from SQL Server 2008 to 2008R2 by using side by side migration.
• Created tables, indexes and designing constraints.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse and also implemented SCD TYPE 1,II
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Enhanced and deploying the SSIS Packages from development server to production server.
• Wrote stored procedures for report generation in SQL Server2008R2.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Administrated the created Reports by assigning permission to the valid user for executing the reports. Rendered reports, managed subscriptions, created reports with report builder, report snapshot and report Cache.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012
• Created and Maintained Database Maintenance Plans.
• Strong team player and self-motivated
• Coding & Debugging, Sorting out their time-to-time technical problems
• Tuned performance for large data files by increasing block size, cache size and target based commit interval

Requirement Gathering, Design, SSIS and SSRS Developer

Confidential, Mt Laurel, New jersey

Responsibilities:

• Interacted with Business team for gathering, and understanding the client requirements to design the ETL Packages
• Developed Source to Target Mapping as per the requirements
• Actively participated in the Installation& configuration of ETL in Development & Production Server
• Experienced in MSBI Installation with Oracle, SQL Server Databases
• Involved in Administration of ETL Services.
• Migration of all SQL based data sources to Cosmos (big data platform) to enable campaign creation via tool.
• Development of SSIS packages, stored procedures and jobs for creating a pipe between cosmos and SQL.
• Created ETL Data Flows for dimension and fact tables and loaded the data into legacy targets in Enterprise Data Warehouse and other systems
• Tuned performance for large data files by increasing block size, cache size and implemented performance tuning logic on sources, control flows, and data flows.
• Created Packages for Transaction processing using containers as For Each Loop, Sequence & controlling flow of data using tasks as Script, Data Flow, File System, Execute Package, Execute Process.
• Created Reusable packages having modular structure which can be reused in other packages.

Analysis and Design, ETL Developer, ADMIN

Confidential

Responsibilities:

• Involved in various stages ofagile methodologies like gathering User requirement and System Specification. System Analysis, Design, Development, Testing and Implementation
• Designed the ETL processes using Data Integrator to load data from multiple databases like Oracle, My SQL, and XML, Flat Files (Fixed Width) to staging database and from staging to the target Data Warehouse.
• Involved in logical and physical data modeling, database design, star schema, data analysis.
• Designed, developed and deployed Business Intelligence solutions using SSIS, SSRS and SSAS
• Used Dimensional Modeling Techniques to identify parameters necessary to create Dimensions and Fact tables.
• Built efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions
• Analyzed all tables and created various indexes to enhance query performance.
• Involving in CR's (Change Request) Issues and resolving them in an estimated time period.
• Extracting Data from different sources like SAP ECC6.0 and flat files and loading them into requested target flat files, excel sheets, Oracle Tables.
• Created and maintained databases, tables, views, users, logins, Indexes, check constraints, and business rules using T-SQL.
• Designed and maintained complex stored Procedures using Joins and Sub queries and to retrieve data from multiple tables

Analysis and Design, Data warehousing Consultant

Confidential

Responsibilities:

• Worked with Business analysts, SMEs and Business Users to understand Business process and Collaborated with business technicians to research existing business, system processes and functional requirements for modifying job
• Created Repositories, Users & assigned the security in the Multi-Team Environment
• Responsible for day to day operations and technical deployment to ensure solution is in compliance with quality and regulations, meeting user's requirements, and applying standards and best practices where appropriate
• Design, develop, and implement user-facing data repositories, i.e. data marts, and related semantic layer (SSRS Report Models, SSAS models/cubes, etc.). Support end-users in the development of reports and data extracts.
• Work with business requirements to identify and understand source systems, design, develop, implement and support ETL applications (SSIS packages) in support of Data Warehousing/BI/reporting functions and data interfaces between operational systems.
• Stay current with industry best practices and technical developments as it relates to data, reporting, and Business Intelligence (BI).

ETL Developer

Confidential

Responsibilities:

• Interacted with Business team for gathering, and understanding the client requirements to design the ETL Jobs.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Designed and deployed various SSIS packages to import the data coming from the different department data source and heterogeneous outsource database and applying various transformations on it so as to modify the data into a usable format for further applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Developed and distributed Tabular Reports, Matrix Reports, and Drill down reports and Ad hoc reports using SQL Server Reporting Services (SSRS)
• Prepared Unit Test Cases and Review Log.

PENTAHO ETL Developer

Confidential, Farmington Hills, MI

Responsibilities:

• Analyzing the existing system and understanding the requirement documents.
• Creating staging area according to the input file layout, proposed in design.
• Creating Pentaho transformations to load data from files to Staging, staging to DW tables.
• Understanding and analyzing the code, accordingly Developed Jobs and Sequencers.
• Developed complex Java transformation as a part Business rules Validation.
• Involved in Defects fixing during the IT Phase
• Developed Jobs & Transformations & Logs as per customer Requirement.
• Created different kinds of Logs for identifying errors & status of transformations
• Created scheduled jobs for batch process jobs for running the jobs & transformations
• Interacting with client on a daily status call & weekly status calls and Detailed Requirements Study

Confidential

Responsibilities:

• Interact with the client to understand the requirements.
• Involved in gathering the business requirements.
• Designing, creating, deploying and rendering sales reports, dashboards and other domain reports using 1 KEY AGILE
• Created best practices, guidelines for obfuscating data while moving data from production to dev and test environments.
• Designing, implementing and rendering dashboards, charts and other reports using SSRS.
• Creation of Views, Cursors, SP, User-defined Functions according to the User requirements
• Troubleshooting and recommended best practices performance issues in production systems
• Hands on experience in creating reports using Conditional blocks.

ETL Developer

Confidential

Responsibilities:

• Understanding the Business and its Requirements.
• Involving in creating packages in SSIS Designer using various Control Flow Tasks and Data Flow Transformations to implement Business Rules.
• Involving in designing, coding, testing of the SSIS Packages.
• Involving in creating various Drill Down, Drill Through reports and Sub-Reports using SSRS as per business requirements.
• Involved in developing report model for business users.
• Involved in creating a cube and deploying a cube with SSAS.

MSBI Developer

Confidential

Responsibilities:

• Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Union all and Execute SQL Task to load data into Database.
• Creating database-consolidating data and Loading into live database using SSIS.
• Unit tested the packages.
• Scheduling the jobs to send the reports.
• Strong experience Creating SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems (SQL Server) and scheduled Jobs to call the packages and Stored Procedures.
• Wrote T-SQL queries, Store Procedures and used them to build packages and reports.
• Involved in maintaining the Database Backups for the team using SQL lite speed backups, database performance tuning, using migration methodologies for improvement.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.

MSBI Developer

Confidential

Responsibilities:

• Involved in Attaching and Restoring the Database.
• Created Tables, Views, Indexes.
• Involved in writing the stored Procedures and Functions.
• Designing database for the new module.
• Inserting data from various sources to the required tables in the database and data mart through SSIS packages.
• Created SSIS packages to migrate data from different data sources to data warehouse.
• Successfully extracted transformed and load data into data warehouse.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
• Involved in enhancing and deploying the SSIS Packages from development server to production server.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server.
• Wrote Parameterized Queries for generating reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.