Candidates About

 

Santosh Kobbajji

Summary

Ø  16 + years of experience in Software Development and Database Design in the areas of Commercial and Business Applications as a Project manager, Architect, Technical Lead, &  and Application Developer.

Ø  Good experience in project management, setting project milestones and man management.

Ø  Extensive knowledge in wide range of RDBMS software specifically built for DW&BI initiatives like Teradata, Oracle and DB2 UDB

Ø  Extensive knowledge in managing complex IT projects with a cross-functional team of business, development, quality assurance, usability engineering and production support teams.

Ø  Focused experience in Information Technology with a strong background in Database development, Data warehouse ETL process using SSIS, Informatica PowerCenter 9.6/8.x/7.x (Workflow Manager, Workflow Monitor, Administrator console, Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation Developer), Informatica Data Quality and Power Mart 5.1 Data Mart.

Ø  Extensive experience in Analysis, Design, Modeling, Development, Implementation and testing of Data Warehousing Business Application Systems of Financial (GECCF, UK and Charles Schwab, CA), and Pharmaceutical (Cardinal Health, NJ).

Ø  Coordinating and monitoring the project progress to assure the flow and completion of work on schedule.

Ø  Dimensional Data Modeling experience using Data modeling, Erwin 4.5/4.0, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling.

Ø  Extensive experience Data Analysis, User Requirement Gathering, User Requirement Analysis, GAP Analysis and Source Systems Analysis.

Ø  Data Analysis, Data Cleansing, Data Reconciliation, Data Discrepancy, Data Scrubbing & Data Validations.

Ø  Excellent experience in SQL Tuning and Application Tuning.

Ø  Hands on experience in Writing the PL/SQL Stored Procedures, Functions.

Ø  Experience in BO universe and creating reports.

Ø  Extensively worked on terabyte size of databases

Ø  Excellent Experience in writing the Shell Scripting (sh, ksh)

Ø  Maintenance and installation of business object 6.0 and creating user on Webi

Ø  Good understanding of Siebel Analytics RPD and reports.

Ø  Conversant with all phases of Software development cycles involving Systems Analysis, Design, Development, testing and Implementation and user co-ordination.

Ø  Documentation, Training end-users, Enhancements and Support of the Application in a live production.

Ø  Ability to handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules, adept in conducting knowledge transition sessions and possess good communication skills.

Qualification

                B.S. Mechanical from Kuvempu University, India.

Technical Skills

 

Operating System	Windows 9x, Windows NT, 2000 Server, LINUX
Hardware	IBM PC
Language	ASP, Visual Basic 6.0, Java
Data Modeling	Erwin, Rational Data Architect, Microsoft Visio
ETL	Informatica PowerCenter 9x/8x/7x,MM,MDM Power connect 7.1, SSIS
Tools	Visual InterDev 6.0, Erwin, Toad, VSS
BI	Business Objects, Siebel Analytics, SSAS
RDBMS	Oracle 9i, Teradata, SQL Server 7.0/2000, MS Access 98

AREAS OF EXPERTISE

Data Warehouse Architecture Business Analysis Project Management Interface with Clients Business Requirements Gathering Business/ Technical Impact Analysis IT Strategy and User Defined Documentation Use Case Development Process Flow Design Technical Design Specifications Develop Functional Specifications

Data Analysis Web Services / Middleware Services User Interface Design QA Analysis & User Acceptance Testing Application Training Documentation Customer Relationship Management Financial Analysis Supply Chain Management  Onshore-Offshore Global Delivery Model

 

Technical Assessments

 

Customer              :  City of Austin, TX                                                                                Feb 2014 – Till Date

Project Name        :  Enterprise BI.

Environment         :  Informatica Power Center 9.5/9.1, Informatica Metadata Manager, Oracle, SSIS, Erwin   

                                   Micro Strategy.

Role:  Data/ETL Architect

Description: Enterprise BI project is the City Of Austin’s big BI initiative to provide a comprehensive and effective reporting system for all the 38 departments. Successfully implemented project for five departments.

 

Responsibilities:

• Build brand new data warehouse environment including newly acquired Informatica and Microstrategy
• Working with the SME to collect all the requirements across the departments.
• Understand requirement definition document (RDD) provided by the business.
• Dimensional Data Modeling to deliver Multi-Dimensional STAR schemas
• Logical & Physical Data modeling, which involved Identifying the facts & dimensions, grain of the fact, aggregate tables etc., for Dimensional Models by using Erwin tool.
• Designed ETL Design specification documents to develop Informatica mappings.
• Extensively worked on Informatica mapping, Workflow, worklet.
• Worked on informatica Master Data Management (MDM).
• Building and maintaining the metadata repository.
• Working as Informatica administrator and perform all the duties by implementing and managing the roles and privileges of the users.
• Develop SSIS package for certain dataset
• Converting SSIS package into Informatica mappings and workflows
• Developing a prototype for the master data management by using Informatica MDM.
• Worked on Oracle stored procedure to meet business requirement.
• Analyzing the source and target system data architecture.
• Design and implement the data reconciliation process.
• Oracle query and Informatica mappings, workflows performance tuning
• Designed and Developed Error handling processes.
• Defined the Best practice document for Informatica.
• Analyze and Resolve data issues which are identified during the UAT phase.
• Adapted ETL Best Practices and followed the ETL naming conventions.

 

 

 

 

Customer              :  Edwards Life Science, CA                                                                                  Oct 2013 – Feb 2014

Project Name        :  Enchilada.

Environment         :  Informatica Power Center 9.5/9.1, Oracle, Toad, Informatica Power Exchange net weaver.

Role:  ETL/Data Architect

Description: This project is to provide a comprehensive reporting system for Dominic republic and Puerto Rico manufacturing unit managers and material procurement teams. Edwards Lifesciences is the global leader in the science of heart valves and hemodynamic monitoring

.

Responsibilities:

• Understand requirement definition document (RDD) provided by the business and understand the manual reporting.
• Dimensional Data Modeling to deliver Multi Dimensional STAR schemas
• Logical & Physical Data Modeling, which involved Identifying the facts & dimensions; grain of the fact; aggregate tables, etc for Dimensional Models
• Designed ETL Design specification documents to develop Informatica mappings.
• Extensively worked on Informatica mapping, Workflow, worklet
• Worked on Oracle stored procedure to meet business requirement.
• Analyzing the source and target system data architecture.
• Design and implement the data reconciliation process.
• Designed to extract the data from JD Edwards
• Designed and Developed Error handling processes.
• Defined the Best practice document for Informatica.
• Analyze and Resolve data issues which are identified during the UAT phase.
• Adapted ETL Best Practices and followed the ETL naming conventions.
• Working with Qlicview reporting team during the data reconciliation process. 

 

Customer              :  AMD, TX                                                                                                             Oct 2011 – Oct 2013

Project Name        :  Financial Transformation Management Reporting (FTMR)

Environment         :  Informatica Power Center 9.5/9.1, SSIS, SSAS, SQL Server, Toad, Informatica Power               

                                   Exchange net weaver.

Role:  ETL Architect/Data Architect

Description: This project is to provide a comprehensive program focused on designing and implementing changes to the current processes, policies, and systems in order to improve the value of finance to the organization

.

Responsibilities:

• Understand system business rules, analyze and System design and work on project proof of concepts.
• Designed ETL Design specification documents to develop Informatica mappings and SSIS Packages.
• Dimensional Data Modeling to deliver Multi Dimensional STAR schemas
• Logical & Physical Data Modeling, which involved
  • ER Modeling - Developing Entity Relationship Diagrams (ERD)
  • Normalizing the tables to 3NF/relationships to arrive at effective Relational Schemas
  • Implementation of Business Rules in the Database using Constraints & Triggers
  • Identifying the facts & dimensions; grain of the fact; aggregate tables, etc for Dimensional Models
  • Developing Snowflake Schemas by normalizing the dimension tables as appropriate
• Worked on Informatica BCI configuration and presenting the proof of concepts of Informatica BCI adaptability  
• Analyzing the source and target system data architecture.
• Design and implement the data reconciliation process.
• Designed to extract the data from SAP BW and SAP extractor by using Informatica power exchange net weaver.
• Designed and Developed Error handling processes.
• Co-ordination with multiple teams for resolving data issues.
• Communicating with the offshore team to get the work status of the team members
• Assigning the work to the offshore team based on the team band width.
• Defined the Best practice document for Informatica and SSIS ETL development.
• Design the job scheduling by using Control-M scheduling tool.
• Risk analysis and setting the mitigation plan.
• Resolving data issues and set up issues during UAT phase.
• Build cube for the reporting by using SSAS
• Adapted ETL Best Practices and followed the ETL naming conventions.
• Involved in informatica performance tuning.
• Involved in Designing the Process-flow workflow for Incremental Load.

 

 

Customer              :  Hewlett Packard, TX                                                                                        Jan 2011 – Oct 2011

Project Name        :  EMEA Wave

Environment         : Informatica Power Center 8.6, SSIS, Oracle 11g, SQL Server, Toad, UNIX, Power Exchange

Role:  ETL Lead/Architect

Description: Providing an opportunity for greater visibility and integrity of global forecasting and planning data, the demand planning solution will enable accurate, timely information to support business decisions and provide the foundation for a consistent and positive customer experience.  In addition, it supports a rapid integration of new businesses on to a common platform and set of processes.

Responsibilities:

• Understand system business rules, analyze and System design (ETL Design) and Development.
• Designed ETL Design specification documents which will be later used by the ETL Development team.
• Extensively used all SSIS tools and various transformations - Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc to generate SSIS packages.
• Analyzing the source and target system data architecture.
• Designed and Developed Error handling processes.
• Co-ordination with multiple teams for resolving data and environmental set up issues.
• Defined the Best practice document for ETL development.
• Risk analysis and setting the mitigation plan.
• Resolving data issues and set up issues during UAT phase.
• Adapted ETL Best Practices and followed the ETL naming conventions.
• Communicating with the offshore team to get the work status of the team members
• Designed logical model to develop the cube and refresh strategy by using SSAS.
• Assigning the work to the offshore team based on the team band width.
• Involved in SQL query performance tuning.
• Involved in Designing the Process-flow workflow for Incremental Load.

 

Customer              :  Amgen, CA                                                                                                          Sept 09 – Dec 2010

Project Name        :  Revenue Management System (GCPS-Global Contract and pricing system)

Environment         :  Informatica Power Center 8.6, Oracle 10g, ModelN, XML, Toad, Agile, UNIX 

Role:  Informatica Lead/Architect

Description: Revenue Management will be the primary system of record for executing the customer contracts that Key Account Managers and Sales Reps negotiate with Amgen customers to increase product revenue and market share.

Responsibilities:

• Understand system requirement, business rules, analyze and System design (Informatica Design) and Development.
• Designed ETL Design specification documents with the help of Data modeling team. These ETL Design specifications were later used by the ETL Development team to create Informatica maps.
• Extensively used all Informatica Client tools and various transformations -Lookup, Filter, Expression(reusable), Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Sequence Generator,Normalizer, Mapplets to generate Informatica ETL’s.
• Worked on the strategy to load the data into complex xml target.
• Analyzing the source and target system data architecture.
• Worked with Data Modelers to Design Data structure for loading extracted data.
• Designed Informatica mapplets and worklets to utilize the reusability feature of Informatica.
• Designed and Developed Error handling processes.
• Co-ordination with multiple teams for resolving data and environmental set up issues.
• Defined the Best practice document for Informatica ETL development.
• Designed Informatica mapplets and worklets to utilize the reusability feature of Informatica.
• Designed to extract the data from SAP to oracle database by using the informatica Power Connect.
• Risk analysis and setting the mitigation plan.
• Resolving data issues and set up issues during UAT phase.
• Adapted ETL Best Practices and followed the ETL naming conventions.
• Communicating with the offshore team to get the work status of the team members
• Assigning the work to the offshore team based on the team band width.
• Provide the project status report to the client on every weekend.
• Involved in informatica and Oracle query performance tuning.
• Involved in Designing the Process-flow workflow for Incremental Load.

 

GE Capital Solutions, MN                                                                                                                     Jan 09 – Aug 09

Project Name        :  GE Fleet Services

Project Type         :  Development and Maintenance

Environment         : SSIS, Oracle 10g, Business Objects 6.5, Toad, Agile, UNIX and Windows XP.

Role                        :  Technical Lead

 Description: GE Capital Solutions Fleet Services provides commercial car and truck financing and integrated fleet management services That help customer to save time and money, and reducing customer fleet’s impact on the environment. The objective of the Fleet Service project is to house the customer vehicle location, health and vehicle performance into the data warehouse. The data are sourced from OLTP and mainframe systems.

Responsibilities:

• Was part of the CORE team during the Analyze, Architect, Design, Build, Test, Deploy and Operate phases.
• Interacted with business analysts, architects and application developer to analyze the data model and gathered the requirements.
• Analyzed existing requirements and consolidated the reports for effective and efficient reporting.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
•  Extensively worked on tuning mappings and reducing processing times.
• During Architect Phase, translated the business requirements to the technical design documents. Developed the Architecture Logical and Physical views. Devised the Change Control procedures from the ETL perspective. Assisted the Data Architect in the Volumetric analysis and requirement.
• Involved in Designing the Process-flow workflow for Incremental Load.
• Involved in SQL query performance tuning. And reduced nearly 2 hours of production window.
• Involved in Data profiling, Data Cleansing and Testing.

 

 

Charles Schwab, CA                                                                                                                             June 07 – Jan 2009

Project Name        :  Finance Corporate and Admin Technology (FCAT)

Environment         :  Informatica Power Center 8.6, Teradata V2R5, DB2 UDB, XML, Business Objects

                                   6.5, Agile, UNIX and Windows XP.

Role                        :  Informatica Architect/Lead

 Description: Charles Schwab is one of the leading financial management and advisory companies, providing online investing, financial advice and banking solutions. The objective of the FCAT project is to house the profitability of both brokerage and bank products into the data warehouse. The data are sourced from various systems IDW, Fidelity and legacy systems. This process loads the customer, Account, household, product and inactive accounts information in the warehouse which is then tied to the Broker Dealer Account and then used by the Decision Support System for the analysis.

Responsibilities:

• Participated in requirement review for FCAT enhancements and validated feasibility of requirements with respect to implementation.
• Wrote functional and technical documents such as Functional Designs and Technical Designs. Some examples of functionalities documented are ‘Financial consultant commission’, ‘Converting server utilization time into cost’ etc.
• ETL Architecture, Data Modeling
• Dimensional Data Modeling to deliver Multi Dimensional STAR schemas
• Design & Implementation of Data Mart; DBA coordination
• Logical & Physical Data Modeling, which involved
  • ER Modeling - Developing Entity Relationship Diagrams (ERD)
  • Normalizing the tables to 3NF/relationships to arrive at effective Relational Schemas
  • Implementation of Business Rules in the Database using Constraints & Triggers
  • Identifying the facts & dimensions; grain of the fact; aggregate tables, etc for Dimensional Models
  • Developing Snowflake Schemas by normalizing the dimension tables as appropriate
• Involved in prioritizing the enhancement task.
• Coordinating with the offshore team and allocating the tasks to the team.
• Used Agile methodologies for the project development
• Involved in configuring the power exchange to bring the data from Siebel CRM system.
• Developed Informatica mappings and workflows.
• Configured and worked on pushdown optimizer
• Involved and developed B2B Data Transformation.
• Developed unix shell scripts to send email to the users about the job status.
• Involved in developing BO universe and multiple reports.
• Developed BTEQ script to accomplish the business rules and to improve the performance.
• Wrote UNIX BTEQ scripts to manage and collect statistics daily
• Documented Enterprise Integration Standards and Best Practices to be used within development team. This provided pointers on integration techniques to use, naming conventions to follow, how to reduce network overload and maximize performance etc.
• Handled production support activities and troubleshoot the issues during the production runs.
• Involved in informatica and Teradata performance tuning. And reduced nearly 6 hours of production window.

Cardinal Health, NJ                                                                                                                              Sept 06 – June07

Project Name        :  Sales Analytics Data Warehouse (SADW)

Environment         :  Informatica Power Mart 7.2, Siebel Sales Analytics 7.2.1, XML, Agile, SQL Server,

                                   Erwin 4.5 and Windows 2000.

Role                        :  Onsite Informatica Lead/ Architect

Description : The project involves development and maintenance of Sales Services division of Healthcare Marketing Data warehouse provides increased capabilities of sales force to sell their products via –Contract Sales, Field Meeting Logistics, Product Launch Support, Non-manpower initiatives

With this data, Cardinal Healthcare is able to effectively perform event management for its clients.

Responsibilities:

• Collaborate with client business leaders, executives, SMEs, information technology and business users on full life cycle engagements.
• Wrote functional and technical documents such as Functional Designs and Technical Designs.
• Responsible for Conceptual data modeling; logical and physical data modeling
• Responsible for Dimensional Data Modeling to deliver Multi Dimensional STAR schemas
• Coordinating with the business users
• Extensively worked in Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms, and Sequences etc., closely worked with DBAs to create Physical Databases.
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse to reduce the cost of the project adopted agile methodologies .
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Provide project leadership to an onsite team of 4 employees, including: Production timetable; status reporting and client/project team co-ordination.
• Developed Informatica mappings and workflows, worklets and sessions
• Developed Reports and RPD in Sales analytics
• Creating user Id in Siebel analytics and granting the user level permission
• Handled production support activities and troubleshoot the issues during the production runs.
• Involved in informatica performance tuning.

 

Charles Schwab, CA                                                                                                                               August 05 – Sept 06

Project Name        :  Sales Analytics Business Intelligence (SABI)

Environment         :  Informatica Power Mart 7.2, OBIEE (Seibel Analytics), Oracle 10g, Toad, Erwin 4.5

Role                        :  Technical Lead/Informatica Architect

Description: Sales Analytics is a new business intelligence application designed specifically to help Financial Consultants and Branch Network Managers to manage their Relationship Practice and monitor and review sales performances.  It helps deepen client relationships and improves sales and retention efforts by delivering target, timely and actionable client intelligence as well as providing quality coaching opportunities for managers through succinct performance analysis and reporting.

Responsibilities:

• Conducted focus group sessions and interviewed subject matter experts to understand the requirement of the of the business partners.