SUMMARY

• About 17+ years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
• Handled Enterprise Data warehousing projects, Enterprise ERP Migrations, Service & SCM integrations.
• Manage, develop ETL architecture and provided strategy related to data cleansing, data quality and data consolidation
• Designed Multi - Dimensional data model (STAR Schema) and enhanced it to meet the growing requirements due to various corporate groups accessing the data.
• Extensive Data extractions and consolidation from Historic Sales history & Analytics data, Issue resolution with extensive source data analysis as well as agreements on data extraction and usage rules with source system teams
• Designed and experience developing dash boarding, data visualization, and analytics using Tableau desktop, and server. Extracts scheduling for offline analytics.
• Manage and Integrate ERP data feeds to DWH. Build Data Model and Maintenance for Directs & In-directs, & Business Consolidations, and Cloud based data integration with Amazon analytics
• Analyzed, identified, and documented data mapping between source, stage and destination repositories.
• Collaborate with business owners & Operations group toward the implementation of changes, and work with Quality Assurance (QA), and change management teams for IT releases to the data warehouse.
• In depth work on Integrations between ERP systems and warehouse applications, B2B, Financial transactions, and External shared service providers.
• Integration systems re-designing to accommodate system limitations and provide development solutions. Implemented reporting strategy on Share-point
• Experience in leading and managing multiple vendor support teams.
• Performed multiple roles - Techno Functional ERP Consultant, Software solutions Architect, and Data Architect
• Strong knowledge in cross functional and technical on Supply chain ERP system, development, and testing B2B systems.
• Demonstrated proficiency in developing and implementing plans for migration and skilled in Data Mapping & Modeling.
• Manufacturing, Services, Logistics, and Process industry domain expertise.
• Business function mapping, gap analysis, design and implemented ERP DataMart architecture
• Excellent communication skills, interpersonal skills, self-motivated, quick learner, team player.

TECHNICAL SKILLS

ERP : SSA Ln 10.4,7, Baan 4c, 5.x, 6.0a, LN tools, Oracle e Business Suite, JD Edwards 9.1

Tools: Tableau Desktop & Server, Power BI, SSIS, SSRS, BIDS tool. VS .NET 2003, 2010,.NET Framework, ASP.NET, MS SharePoint, ASP, Visual Basic 6.0, VB.NET, Quality center

Cloud Computing: Microsoft Azure - Cloud Services (PaaS & IaaS), Active Directory, Application Insights, and SQL Azure

RDBMS: Oracle 8, 10, 11g, MS SQL Server 2000 - 2016, DB2, Image Plus

Languages: C, C++, Java, HTML, XML, XSLT

OS: Windows XP, Win 95/NT, 2003, Windows 7 Prof, Unix

Processes: SEI CMM, Lean, Process value streams.

Process Tools: MS project, Jira, HPQC

Knowledge base: Big data framework.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr Solutions & DWH Architect

Responsibilities:

• Working as Sr. Solutions and DWH Architect managing Confidential 's Sales, Logistics & DWH environment. Enterprise strategy and Streamlining logistics processes & Customer Management.
• Plant Improvement Initiatives and Product variant efficiency planning.
• Customer Insight Universe upgrade.

Environment: Tableau Desktop & Server, Mulesoft, Business Objects, Infor LN 10.7

Confidential

IT Project Leader

Responsibilities:

• Worked on multiple projects as an IT Leader & Solutions Architect for Confidential Canada & North America ERP systems for Enterprise Data warehousing & ETL processes.
• Design conceptual and technical architecture and marketed it with corporate sponsors and stakeholders.
• Define strategies for back- and front-end construction, data security, metadata population and usage, Web usage, error handling, reconciliation, and reference data maintenance.
• Design and developed logical and physical data models for Staging, Data Warehouse, and Data Marts.
• Built and implemented procedures for data load, validation, transformation, and data mart population.
• Design & Manage Enterprise Data warehousing, Sales, POS directs & in-directs DWH ETL processes and reporting via SSRS, SP, and Tableau desktop & Server
• Designed & Implemented Kidde Fire extinguisher Recall Processing integrated with JDE ERP and implemented DWH cubes and dashboards for daily reporting.
• Implemented Integration flow between ERPs having revenue recognition at JDE and Manufacturing, Inventory and Shipping functions in Baan ERP.
• In depth data modeling and design integration data structure to move Legacy Services ERP to Confidential ’s preferred Service ERP used on multiple business units.
• Designed & developed Integration framework model to transfer HP Master Data and transactional data flows between the systems in a periodic fashion.
• Worked on design architecture for data warehousing strategy and phase II implementation of migrating Services Application to new system across CA branches.
• Integration of commonly shared application data for streamlining Products across business units.
• Performed Data Modeling on Baan ERP system to accommodate in new HP system. Critical Master data like Customers, Vendors, GL, Products, BOM structure and common parameters.
• Developed customized data extractions to import key transactions like Financial journal entries, Open Orders sales & purchase, routings, standard costs and AR Open entries.
• Design overview and sign off on Data Mapping function with Development team and with CA Business team to have clear visibility what is getting migrated.

Environment: Tableau Desktop & server, SSRS, SSIS, Windows NT, Baan Infor ERP, Gemini Tools, Open World, Oracle 10g, Trax, FieldPro, MS SharePoint, MS Projects, HP 3000, Oracle E-Business, JDE 9.1

Confidential

Techno functional Consultant & OSC

Responsibilities:

• Responsible to ensure the smooth functioning of the Application, addressing technical, functional and project development/deployments.
• On-site Coordinator to transfer Project work products to Offshore and manage deliverables.
• Interfaced with business users to prepare and update Business Requirement Document (BRD)
• Analyze the various client interaction models followed by Confidential - Confidential .
• Extensive development of customization sessions using LN Tools set.
• Created Web services in interface with 3rd party mileage providers like PC Miller.
• Provide systems expertise (training) to system users, business partners, and other internal/external customers including trouble shooting issues, as well as, identifying and correcting inefficiencies.
• Extensively worked on production support, analysis, and customization based on different Client request in the ERP system.

Environment: Windows NT, Baan Infor ERP, Gemini Tools, Open World, Oracle 10g, ControlM, Test director, Shell scripts.