Professional Summary

• Creative problem solver with significant experience in leading organizational change through implementation of information technology. Customer service oriented with strong communication and analytical skills. Exceptional abilities in project design and management with the organizational and supervisory skills to assure success. Delegates and monitors work to meet and beat deadlines. Tendency to thrive in dynamic and fluid environments while remaining pragmatic and focused.
• Leverages knowledge of data warehouse and software development methodologies to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines.
• Builds ETL architecture and provides guidance to ETL developers on the best practices to handle high volumes of data.
• Expert at Data Provisioning and Data Modeling
• Experienced in reporting techniques such as creating calculation views, managing attribute mappings, creating analytic privileges, adding variables, using system generating joins.
• Provides knowledge transfer to IT users.
• Develops a collaborative working relationship with clients.
• Works with project managers, SAP's offshore and partner consultants to develop consulting and project methodology, techniques, tools, and solutions.
• Responsible for SAP Data Services development.
• Analyses data contained in source/target databases.
• Resolves technical issues and implement code modification needed to support changing user requirements for multiple data services jobs.
• Besides BOBJ Data Services BODS , I also use SAP Landscape Transformation SLT for real time replication.
• Developing and delivering, executive level, sales-oriented and technical presentations
• Works with different types of reporting tools: Excel, BO Explorer, BO Crystal Reports, Dashboard.
• Created many Analytic and Calculation views with hierarchies, measures, variables.

Confidential

Business Impact Analysis

• Expert in CranSoft tools and security.
• Designed and developed ETL solutions using SAP Data Services as well as Cransoft.
• Developed ETL jobs, Work Flows, Data Flows and other Data Services components.
• Worked extensively with EZMap , CranSoft DataConstructionServer WebApp development , BackOffice Data StagingWarehouse DSW , and BDCdirect .
• Expert in BDC and LSMW.
• Worked in creating Profit Center, Cost Centers, Cost Elements, Activity Types, Statistical Key Figures, and Internal Orders.
• Expert in SQL Server 2005/2008.
• Used several BackOffice functions to modify data.
• Created Hierarchies for Profit Center, Cost Center, Statistical Key Figures, Cost Elements, Activity Types, and Account Groups SETHEADER, SETHEADERT, SETNODE SETLEAF .
• Created target and source rules and validation reports for multiple sources for all assigned objects.
• Created Remediation rules at target level.
• Worked with DataGarage to manage the Legacy sources.
• Created Target Export to be used by BDC and LSMW in SAP ECC 6.0.
• Worked extensively with several SAP Transactions in FICO.
• Expert in creating DTS and SSIS packages in SQL Server.
• Created several WebApps to accommodate data construction for many objects.
• Created rules for several fields including zRelevant, zSource, and zLoaded zInSAP .
• Configured several applications in CranSoft for optimal performance.

Confidential

• Migrated all customer master objects from R3 into ECC including, Customer Contacts, Sales Information, Loading Points, Tax Grouping, Tax Indicator, Bank Details, Partner Functions, Shipping Data and Sales Data.
• Utilized SAP Data Services as an ETL tool for various objects.
• Conducted several meetings with clients to help them formulate conversion rules for each field.
• Used LSMW as the standard data loading method.
• Created complete set of rules for the objects where EZMap was not used.
• Utilized EZMap 5.3.1 extensively to generate automated rules and modified the complex ones as well as created several target level rules.
• Researched to find out the errors in customer master configuration.
• Created reports for customer address cleansing, including de-duplication, finding inconsistencies between addresses.
• Created several Web-apps to support client in their data cleansing activities.
• Created many Cranport packages for movement of data.
• Optimized DataGarage for automation and ease of use.
• Expert in SQL Server 2008, New CranSoft Tool 4.5, CranPort , SSIS Packages to replace DTS packages , Stored Procedures, and editing DTS Packages in SQL Server 2008.
• Provided expertise in testing the training server, Software, and Training documentation.
• Created all validation reports for General Ledger, Accounts Payable, and Accounts Receivable.
• Imported tables from the legacy to the source in DataGarage .
• Created detailed documentation with extensive data analysis for every procedure to help client better manage their data.
• Scheduled batch process to run on weekly basis.
• Worked extensively with BackOffice Data StagingWarehouse DSW , DataGarage , BDCdirect , and LSMW.
• Created views and Stored Procedures, as well as other BackOffice Functions in SQL Server 2005 for many different Rules and Validation reports.

Confidential

• Involved in every aspect of Data Conversion from start to Go-Live.
• Worked extensively with CranSoft and SAP.
• Expert in AdeptSQL for CranSoft instance replication.
• Managed Vendor / Quality / APO / CRM objects for data conversion.
• P2P - Extensively worked with P2P objects PIR, Vendor Contracts, Quality Info Records, Master Inspection Characteristics, etc. .
• Worked with SAP Data Services in conjunction with DSW.
• BW/BI Sales History and Obligation data conversion lead
• SCM APO Extensive knowledge of Supply Chain SCM and Advanced Planner and Optimizer APO including Location Master, Product Master, Transportation Lanes, and Product Interchangeability.
• Monitored Core Interface CIF process that replicates Materials and PIRs into APO.
• Inherited other objects including Contact information for complete overhaul and revamp of all sources, targets, rules, and reports.
• Worked with SD Objects, loading Sysco Contacts into CRM and replicating over to ECC.
• Worked with Functional team to update and finalize Functional Specs.
• Led high level meetings to accomplish tasks and derive resolutions.
• Performed CranSoft Toolset training for BackOffice employees and clients.
• Worked with DataFactory associates to bring them up to speed with team objectives.
• Communicated / created messages with SAP to resolve issues related to APO Transportation Lanes.
• Created many Super Sources to accommodate for multiple companies with similar data structure.
• Worked extensively with EZMap , CranSoft DataConstructionServer WebApp development , BackOffice Data StagingWarehouse DSW , and BDCdirect .
• Created SSIS packages in SQL Server 2005 to bring in construction data from disparate sources.
• Developed MS Access application to collect data from business and transport it directly in to DCS tables, minimizing time and effort to populate web applications.
• Extensively utilized BAPI to create and modify LSMW to load object.
• Recorded transactions using SHDB to create a load program for BDC.
• Created many remediation rules at target level.
• Developed Excel documents to collect data from disparate sources to centralize in CranSoft DataConstructionServer .
• Created complex web application in CranSoft DataConstructionServer to collect data for quality objects.
• Expert in CranSoft tools and security.
• Worked extensively with SAP Application Development team to debug SAP programs, including Transportation Lanes BAPI.
• Worked with Security and Basis teams with related issues.
• Created many validation and reconciliation reports for vendors.
• Expert in SQL Server 2000/2005. Used several BackOffice functions to modify data.
• Skilled in HPQC defect management.
• Performed Knowledge Transfer to other BackOffice employees and Sysco counterparts.

Confidential

• Worked extensively with BackOffice Data StagingWarehouse DSW , DataGarage , BDCdirect , and LSMW.
• Experienced in creating DTS Packages, Validation Reports, and Source Rules and Target Rules including Stored Procedures for different Targets and Sources.
• Created DTS packages to migrate data from source files to the source tables.
• Worked heavily with views and Stored Procedures, as well as numerous BackOffice Functions, in SQL Server for many different Rules and Validations.
• Ensured all procedures were well-documented.
• Created a Source Rule to update Order Type zAUART field in stVBAK table for Target ttVBAK in SD Team.
• Created Insert and Delete Rules for many different sources.
• Created all Rules for zOKToLoad and zLoaded for stVBAK table before the data was inserted into the Target Table.
• Created all the Validations for zOKToLoad and zLoaded for stVBAK to verify if the data that had been inserted into Target Table was accurate before the final load.
• Helped to migrate all XREF Source Tables, as well as their source files and DTS packages, from their disparate databases into a new DB called sdbManual to keep up with the new methodology.