SUMMARY:

• Over 10 years of experience in Database Design, Development, Testing and Production Environments as a BI Developer.
• MSBI - SSIS, SSRS & Business Objects Developer, SQL Server, Oracle.
• Primary Skills: SSIS, SSRS, Business Objects, SQL Server, Oracle, ETL Testing.
• Good experience with data warehouse modelling of ER, 3NF, and Dimensional Star Schemas models for BI reporting.
• Experienced in the full life cycle (SDLC) of Data Warehouse - design and implementation, and ETL development and support
• Experience in ETL/Manual testing on Windows/Linux Environment. Experience in preparing/reviewing/executing Test cases, Defect logging/tracking/analysis as per the Functional Specification
• Good knowledge on Testing Life Cycle, Bug/Defect life cycle, Defect tracking and management.
• Good experience in development of T-SQL scripts, SSIS, SSRS, Business Objects, Stored Procedures, Triggers, Functions and Views for business logic implementation.
• Good knowledge with Netezza SQL
• Good experience of designing Star Schema and created Fact and Dimension tables for the Data Warehouse using Erwin.
• Good understanding and designing of Star and Snow Flakedata models Schema used in relational, dimensional and multidimensional data modelling.
• Experienced in migration projects like SQL server migration from 2008 to 2012/2014/2016 and SSIS packages from 2008 to 2012
• Good Logical, analytical, interpersonal skills and commitment to perform quality work as well as excellent team member.
• Development in MSBI (SSIS and SSRS), SAP Business Objects and Data Warehousing applications for Banking, retail, Recycling and insurance industries.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as Requirement Gathering, Development, Testing, Migration, Security management, Training and Support.
• Gathering functional requirements, Solution Design, Estimations, preparing technical specification documents, Design Specification documents review as per the project process.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, SQL Joins, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Ability to write complex Transact SQL (T-SQL) queries, Sub queries, Co-related and Non-correlated sub queries, Dynamic SQL queries etc.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.
• Highly experienced in complete cycle of SQL Server Integration Services (2005/2008/2012), Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
• Transformed data from one server to other servers using SQL Server Integration Services (SSIS) (2005/2008/2012).
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Created SSRS Reports
• Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.
• Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements
• Developed different type of reports by using SSRS and SQL Server 2008/2012.
• Experience in providing Logging, Error Handling by using event handlers and custom logging for SSIS Packages.
• Knowledge in creating complex drill down reports, parameterized reports, dropdowns and images, charts using SSRS 2005/2008 and SAP Business Objects XI 3.1, XIR2/6.5/6.1/5.1, BO 4.1.
• Experience in Business Intelligence tools like SAP Business Objects XI 3.1,XIR2/6.5/6.1/5.1 (CMC, CCM, Info view, Designer, Desktop Intelligence, Web Intelligence (RC), BOMM, BCA, and Supervisor), BO BI4.1 and ETL (Extraction, Transformation and Loading) solutions MSBI (SSIS).
• Proficient in design, development, deployment of SAP Business Objects Universes using Designer. Experience in performing administrative tasks using CMC, Info View, Broadcast Agent, and Supervisor. Extensively involved with creating new reports and supporting the existing reporting system using Web Intelligence and Desktop Intelligence.
• Proficient in designing and developing the ETL (Extraction Transformation and Loading) Packages by using Microsoft SQL Server Integration Services 2008/2012 (SSIS) and involved in migrating the ETL code from one Environment: to another environment.
• Experience in development of Business Objects & Web Intelligence reports from various sources Oracle 9i, SQL Server 2005/2008/2012/2014.
• Having good knowledge in using relational database like SQL Server 2005/2008/2012.
• Experience in Warehouse development and support, working with Data Migration, Data Conversion and Extraction/Transformation/Loading using MSBI (SSIS).
• Strong understanding of the SAP Business Objects and SSIS suite of Software and data warehouse/data mart concepts to build out both canned and ad-hoc reporting solutions.
• Experienced in interacting with business users to analyse the business process and requirements and transforming requirements into designing database, documenting and rolling out the deliverables.
• Proven ability and experience in creating complex financial business reports using Web Intelligence, Desktop Intelligence/Full Client Reports.
• Discuss with the business team to clarify the requirements to get clarity of certain business functionalities.
• Participate in the business team meetings to represent the offshore development team to help the business team with technical feasibility.
• Responsible for Production, customer issues resolution.
• Involved to develop the .Net Script in SSIS.
• Good at collaboration and interpersonal skills.
• Can work as individual as well as a team player.

TECHNICAL SKILLS:

Primary Skills: MSBI 2008/2012 (SSIS), SQL Server Reporting Service (SSRS), SAP Business Objects XI R3.1/4.1/R2/6.5/6.1/5.1and SQL Server 2008/2012/2014, Oracle 9i/8.x/10g,Netezza SQL.

Operating Systems: Windows /98/2000/2003/XP.

Languages: SQL, T-SQL, PLSQL,Netezza SQL.

Development Tools: MSBI SSIS Suite, SQL Server Reporting Service (SSRS), Web Intelligence, Desktop Intelligence, BOMM, QAWAAS, Web I Rich Client, Widgets, Designer, IDT, UDT and Tableau, Informatica.

Database Connectivity: ODBC or OLEDB.

Databases: SQL Server 2005/2008/2012/2014/2016 and Oracle 8i/9i/10g, Netezza SQL.

Domain Knowledge: Sales, banking and insurance, recycling.

Legacy Systems: Mainframes.

Testing Tools: Mantis Testing Tool, PVCS and TFS.

Configuration Management: CMC, Import Wizard.

PROFESSIONAL EXPERIENCE:

Confidential - Los Angeles, CA

MSBI (SSIS) with SQL Server & Business Objects

Responsibilities:

• Worked on complete Data Base including ETL & BO operations,Netezza SQL, SQL server operations.
• Extensively used ETL Components to Extract Data from Different Sources.
• Designing and development of SSIS packages to fetch data from different data sources.
• Implemented dimensional model (logical and physical) in the existing architecture.
• Conducted ETL development in the Netezza environment using standard design methodologies.
• Working on Development and training environments setup.
• Wrote MS Access Queries based on user’s request.
• Used Lookup’s and SCD’s to capture the CDC Data.
• Designed and implemented Dimensions and Measures according to business requirement.’
• Development of UNIT test cases and prepared technical specifications for SSIS packages.
• Implementation of CDC Techniques and applying standards like logging check points, and package configurations.
• Creation of source Queries at Analysis and Designing phase.
• Preparation of mapping documents and technical design documents based on client requirement specifications.
• Testing of reports for data validation at different levels and preparation of Test results document.
• Working on SSIS Packages Migration from Dev to UAT to Prod.
• Working in performance tuning and deployment phase.
• Ensuring quality, timeliness of the project deliverables.
• Creates technical specifications, test plans and test data to support ETL processes.
• Expert in cleansing data for data consistency whether the data source is a single system or multiple disparate sources
• Expert in Merge Join transformation, which can take two different inputs and merge them together by comparing a set of key columns, which performs different types of joins.
• Expert in SQL joins, sub queries, tracing and performance tuning for better running of DTS packages.
• Experience in Event Logging, Resource management, Log files, File and File Groups, Security, Backup and Recovery
• Used SSIS Packages for extracting, cleaning, transforming and loading data into data warehouse.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts
• Creation and maintenance of Business Objects Reports.
• Creation and maintenance of Business Objects Universes.
• Created sophisticated SQL Server database to responsively handle complex queries (triggers, stored procedures, views, functions) and .Net data access components.
• Discuss with the business team to clarify the requirements to get clarity of certain business functionalities.
• Participate in the business team meetings to get requirements.
• Responsible for Production, customer issues resolution.
• Experience in ETL/Manual testing on Windows/Linux Environment. Experience in preparing/reviewing/executing Test cases, Defect logging/tracking/analysis as per the Functional Specification
• Creation of use cases as per the functional specification
• Worked on Business Objects 4.1 including Designer(IDT&UDT), Web Intelligence, Info View, Web intelligence rich client and crystal reports
• Created reports using prompts/ combined queries, report level filters, alerters
• Created reports from multiple data providers
• Created drill and master/detail and linked reports

Environment: BO 4.1, MS BI (SSIS 2012), NetezzaSQL,SQL Server 2008/2012/2014, BO-SDK, Tarck-IT, TFS,zira

Confidential - Mayfield heights, OH

MSBI (SSIS) with SQL Server & Business Objects

Responsibilities:

• Single point of contact for complete Data Base including ETL & BO operations, SQL server operations.
• Extensively used ETL Components to Extract Data from Different Sources.
• Designing and development of SSIS packages to fetch data from different data sources.
• SQL server Upgrade from SQL 2008 from SQL Server 2016
• Implemented dimensional model (logical and physical) in the existing architecture.
• Working on Development and training environments setup.
• Wrote MS Access Queries based on user’s request.
• Used Lookup’s and SCD’s to capture the CDC Data.
• Designed and implemented Dimensions and Measures according to business requirement.’
• Development of UNIT test cases and prepared technical specifications for SSIS packages.
• Implementation of CDC Techniques and applying standards like logging check points, and package configurations.
• Creation of source Queries at Analysis and Designing phase.
• Preparation of mapping documents and technical design documents based on client requirement specifications.
• Testing of reports for data validation at different levels and preparation of Test results document.
• Working on SSIS Packages Migration from Dev to UAT to Prod.
• Working in performance tuning and deployment phase.
• Ensuring quality, timeliness of the project deliverables.
• Creates technical specifications, test plans and test data to support ETL processes.
• Expert in cleansing data for data consistency whether the data source is a single system or multiple disparate sources
• Expert in Merge Join transformation, which can take two different inputs and merge them together by comparing a set of key columns, which performs different types of joins.
• Expert in SQL joins, sub queries, tracing and performance tuning for better running of DTS packages.
• Experience in Event Logging, Resource management, Log files, File and File Groups, Security, Backup and Recovery
• Used SSIS Packages for extracting, cleaning, transforming and loading data into data warehouse.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts
• Creation and maintenance of Business Objects Reports.
• Creation and maintenance of Business Objects Universes.
• Created sophisticated SQL Server database to responsively handle complex queries (triggers, stored procedures, views, functions) and .Net data access components.
• Discuss with the business team to clarify the requirements to get clarity of certain business functionalities.
• Participate in the business team meetings to get requirements.
• Responsible for Production, customer issues resolution.
• Experience in ETL/Manual testing on Windows/Linux Environment. Experience in preparing/reviewing/executing Test cases, Defect logging/tracking/analysis as per the Functional Specification
• Creation of use cases as per the functional specification
• Worked on Business Objects XIR3 including Designer, Desktop Intelligence, Web Intelligence, Info View, Web intelligence rich client and crystal reports
• Created reports using prompts/ combined queries, report level filters, alerters
• Created reports from multiple data providers
• Created drill and master/detail and linked reports
• Worked on code migration from BO XIR3.1 to BO 4.1 and SSIS 2008 R2 to SSIS 2012

Environment: BO XI R3/4.1, MS BI (SSIS), SQL Server 2008/2012/2014/2016, Share point, BO-SDK, Tarck-IT, TFS

Confidential - Montpelier, VT

MSBI (SSIS, SSRS) & BO Senior Consultant

Responsibilities:

• Extensively used ETL Components to Extract Data from Different Sources.
• Designing and development of SSIS packages to fetch data from different data sources.
• Using Lookup’s and SCD’s to capture the CDC Data.
• Worked on Business Objects XIR3 including Designer, Desktop Intelligence, Web Intelligence, Info View, Web intelligence rich client and crystal reports
• Created reports using prompts/ combined queries, report level filters, alerters
• Created reports from multiple data providers
• Created drill and master/detail and linked reports
• Worked on code migration from BO XIR3.1 to BO 4.1
• Designed and implemented Dimensions and Measures according to business requirement.’
• Development of UNIT test cases and prepared technical specifications for SSIS packages.
• Implementation of CDC Techniques and applying standards like logging check points, and package configurations.
• Creation of source Queries at Analysis and Designing phase.
• Preparation of mapping documents and technical design documents based on client requirement specifications.
• Checking of PDF and excel views of reports for formatting issues.
• Testing of reports for data validation at different levels and preparation of Test results document.
• Helped Production team for SSIS Packages Migration from Dev to UAT to Prod.
• Worked in performance tuning and deployment phase.
• Worked in migration of SQL server migration from 2008 to 2012 and SSIS packages from 2008 to 2012
• Ensuring quality, timeliness of the project deliverables.
• Creates technical specifications, test plans and test data to support ETL processes.
• Expert in cleansing data for data consistency whether the data source is a single system or multiple disparate sources
• Expert in Merge Join transformation, which can take two different inputs and merge them together by comparing a set of key columns, which performs different types of joins.
• Experienced in DTS Package migration using Migration Wizard and manual upgrade.
• Expert in SQL joins, sub queries, tracing and performance tuning for better running of DTS packages.
• Experience in Event Logging, Resource management, Log files, File and File Groups, Security, Backup and Recovery
• Used SSIS Packages for extracting, cleaning, transforming and loading data into data warehouse.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts
• Understanding OLAP process for changing and maintaining the warehouse, optimizing dimensions, Hierarchies and adding the aggregations to the cube
• Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.
• Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements
• Developed different type of reports by using SSRS and SQL Server 2008/2012.
• Created sophisticated SQL Server database to responsively handle complex queries (triggers, stored procedures, views, functions) and .Net data access components.
• Discuss with the business team to clarify the requirements to get clarity of certain business functionalities.
• Participate in the business team meetings to represent the offshore development team to help the business team with technical feasibility.
• Responsible for Production, customer issues resolution
• Experience in ETL/Manual testing on Windows/Linux Environment. Experience in preparing/reviewing/executing Test cases, Defect logging/tracking/analysis as per the Functional Specification
• Creation of use cases as per the functional specification

Environment: BO XI R3, BO BI 4.1, MS BI (SSIS and SSRS), SQL Server 2008/2012, Biz-talk, BO-SDK, Mantis, PVCS.

Confidential

MSBI (SSIS, SSRS) & BO Team Lead

Responsibilities:

• Understanding of client business requirement and documentation of same
• Understanding of client business requirement and documentation of same
• Extensively used ETL Components to Extract Data from Different Sources
• Designing and development of SSIS packages to fetch data from different data sources
• Worked on Business Objects XIR3 including Designer, Desktop Intelligence, Web Intelligence, Info View, BOMM crawlers
• Creation of reports using prompts/ combined queries, report level filters, alerters
• Working on Test cases of SSIS Packages and Data cleansing.
• Using Lookup’s and SCD’s to capture the CDC Data.
• Development of UNIT test cases and prepared technical specifications for SSIS packages.
• Implementation of CDC Techniques and applying standards like logging check points, and package configurations.
• Creation of source Queries at Analysis and Designing phase.
• Preparation of mapping documents and technical design documents based on client requirement specifications.
• creating merged dimensions at report level by using multiple data providers
• Checking of PDF and excel views of reports for formatting issues
• Testing of reports for data validation at different levels and preparation of Test results document
• Universe and Reports Migration from Dev to UAT to Prod
• Worked in performance tuning and deployment phase.
• Ensuring quality, timeliness of the project deliverables
• Creation of BOMM crawlers on different databases, packages of SQL Server2008
• Scheduling of BOMM Crawlers
• Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.
• Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements
• Developed different type of reports by using SSRS and SQL Server 2008/2012.

Environment: MSBI (SSIS, SSRS), SQL Server 2008/2012, Biz-talk, BO-SDK, Mantis, PVCS.

Confidential

MSBI (SSIS) & BO Senior Systems Executive

Responsibilities:

• Worked on BOXI development and Production support for Confidential Security and Confidential Sensing
• Worked on Business Objects XIR 2 including Designer, Desktop Intelligence, Web Intelligence, CMC, CMS, Info View, Migration
• Developed and Maintained Universe as per the requirements
• Created reports using Universe and Excel as main data providers
• Created Cross Tab, Master Detail and Chart reports using Business Objects functionality’s like Combined Queries, Slice and Dice, Formulas, Drill-down analysis
• Migration of BO 5.1.8 Reports to BO XI R2 Reports
• Worked on Scheduling of Reports.
• Worked on Monitoring CMS servers.
• Worked on Universe and Report Migration from Dev to QA to Prod.
• Worked on Assigning the authorization to user depending on his role

Environment: Business Objects XI WebI, Business Objects5.1.8, Business Objects XIR2, Toad, BODI and Oracle Apps