SUMMARY:

Over 6.5 years of IT experience in Data warehousing & Business Intelligence. Strong knowledge in requirement gathering, analysis, estimations, designing, development, Implementation, production support and managing Static & Real time data warehouse systems. As a professional in a corporate environment, it is highly significant to provide the best possible customer experience to stay competitive. In this day and age of business, the customers are much smarter. As a result, it is essential to be detailed when working with our customers and I do believe that I have the drive and passion to work along with the customers and help them achieve their goals rather than just work for the customers.

TECHNICAL SKILLS:

Informatica Power Center 9.6.1

PL/SQL Programming

Team Leadership

Oracle SQL Developer

Datastage 7.5.1/9.1

Project ManagementOracle (11g/9i)

PROFESSIONAL EXPERIENCE:

Informatica Lead - Sales

Confidential, Dearborn, MI

Responsibilities:

• Analyzed the requirements, Prepared Mapping & Analysis document, Logical & Physical model, Prepared Design document, Developed Mapping to Load Dimensions and Fact tables from Sales Order Processing (OLTP System) as a source.
• Prepared detail technical design documents for all the requirements to ensure accuracy and completeness against the requirements and assign them to the team.
• Developed various robust mappings using mapping designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Sequence Generator Transformation.
• Created complex mapping which involved Slowly Changing Dimensions with a connected lookup transformations using dynamic cache.
• Monitored Workflows and Sessions using Workflow Monitor.

Senior Software Consultant - DW & BI Onsite Lead

Confidential, Lexington, MA

Responsibilities:

• Worked closely with business users/Stake Holders to understand business requirements and convert that to functional and technical specifications and get it signed off by the users.
• Prepared detail technical design document for all the enhancements to ensure accuracy and completeness against the business requirements and assign it to offshore team for detail code changes in the client/server applications according to enhancements.
• Designing ETL strategy from base table to DW objects and developing ETL mapping and transformations using PL/SQL Programming to load data from various sources like flat files, oracle database into target oracle 9i database and developed SQL scripting to execute the PL/SQL packages, developed UNIX Shell scripting to send and receive data from external systems via FTP process, for execution of Data stage jobs and SQL scripts and job scheduling via UC4 (Third party tool).
• Developing complex impromptu reports and ad-hoc reports for the users using Cognos Impromptu Admin and security implementation for reports, creating triggers/Events using Cognos Server Admin and stopping/restarting the cognos services, rebooting the cognos server, analyzing the clogged queues using Cognos Configuration Manager and deploying cognos catalog, Impromptu reports, Impromptu Web Reports (IWR) using Cognos Server Admin in production and developed windows batch processing for scheduling IWR Reports.
• As an Onsite lead, I have handled Project management activities like Planning, Estimating resources, Allocation of resource, Assigning tasks, tracking and reporting progress, Issues management and solving, Defect prevention, successfully delivered major projects, more than 3500+ bugs/enhancements for which I have been appreciated by client/director, preparing status reports, attending daily and weekly project meeting with customers, managers and onsite coordinates to update the status/challenges/risks and people management responsibilities like appraisals and Mentoring.
• Acquired initial 3 months of Knowledge Transition of all the PLG applications and effectively transferred it to offshore of 4-member team and received accolades from client, client directors, senior managers and managers.
• Provided 24x7 on-call production support for five critical applications, various types of ticket resolutions and answering all the user calls and clarifying their doubts and helping them to resolve the issues.
• Analyzing all the reported bugs/enhancements and preparing defect based effort estimation for completion of assigned tasks, assigning priorities for defects and tracking workflow based on the priorities in the defect systems.
• Analyzing and finding Root Cause for all the reported P1/P2 high priority issues thoroughly and performing resolutions and fix immediately in the production system once approved by change approval board and client.
• Preparing and executing thorough test plans and testing (unit, system, regression and user acceptance testing) in dev. /test environments and validation of data/jobs in production after deployment.
• Presenting all the pending changes and necessary documents to change approval board for implementation and versioning control, deploying all jobs/scripts/database objects into production via PVCS 3rd party tool.
• Scheduling daily offshore calls to explain about the issue/enhancements and resolving all the technical issues faced by the team during the development phase, reviewed their work and prepare it for UAT phase.
• Have provided recommendations for Development best practices and Performance Improvement
• Have been involved in in Unix Server migration and database migration.
• Have also provided value adds to the customers by automating most of the manual year end processing, manual analysis/fix done during night time production issues, restructuring of major reports, re-structuring of inefficient designs, performance tuning of long running packages and provided Innovative ideas to reduce the duration of daily batch jobs load from 8hrs to 5hrs. This value adds benefited customers with no manual interventions, reduced time and optimize cost for which I received HIGH FIVE award from customers.

Data Stage Consultant

Confidential

Responsibilities:

• As a consultant my duties was to understand existing design and provide suggestions for efficient design.
• Guide developers to use right data stage components, follow the best ETL strategies, best data warehousing/ETL practices and resolve the technical issues faced by the team.
• I was also involved in developing the ETL mapping and transformations using Data stage 9.1.

Project Lead/Team Player

Confidential

Responsibilities:

• My responsibility was to gather system and data requirements from Onsite Coordinators and design logical and physical dimensional models for the data warehouse in a star and snowflake schema using Erwin Data Modeler.
• I studied the existing Systems and analyzed mapping between the Vantive CRM Source System and SAP CRM Source System and prepared a thorough impact/ Confidential analysis documents on the current system.
• I have designed detail high level, low level technical design documents and ETL strategy from base table to data warehousing objects.
• I have developed ETL mapping and transformations using Ascential Data stage 7.5.1 to load data from various sources like flat files, oracle database into target oracle 8i database, Job sequencer for job flow, routines to re-set the dates in control tables and job scheduler to execute the batch jobs.
• Developed FTP jobs to receive and send data to external system.
• Developed framework models/packages for the users in Cognos 8 Framework Manager.
• As a project lead, managed 17 members team, explained all the requirements & design, delegate the tasks, helped in development to resolve all the technical issues, reviewed their work and delivered it to onsite.
• I have also prepared detail test cases and done thorough testing (Unit, System, and Regression and User acceptance) and validation of jobs/data after production move.
• I have coordinated with QA team to transfer the knowledge/requirements for QA testing.
• I have handled project management activities such as Planning, Estimating resources, Allocation of resource, Assigning tasks, tracking daily tasks, preparing status reports, attending daily and weekly project meeting with customers, managers and onsite coordinates to update the status, challenges and risks and people management responsibilities like appraisals and Mentoring to all 17 members.
• I have been awarded as a best performer in DW&BI Bangalore and received multiple times SCOPE award for best performer in project.

Performance Tuning Consultant

Confidential

Responsibilities:

• As a consultant my duty was to performance tune all the existing Stored Procedures and packages.
• Guided and helped developers to resolve all the technical issues faced during the development.
• I was also involved in developing ETL jobs using SQL SERVER 2005 Integration Services.

DW Team Member

Confidential

Responsibilities:

• My responsibilities were to understand the requirements and design for all the modules and prepare design documents.
• Analyze the source systems and mapping between the source system and TMC.
• Develop ETL jobs using SSIS to load data from various sources.
• Prepared test documents and done unit testing for all the various modules.
• Prepared reconciliation scripts, requirement traceability matrix and unit test cases.
• Automated unit test cases for all the modules.

Team Player/ Testing Lead

Confidential

Responsibilities:

• Performed unit, system, integration and regression testing by using SQL scripts and generate the test reports.
• I have prepared release notes for internal auditing.
• I have provided Value Ads to the customer by creating a testing tool called IBIS TESTING TOOL using Visual Basic which reduced day-to-day manual testing, time and cost.
• This tool was recognized and appreciated by the managers.