Experience

Niche Polymer LLC

• United States
• Plastics Manufacturing
• 1 - 100 Employee

• Sr Microsoft Dynamics Consultant

  • Jan 2021 - Present

  Upgraded Nav 2018 to Business Central. Currently working on project upgrading from QuickBooks to Business Central. Experience working in the full life cycle implementation of D365 to my client. Responsibilities varies from Requirement gathering, analysis, investigation and project planning and Gathered client requirements and business process, development, testing, deployment, support of Microsoft Dynamics projects. Implemented Gap analysis for finding out the required number of customizations needed to meet the client requirements. Developed customized reports, check printing job, various print versions as per client requirement using AL Language. Extensively worked with MS Dynamics 365 Business central report, SSRS, Power BI reports. Created configuration packages to migrate data from QuickBooks to Business Central. Created Dashboards, Views, Reports, charts and all the security roles and users accordingly in the system based on roles. Configured Approval workflow for Purchase and Sales in Power Automate. Created User Manuals for training and provided User Training to different department as per their Role.



Intercontinental Export Import, INC

• United States
• Plastics Manufacturing

• Lead Power BI Data Analyst/ Sr. SQL Developer

  • Mar 2017 - Dec 2020

  Planned, developed, tested, and implemented SQL Server DB for sister companies. Led the development of reporting solution suite containing Power BI Reports for Corporate customers. Participated in requirements meetings and data mapping sessions to understand business needs. Identified and documented detailed business rules. Developed at least two – three visual options for each report for discussion with product owners and leadership. Integrated Custom Visuals based on business requirements using Power BI desktop. Developed complex SQL queries using stored procedures, temporary table to support Power BI and SSRS Reports. Embedded Power BI reports on the In-house portal page and also managed access of reports and data for individual users using Roles. Provided continued maintenance and development of bug fixes for the existing and new Power BI reports. Created Bulk Upload data procedures for Master Tables. Scheduled Daily Backup procedures for DB. Created reports under SSRS and subscribed them for different users to get reports in Email. Created Crystal Reports and SQL Server procedures for reporting. Created Documentation for steps need to be taken while upgrading. Involved in Agile methodologies from Software Requirements Analysis Phase to Design, Development, Testing, Integration, Implementation and Maintenance.



SIRNAIK GREEN TECHNOLOGIES PRIVATE LIMITED

• India
• 1 - 100 Employee

• SQL DBA/Developer

  • Jan 2011 - Apr 2016

  Installed, configured, administered SQL Server 2012/2008R2 production and development environments. Worked on clustered virtual host and migrated to other hosts during the patching process. Reviewed the software dependencies and proof-of-concept test in a lab environment before the patch is applied to production system. Monitored and managed the Table spaces and data files growth. Analyzed Tables & Schemas, collected system statistics and rebuilt indexes. Migrated multiple databases, SSIS packages, SSRS reports 2012/2008R in both in In-place and Side-by-Side migration methods. Moved several existing production databases, jobs, packages, reports, linked server, logins, and other computer objects to new versions of SQL server. Worked closely with application team, development team and infrastructure team for planning and Implementation of the migration and for new application requirements\releases. Monitored database system details within the database, including stored procedures and execution time and implement efficiency improvements. Migrated new database structures (tables/indexes/stored procedures) from test to production environment. Automated database refresh from production to test using custom scripts. Created databases, Logins, Roles and granted appropriate permissions. Worked with offshore team on pending issues and coordinating migration project activities to meet the project deadlines. Developed and deployed SSIS packages and SSRS reports.



Future Knowledge Services Ltd

• Retail
• 300 - 400 Employee

• SAP MDM Consultant

  • Oct 2009 - Apr 2010

  Created, Maintained & Deleted Article Master. Created, Maintained & Deleted Customer Master. Archived Article Master & Customer Master. Involved in One Time Cleanup Project for PIR creation & updation, MRP updation, Legacy Data Enrichment process , POS Description updation , Article Listing issues. Reclassified MCs. Team Management. Created, Maintained & Deleted Article Master. Created, Maintained & Deleted Customer Master. Archived Article Master & Customer Master. Involved in One Time Cleanup Project for PIR creation & updation, MRP updation, Legacy Data Enrichment process , POS Description updation , Article Listing issues. Reclassified MCs. Team Management.



Passionate Accelerated Solution

• India

• SAP SD Consultant

  • Mar 2008 - Sep 2009

  Analyzed existing business processes, defined business requirements and documented gap analysis against SAP R/3 functionality. Prepared the Business Blue Print. Defined the Organization structure based on Sales Area ( A combination of Sales Organization, Distribution Channel, and Division ) and Also Sales office ( Based on Geographical aspects ) and Sales Group Customer master was designed with different account groups, Partner Functions and customized Partner Determination Procedure for Customer Master. Configured Customized Sales document types like scrap sales, Credit/Debit Memos, Direct Factory Sales, Government sales, Export sales, Stock Transfer orders, Depot Sales, Sales return at Factory and Depot, and Assignment with Sales area. Configured the Basic Functions like Pricing Procedures, Incompletion Procedures, Revenue Account Determination, Free goods Procedures determination, Output Determination, Partner functions and Set up Partner determination Procedures, Text Determination Procedures Customized Pricing procedure determination based on various businesses of client - Factory sales, Depot Sales, Sales Return, Export Sales, Stock Transfer, Scrap Sales Configured Account Assignment group of the Customer, Account Assignment group of the Material, Tax Classification of the Customer, Tax Classification of the Material Configured Product hierarchy, Transportation group of the Material, Loading group of the Material Basic Shipping Functions – Shipping point determination Basic Transportation Functions – Defined Routes, Shipment types, Shipment cost types, Route Determination Module SD-FICO and SD-MM integration Prepared the format of Open sales order, Free goods condition record, Tax condition records, Basis price condition record, and Open Stock transfer order to collect the cut over data for the purpose of Go-Live. Prepared LSMW of Customer master, Tax Condition records, Basis price condition records, Free goods condition records



Claris Lifesciences Limited

• United Kingdom
• Chemical Manufacturing

• ERP Developer

  • Sep 2007 - Feb 2008

  Created web portal which provided interface between Marketing head and Product Executive. Product Executive could submit his Requisition and then it went under various modes of approval/rejection. Customer could also submit their online feedbacks. Implemented this project based on Software Development Life Cycle stages: Recognized the need, Feasibility study, Analyzed, Designed, Coded & Tested, and Implemented. Provided Authentication and Authorization .NET security mechanisms by allowing the users to Log in based on their roles. Validation controls by using VB.NET and JavaScript were implemented to perform validations. Implemented various Classes and Modules in VB.NET for efficient reuse of code. Created Stored Procedures for automated rules and updating to relating tables using sql server 2005. Created parameterized Crystal Reports for all analysis and reporting needs of application. Used Visual Source Safe for version control and history during development. Involved in Unit testing of the application.



Unique Infotech

• Australia
• Information Technology & Services
• 1 - 100 Employee

• ERP Developer

  • Jan 2007 - Aug 2007

  Involved in developing banking module using ASP.NET and C#. Developed web forms for Account Summary, History, Member Profile, Transfers, and Loan Product Services using ASP.NET. Performed form based authentication. Developed user controls and extensively used HTML and Web server controls. Performed client-side and server-side form validations using JavaScript and ASP.NET validation controls. Defined Cascading Style Sheet (CSS) for ASP.NET web forms. Configured Web.Config file for Form based authentication and authorization. Used Data Grid and Repeater for displaying records in Multicolumn grid. Used ASP.NET rich controls like Calendar controls. Used MS SQL Server 2005 as the database and ADO.NET for database connectivity. Created Stored Procedures and triggers for automated rules and updating related tables using SQL Server. Used Microsoft Visual SourceSafe for version control. Created parameterized Crystal Reports for all analysis and reporting needs of application. Involved in unit testing to ensure quality.