DataStage Developers with SAP

Title

APPLICANT 1 - DataStage/SAP

Requirements

• 7 years of experience in analysis, design, modeling, development, implementation and testing of applications in data warehousing and client/server environment using DataStage 8.0.1/7.0/6.0/5.2
• 5 years of strong Data Warehousing experience on Extraction, Transformation and Loading (ETL) processes using Ascential Data Stage (Manager, Designer, Administrator, Director), Parallel Extender, SAP PACKS (ABAP EXTRACT, IDOC EXTRACT, IDOC LOAD, BAPI EXTRACT, and BAPI LOAD).
• Worked on DataStage client tools DataStage Designer, DataStage Director, DataStage Manager.
• Worked on IBM DataStage , Qualitystage 7.5.2 EE ( Parallel Extender )
• Expertise in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon.
• Developed Server jobs for extracting, transforming, integrating and loading data to targets.

DBA/Data Modeling

Title

APPLICANT 1- DBA/Modeler

Requirements

• Over 15 years experience as an Oracle Apps 11.x ERP DBA, Oracle Data Warehouse DBA, Onsite Oracle Support
• Experienced conducting Performance tuning, Installations, Requirement Analysis, Design Reviews, Test Planning, Test Plan Reviews, Implementation, Peer reviews
• Knowledgeable in administering tight Oracle user security to meet SOX-404 requirements
• Experienced with Multiple Database technologies and environments
• Strong skills in Database Design, Capacity Planning, Application Security, Application Development, Production Support, Change Management Process and Business User Support
• Application design and development and support cycles.
• Strong database and developer analyst skills, performing requirement gathering, design and implementation.
• Strong Data Modeling experience in OLTP and OLAP environments.
• Winner of "IT Excellence Award" and six times winner of "IT Achievement Award" Award

Title

APPLICANT 2 - DBA/Modeler

Requirements

• Over 26 years of experience with IT infrastructures, business applications development, and support. Expertise in End-to-End Project Planning and Execution, Strategic, Process Design and Redesign, Change Management, Management of Measurable Business-Performance, Cross-Functional Project Team Leadership, Organizational and Team Development, Productivity and Efficiency Improvement, Training, Negotiation, Persuasion, Communication, Problem Solving, Decision Making, and Vendor Management.
• Over 7 years of SAP HCM Functional Consultant experience with expertise in implementing Payroll (PY), Personnel Administration (PA), Time Management(PT), Benefits (BN) and Organizational Management (OM) across Health, Manufacturing, Electronics and IT sectors using versions R/3, 4.0B, 4.6C, 4.7 and ECC 5.0 & 6.0
• Over 9 years of experience in mainframe applications (Cobol, DB2, JCL, CICS, SQL, COGEN, CABS, XPEDITER, PST, MQ series)

Data Warehouse

Title

APPLICANT 1- Data Warehouse

Requirements

• Over 15 years of Total IT experience with Oracle Certification - SQL PL/SQL, DBA. Exposed to entire life cycle of the project that includes data modeling, design, coding in backend (Packages, Stored Procedures/Functions & Triggers) and GUI front end, testing and implementation.
• Experienced in SQL, PL/SQL, Oracle tools including Oracle Forms, Oracle Reports, Oracle RAC, SQL*Plus, SQL*Loader.
• Experienced in Data Warehousing (Ralph Kimball Approach) design and development using Informatica Powermart ETL, Data Migration, and Business Intelligence Solutions & Decision Support Systems and in Oracle Database Administration, Backup & Recovery and Performance tuning.
• Data modeling experience developing ER and dimensional models using Power designer and Erwin tools.

Title

APPLICANT 2- Data Warehouse

Requirements

• Over 6 Years of work experience in IT Industry in Designing, Developing and Implementing Enterprise data Warehouse and Data marts.
• Area of expertise encompasses requirements analysis, database design, development, administration, quality assurance, establishing best practices and data quality, production support, and documentation.
• Extensive experience in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems using ETL Tools Ascential DataStage EE/PX 7.5.x/ (Manager, Designer, Administrator, Director), IBM Information Server V8.0 (DataStage), Modeling Tool Erwin, OLAP and OLTP.
• Strong experience in Data Warehousing, Data Architecture, Data Modeling, Data Analysis, Decision Support System (DSS) and GUI applications.
• Experienced in various Data sources like Oracle 9i/10g, SQL SERVER and DB2 UDB.

Senior DataStage (information Server) ETL

Title

Applicant 1- Datastage/ETL

Summary

Title

Applicant 2- Datastage/ETL

Summary

Data Warehouse Developer and Modeler

Title

APPLICANT 1- DataWarehouse Modeler

Requirements

• Business Intelligence and Data Warehouse expert.
• Extensive experience in management consulting to improve operations and decision making through the use of Information Technology and process improvement.
• Track record of delivering projects on-time, on-budget; project completion rate on over $500 million of domestic and international ERP, data warehousing, process improvement and capital equipment projects.
• Partner/Off Shore Development: Coordinate with consulting firm partners, VARS, and OEMs to achieve mutual revenue and customer satisfaction targets in China, India, Holland, Germany, and Spain

Title

APPLICANT 2- DataWarehouse Modeler

Requirements

• Informatica and Cognos Certified Professional with 6 years of thorough industry experience as Data Architect/Data Modeling.
• Interacted with various Business users in gathering requirements to build the data models and schemas.
• Ensured compliance with standard software development practices, processes and enterprise standards
• Created Physical and Logical data models using Erwin.
• Created tables, indexes, views, functions, procedures and sequences in Oracle backend
• Hands on experience in writing T-SQL queries, Stored procedures etc
• Good knowledge in developing PL/SQL Stored Procedures, functions to ensure successful execution of the ETL processes
• Good Knowledge of SDLC( Software Development Life Cycle)
• Involved in Unit testing, System testing while moving the code from development to production.
• Developed Design Documentation for all development efforts
• Implemented Informatica ETL methodology for designing and developing extraction, transformation and load processes

Cognos Developer

Title

APPLICANT 1- Cognos BI Developer

Requirements

• . 8+ years of IT experience with specialization in Cognos Enterprise Planning 7.X 8.1, 8.2,8.3,8.4 & Cognos TM1 along with Cognos BI
• . Develop Planning & Forecasting & Budgeting models covering Strategic planning, Capital Project Planning, Revenue, Sales Planning, Profitability Planning, Salary and Compensation Planning , Commercial Model , Product Management Model.
• . General & administrative planning ,cost allocation based on Cost centers or Departments or Regions
• . Strong knowledge and experience in managing corporate financial planning process using driver/profile based Rolling forecasts, the Variance analysis and reporting, forecast based on KPIs, exception management reporting and consolidation
• . Proven Cognos Planning project management, Risk identification & Resource management and identifying critical paths , Conflict resolution and Project performance evaluation
• . Expertise with Finance/Banking,Automobile,Insurance,Healthcare/Pharmaceutical,IT , Sales , Engineering & retail domains

Title

APPLICANT 2- Cognos BI Developer

Requirements

• 10 Years of Experience in Cognos Tool suites such as Planning and Reporting.
• Over 6 years of Cognos Planning and around 4 years of BI experience.
• Knowledge and Experience using Cognos Enterprise Planning Suite v7.3 to v8.4 (Analyst, Contributor Administration Console, Contributor Web, Planning Manager, Excel, Access and power point tools for Planning, Budgeting, Forecasting and Reporting).
• Cognos BI reporting- C8 - FWM, RS, QS, AS, CRN v1.1, IMR, IWR, Power Play, PP Transformer, PPES, UPFRONT Web portal.
• IBM-Cognos Corporation Trained Enterprise Planning Professional.
• Experience meeting with the business users and gathering the requirements
• Strong understanding of Financial Forecasting and Reporting Process.
• Knowledge and Experience on Implementation, Design, Development, Testing, Integration, Administration, Technical Support, Performance Tuning, Installation, Configuration, Upgradation, Migration, Maintenance and Knowledge transfer.
• Data Modeling, Process Modeling, Data Transformation from OLTP to Operational Data Store, Data Warehouse for Consolidation and rollup of data into OLAP.
• ETL tools such as Erwin, Decision Stream and Data Manager

Title

APPLICANT 3- Cognos Developer

Requirements

• Over 8 years of experience in software industry and more than 6 years working experience on Cognos Business Intelligence reporting.
• 3+ years of experience working with Cognos 8 BI (Cognos Connection, Framework manager, Report Studio and Analysis Studio, Query Studio).
• 3 + experienced in requirements capturing from end users and designing implementation strategy.
• IBM Certified Cognos 8 BI Reports designer and IBM Certified Cognos 8 Meta Data Models developer.
• Experienced in designing packages and creating models and dimensionally modeled relational (DMR) using Framework manager.

DATAWAREHOUSE / ETL

Title

APPLICANT 1 - DATAWAREHOUSE

Requirements

• 14+ years of IT experience
• 12+ years as Analyst, Developer, Modeler/Architect, DBA and Team Lead.
• 10+ years in Oracle Database Back-end development (SQL, PL/SQL).
• 7+ years in Oracle Front-end (Developer Suite – Forms/Reports etc.) development.
• 6+ years in CASE Tool (Oracle Designer) development.
• 5+ years in Database Migration.
• 1+ years in IBM DB2 UDB (AIX) development.
• 10+ years in UNIX based development.

Title

APPLICANT 2 – DATAWAREHOUSE

Requirements

• 5 years of IT experience as a Program Analyst, this includes Data Warehouse Developer experience using ETL Tool Informatica.
• Hands on experience with Informatica which includes working with (Power Center, workflow manager, workflow monitor and repository manager)
• Experience with various database like Oracle, SQL Server and Teradata.
• Strong data warehousing concepts.
• Worked with business users as well as technical team.
• Strong experience in unit testing and integration testing of various ETL processes.
• Excellent communication and goal oriented skills.
• Strong problem-solving skills and has ability to work with little direction

SAP BW/BI/ECC

Title

APPLICANT 1- SAP

Requirements

• Eight years of IT experience in Private enterprise, including seven plus years in SAP BW/BI and one year experience as ABAP/4 consultant and test engineer.
• Experience with implenmentation of three full cycle BW projects and two support projects.

Title

APPLICANT 2- SAP

Requirements

• 10+ years of experience in designing, development, and implementation of Information Technology Systems in SAP BW/BI, SAP Portals and R/3 it includes 4 Implementations and development.
• Hands on experience in leading all stages of system development efforts, including requirements definition, design, architecture, testing and project based efforts while managing, motivating, and guiding team.

SAP HR

Title

Applicant 1- SAP HCM Consultant

Summary

10 years of SAP experience as an IT professional in multiple roles. His strength lies in problem solving, business requirements gathering and analysis, all phases of SDLC including change and people management. He was involved in various projects involving SAP CRM, SAP ERP ECOMMERCE, SAP HCM, SAP R/3 / ECC development, APO CIF Integration, CRM Middleware Integration and IDOC/ALE management. He was actively involved in various phases of implementation including requirements gathering, writing functional/technical specifications, development, unit and integration testing, go-live and production support. He is a conscientious and thorough individual who is responsive to users with excellent interpersonal and communication skills with ability to work both as an individual and in a group and to learn and adapt quickly to the environment.

Title

Applicant 2- SAP HCM Consultant

Summary

10 years of extensive experience in the Information Technology industry with excellent SAP HCM techno-functional experience. Hands-on experience in 5 full cycle SAP implementation for multiple countries; also Involved in multiple SAP upgrade projects. Always volunteered at many client sites to step up for new tasks and help them to save consulting dollars. Has an ability to learn new things quickly and efficiently. Expertise in implementing complex business rules that includes making changes to time management schemas and personal calculation rules and developing numerous custom time functions/reports.

Competency in SAP environment administration, authorizations and security, user creation, assigning profile, activity groups, and authorization. Sound knowledge and experience in evaluating current client process and identifying areas of improvement. Excellent communication skills, systematic approach and ability to work effectively in a fast paced environment as well as strong analytical, inter-personal, and problem-solving skills.

Title

Applicant 3- Senior SAP HCM Consultant

Primary Skills

SAP HR/HCM and ESS/MSS Development ,Payroll and benefits Interface Development, WebDynpro for ABAP, Adobe Forms, Custom PCR ,UWL,BSP, Web Services, SAP NetWeaver Portal (NW2004s), Composite Application Framework (NW2004s), CAF Guided Procedures (NW2004s), SAP HR/HCM ABAP, RFC,WAS and BAPI component development. Extensive experience in development of WebDynpro applications (Java & ABAP) and Portal architecture & planning.

Summary

Excellent mix of HR technical, business and Functional skills in Unicode and non Unicode systems. Highly Skilled in SAP R/2 tHRu ECC Upgrade. Enjoys delivering product that Is # 1 in quality and easy to use .Over 14 years of IT and Consulting experience, Platinum Level Senior SAP R/3 HR Techno functional Sr SAP Consultant who demonstrates commitment for continual improvement in business and management areas. Able to provide solutions and expertise to SAP customers and their business units. Able to deliver on time and on budget with documented successes in Project Management Office (PMO).Capable from Blueprint to Go-Live with Post Go-Live including Production Stabilization, Maintenance, Support and Business Processing Plans (BPP), application code maintenance. Strategic thinker but able to leverage existing technology .Able to develop innovative and appropriate solutions to business and technical problems across a wide spectrum of environments and manage them to completion. Able to plan, organize and manage complex situations and tasks. Able to provide leadership, guidance and supervision to large and small groups. Able to analyze and extract core issues in complex business and technical processes. Excellent communication, interpersonal and organizational skills Comprehensive understanding of the SAP R/3 Business Data Model with strong process-to-technology mapping capabilities and full grasp of integration issues. Proven experience in architecting, configuring, and implementing SAP NetWeaver and SAP application modules with Web Integration Team with analysis and collection of business requirements and the building of technical infrastructure which includes: identification of HR ABAP development requirements, Web development tools and methodology, Basis/Web AS requirements, security requirements, and network requirements relative to SAP deployment to the sites and corporate intranet. Demonstrated experience in HR ABAP with strong WebDynpro for Java/HR ABAP knowledge. Strong Knowledge of guided procedures, and Adobe Forms.