PROFESSIONAL SUMMARY:

• A solid reputation built around a proven track record of over 14 years successfully contributing technology solutions & people skills in diverse business environments.
• Hands on Experience in Architecture design of Extraction, Transformation & Loading Environment using Data Services.
• Experience with SAP EIM suite including Data Integration, Data Quality Management, Metadata Management, and Data Insight / Profiling, Knowledge of Business Objects Enterprise (Web Intelligence and Desktop Intelligence.
• Hands on SAP BO Designer, Repository management, and Management console in Business Objects 3.1, 3.2 and 4.0
• Experience designing ETL flows, data cleansing, parsing, matching, and auditing
• Designed JOBS Workflows, Data Flows, scripts and executing jobs to extract data from a variety of data sources, transform the data, and load the data to specified destinations using BODS.
• Experience in loading Master & Transactional Data from Various sources to SAP ECC.
• High Level Competence in Web Based and Client Server Applications blended with excellent business partnership skills applying strategic thought process and being committed to deadlines.
• Expertise in design and development of web centric Object Oriented applications using C#,VB.Net, Microsoft Visual Studio.NET, XML, XSLT, IIS, PL/SQL, SQL, WCF, WPF, Web Services, Web logic, Entity Framework, XML, XSLT, SOAP, HTTP, SMTP, UML, Crystal Reports, SSRS, C++, C, JavaScript and HTML,SOAP, HTTP, C++, C, JavaScript and HTML.
• Experience in generating reports using SSRS and SAP Crystal Reports.
• Experienced in Object - Oriented analysis and design, OOAD Techniques, developing Use Cases, Interaction Diagrams (Use case, Sequence and Class diagrams)
• Developed complex applications using .Net Framework, C#, COM/DCOM/COM+
• Worked with ADO.NET, ADO (ActiveX Data Objects), DAO (Data Access Objects), and ODBC (Open Database Connectivity) database connection technologies
• Experienced in design and development of RDBMS using Oracle, SQL server.
• Experience in Query Optimization.
• Well versed Experience in Developing Enterprise Caliber Objects(ECDO’s)
• Well versed Experience working on Silk Central Tool.
• Team player with excellent skills in business partnership, technical leadership and team building.

TECHNICAL SKILLS:

Hardware Platforms: Intel Pentium based PCs onwards

Operating Systems: Windows 2003,Windows XP, Windows 2000 Professional

ETL Tools: Business Objects Data Services (4.0/3.2/3.1)

Programming Languages: C#, VB.NET, ASP.NET, ADO.NET, WCF, WPF, XML, XSLT, XPATH, C, C++, SQL, PL/SQL

Databases: SQL Server 2000,SQL Server 2005,ORACLE 7.x, 8.x, 9.x, 10 G, MS-Access, TOAD, Oracle J Developer, and PL/SQL Developer, SSIS

Web Technologies: HTML, AJAX, XML, XSLT, XPath, JavaScript and VB Script

Other S/W Tools: Visual Studio for .NET, Clear Case, PVCS-Dimensions, MS VSS, Surround SCM, ImageWriter, Test Track Pro, Silk Central, Crystal Reports, SSRS

Application Servers / Web Servers: IIS

Protocols: SOAP, HTTP, FTP, SSL, SMTP, SNMP, Web Services

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

Responsibilities:

• Interaction with the Business Users to analyze the source data and gather requirements, technical specifications in migration of the data to the target SAP system
• Migration of data from the legacy Order Management System (OMS) to the new SAP R/3 ERP 6.0.
• Staging the source data into Data Services Engine from SQL server, flat files and Excel spread sheets implemented necessary transformations to transform as per the target SAP architecture and loaded into the SAP R/3 system using the Idocs and custom load files.
• Worked extensively in Data Analyzing, Data Profiling, Data Validation and data reconciliation.
• Involved in Data Cleansing, De-duplication and Data Enhancement activities to enrich the Master and Transactional data.
• Created complex source to target data mappings as a part of building the design according to the mapping requirements.
• Built and Unit tested the jobs for migrating objects using SAP Business Objects Data Services following the AIO best practices to load Master and Transactional data objects into SAP ECC.
• Extensively used Lookup ext, Lookup seq and also created custom functions.
• Used Global variables, Local Variables and Parameters between Work flow and Data flow as per mapping requirements.
• Performed the Correctness test by running the DS jobs and validated the results by comparing the data from the test results of original legacy data.
• Tuned and monitored Data Services Jobs and Transformations for the better performance of jobs.
• Migration of jobs between different Central repositories and executed from Central Management Console as a part of different loads.

Environment: SAP Business Objects Data Services 3.2, Data Quality, SAP R/3 ERP 6.0, Flat files, SQL Server 2008.

Confidential, Des Moines, IA

Lead

Responsibilities:

• Work with business partners including BA's, subject matter experts to analyze & prioritize requirements and specifications including filling gaps as necessary
• Lead and support various design and development activities.
• Build BODS jobs for Vendor Master, SD Pricing, PIR, Account Payables and Source List to load the Data into SAP.
• Built Jobs with Validation, Error Handling and Reconciliation capabilities.
• Involved in Data Cleansing, De-duplication, Data enhancement activities to enrich the Master and Transactional Data.

Confidential, West Des Moines IA

Responsibilities:

• Work with business, subject matter experts to analyze & prioritize requirements and specifications including filling gaps as necessary
• Lead and support various design and development activities for the web pages
• Write unit test cases and perform unit testing
• Write Packages and store procedures using Oracle.

Confidential, Des Moines, IA

Sr. Programmer analyst

Responsibilities:

• Define and validate physical system requirements.
• Analyze business and system requirements, including impact analysis on existing systems, to develop systems specifications.
• Develop .NET assemblies using C#
• Deploy code to production Internet Information server (IIS) using release process.
• Connecting to SQL Server database using ADO.Net objects.
• Created tables and stored procedures in SQL Server database.
• Testing the application before deployment.
• Develop stored procedures for SQL server database using TSql.
• Coordinate as a senior software developer management/tracking of technical issues, risks, and change requests and Participate in design reviews.
• Responsible in writing pacakages using Oracle 9i.
• Responsible in writing & executing the Unit test cases

Confidential, Desmoines, IA

Sr. Programmer/ Analayst

Responsibilities:

• Involved in writing components that facilitate the corporate to configure the Sapphire Application utlizing WebLogic, IDL
• Worked on a crucial part ‘Lender ’, which is used to set up Business units, Departments, Dual Codes, TimeZone Information, Products, Insurance products and Reporting Units for the business at different levels namely Region, Divison, District, Branch, HomeOffice etc.
• Wrote and tested Interfaces utlizing the CORBA specifications architecture
• Involved in different phases of development, design & implementation through solution writing and coding
• Utilized RationalRsoe to get the persistence classes information and for coding and design implementations.
• Used UML, ExpertFrame for modeling

Confidential, Fort Lauderdale, Florida

Senior Developer Analyst

Responsibilities:

• Worked with user requirements to produce development specification & development design
• Visual Basic (6) applications development (forms, classes, controls)
• Oracle (8.05 for NT) database design (tables, packages, stored procedures, functions).
• Design Review (design validation, optimization, and review for omission).
• Responsible for reporting development using Crystal Reports 7.0.
• VideoSoft VS FlexGrid 6 & 7
• Design and development of Enterprise Caliber Data Objects using Asp3.0, HTML, VbScript, Visual Interdev, MTS, COM, DCOM, COM+

Confidential

Responsibilities:

• Responsible for the design and development of Various Screens.
• Designed and developed reports using Crystal reports to assist different levels of Management in analysis and decision-making.
• Used SQL * Plus to design tables
• Used DAO’s to handle database
• Used OLE objects to Connect to Office tools
• Performed coding and testing for individual screens.
• Introduced Specific Query tables in the system, which has greatly enhanced the system’s query capabilities.

Confidential

Responsibilities:

• Responsible for the design and development of Various Screens.
• Designed and developed reports using Crystal reports to assist different levels of Management in analysis and decision making.
• Used SQL * Plus to design tables
• Used DAO’s to handle database
• Use OLE objects to connect to the Ms Office tools
• Performed coding and testing for individual screens.

Confidential

Responsibilities:

• Responsible for the development of Various Screens.
• Developed reports using Crystal reports for generating various reports to assist different levels of Management in analysis and decision making.
• Used SQL * Plus to design tables
• Performed coding and testing for individual screens.
• Given Imparted to the End users.
• Used OLE to connect to the Office tools

Confidential

Responsibilities:

• Responsible for the development of Various Screens.
• Developed reports using Crystal Reports for generating various reports to assist different levels of Management in analysis and decision-making.
• Used SQL * Plus to design tables
• Performed coding and testing for individual screens.
• Given imparted to the End Users