Sql Server Project

Summary:

• Overall *.* years of experience in Data warehousing & Data Migration Projects in Energy & Utilities domains.

• Involved in all phases of Software Development Life Cycle

• Have worked on large data warehouses & data migration projects

• Strong knowledge on Data Migration processes, tools & technologies

• Expertise in various DW tools that include SAP BODS, SAP Data Insight, SAP Business Objects, SAP-BW/BI, SAP Best Practices for Data Migration solution, IDE, IDQ and Informatica Powercenter, Legacy System Migration Workbench

• Experience on various databases including Oracle & SQL Server

• Excellent communication and analytical skills, self-motivated, ability to conceptualize, document and communicate project ideas and plans.

• Ability to work independently and manage teams with efficient, pro-active and agile development strategies

• Strong knowledge on Wipro Quality processes & LEAN methodologies

• Worked in various roles including Team Member, Team Lead, Internal Quality Coordinator, Technical Consultant & Technical Lead

• Knowledge on designing & implementing development architectures

• Knowledge on analyzing & reviewing infrastructure requirements for projects

• Knowledge on data warehousing tools & server administration

• Knowledge on effort estimations as per Wipro VelociQ techniques

• Strong Exposure in developing, tuning and designing ETL solutions using Business Objects Data Services & Informatica

• Strong IT experience in the areas of analysis, design, development and testing in ETL process, Oracle, PL/ SQL and Data warehousing concepts.

• Ability to work independently and manage teams with efficient, pro-active and agile development strategies.

• Excellent communication and analytical skills, self-motivated, ability to conceptualize, document and communicate project ideas and plans.

• Experience in writing UNIX shell scripts to schedule the jobs

Education:

MS in Software Engineering, Birla Institute of Technology & Science, Pilani

Technical Summary:

Data Warehousing Informatica Power Center 8.6

Informatica Data Quality (IDQ)

Informatica Data Explorer (IDE)

Business Objects Data Services

BO Data Insight

Business Objects Reporting

Legacy System Migration Workbench (LSMW)

Databases Oracle 9i, 10g, SQL Server 2005

GUI Visio

Tools ERwin, TOAD

ERP SAP ECC

DBMS Oracle 10g, PLSQL, SQL *PLUS, MS Access

Certifications:

• Informatica Certified Mapping Designer

• Microsoft Certified SQL Server2005 Professional

• Oracle Certified Oracle10g SQL Expert

Achievements:

• Received “Feather in My Cap” award twice for my best performance.

• Received “Star Performer of the Quarter” in BTS-ES

• Published white papers & Reusable components in Wipro on Informatica Powercenter coding standards

• Published a case study on Data Migration solution for one of the Europe’s largest Water utility provider, which made available in WIPRO.COM corporate website

• Registered expert for Oracle, SQL Server, Informatica, and Business Objects Data Services in Wipro’s internal expert’s forum.

Project Details:

US Foundation Programme – National Grid USA

Start Date: Jan-2011 End Date: Till Date

Role: Technical Lead Team Size: 30

Environment: SAP BO Data Services, SAP BO Data Insight, Oracle 10g, SQL Server, SAP ECC 6.0, SAP SRM 7.0, LSMW

Project Description: National Grid has undertaken US Foundation Program to transform and integrate back office business processes for US operations to SAP ECC6. As a part of this upgrade, legacy systems, PeopleSoft for legacy National Grid & Oracle for Keyspan Energy, will be merged into SAP.

Responsibilities: As a Technical Lead my responsibilities include:

- Analyzing the source system and business process using BPDs

- Identifying the requirement gaps

- Analyze and come up with the DM process & architecture approaches

- Designing & implementing the architecture

- Guiding the team in developing the Functional Specs & Technical Specs

- Reviewing the developed Functional specs & Technical specs

- Provide the server sizing requirements for Development & Quality Environment

- Setting up the DM landscape with all the required ETL environments

- Providing technical leadership to the team

- Guiding the team in design and development of the data conversion jobs in BODS

- Prepare checklists for various deliverables associated to various mile stones

- Analyze & review the data masking requirements and prepare the data masking scripts

- Developed the BODS jobs for GL Balances (Extract, Transform & Load into SAP)

- Profile the data using BO Data Insight for the key objects

- Developed the reusable solution for automated validation of SAP configuration with Value translation data and vice versa.

Plant BI – AES, USA

Start Date: Jul-2010 End Date: Jan-2011

Role: Technical Consultant Team Size: 8

Environment: Oracle 9i, SQL Server, SAP BI 7.0, BO Reports, Crystal Reports, BO XCelsius

Project Description: As part of Genesis Programme AES would like to have a one stop view of executive summary for its plant’s performance using the cutting edge BI technologies. To implement this plant performance view AES started a pilot project for one of its Power Generation plants in Huntington Beach, CA, where a dashboard was developed to know the performance of the plant in one go.

Responsibilities: As a Technical Consultant my responsibilities included:

- Analyze the source systems (Oracle & SQL Server based apps) and generating the logic to extract only the selected & required records.

- Data Modeling in SAP BI

- Creating the Info Objects, DSOs, Cubes, Multi Providers and BEx queries etc…

- Extracting and loading the data from source system into SAP BI

- Developing the transformations to consolidate the data and transform the data as per business requirements.

- Creating the process chains to extract the data from legacy and load data into SAP BI

- Creating the BEx queries and feed in the SAP Business Objects reports and SAP Crystal XCelsius dashboards.

Data Migration – Severn Trent Water, UK

Start Date: May-2009 End Date: Jun-2010

Role: Technical Lead Team Size: 20

Environment: SQL Server 2005, Informatica Powercenter, Informatica Data Quality, Informatica Data Explorer

Project Description: Severn Trent Water is one of the world's largest utility services provider, based out of UK. As part of the strategic initiatives, STW has decided to implement the SAP ERP solution in the organization. This project involved in transforming the data from Legacy systems to the format that is accepted by SAP. This was done in 2 releases with R1 being the back office applications and R2 being the front office applications.

Responsibilities: As a technical lead my responsibilities included:

- Designing & implementing the architecture and guiding in design & development of the project.

- Responsible for building the ETL and Database environments.

- Responsible for providing the technical leadership during crucial, early phases of a client initiative, focusing particularly on requirements gathering, technology selection, developing prototypes, proof of concepts and initial system design.

- Responsible for recommending appropriate tools at various phases of the project and for quality of design and deliverables.

- Responsible for setting up, supporting & administering the tools and controlling the access through security roles.

- Gather and analyze the feasibility of business requirements from customer.

- Responsible for providing the technical guidance & support to the team throughout the development process.

- Responsible for conducting various team meetings such as weekly team meetings, Look Ahead Meetings, Release plan meetings etc

- Coordinating with onsite team for any clarifications during the development of the scripts.

- Reviewing the deliverables by the team and providing review comments to ensure defect free deliverables.

- Identifying and resolving any issues in the development scripts by the team.

- Improve the performance of the scripts by finding out the bottle necks in the scripts and resolving the issues with them.

- Requirements gathering and analysis of the difficult and complex objects.

- Build the ETL scripts for critical & complex objects such as Task Lists & Maintenance Plans.

- Ensure proper data transformation and zero issues post data load.

- Responsible for tracking & reporting of the work from offshore and inform the management.

- Participate in change control board meetings.

- Do impact analysis for the architecture change requests.

- Ensure the compliance of the project for various organizational quality & security standards.

- Complete responsible for delivery of the qualitative and defect free work products from offshore.

DWOR+ – Thames Water Utilities, UK

Start Date: Aug-2008 End Date: May-2009

Role: Technical Specialist Team Size: 5

Environment: SQL Server 2005, Informatica Powercenter, MS Access, VB Macros, Business Objects Reporting,

Project Description: Daily Weekly Operational Reporting (DWOR+) application provides integrated reporting from different work management systems and reporting systems in Customer Services. The major functionality provided by DWOR+ is as follows:

- An integrated data mart for cross functional data with different granularity for operational and strategic decision making

- Automatic data extraction and loading from heterogeneous platforms

- Web based interface to capture the master data and summary data

- Web based Agent’s and Company’s performance report with drilldown

- Business Object Universe layer for BSC and Ad-hoc reporting

Responsibilities: As an ETL Specialist I was responsible for:

- Designing the ETL architectural solution and building the ETL environment.

- Responsible for developing, testing & deploying the ETL scripts for data loads into SQL Server database

- Have identified and Implemented the strategy to use Informatica’s inbuilt scheduler for data load batch processing

- Have identified and implemented the strategy for setting the dependency among the workflows in Informatica to maintain the data integrity through Event Wait and Event Raise mechanism.

- Have developed the macros to extract the data from MS Access database and generate the extracts.

- Have developed many key functions and stored procedures used to calculate various measures (KPIs) by taking data from a SQL Server 2005database and report them on the front end screens of the application.

BI Apps Support & Maintenance – Thames Water Utilities, UK

Start Date: Apr-2008 End Date: Aug-2008

Role: Team Lead Team Size: 8

Environment: Oracle, Cognos BI, SQL Server 2005, Informatica Powercenter, MS Access, VB Macros, Business Objects Reporting

Project Description: Thames Water Utilities is the Europe's largest clean water and wastewater Services Company, serving nearly 12 million domestic and commercial customers in London and Thames Valley. It also provides services like underground pipeline and networks, integrated waste management solutions, ground maintenance and facilities management.

As part of the service operations, there were many BI applications to support the day to day operations of the mid & senior management. The aim of the project is to support various BI applications and provide resolutions to the issues in those applications.

Responsibilities: As offshore team lead my responsibilities include:

- Providing the technical guidance to the team

- Identify and implement any enhancements in the existing systems

- Played a key role in developing & implementing the architectural solution for CM2NI, which was a sub project of ME & I systemization

- Responsible for coordinating the development, testing and implementation of the change from offshore.

- Responsible for identification of areas of improvement in the existing systems and provide solutions for the issues related to performance, availability of the systems.

- One such example of the activity is fine tuning the long running data load batches in ME & I Systemization and VIP.

- Responsible for planning & allocating the work to the team

- Tracking & reporting the status of the work to management and ensure the timely delivery of the tasks assigned to the team

- Responsible for support releases, such as ME & I Systemization support release and MAXIMO MIS support release.

- Was part of Change Control team for BI applications and responsible for doing the impact analysis of implementing various changes as per the business requirements and issue resolutions.

- Responsible for ensuring that change management process is being followed as per the organizational policies throughout the implementation.

- Responsible for coordinating with business user for any adhoc requests and issue resolutions.

BI Apps Support & Maintenance – Thames Water Utilities, UK

Start Date: May-2007 End Date: Apr-2008

Role: Team Member Team Size: 6

Environment: Oracle, Cognos BI, SQL Server 2005, Informatica Powercenter, MS Access, VB Macros, Business Objects Reporting

Project Description: Thames Water Utilities is the Europe's largest clean water and wastewater Services Company, serving nearly 12 million domestic and commercial customers in London and Thames Valley. It also provides services like underground pipeline and networks, integrated waste management solutions, ground maintenance and facilities management.

As part of the service operations, there were many BI applications to support the day to day operations of the mid & senior management. The aim of the project is to support various BI applications and provide resolutions to the issues in those applications.

Responsibilities: As a team member my responsibilities include:

- Supporting the BI applications including data loading and reporting

- Supported the applications like MAXIMO MIS which is the reporting solution for various above ground assets of Thames Water Utilities Ltd (TWUL)

- Implemented Location hierarchy changes

- Modification of BRIO, Cognos reports

- Supported Vistec information Processing system (also known as Reportsmart) which is the reporting solution for Thames Water’s below ground assets

- Involved in the modification of Business Objects reports, Health & availability of the application

- Modification of Informatica ETL scripts, Performance tuning of the jobs that load data into the warehouse

- Supported the ME & I systemization application which is the reporting solution built on above ground assets specially for Metering, Electrical & Instrumentation departments of TWUL

- Supported the application, Location hierarchy changes

- Modification of key Business objects reports (such as Technician Utilization report)which help the line managers and mid management

- Resolved the issues in the application through incident management and have followed the TWUL’s change management norms for all the change requests implemented

Contact this candidate