Anji Botha

Phone: 647-***-**** E-Mail: acsrfb@r.postjobfree.com

Summary: Has 11+ years of experience delivering enterprise software solutions including IT project / program management consulting. Has steered several large-scale IT engagements through diverse technology platforms and information architectures, integrating business-driven decisions with systems engineering to align people, processes, and technology with the overall program goals. Takes an integrated / holistic view of the enterprise architecture, IT infrastructure and business needs to create actionable roadmaps and implement solutions, enabling organizational change.

Lead a Team and assigned Project resources and estimated funds required between On-Site and Off-Shore teams, assembling project plans and teamwork assignments, directing and monitoring work efforts on a daily basis, identifying resource needs, performing quality review; and escalating functional, quality, timeline issues appropriately.

Responsible for managing one or more cross-functional projects of medium to high complexity and overall coordination, status reporting and stability of project oriented work efforts, Provide best practices and procedures to improve quality of deliverables and efficiency of development team.

Assisted Program Manager(s) in partnering with senior management of the business community to identify and prioritize opportunities for utilizing IT to achieve the goals of the enterprise.

Established and implemented project management processes and methodologies for the IT community to ensure projects are delivered on time, within budget, adhere to high quality standards and meet customer expectations.

Proponent of agile SDLC practices, value-based prioritization of scope of work (quick wins), tool-based requirements management / change control, iterative and test-driven development approach, source / version control, release management with continuous integration for incremental builds (unit testing, coverage reports…), framework-based application architecture (for common components: security, logging, exception handling, object-relational mapping, user interface, etc.), adherence to coding standards and guidelines (static code analysis), traceability of requirements, peer code reviews, risk management and issue / defect tracking.

Proficient in preparing a Project Charter which is a statement of the scope, objectives and participants in a project and is a critical document to ensure that everyone involved in the project is aware of its purpose and objectives.

Experienced in Project governance which is the framework which ensures that the project has been correctly conceived and is being executed in accordance with best project management practice and within the wider framework of the University's governance processes

Experience with infrastructure capacity planning and sizing, and virtualization for increased server utilization rates and cost reduction (HW / SW).

Sound Knowledge of Dimensional Modeling using Star schema and Snow Flake schema for faster, effective query processing and Business Analysis Requirements.

Proven experience in complete life cycle of Design, Maintenance and Documentation of Data Marts.

Strong business understanding of Banking Financial, Telecommunication, Pharmaceutical, Manufacturing and Service oriented industries.

Professional Experience

Employer: Cognizant Technology Services

Client: First Data, Coral Springs, FL May 2014 Oct 2014

Project Manager

Focused on IDS DSS Project Management in Migrating and Upgrading the IT Infrastructure of AIX UNIX Servers, DB2 Databases, Informatica Application and SAP Business Objects which are used to transform the data that is extracted from various source like Flat files, COBOL Files, SAS Files and Mainframe Files to load dimension and fact tables. DB2 is used as the target database. This warehouse is to generate reports and analyze the sales of various products. The later phases of the Data Warehouse life cycle that mostly involved using SAP Business Objects 4.1

Responsibilities:

Responsible for Business meeting, conversion of business rules into technical specifications, Helped get Estimated Hours in preparation of the PEG.

Arranged Team meetings and make sure appropriate projects are charged with working hours spend and Production Support hours are charged into Production Support Buckets.

Prepared Project Charter which is a statement of the scope, objectives and participants in a project and is a critical document to ensure that everyone involved in the project is aware of its purpose and objectives.

Made every effort to be as accurate and complete in our project estimates as possible. If it is necessary to go beyond the time allocated then notify the team in advance as the time approaches.

Worked on Project planning as part of project management, which relates to the use of schedules such as Gantt charts to plan and subsequently report progress within the project environment. Initially, the project scope is defined and the appropriate methods for completing the project are determined.

Gathered the project requirements statement defining the capability and performance that the project will provide. The requirements are used to guide the design of specific project deliverables, and to assess whether those deliverables are satisfactory for the intended purpose. The project requirements describing what is needed; the deliverables are how that is accomplished; and the outcomes describe why the project is worthwhile

Prepared the project status report is the project manager's billboard to the world as far as how things are going on his project. Started clean at the beginning of the project, full of optimism predicting the future of the engagement and indicating what's coming up in the coming days and weeks.

Worked on Project risk analysis is concerned with the assessment of the risks and uncertainties that threaten a project. Project risk analysis has a broad range of applications, just as the definition of a project is broad.

Worked on Issue log which is a term used to cover any concern, query, and Request for Change, suggestion or Off- Specification raised during the project. They can be about anything to do with the project.

Engaged the client to institute a data governance / stewardship model, with careful consideration to the change management / organizational design aspects, to guide the data quality and MDM initiative.

Architected solutions that promoted the utilization of Data Flux from a latent data cleansing tool to a full-fledged enterprise platform, exposing real-time data matching, data standardization, and CASS certification services.

Gained consensus with the Data Governance committee on the record sub-setting / survivorship process to maintain the Customer Master data.

Engaged in planning and architecting the migration of the National Sales Support application (a custom-built Oracle Forms application that provides CRM functionality and tracking of telemarketing activity) to Salesforce utilizing InsideSales.com.

Facilitated client meetings to report on the progress of projects, risks, and issues, and to explore risk mitigation and issue resolution strategies.

Tailored the development methodology and team commitments to the specific project needs.

Helped the client better understand the root cause of their problems to ensure well-scoped statements of work for solutions from other vendors.

Increased offshore staff leverage as part of resource planning and staffing.

Installed and Maintained Informatica Power Center and Power Exchange and Meta Data Manager/Data Integration Services for Data Quality 9.6 Server through Informatica Administrator. Applied Hotfix’s.

Employer: Cognizant Technology Services

Client: JP Morgan CHASE, Columbus OH April2011 April 2014

Project Manager/Project Lead

Managed Projects in Integrated Consumer Data Warehouse (ICDW) as part of Project Management team. Which includes Managing projects which are using Informatica to transform the data that is extracted from various source like Flat files, COBOL Files, SAS Files and Mainframe Files to load dimension and fact tables. TERADATA used as the target database. This warehouse is to generate reports and analyze the sales of various products. The later phases of the Data Warehouse life cycle that mostly involved using OLAP tools, especially COGNOS Impromptu & Power play. Data is Fork lifted from Existing Enterprise Data Warehouse (EDW) built on DB2 using Abnitio. Various Data Marts are re-built in ICDW. Reporting Customized many reports using COGNOS Impromptu reporting functionality such as slice and dice, drill down, Prompts, sorting and filter for full reports

Responsibilities:

Worked on Project planning as part of project management, which relates to the use of schedules such as Gantt charts to plan and subsequently report progress within the project environment. Initially, the project scope is defined and the appropriate methods for completing the project are determined.

Evaluated data conversion, data integration, and change data capture approaches and recommended changes to minimize risk.

Communicated technical decisions, issues, risks, constraints, and architectural imperatives to the leadership team, usually by utilizing visual aids.

Consulted EDW’s Information Security team to establish policies and procedures based on NIST guidelines.

Engaged qualified SMEs to evaluate IVR solution against the RFP / acceptance criteria and recommended improvements.

Reviewed the technical architecture and design of UI Separation Information Data Exchange System (SIDES) to estimate integration effort.

Evaluated legacy application modernization options to address immediate operational needs, which were ultimately enabled through a non-invasive solution involving wrappers, MQ Bridge, screen scraping and service interfaces; minimizing modifications to the core business logic.

Gathered the project requirements statement defining the capability and performance that the project will provide. The requirements are used to guide the design of specific project deliverables, and to assess whether those deliverables are satisfactory for the intended purpose. The project requirements describing what is needed; the deliverables are how that is accomplished; and the outcomes describe why the project is worthwhile

Prepared the project status report is the project manager's billboard to the world as far as how things are going on his project. Started clean at the beginning of the project, full of optimism predicting the future of the engagement and indicating what's coming up in the coming days and weeks.

Responsible for Business meeting, conversion of business rules into technical specifications, Helped get Estimated Hours in preparation of the PEG.

Worked on Project risk analysis is concerned with the assessment of the risks and uncertainties that threaten a project. Project risk analysis has a broad range of applications, just as the definition of a project is broad.

Worked on Issue log which is a term used to cover any concern, query, and Request for Change, suggestion or Off- Specification raised during the project. They can be about anything to do with the project.

Arranged Team meetings and make sure appropriate projects are charged with working hours spend and Production Support hours are charged into Production Support Buckets.

Installed and Maintained Informatica Power Center and Power Exchange and Meta Data Manager/Data Integration Services for Data Quality 9.1 HF3/HF4 Server through Informatica Administrator. Applied Hotfix’s.

Employer: Formally RCI now owned by Wyndham

Wyndham Exchange Rentals, Indianapolis, IN August 2008 –April 2011

Project Lead & Lead ETL Administrator/Developer

Played Lead role in Data Warehouse department as Project manager and Managed a team of Administrators and Developers who are using Informatica Power Center to transform the data that is extracted from various source like Oracle, MS SQL Server, IBM DB2, Flat files and XML to load dimension and fact tables. DB2 was used as the target database. This warehouse is to generate reports and analyze the sales of various products. The later phases of the Data Warehouse life cycle that mostly involved using OLAP tools, especially COGNOS Impromptu & Power play. Individual Data Marts were developed for all the kinds of applications and user bases. Reporting Customized many reports using COGNOS Impromptu reporting functionality such as slice and dice, drill down, Prompts, sorting and filter for full reports

Environment/Tools:

Informatica Power Center 8.6.1 HF 11, Cognos 7.1, DB2 UDB, Oracle 10g RAC, Teradata v2 r5.1, PL/SQL, Erwin, AIX-UNIX shell scripts, Windows, SQL, SQL*Loader, TOAD, Autosys.

Responsibilities:

Lead Team of size 14+ with more than 6+ projects being developed at the same time. Co-Ordination between On-Site and Off-Shore teams and 24Hours development mode for PRD Support.

Responsible for Business meeting, conversion of business rules into technical specifications, Helped get Estimated Hours in preparation of the PEG.

Arranged Team meetings and make sure appropriate projects are charged with working hours spend and Production Support hours are charged into Production Support Buckets.

Installed and Maintained Informatica Power Center and Power Exchange and Meta Data Manager 8.1.1/8.6.1/9.1 Server through Informatica Administrator. Applied Hotfix’s.

Proficient in configuring and administering LDAP Configurations into Informatica Application and manage Group/User Privilages.

Extensive experience in implementing and architecting informatica Power Center and Power Exchange on multiple nodes in same domain formed as a Grid. Power Center Integration Servers are run on two nodes and Power Center Repository is run on Single node with a fail over node.

Installed and configured Informatica Power Center and Power Exchange Server/Client on Windows Platform Servers/Machines.

Configured Power Exchange 8.6.1 to extract data from Oracle Logminer.

Worked extensively on Disaster Recovery(DR), also worked with VMWare to share the file system between the servers(nodes) and maintain the server uptime.

Created Power Exchange Logger groups, and configured Power Exchange to store data in Logger Groups.

Worked -extensively on DB2/IMS/Oracle/SQL Server Batch/CDC Source Mappings/Workflows.

Used ERWIN Tools Extensively for Data Modeling and Table Structure Desing.

Used Informatica Power Center for extracting Source data and loading into target table

Created complex mappings using Mapplets Designer to reuse Mapplets in the mappings, Mapping Parameters and Mapping Variables to use globally

Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor

Developed transformation logic and designed various Complex Mappings and Mapplets using the Designer

Worked on various transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy and Stored Procedure

Employer: Corporate Computer Services (CCS)

Client: Foremost Insurance Group, Grand Rapids, MI March 2007 – Jully 2008

A Part of Farmers Insurance

Project Lead & Lead ETL Administrator/Developer/Architect

Foremost Insurance Group. Developed a Atomic Data Warehouse using Informatica Power Center to transform the data that is extracted from various source like IBM DB2, Flat files and XML to load dimension and fact tables. DB2 was used as the target database. This warehouse is to generate reports and analyze the Data. The later phases of the Data Warehouse life cycle that mostly involved using OLAP tools, especially Business Objects XI. Individual Data Marts were developed for all the kinds of applications and user bases. Customized Reporting were done using Web Business Object using functionality such as slice and dice, drill down, Prompts, sorting and filter for full reports.

Environment/Tools:

Informatica Power Center 8.1.1, Business Objects XI, DB2 UDB, Erwin, AIX-UNIX shell scripts, Windows NT, DB2 Control Center.

Responsibilities:

Lead Team of size 6+ with more than 6+ projects being developed at the same time. Co-Ordination between On-Site and Off-Shore teams and 24Hours development mode for PRD Support.

Installed and Maintained Informatica Power Center and Power Exchange and Meta Data Manager 8.1.1/8.6.1 Server through Informatica Administrator. Applied Hotfix’s.

Used Informatica Power Center for extracting Source data and loading into target table

Created complex mappings using reusable Mapplets, Mapping Parameters and Mapping Variables to use globally

Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor

Developed transformation logic and designed various Complex Mappings and Mapplets using the Designer.

Worked extensively on XML Sources as part of ETL Mappings.

Worked on various transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy and Stored Procedure

Managed user groups, users and the associated privileges

Extensively worked with the Informatica server that runs on UNIX platform and used Workflow Monitor to monitor the Informatica server and reviewed Logs that are generates for each session when it runs.

Configured and ran the Debugger from within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow

Configured and used FTP by the Informatica Server to access source files

Worked with pmcmd command line program to talk with the Informatica server

Extensively used TOAD to test, debug SQL and PL/SQL Scripts, packages, procedures, triggers, and functions.

Involved in the preparation of documentation for ETL standards, procedures and naming conventions.

For better performance created Partitions, SQL Over ride in source qualifier

Used session partitions, Dynamic cache memory and index caches for improving performance of Informatica server

Organized data in reports using Filters, Sorting and Ranking data with alerts

Developed and generated customized reports using Business Objects XI by querying on the Data Warehouse.

Employer: GR89 InfoServices Private Limited

Client: Sterling Commerce Inc, Columbus, Ohio Jan 2006 – Feb 2007

An AT&T company

Data Warehouse Architect /Lead ETL Developer

Sterling Commerce Inc. Developed a Data Warehouse using Informatica Power Center to transform the data that is extracted from various source like Oracle, MS SQL Server, IBM DB2, Flat files and XML to load dimension and fact tables. DB2 was used as the target database. This warehouse is to generate reports and analyze the sales of various products. The later phases of the Data Warehouse life cycle that mostly involved using OLAP tools, especially COGNOS Impromptu & Power play. Individual Data Marts were developed for all the kinds of applications and user bases. Reporting Customized many reports using COGNOS Impromptu reporting functionality such as slice and dice, drill down, Prompts, sorting and filter for full reports

Environment/Tools:

Informatica Power Center 7.1.3, Cognos 7.1, DB2 UDB, Oracle 10g, Teradata v2 r5.1, PL/SQL, Erwin, AIX-UNIX shell scripts, Windows, SQL, SQL*Loader, TOAD, Control M.

Responsibilities:

Lead Team of size 4+ with more than 6+ projects being developed at the same time. Co-Ordination between On-Site and Off-Shore teams and 24Hours development mode for PRD Support.

Worked extensively on DB2/IMS/Oracle CDC Sourced Mappings/Workflows.

Used Informatica Power Center for extracting Source data and loading into target table

Created complex mappings using Mapplets Designer to reuse Mapplets in the mappings, Mapping Parameters and Mapping Variables to use globally

Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor

Developed transformation logic and designed various Complex Mappings and Mapplets using the Designer

Used Control M for scheduling purpose

Worked on various transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy and Stored Procedure

Worked extensively on SQL Loader to get the data extracted from SQL Server

Managed user groups, users and the associated privileges

Extensively worked with the Informatica server that runs on UNIX platform and used workflow monitor to monitor the Informatica server and reviewed error logs that it generates for each session it runs.

Configured and ran the Debugger from within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow

Configured and used FTP by the Informatica Server to access source files

Worked with pmcmd command line program to talk with the Informatica server

Extensively used TOAD to test, debug SQL and PL/SQL Scripts, packages, procedures, triggers, and functions.

Employer: GR89 InfoServices Private Limited

Client: WEA TRUST, Madison, Wisconsin Aug 2005 – Dec 2006

Lead ETL Informatica Architect/Developer

WEA Trust is charged with designing and maintaining benefit plans that are responsive to the needs of school employees, that are compatible with the collective bargaining philosophy and dynamics, and that are faithful to the fiduciary relationship between the union and its members. The Trust is a not-for-profit corporation that is dedicated to helping public school employees find ways to address the health care cost crisis while providing them comprehensive health care at a reasonable price. The Wisconsin Education Association Council (WEAC) created the WEA Trust in 1970 to provide insurance and benefit plans for public school employees and their families. The first offerings were health, life, and disability plans.

Environment/Tools:

Informatica Power Center 7.1.2, Oracle 9i, DB2, Mocha Soft, Aqua Data 4.5, IBM iSeries Access, AIX Scripting

Responsibilities:

Involved in Dimensional Modeling of the data warehouse to design the business process

Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation

Worked on Dimensional modeling to Design and Develop STAR Schemas and SNOWFLAKE Schemas, used ER-win 4.0, identifying Fact and Dimension Tables.

Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions

Worked closely with business analysts to understand and document business needs for decision support data.

Involved in developing & testing of ETL, Informatica mappings, workflows, sessions using Informatica.

Extensively utilized Informatica Power Center to load data from oracle and Fixed-Width, Delimited Flat files into Data Warehouse.

Imported various heterogeneous and homogenous sources using Informatica 7.x source analyzer.

Involved in working with ODS (Operational Data Store) to extract data from the Data warehouse.

Involved in writing procedures, functions in PL/SQL.

Designed sessions using Workflow Manager and monitored using Workflow Monitor

Created & launched scheduled tasks/sessions. Configured email notification. Setting up tasks to schedule the loads at required frequency using Power Center.

Automated Worklets and Session schedule using Unix Shell scripts.

Monitored Sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged Mappings for failed sessions

Designed Star Schemas and Bridge Tables to control slowly changing dimensions

Involved in Unit testing of Mappings and Workflows.

For better performance created partitions, and used SQL Override option in source qualifier

Involved in extensive Performance Tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.

Used session partitions, dynamic cache memory and index caches for improving Performance of Informatica Server.

Employer: GR89 InfoServices Private Limited

Client: AETNA, Pittsburg, Pennsylvania Feb 2004 – Jul 2005

Data Warehousing/Data Analysis/ Informatica Developer

AETNA is a global insurance organization serving businesses and individuals with a wide range of insurance products and insurance-related services. It has wide range of Insurance Products that include Auto insurance, Personal Insurance, Casualty insurance, and Life insurance. Claims Management System provides the technology that assists claim professionals in administering claim practices in a timely and effective manner. This application involves in designing and development of the Data Warehouse. The company’s data come from different operational sources like DB2, Oracle, and Sybase and is then loaded into the Claims Data Warehouse built on Oracle using Informatica. Various Business Rules and Business Processes were applied to Extract, Transform and Load the data into the Data Warehouse. This Data warehouse was designed for the Reporting for the AETNA. This warehouse reports the historical data stored in various databases and Flat Files.

Environment/Tools:

Informatica Power Center 6.2, UNIX, Oracle 9i, MS Access, Excel, Oracle 9i, SQL * Loader, Erwin 4.0, Windows 2000

Responsibilities:

Interacted with the management and user community to understand and gather requirements.

Created physical and logical structures of the database and tables using ERwin 4.0 and Oracle

Generated a physical data model using ERwin

Developed mappings using Source qualifier, Aggregators, Connected & unconnected Lookups, Stored Procedures, Filters, Sorter & Update strategy Transformations using Power Center7.0/6.2.

Worked with various transformations like Aggregator, Expression, Filter Source Qualifier, Joiner, Sorter, Router and Look Up and Stored Procedure etc to incorporate the business rules into the mappings.

Performed various Aggregate Function like AVG, MIN, MAX, COUNT, FIRST, LAST, STD DEVIATION, MEAN AND MEDIAN

Used XML Transformation to move data from XML files from staging to Targets of Claimant Data.

Involved in migrating the Repository from Development, testing and Production after testing

Involved in Creating tasks, work lets, workflows to load various dimensions that include Products, Product Categories, Coverage Type, Coverage Level, Risk Level Dimensions.

Employer: GR89 InfoServices Private Limited

Client: Kmart Corporation, Troy, Michigan Oct 2003 – Jan 2004

Informatica Developer and Business Objects Developer

Advertisement Forecasting – Forecast Accuracy Analysis

“Ad Forecasting and Ad Effectiveness” is the state of the art project dealing with advertisement effectiveness and sales forecasting. Forecast accuracy analysis is a metrics system that is used to measure the accuracy of various forecasting models. This system is decision support application, which will interact with forecasting system to provide best forecast for a merchandise enabling clients to plan for procurement. This system will collect the sales information from the POS and Inventory information from the store systems to calculate the different factors, which will affect the sales.

Responsibilities:

Interacted with end users and business analysts to identify and develop business requirements and transform them into technical requirements.

Used Extraction Transformation and Loading tool to transfer the data to the target Database.

Worked on Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.

Developed various Informatica mappings and mapplets using complex transformations like Aggregators, lookups, Filters, Sequence Generator, Normalizer, Update strategy and stored procedure transformations.

Worked with Heterogeneous targets in Power Center 6.1.

Implemented Slowly Changing Dimension Type 2 in the logic.

Involved in Performance tuning and elimination of bottlenecks for better performance.

Responsible for Creating workflows and work lets. Created Session, Event, and Command, Control, and Decision tasks in Workflow Manager.

Wrote shell scripts for extracting data from different sources like flat files, and oracle databases and for transformation of data.

Involved in Unit, System integration, User Acceptance Testing of ETL Process.

Responsible for delivering their report requests or needs, updating of the reporting database changes as it pertained to the Oracle database, creation of reports and exporting results.

Mentored end users and technical users.

Provided on-demand analysis for company management via SQL and quickly created Business Objects reports.

Involved in generating reports in Business Objects

Involved in implementing the best practices, methodologies & strategies using Business Objects Designer & Reporter.

Employer: Kredence Software Solutions

Client: Glaxo Pharmaceuticals Limited, INDIA. Feb 2002 – Sep 2002

Data Warehouse/Informatica Developer

This assignment is for the project in Glaxo for creating the corporate Data Warehouse from the operational OLTP system and staging area using extraction capabilities of Informatica Power Mart. Operational sources exist in OLTP environment comprising of Oracle 8. This project is a pilot project towards creating the corporate Data Warehouse in Oracle 8i for Glaxo using the existing operational data for better decision-making and analysis. Extraction and Transformation tool, which has been used in project, is Informatica and the proposed front end OLAP tool would be Business Objects.

Responsibilities:

Study on the existing systems used for operational data management in Oracle 8

Extensively used Informatica client tools – Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.

Identifying suitable dimensions and facts for sales schema

Creating the Source Definitions, Target Definition and Mapping in Informatica Designer.

Designed the mappings between

Contact this candidate