Professional Experience
I have the privilege to work with these cool companies.
Consultant, Aspen Medical Products
Aug 2022 – Present
- Responsible to Create EDI using Astera Centerprise for various retail transaction including 997,810,855,856,940.
- Configured Trading Partner Profiles for both Inbound and Outbound for various Trading Partners.
- Worked on both Inbound and Outbound using ANSI X12, EDIFACT (D01B) standards.
- Responsible to handle production support issues related to EDI.
- Responsible to design and develop the automation of EDI file transmission (Inbound and Outbound) on FTP and SFTP.
Migration Architect, M.H.Alshaya CO
Feb 2019 – Jan 2020
- Responsible as part of the JDA team for the large digital transformation i.e. Business in PHOENIX Project for Data Conversion and secure Migration of the data from the existing (“source”) systems to the (“target”) systems. JDA is one of their “Target Systems”.
- Part of the Retail Planning and Optimization migration group which included EP, AP, AO, Demand, Promo, MDO.
- Attending meetings with the Alshaya JDA team to understand business requirements from the Alshaya JDA team.
- Created Logical and Technical documents.
- Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
- Providing technical requirements to the team for the development.
- Designing data processing flow to implement in the ETL.
- Validating and verifying data after the load into the tables and XML output files for expected format and hierarchies.
- Delivering data in each data drop to Alshaya JDA
- Attending meetings to get the feedback on the delivered data in XML files and have the teamwork on the feedback implementation.
Technical Lead, Microvention
Apr 2018 – Jan 2019
- Installation of SQL SERVER 2016 software in the servers.
- Created Logical and Technical documents.
- Create POWER BI report and deploy in SSRS Report Portal and Create Excel report using VBA macro code.
- Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions.
- Working on creating reports & dashboards.
- Created DRILL DOWN Reports, DRILL THROUGH Report by Region.
Project Manager, KOF- Coca Cola, FEMSA
Jan 2017 – Feb 2018
- Participated in requirement gathering, organizing daily project status update meetings with clients, managing leave plans of teams, environments setup, managing tasks on JIRA sprints on daily basis, and creating weekly status reports.
- Created Logical and Technical documents.
- Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
- Working on creating reports & dashboards for Countries (ARG, COL, MEX, BRZ, PHI, and Central America Countries.)
- Created DRILL DOWN Reports, DRILL THROUGH Report by Region.
- Deployed and Migrated packages from Dev to the Production server.
- Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
- Created EXCEL Report using VBA macro code
Application Team Lead (DWH), Spectrum Brands
Feb 2014 – 2022
- Designed and developed new analytical Applications based on file-based ERP.
- Created required target tables, views, triggers, and procedures in Oracle 11g Database.
- Extract, Transform and Load data using Informatica to the target tables.
- Analytics, OBIEE 11g support/ maintenance
- Architected, and configured OBIEE implementation including custom Sales/Spend tables.
- Informatica, DAC, OBIEE repository, and dashboards.
Datawarehouse Developer, Quest Software
Jan 2012 – Dec 2014
- Designed and developed new analytical Applications based on SQL and file-based ERP.
- Participated in requirement gathering, analyzing account hierarchy for all lines of business, prepared the design documentation, mapping requirements to cube functionality and to-be designed
- Connected BI to Oracle DW/ Cubes to create Sales, Inventory, Forecast, Demand & Marketing reports to help users with reconciliations and comparisons of actuals vs Forecast vs Demand.
- Created ETLs to load data from source to Oracle tables and used different transformations according to the requirement.
- Created and monitored DAC plan for full and incremental load
- RPD configuration and modeling, defining hierarchy and security (data level and row-level), and Report creation with different visuals in OBIEE.
- Later, also involved in the setup of the new OBIEE environment for better performance requirements.
Software Developer Trainee, Spice Digital Ltd
Mar 2011 – Sep 2011
- Created windows Batch files to consolidate various flat files into one flat file and import flat file data into the database.
- Created web pages layout in ASP.NET and code programming in C#.
- Configured SMTP to send auto-generated emails.
Junior Software Developer, Indus Infotech
Mar 2010 – Feb 2011
- Created tables, and complex stored procedures as per the requirement in MS SQL Server.
- Created web pages layout in ASP.NET and code programming in C#.
- Creating JavaScript validation code on the Front-End Application pages.
- Created CSS to provide design layout for web pages.