SUMMARY

• 20+ years of experience in enterprise - scale architecture design, integration of business applications & data, technology services - across varied business domains including automotive, pharmaceutical, healthcare, transportation, logistics, commodity trading, etc.
• Expertise in Data migration from Non-SAP systems to SAP with 10+ go-live production releases
• Strong experience in driving business ROI through architecting database solutions and applications per domain-specific requirements
• Strategic thinking, problem solving and proven leadership qualities with extensive experience in leading team of developers, business analysts & QA in initiatives focused on enterprise grade, highly scalable and highly dynamic database, data warehouse and business intelligence environments

TECHNICAL SKILLS

• SQL Server 2008 R 2/2005/2000/7.0
• Oracle
• MS Access
• Stored Procedures
• Complex T-SQL
• Performance Tuning
• Triggers
• Functions
• SQL Server Integration Service (SSIS)
• SSRS
• SSAS
• DataStage
• SAP Business Objects Data Services 4.x
• DTS
• Data Marts
• Enterprise Data Warehouse
• Information Steward
• ER Studio
• Erwin
• Visual Studio
• MS Visio
• PVCS
• Web Development
• ASP
• ASP.NET
• VB.NET
• DHTML/HTML
• CSS
• VBScript
• JavaScript

PROFESSIONAL EXPERIENCE

Confidential, Maumee, OH

SAP Data Migration Architect

Responsibilities:

• Master data profiling from legacy system for objects like customers, vendors and materials
• Designed/developed SSIS fuzzy logic deduplication reports on various legacy master data objects that helps business to identify and clean the legacy data before migration
• Legacy data profiling using Information Steward, BODS, SQL Server and custom SQL queries
• Working with business and functional teams during blue printing phase of SAP Implementation and preparation of technical specifications and Logical Data Mapping (LDM) documents
• WRICEF’s Handled end to end from Legacy system to SAP: Material Master, Bill of Materials (Purchase and Sales), Recipe, Rate Routing, Production Version, Equipment Master, Certificate Profiles, Sampling Procedure, etc.
• Extracting data from legacy systems into staging databases, data cleansing, filtering, apply business and transformation rules (ETL) using Data Services (BODS), SSIS, Stored Procedures and T-SQL
• Design/Build - Data pre-validation checks/process across all objects. This will help ensure to catch the SAP master data and configuration issues before the data loads.
• Designed/developed automated data validation reports that compares the staging and SAP data and list out the differences to help business speed up the validation process and saving 80% time
• Architecting standards, best practices, code reusability and Quality check automation
• Hands on development in SSIS, BODS, Stored procedures and Complex Transact-SQL

Environment: SAP, BODS, LSMW, Winshuttle, Information Steward, SQL Server, SSIS, ETL, Complex T-SQL, Stored Procedures, HPQC

Confidential, Maumee, OH

SAP Data Migration Architect

Responsibilities:

• Legacy system data profiling, staging database design, security design/setup and entire end to end solution design for staging the legacy data for SAP Implementation
• Extracting data from legacy systems into staging databases, data cleansing, apply business rules and perform ETL using business objects data services (BODS), SQL Server, Stored Procedures and T-SQL
• Hands on design/development of Business Objects Data Services jobs for perform ETL operations as per functional and technical requirements
• Extracting data from legacy system into staging databases, data cleansing, apply business rules and perform ETL using business objects data services (BODS), SQL Server, Stored Procedures and T-SQL
• Design/Build - Data pre-validation checks/process across all objects. This will help ensure to catch the SAP master data and configuration issues before the data loads.
• Designed/developed automated data validation reports that compares the staging and SAP data and list out the differences to help business speed up the validation process and saving 80% time
• Architecting standards, best practices, code reusability and Quality check automation
• Hands on development in SSIS, BODS, Stored procedures and Complex Transact-SQL

Environment: SAP, BODS, SQL Server, SSIS, ETL, Complex T-SQL, Stored Procedures, HPQC

Confidential, MI

Sr. Business Intelligent Architect

• Lead a team of DBAs, System Analysts, Quality Analysts on daily operations of data warehouse environment which includes development, support and various maintenance activities
• Data warehouse architecture, database design, data modeling, data profiling, data integration and transformation in healthcare domain such as Provider, Member and Claims
• Conceptual, logical and physical data modeling using ER Studio, transforming logical to physical models and generating DDL for database implementation
• Working with business and process teams to understand and gather requirements and involved in technical and data mapping documentation
• Hands on experience developing complex SSIS packages, T-SQL, Stored Procedures on huge volumes of Provider, Member and Claims data marts
• Database Management, Weekly maintenance plan, backup/recovery and production support
• Architecting coding standards, performance tuning, query optimization and best practices

Environment: SQL Server 2008 R2, ER Studio, Data Warehouse, SSIS, T-SQL, Stored Procedures, Visual Studio 2008, Windows Server 2008

Confidential, Dearborn, MI

SQL Data Architect

Responsibilities:

• SQL Server DB architecture, design, development, administration and Performance tuning
• Design/develop data models - Logical and Physical database design using ER/Studio
• SSIS, Data migration, extraction, quality assessment, data cleansing, loading and validation
• Data warehouse architecture design, development and maintenance
• Migration experience from SQL Server, SQL Server
• Complex highly performance tuned Stored Procedures, Functions, Triggers and T-SQL Scripts
• Define and implement best coding practices, standards, conventions, readability & reusability
• Engaged in innovative concepts and programming techniques (Agile & Extreme Programming) on how to develop high quality software and still maintaining shorter time to market

Environment: SQL Server 2008 R2/2005/2000, Data Warehouse, SSIS, SSRS, T-SQL, Stored Procedures, ER/Studio, Visio, ASP.NET, VB.NET, XML, JavaScript, DHTML, HTML, CSS, Visual Studio 2008, PVCS, IIS 6.0 and Windows 2003

Confidential, Kalamazoo, MI

Sr. Software Engineer

Responsibilities:

• Requirements gathering, business user interactions and project planning & management
• Design the architecture of the application and database design
• Programming the application using ASP.NET, VB.NET, C#, ADO.NET, XML, XSL, JavaScript, HTML, DHTML, CSS using Visual Studio.NET
• Written SQL server stored procedures and designed SQL server 2000 Reports
• Written SQL scripts, SP’s and DTS package to import data into STOR database.
• Designed ETL jobs & Sequencer using DataStage to import data from centralized databases
• Quality assurance testing, Production plan, roll and support.

Environment: ASP.NET, VB.NET, C#, XML, XSL, JavaScript, DHTML, HTML, CSS, SQL Server 2000, DataStage7.5, DTS, Microsoft Visual Studio.NET, Visual Source Safe, IIS 5.0 and Windows 2000.

Confidential, Louisville, KY

Sr. Software Engineer

Responsibilities:

• Business requirements gathering, analysis and architectural design of the application
• Automated data load into Oracle from mainframe on daily, weekly and monthly basis
• Created & implemented best coding practices for web and database development
• Coding in ASP, VBScript, JavaScript, Oracle PL/SQL procedures, SQL, DHTML, HTML & CSS.
• Involved in testing the application end to end, fixing bugs, production rollout and planning.
• Tools used are Visual Interdev6.0, PVCS version manager and PVCS tracker.

Environment: ASP, JavaScript, VBScript, DHTML, HTML, Oracle9i, PL/SQL, SQL Navigator, IIS 5.0, Windows 2000, Microsoft Visual Interdev6.0, PVCS Version Manager and PVCS Tracker.

Confidential, Louisville, KY

Sr. Software Engineer

Responsibilities:

• Interacted with Business Analyst and Users to understand the business rules of the system.
• Designed user interface screens with HTML, DHTML and JavaScript using Visual Interdev6.0.
• Development of the application includes client-side validation in JavaScript, server-side scripting in ASP with VBScript, Database connections with ADODB and OLEDB.
• Written PL/SQL Packages in Oracle8i and invoked from ASP.
• Assisted in writing test scripts, testing of the application and deployment in production.

Environment: ASP, JavaScript, VBScript, DHTML, HTML, Oracle8i, PL/SQL, IIS 4.0, Windows NT Server 4.0, Microsoft Visual Interdev6.0 and PVCS.

Confidential, Framingham, MA

Sr. Software Engineer

Responsibilities:

• Understanding the business rules and incorporating them in the development of the application.
• Client-side validation is written in JavaScript, Server-side scripting in ASP with VBScript, Database connections with ADODB and OLEDB, development environment is Visual Interdev.
• Written PL/SQL Packages in Oracle and invoked from ASP pages.
• Involved in the Testing and production implementation phase of the application.

Environment: ASP, JavaScript, VBScript, DHTML, HTML, Oracle8i, PL/SQL, IIS 4.0, Windows NT Server 4.0, Microsoft Visual Interdev6.0 and Visual Source Safe.

Confidential

Software Engineer

Responsibilities:

• Involved in user requirement analysis, prototyping, database designing and Quality assurance
• Front end designed using ASP, HTML, DHTML, JavaScript using Visual Interdev
• Designed/written Business/Data Layer COM components in Visual Basic and deployed in MTS
• Designed & written Stored Procedures in SQL Server 7.0
• Involved in preparing test scripts, testing of application and production deployment.

Environment: ASP, Visual Basic, ActiveX DLL (COM), XML, JavaScript, VBScript, DHTML, HTML, SQL Server 7.0, IIS 4.0, MTS, Windows NT Server 4.0 and Microsoft Visual InterDev.

Confidential

Software Engineer

Responsibilities:

• Developed multiple web development projects using HTML/DHTML, CSS, JavaScript, VBScript as front-end and SQL Server as database
• Administration & maintenance of production web server, setup and maintain domain names, FTP and email services
• Install, configuration, setup and maintenance of IIS, DNS, WWW Services, ISAPI, CGI Scripts, FTP, NT Authentication, Extranet, SSL, ODBC, SMTP
• Performance monitoring, analyzing server resources, data backups weekly/monthly

Environment: Windows NT Server 4, IIS 4.0/3.0, DNS, HTTP, WWW, FTP, SMTP, Web Development