EXPERIENCE 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.
• Strong experience in Data migration from Non-SAP systems to SAP system with 5 full life cycle implementations
• Strong experience in driving business ROI through architecting database solutions and web-based applications per domain-specific requirements
• Proven Leadership qualities with extensive experience as mentor to team of architects and developers in initiatives focused on enterprise grade, highly scalable and highly dynamic database environments

TECHNICAL SKILLS:

Databases: SQL Server 2014, 2012, 2008 R 2/2005/2000/7.0 , Oracle, MS Access

BI/DW: SSIS, Business Objects Data Services, DataStage, DTS, Data Marts, Enterprise DW

Languages: ASP.NET/ASP, JavaScript, VBScript, DHTML, HTML, CSS and T-SQL

GUI/Tools: BODS, ER Studio, Visual Studio, MS Visio, PVCS, Visual SourceSafe

OS: Windows 7/2012/2008/2003/ XP/2000/NT

PROFESSIONAL EXPERIENCE:

Confidential, Maumee, OH

SAP Data Migration Architect

Responsibilities:

• Master data profiling from legacy system for objects like Customers, Vendors and Materials
• Assisting business to identify the duplicates by writing fuzzy logic duplication reports using SSIS.
• Working with business and functional people in blue printing phase of SAP which includes writing functional and Technical Specifications along with Logical Data Mapping (LDM) document.
• WRICERF’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 Profile and Sampling Procedure.
• Developed Pre-validations checks/process that captures almost all the errors ahead of time before loading to SAP system.
• Extracting data from legacy systems into staging databases, data cleansing, applying business rules and perform ETL using business objects data services and SQL Server
• Design/Architect/Build - Data pre/post validations and Data validation automation scripts
• Architecting standards, design best practices, code reusability, Quality check T-SQL scripts automation and documentation
• Hand on development in stored procedures, T-SQL scripts, BODS Transformations.

Environment: SAP, BODS, SQL Server, 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 various legacy systems into staging area, apply all the business rules and transformations, data cleansing, data quality check and create final data for SAP.
• Hands on design/development of Business Objects Data Services jobs for perform ETL operations as per functional and technical requirements
• Design/Architect/Build - Data pre/post validations and Data validation automation scripts
• Architecting standards, design best practices, code reusability, Quality check T-SQL scripts automation and documentation
• ETL using business objects Data services for getting legacy data into staging databases and applying various data cleansing/transformation rules
• Hand on development in stored procedures, T-SQL scripts, BODS Transformations.

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

Confidential, Maumee, OH

Sr. SQL Data Architect

Responsibilities:

• Enterprise wide SQL Server migration from R2.
• Migration Planning and Design, Best practices and standards, Quality Improvement
• Database design, Data modeling logical/physical design, capacity planning, security design
• Architecting standards for Data migration, extraction, quality assessment, data cleansing, validation and loading

Environment: SQL Server, Enterprise Data Warehouses, Data Marts, SSIS, DTS, T-SQL, Stored Procedures

Confidential, Michigan, MI

Sr. Business Intelligent Architect

Responsibilities:

• Lead a team of DBAs, System Analysts, Quality Analysts on daily operations of Large private cloud environment which includes support and various maintenance activities
• Database Management, Weekly maintenance plan, backup/recovery, production support
• Database design, Performance tuning, query optimization, coding standards, best practices
• Planning and migration of huge databases, security design using Active Directory
• Security configuration/management, deployment of warehouse/data mart across DEV, SIT, UAT and PROD environments with high level of security granularity

Environment: Private Cloud 60TB, VM Ware, Oracle 10g, SQL Server 2008 R2, Data Warehouse, Data marts, SSIS, T-SQL, Stored Procedures, Visual Studio 2008, Windows Server 2008

Confidential, Dearborn, MI

Technical 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 Confidential 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, Analysis and Architectural design of the application
• Tech Lead for the team of 6 developers
• Automated data load into Oracle from mainframe on daily, weekly and monthly basis
• Created, documented & implemented the best coding practices for web development.
• Coding in ASP, VBScript, JavaScript, Oracle PL/SQL procedures, SQL, DHTML, HTML & CSS.
• 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 applied 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.
• Involved in the Testing and 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.