Ravi R
?+91-996**-***** +91-809**-***** ) +91-044-****-**** -:
****.****@*****.***
Objective: Seeking a challenging position in IT, research and development
in DW. Excited to learn and adapt the new technologies as and when needed
in a fast pace. Highly motivated to excel in DW, ERP and CRM arena
Experience Summary:
Worked 4+ years in USA, 4 months in Middle East and travelled Singapore /
Malaysia / Hongkong & SriLanka for short term
14+ years of experience in various roles like Director - Technical /
Project Manager / DWH Architect / BA / Technical Lead / Sr. ETL Developer /
SAP Functional Analyst / PeopleSoft Consultant and Sr. Exe Customer Support
In-Charge. Gathered requirements by interacting with end users, analyzed,
modeled requirements and documented as per the CMM standard and managed
application development through User Requirement, Design, Data mining,
Testing, Implementation, Training and Support.
Having excellent experience in Software Development Life Cycle (SDLC)
covering the Requirement Analysis, Design, Testing and Implementation and
very good in coordinating and developing many applications for customers.
Domain Experience: BIDW: Governance & Regulatory / CPG / CFS / Telecom
/Logistics / Semi-Conductor & IT / Healthcare & Life
Sciences / Marketing
HRMS: Payroll, Time & Labor / CRM: Air Travel Reservation &
CRS.
Soft Skills:
> Ability to work well in a broad-based inter-departmental team with a
broad spectrum of staff (Architects, Designers, Project / Program
Managers, Customer & Stakeholders, QA and Functional Managers)
> Strong leadership and decision-making skills.
> Ability to take both technical direction, make technical decisions and
ability to negotiate to develop win-win situation.
> Excellent customer management, strong negotiation and business
communication skills.
> Excellent self-management skills to work independently with minimal
supervision, collaborative, imaginative, resourceful, and reliable
technology savvy.
> Developed, modified, maintained distributed project documentation,
project communications and inter-team knowledge transfers.
> Ability to manage projects aligned with business and IT strategy and
in compliance with the organization's architectural standards like SEI-
CMM, 6?, ISO, PMP and other International Quality Standards.
> Worked on Onsite - Offshore and vice versa.
> 10+ years of experience in Project Management.
> 8+ years of work experience in DWH / BI with Informatica / BO.
> Capable of leading / build DWH / BI Practice.
> Good knowledge in Data Warehousing Concepts (Kimball and Inmon data
warehouse philosophies, STAR, Snow Flake Schema and Galaxy Schema,
Staging area, SCD Type 1, 2, 3, Granularity, Dimension, Confirmed
Dimensions, Fact & Factless Fact), Dimensional Modeling, Physical &
Logical Designs.
> Proficient in Informatica Power Center 6.x / 7.x / 8.x.
> Worked on heterogeneous sources, developed common reusable
transformations and Mapplets logic to reduce the cost of Development
time & efforts.
> 10+ years of experience in different databases like Oracle, SQL
Server, DB2 and MS-Access2000.
> 7+ years of experience in Data Modeling (CA-ERWin / MS-Visio).
> Experienced in using TOAD, PL/SQL Developer and Win SQL.
> Worked in HP Quality Center Site admin / Requirements / Test Plan /
Test Lab Modules.
> Worked in IBM Web Logic Web Content portal services...
> Working on Cognos Cloud for JNJ, Belgium.
Technical Skills:
> DBMS & RDBMS: Oracle 7.x / 8.x / 9.i / 10g, SQL Server 2005, DB2, Access
and Foxpro-2.5.
> ETL: Informatica 6.x / 7.x / 8.x, Designer / Workflow Manager / Workflow
Monitor / Repository Manager
> ETL: BO Data Integrator 11.5-XI R2 / Designer / Microsoft DTS / SAS EG
4.3
> BI: Crystal 8, Cognos 10.1.1 / 8.4 / Framework Manager / Report Studio /
Query Studio,
> Tools: Toad, Win SQL 5.0, ER Win 3.0, 4.0, Visio, and UML Enterprise
Architect, IBM Web Logic Web Content.
> MDM: Stratature - EDM 4.1 (Microsoft)
> ERP: SAP ver.4.6 C HR ASAP Methodologies / People Soft ver.7.5 / 8.0 HRMS
> (People Tools, People Code, SQR, Application Engine, PS-Query, Data
Mover, Import Manager, Security Administrator)
> Testing: HP Quality Center ALM 11, QTP 9.2
> O/s: Windows Family, UNIX and Dos / Packages: MS-Office & Adobe.
Education:
MCA (Master of Computer Applications, University of Madras)
B.Com (Bachelor of Commerce, University of Madras)
Member: Project Management Institute (PMI)
Accomplishments:
Awarded by CEO for EOQ (Employee of the Qtr - Jul - Sep'12) in Technosoft
Global, India
Prepared / Posted DW/BI paper in Oracle Open World 2012 conference
Conducted DWH / BI training very often in previous organization
Successfully completed PeopleSoft to SAP ERP Migration in YASH Inc
Successfully completed ISO-19011-2002 and secured Internal Auditor
Certification in Prolease.
Awarded by VP for Best Employee in Allsec India
Successfully implemented Legacy ERP in M/s. Shri Renuga Textiles Ltd, India
Professional Experience:
Technosoft Global, India since Jul'12
Sr. Architect - DWH / BI
Project: Q-GRAMM (Global Regulatory Affairs Metrics Management)
This is a Data Warehouse / Business Intelligence project. This project
consists of Data mart / Data Warehouse. It helps to identify the
Regulatory affairs throughout the world for Quintiles / J&J, to make the
business view better and helps to identify potential product and make the
business concentration & growth in those areas.,
Job Involved:
> Developed new data models that support the ongoing growth of the business
ensuring that model approvals.
> Overseen all technical aspects of the company's BI Development.
> Review the existing product range and, through value-engineering, look
for opportunities to reduce costs / improve efficiency.
> Leading / Working on BI Development and Delivery.
> Architecture Design and Planning
> Cognos Framework Model Design
> Represented Solution to Prospects at Events
> Done POC / Prototype data models (Quintiles, USA / Johnson & Johnson,
Belgium)
> Taking care of Pre-Sales activities / proposals.
Environment: Cognos 10.4 BI on Cloud (Report Studio, FM), Oracle 9i, Pl-Sql
Developer, Windows XP Professional.
PDS, India Jan'10 - May'12
Director - Technical
Job Involved:
> Developed new data models that support the ongoing growth of the business
ensuring that model approvals.
> Overseen all technical aspects of the company's Development and QA
processes.
> Review the existing product range and, through value-engineering, look
for opportunities to reduce costs / improve efficiency.
> Foster a workplace culture amongst the technical team that inspires
performance and is generally more outward looking.
> Development and Delivery of Product Demonstrations
> Customer Evaluation and Implementation
> Technical Writing and Solution Training
> Architecture Design and Planning
> Represented Solution to Prospects at Events
> Designed POC / Prototype data models
> Taken care of Pre-Sales activities / proposals.
Project: Fertilizers
Client: PIC, Kuwait Jan'10 - Dec'10 PM /
Data Warehouse Architect
PIC is a State Government Petroleum Company with many subsidiaries and
divisions; it's called as K companies in Kuwait It's an onsite -
offshore project and right now it went live and I am supporting from
offshore since May'10.
This is an end-to-end Data Warehouse / Business Intelligence project. This
project consists of 6 Data mart's in the DWH. It helps to identify the
Product wise Production / Costing / Failures / Exports / etc, to make the
business view better and helps to identify potential product and make the
business concentration & growth in those areas.,
Job Involved:
> Studied the as-is business process and gathered system requirements by
interacting with SME.
> Worked on Data Stage 8 client tools.
> Created folders, user groups and users within them and assigning
selective privileges.
> Implemented CDC for complex fact tables.
> Informatica Mappings Optimized for performance and data movement
scheduled.
> Involved in managing Informatica backup and restores.
> Mentored EDW team in their ongoing development issues, best-practices,
performance tuning etc.
> Prepared Unit Test Cases and validated in line with design.
> Created Frame Work Model (Star Schema).
> Designed various types of reports like List, Drill-through, Cross-tabs,
Column charts & Bar charts.
> Developed Detail and Summary reports based on management hierarchy with
Drill Down and Drill through capability.
> Developed reports using Master Detail Relationship.
> Developed prompted reports using different prompts like Value Prompt,
Date and Time prompt etc.
> Developed reports using Conditional Layouts and condition expression like
String Variable and Boolean Variable.
> Enhanced Existing Reports as per change request.
> Bursted reports based on hierarchy and groups. Bursting reports, event
handling, scheduling jobs using CRN
> Tested newly developed reports & enhanced existing reports.
> Maintained documentation for each activity process.
> Prepared proposal for KSE and got the deal too.
Environment: Data Stage 8, Cognos 8 BI (Report Studio, FM), Oracle 10g,
Toad, Visio, Maximo, Microsoft Project Server, Windows XP Professional.
Global Cynex Inc, VA, USA Feb'06 - Dec'09
Architect / BA / PM
Client: Guthy-Renker, Palm Desert, CA Aug'08 - Sep'09
ETL / Data Warehouse Analyst
Established in 1988, Guthy-Renker is today one of the world's largest
direct response television / advertising companies with sales of more than
$1.8 Billion per year and an average annual growth rate of 25% over the
last 10 years. Their marketing products are Victoria Principal, Proactiv,
Principal Secret, Sheer Cover, Meaningful Beauty, and the list
continues
Project: FR
This project is all about Financial Returns; we build a data mart which
contains all sales and financial transactional data's. This data mart
provides all information about total sales, refunds, returns, claims,
adjustments by product, year wise. This helps to make vital decision.
Job Involved:
> Studied the as-is business process and gathered system requirements by
interacting with SME
> Worked on Informatica Power Center 8.1 client tools
> Created folders, user groups and users within them and assigning
selective privileges
> Implemented CDC for complex fact tables
> Informatica Mappings Optimized for performance and data movement
scheduled in Informatica Workflows.
> Done Data Masking using Data masking tool.
> Data Masked for precaution from a business security standpoint and in
many cases it was a legal obligation.
> Defined Rules sets for Data Masking to run as and when necessary
> Involved in managing Informatica backup and restores
> Mentored EDW team in their ongoing development issues, best-practices,
performance tuning etc
> Monitored and identified long running queries and reported to optimize
data warehouse design and query performance
> Monitored and provided visibility to who uses which data at what time, to
identify dormant and unused data
> Identified what data is used by which departments to prioritize resources
> Prepared Unit Test Cases and validated in line with design
> Created Frame Work Model / Reports in Cognos as per the requirement (List
/ Cross Tabs)
Environment: Informatica PowerCenter 8.1.1, Cognos 8.3, Oracle 10g, Net
2000, Toad, Visio, Microsoft Project Server, Windows XP Professional.
Client: Microsoft, Sammamish, WA Jun'08 - Aug'08
Business / Data Warehouse Analyst
BI COE
Project: Stratature - EDM
Microsoft has acquired privately held Stratature, a company that
specializes in so-called master data management software. As a result of
the acquisition Microsoft will build master data management tools into its
Office System line. The move complements the company's strategy to bulk up
the business intelligence tools in Office and SQL Server.
Job Involved:
> Studied the as-is business requirement document which was prepared by SD,
updated the earlier version of Functional Specification and preparing
Functional Specifications for version 2.0 (Planning Hierarchy)
> Served as a liaison between SD, Dev, Testing and OPS in order to
implement corporate requirements
> Mastered Finance as part of Master Data Management
> Done POC for the requirements which is / was sent by SD (Solution
Delivery)
> Communicated effectively with all users, at different levels of hierarchy
for all EDM related queries
> Done Data analysis, Cleansing & Profiling)
> Implemented Change Data Capture for Planning Hierarchy
> Created Functional Specification and Test Plan
> Done Unit Test Cases / Test results reviews
Environment: Stratature - EDM, SQL Server 2005, Visio, Microsoft Share
Point, VSTF, Windows XP Professional.
Client: Saber, Columbia, SC Jan'08 - May'08
Sr. Informatica Consultant / Arch
(EDS Company)
Incorporated in 1997 and headquartered in Portland, Oregon, Saber has been
focused on delivering premier services to State and Federal Government.
Saber is the one of the State and Federal Government projects implementer.
Some of their projects are Elections, Public Retirement Systems, Enterprise
Health, Human Services, Unemployment Insurance, Motor Vehicles, Tax and
Revenue, Justice, and Information Technology Outsourcing (ITO).
Project: CFS (Child Support Education System / Family Court System)
It's a migration project for SC State Government. This project is more
related to Child Support and Family Court. They are moving to the new
application in .Net from their old application which was developed 30 years
back (QS/1).
Job Involved:
> Studied the as-is business process and gathered system requirements,
prepared documents and standards
> Done Physical Data / Logical Design Model through ER Win
> Coordinated the development effort with the system designers and
developers
> Now the entire migration process in place and it's very helpful for the
new person who ever step in to the project
> Used SSIS client tools to migrate data's from flat files to SQL Server
2005
> SSIS Mappings Optimized for performance and data movement scheduled
> Designed mappings in such a way to do Cleansing and Profiling after data
extraction from flat files
> Designed to capture Meta Data for auditing and reporting purpose
> Done Unit Test Cases and validated in line with design
> Done SOC, UTP, UAT and changes as part of CFS
Environment: SSIS, DTS, SQL Server 2005, DB2, Visio, Microsoft Share Point,
QS/1 Mainframe, Windows XP Professional.
Client: Level-3 Communications, Broomfield, CO Jun'07 - Nov'07
Lead - Informatica Consultant
Level 3 is an international communications company headquartered in
Broomfield, Colorado. The company operates one of the largest
communications and Internet backbones in the world.
Founded in 1998, Level 3 has been focused on delivering premier services
over one of the world's most advanced, IP-optimized networks. Level 3 owns
and maintains approximately 48,000 intercity route mile. We offer a
comprehensive portfolio of network offerings that spans Internet Protocol
(IP) services, broadband transport, Colocation services, and patented
Softswitch-based managed modem and voice services.
Project: Disconnect
It's a migration project for Level -3. They acquired several companies and
it's more of consolidation of data and retiring the systems (Clarify 6.3,
Wintel, Looking Glass, Network Engineer, etc,).
Job Involved:
> Studied the as-is business process and gathered system requirements by
interacting with SME
> Served as a liaison between deployments, COE, offshore team, and
functional team in order to implement corporate requirements for our
Onsite - Offshore project Model
> Coordinated the development effort with the Data Modeler, system
designers and developers
> Communicated effectively with all users, at different levels of hierarchy
and provided technical support for all migration related queries
> Worked on Informatica Power Center 8.1 client tools
> Extracted data from legacy Sources, XML & Flat files transformed and
loaded into Oracle and Flat files Targets using Power Center
> Implemented CDC for complex fact tables
> Designed to capture Meta Data for analyzes
> Informatica Mappings Optimized tuned for performance
> Data's transformed from Source to Target (Cleansing, Profiling)
> Prepared Unit Test Cases and validated in line with design
> Done SOC, UTP, UAT and changes as part of Disconnect
> Created Frame Work Model (Star Schema)
> Designed various types of reports like List, Drill-through, Cross-tabs,
Column charts & Bar charts
> Developed Detail and Summary reports based on management hierarchy with
Drill Down and Drill through capability
> Developed reports using Master Detail Relationship
> Developed prompted reports using different prompts like Value Prompt,
Date and Time prompt etc
> Developed reports using Conditional Layouts and condition expression like
String Variable and Boolean Variable.
> Enhanced Existing Reports as per change request
> Bursted reports based on hierarchy and groups. Bursting reports, event
handling, scheduling jobs using CRN
> Tested newly developed reports & enhanced existing reports
> Maintained documentation for each activity process
Environment: Informatica Power Center 8.1, Cognos 8 BI (Report Studio, FM),
Siebel 7.8, Clarify 6.3, Kenan, Oracle 9i, SQL Server 2005, DB2, Toad,
Visio, Microsoft Share Point, and Windows XP Professional.
Client: Schneider National, Green Bay, WI Jan'07 - May'07
Lead - DWH Consultant / BA
Schneider National - leading provider of premium truckload and Intermodal
services. Schneider solutions include: One-Way, Intermodal, Dedicated,
Bulk, Transportation Management, Transloading Services, International
Services and Schneider Payment Services. Schneider National has a 70-year
track record of providing expert transportation and logistics solutions,
Schneider National serves more has 80 percent of the Fortune 500 companies,
offering the broadest portfolio of services in the industry.
Schneider operates 14,000 tractors, 40,000 trailers and has partnerships
with over 6,000 carriers with 36 locations in North America, Canada, China,
Mexico & the Netherlands with headquarters in Green Bay, Wisconsin.
Schneider covers more than five million loaded miles per day. Schneider
annual sales are $3.0 Billion; it has 20,000 associates, 15,000 drivers and
independent contractors.
Project: Intermodal
This mart was very much helpful to find out the exact arrival of the box in
the destination and helpful to deliver the box on time and avoid the ramp
detention too.
Project: Ramp Detention
To find out exactly how long it was in the ramp after reach the
destination. Hence the system was not in place this mart will helpful to
calculate the Detention charges.
Project: CSC Analytics
This mart helps to find out the CSR call duration, LPD by each client and
person, target achievers, commitment towards delivery. It will be used as
substitute during Siebel downtime.
Job Involved:
> Studied the as-is business process and gathered system requirements by
interacting with SME & solution recommendation
> Handled multiple projects and served as a liaison between deployments,
COE, offshore team, and functional team in order to implement corporate
requirements for our Onsite - Offshore Model project
> Coordinated the development effort with the Data Modeler, system
designers and developers
> Managed client expectations and responsible for final deliverables within
the specified scope, budget and time.
> Done Peer-Review for other projects
> Communicated effectively with all users, at different levels of hierarchy
and provided technical support for all migration related queries
> Created Dimensional and Facts in the Physical Data Model through ERWin
> The EDW contains 60 Data Mart which was Star and Snow Flake Schemas
> Done Source to Target GAP Analyses and prepared Mapping Specification.
> Defined conversion process to transform the data from Source to Target
(Cleansing, Profiling)
> Extracted data from legacy Sources, XML & Flat files transformed and
loaded into Oracle and Flat files Targets using Power Center
> Done CDC for complex tables based on dates
> Used PVCS for version control management and ensured documentation is
common and accessible to everyone in the organization
> Worked with pmcmd to interact with Informatica Server from command mode
and executed the shells scripts.
> Prepared Unit Test Cases and validated in line with design. Done SOC, UTP
& UAT as part of project
> Conducted Survey on Project Research & Analysis on post implementation
for user rating
> It's an End - to - End Enterprise Data Warehouse and Business
Intelligence Project
> Created Frame Work Model (Star Schema)
> Designed various types of reports like List, Drill-through, Cross-tabs,
Column charts & Bar charts
> Developed Detail and Summary reports based on management hierarchy with
Drill Down and Drill through capability
> Developed reports using Master Detail Relationship
> Developed prompted reports using different prompts like Value Prompt,
Date and Time prompt etc
> Developed reports using Conditional Layouts and condition expression like
String Variable and Boolean Variable.
> Enhanced Existing Reports as per change request
> Bursted reports based on hierarchy and groups. Bursting reports, event
handling, scheduling jobs using CRN
> Tested newly developed reports & enhanced existing reports
> Maintained documentation for each activity process
Environment: Informatica PowerCenter 7.1.3, Cognos 8 BI (Report Studio,
FM), Siebel 7.8, Oracle 9i, DB2, Toad, PVCS, Visio, UNIX, Windows XP
Professional.
Client: Microchip, Chandler, AZ Sep'06 - Dec'06
Sr. ETL Developer / BA
Microchip - leader in Semi-Conductor industry. It's founded 18 years ago.
The annual sales are $267.9 Million, Operating Income was 91.3 Million and
Net income are 84.2 Million. It has business operations in America, Asia
and Europe. Microchip is ranked #66 on the 2006 Arizona Top 100 list with
2,000 employees.
Project: Adexa
This mart provides multi-line Vendor details by daily basis. The data
consolidation at Global Vendor level and the development of ETL procedures
to load the data in to the Adexa MDM data mart
Job Involved:
> Studied the as-is business process and gathered system requirements by
interacting with SME & solution recommendation
> Done Source to Target GAP Analyses and prepared Mapping Specification
> Coordinated the development effort with the Data Modeler, system
designers and developers
> Communicating effectively with all users, at different levels of
hierarchy and provided technical support for all migration related queries
> Managed client expectations and responsible for final deliverables within
the specified scope, budget and time
> Worked on MDM (Master Data Management)
> Defined conversion process to transform the data from Source to Target
(Cleansing, Profiling)
> Extracted data from Sources like Adexa and BaaN transformed and loaded
into Oracle Targets using Data Integrator 11.5 client tools
> Done Mapping Optimization, Tuning, Unit Test Case, SOC, UTP and UAT
documentation
> Used VSS for version control management
> Used Share point for publishing documents and knowledge sharing
management
Environment: Business Objects Data Integrator 11.5-XI R2, Oracle 9i, SQL
Server 2005, PL/SQL Developer, VSS-Ver.8.0, BaaN-MRP, Adexa-SCM, Microsoft
Share Point, Windows XP Professional.
Client: Cardinal Health, Dublin, OH Mar'06 - Sep'06
Sr. ETL Developer / BA
Cardinal - leader in HealthCare industry. It's opened its doors 35 years
ago. The annual sales are $74.9 Billion, operating income are 1.24 Billion
and business operations in six continents. Cardinal Health was ranked #19
on the 2006 Fortune 500 list, #2 in its category on the 2006 list, Fortune
100 Most Admired Companies with more than 55,000 employees.
Project: DSA MDM provides multi-line Vendor details by daily basis. The
project entailed with design, implementation of reporting data mart,
analysis and sourcing. Then Global consolidating at a Vendor level and the
development of ETL procedures to load the data in to the DSA MDM data mart
Project: Emptoris provides multi-line Unit (Product, Location) details by
Monthly basis. The project entailed with design, implementation of
reporting data mart, analysis and sourcing. Then Global consolidating at a
Unit level and the development of ETL procedures to load the data in to the
Emptoris data mart
Job Involved:
> Studied the as-is business process and gathered system requirements by
interacting with SME & solution recommendation
> Done Source to Target GAP Analyses and prepared Mapping Specification
> Coordinated the development effort with the Data Modeler, system
designers and developers
> Communicated effectively with all users, at different levels of hierarchy
and provided technical support for all migration related queries
> Managed client expectations and responsible for final deliverables within
the specified scope, budget and time
> Worked on Emptoris / MDM (Master Data Management) and Facets datasets,
Rosetta Data marts
> Extracted and transform policy and member medical benefits information
from a Trizetto Facets database into an Operational Data Store
> Extracted then aggregated out-of-pocket and overall lifetime benefit
accumulations from two legacy mainframe claims administration systems (BEN
and CompuTrak). Applied Facets benefit configurations at a policy-division-
class-product level. Loaded Facets-ready ABI keyword records. After
import, the success and resubmit logs are evaluated through Informatica to
reconcile the import results with the staged records
> Designed, built, and deployed an Accumulator Threshold Mart to track the
results of conversion efforts, including post-conversion changes to
benefit configurations and adding or removing members. When members meet
or exceed benefit maximums in Facets, the Threshold Mart records this
event for the business to evaluate. The accumulator contribution from
Legacy is included in the Mart and used to determine whether manual
adjustments are necessary to Legacy to remain synchronized with Facets.
Complex business rules are implemented to handle one and two-way cross-
apply, carry-over, plan year vs. calendar year, and coordination of
benefits
> Analyzed facets data like claims, billing to resolve related subject
areas issues
> Used Facets application to open, add generations, enter and save
information
> Created Dimensional and Facts in the Physical Data Model through ER Win
> Worked on Power Center 7.1.3 client tools Designer, Workflow Manager,
Workflow Monitor
> Defined conversion process to transform the data from Source to Target
(Cleansing, Profiling)
> Extracted data from legacy Sources, XML & Flat files transformed and
loaded into database and Flat files Targets using Power Center
> Used shortcuts to reuse objects without creating multiple objects in the
repository and inherit changes made to the source automatically. It
reduced the cost of Development time
> Mapping was designed in such a way to capture Meta Data for analytics
purpose
> Used extensively Stored Procedure for creating/dropping of constraints
> Used Workflow manager / Monitor for Workflow, Session Monitoring, and
database connection
> Worked with pmcmd to interact with Informatica Server from command mode
and executed the shells scripts.
> Done Unit Test Case, SOC, UTP, UAT and changes documentation
> Moved mappings from Development to Stage
Environment: Informatica PowerCenter 7.1.3, Oracle 9i, SQL Server 2005,
DB2, TOAD, Putty, UNIX, Windows XP Professional.
YASH Inc, Hyderabad, India Oct'05 - Feb'06
SAP HR Functional Analyst
YASH Inc is an implementer, solutions provider for ERP, CRM, SCM, EAI, BI,
Security Solutions and QA Testing. YASH is a COE for SAP, Oracle,
Portals, Actuate, Interwoven, Sun-J2EE, Microsoft.Net and Alliances with
SAP, Actuate, IBM, BEA, Oracle, Mercury Interactive, Interwoven, Microsoft,
SecureNet Ltd, Scalar USA, CA. YASH has proven competence in verticals
such as Manufacturing, Chemicals, Financials, Retail and Distribution. Its
regional operations include North America, Northern Europe & Asia Pacific
and Middle East.
Project: It's a PeopleSoft HRMS to SAP HR migration Project for Terra
Industries, USA. The entire PeopleSoft HRMS system migrated to SAP HR
(Process and Database).
Job Involved:
> System Study
> Migration Planning from PeopleSoft HRMS to SAP HR
> Migration Planning from Ingress to Oracle database
> Mapping of PeopleSoft Process to SAP Process
> Prepared Templates for Data Migration
> Worked offshore - onsite modal
Environment: PeopleSoft HRMS, SAP HR, Informatica 6.0, Power Connect, DFx,
Visio, Ingress and Oracle 8.x.
Medisoft Solutions, Mysore, India May'05 - Oct'05
Business Analyst
Medisoft is MOG Business Group and concentrating in various segments like
Total Payroll Solutions, Medical Transcription, Data Conversion, Networking
Infrastructure and eBusiness.
Job Involved:
> Setup a Payroll Outsourcing Division
> Prepared Project Report from scratch till UAT signoff in Payroll
> Managed a team of 40 people in Payroll & 10 in Technology
> Conducted seminars & organizing Interviews for various divisions
> Prepared Brochure, Questionnaire, RFQ, PPT, Client Demo and finalization
of Payroll Outsourcing Leeds
> Web