SAP BODS Developer

• More than twelve years of professional experience including ten years of IT experience, and more than four years of programming experience in Application development and Application architecture
• More than two Years of Experience as SAP BusinessObjects Data Services Consultant
• Excellent understanding of Application Development LifeCycle and expertise in Data modeling and Data Warehousing using Agile Methodology
• Data Migration and Data Mart development experience to create an Extended Star Schema
• Experienced in creating TYPE I, II SCD (Slowly Changing Dimensions) JOBS
• Well versed in installing, using and extracting data from Oracle and MYSQL Databases
• Experienced in installingBODS XI 3.2 including Client/Server and configuring JobServer, Access Server, Profiler Server and setting up Local, Central & Profiler Repositories
• Expertise in setting up DataStores and configuring using WebAdmin to create User Profiles and User credentials
• Well versed in using Data Services Designer to ETL from multiple sources including Flat Files, Excel workbooks, XML; SAP ECC and third-party tools through DataStore setup and custom transfer program
• Well versed in using Performance Tuning techniques to improve Throughput of data
• Fluent in utilizing Data Integrator and Platform transforms, Variables and functions
• Fluent in SQL Coding using different software tools such as MYSQL Editor, TOAD and Ms SQL Server Management Studio 2008
• Experienced in programming components for ETL Tools and Working with them
• Experienced in using .NET technologies, such as C#, VB.NET, ASP.NET 2.0 and ASP.NET 3.5, ADO.NET, ASP.NET 4.0 and LINQ
• Experienced in making Use Cases and technical diagrams in MS-VISIO and IT-landscape
• Specialized in Designing, Coding and Implementing Drag & Drop functionality for chart diagrams
• Commendable knowledge of XAML
• Microsoft Certified professional with extensive experience in designing and developing applications on the Microsoft .NET platform and Architecture
• Languages proficiency in Dutch, English, German, Hindi and Urdu

BODS:

Installation and Configuration of BODS, Repository configuration and maintenance, WebAdmin/Management Console, Queries in Data Services, MYSQL-Front and MySQl Server, ETL, Data Integration, Data Profiling, Data Modeling, Data Warehouse, Data Conversion, Check-In, Check-Out objects with Central Repository, Work Flow, Conditionals, Data Flow, Query, Transforms, Lookups, Variables, Functions and custom Functions, Data mapping functions and conversions; Publishing jobs as webservice, Proficient in C#, Visual Basic .NET, Active Server Pages .NET, XAML, HTML, XML, Java, JavaScript, Flash, SQL, LINQ To Entity, -to object, -to SQL, SQL plus, LAMDA expressions

Applications:

Adobe Photoshop from 6 to CS 2, VISIO, MS-Office (MS Word, Excel, PowerPoint, Access), Visual Studio 2003/ Visual Studio 2008/ Visual Studio 2010/ SAP Business Objects Data Services Designer, My SQL-Front, Microsoft SQL Management studio

Database:

Microsoft SQL server 2000/2005/2008, MYSQL server 5.1, ORACLE 11g

Platforms:

Windows NT, 2000, XP, Windows Vista, Windows 7, Server 2003, Server 2008, MAC OS, Virtual Platforms Parallels

Methodology:

Interactive Application Development (IAD), Agile, Rational Unified Process (RUP), testing with TMAP, Prince 2, ITIL process, TOGAF

Experience

Confidential, Farmington, CT
SAP BODS Developer

03/2009 - Present

• Implemented Data Mart to handle 30 years of historic data comprising of a volume of around 90 Million records from numerous source systems including mainframe and SAP and building a Type-II Extended Star Schema
• Gathered the requirement and performed Fit/Gap analysis
• Ran the existing Webi reports used by Client pulling data related to product's Warranty, Repair History, Service Contracts, Optional Contracts, Billing & Customer Claims and GL accounts
• Submitted FTE's, Disk Space requirement to the Management for Phase 1 and Phase 2 DW implementation
• Analyzed IMG to understand the Table metadata, Source systems, File Formats, Data Types, Column Names, Field Lengths and schedule
• Worked to optimize the S2T mapping document and documented the transformation logic
• Installed BODS 12.2.2 , MYSQL with the patches
• Completed the configuration of DataStores, Local Repository & its Connections
• Created Developer Profile in Management Console and obtained credentials to connect to BODI
• Imported ATL files for Rapid Mart to be used with SAP ECC
• Wrote SQL statements to create table DDL in staging area, also for Dimension and Fact tables
• Created the ETL Jobs in BODS in a multi-developer environment maintaining versions in CR
• Added SQL Statements, functions and Variables in Initialization and End-job Scripts, created Workflows, DataFlows, IfThenElse Statements and Where Clauses
• Used Formats and Transforms including Flat File formats, Query, Table Comparison, History Preserving, Hierarchy Flattening, Match Transform, Validation Transform, Key Generation and Map Operation.
• Used Auditing and filtering features to analyze the data flow and performed debugging to do Error Management
• Utilized Lookups, Lookup_ext, table Joins, Match, Merge transforms and custom functions
• Utilized Data Profiling including Column and Relationship on tables
• Performed Job Validation and Syntax checks and Dry Run to evaluate for errors, execution time and bottlenecks. Utilized the Debugging function adding Breakpoints, Try and Catch block, Target table Auto-Correct Load and Auto-recovery mechanisms
• Loaded the test data to estimate job run time and Performance Statistics and optimized and fine tuned the job. Used Push Down where applicable.
• Exported Metadata in XML format to be consumed by the Universe to generate Webi Reports
• Scheduled Jobs in Management Console and in Tidal maintaining Parent-Child relationship and dependencies in QAS and communicated the same with the BO Admin

Confidential, Sometown, NY
Marketing Software Engineer

08/2008 - 1/2009

• Developing in syntax C#
• Exporting a part of customer oracle database table to an appropriate readable format for Invenna
• Using ETL tool to research customer DATA by drilling down and identifying good customers
• Writing SQL-Plus migration scripts
• Creating Icons in adobe Photoshop
• Forming animation with expression blend
• Programming a workflow with Syncfusion Libraries as WPF component for the ETL tool for campaign Management
• Maintaining the conceptual model
• Generating and hosting WCF services for reading and writing files utilizing NET-TCP/IP protocol(1.2 SOAP)
• Producing an unzip tar tool
• Writing and reading xml configuration files
• Maintaining documentation building case sensitive context functionality, libraries MADCAP
• Testing the ETL tool functionality

Confidential, Amsterdam, The Netherlands
Software Engineer

01/2008 - 06/2008

• Migrating customer data from lotus notes to Microsoft Dynamics
• Drilling down DATA and de-duping customers
• Developing in syntax C#
• Responsible for Product Release management
• Debugging windows application
• Talking to WebServices Microsoft Dynamics CRM 4.0 (WSDL)
• Programming LINQ to entity
• Reading writing to DB SQL server
• Documentation

Confidential, Amsterdam, The Netherlands
Systems Engineer

06/2006 - 12/2007

• Validating the software landscape architecture
• Tuning the N-tier generated .NET ENTERPRISE SOLUTIONS
• Building weekly, monthly, quarterly and yearly Churn Graphs
• Developing in syntax VB.NET, building parts of Web Applications
• Creating and customizing Stored Procedures
• Testing the software, ensuring the functionality for positive and negative Test Cases
• Creating technical documentation including Use Cases, Technical Diagrams, Data and Process Flow Diagrams

Confidential, The Netherlands
Junior IT Architect

06/2005 - 05/2006

• Advising and designing an architecture in portals in Lotus Notes for the Management Team of IGS Finance & Planning, in accordance with the regional finance controller of EMEA, and efficiently implementing the suggested solution

Confidential, UK
.NET Developer and Test Lead

06/2004 - 05/2005

• Building a BUG tracking application by scanning folders in which bugs were generated reading them and giving them a priority status
• Developing syntax C# in visual studio 2003
• Making use cases and technical diagrams
• Updating tables in SQL server 2000
• Leading a test team

Confidential, Amsterdam, The Netherlands
Tech Support

05/2002 - 08/2002

• Giving support for technical cable line problems, helping out customers remotely with their computer problems

Confidential, The Netherlands
Cargo Admin

12/1999 - 05/2000

• Responsible for validating airways bills, which come with cargo according to the appropriate procedures. Controlling shipments with packages that arrive in Schiphol in the Netherlands

Confidential, The Netherlands
Group Leader "La Post" Department

2/1998 - 05/1999

• Responsible for making deadlines when processing post to France. Leading a Team of 20 workers and responsible for the workflow

Confidential, Finance, The Netherlands
Admin

2/1997 - 5/1997

• Administrative work in finance department

Education & Training

Bachelor of Science, Major in Software Engineering

2007------

SAP BusinessObjects Data Integrator Training
Microsoft Certified ASP .NET 3.5 (70-564)
Microsoft Certified Framework Foundation 3.5 (70-536)