ERP Business Analyst / Informatica Development and Full stack developer
HI there! I am a full stack developer having proven experience in ERP Business analyses. For many years I have developed business requirements documentation, managed data cleanup and data migration for all customer and historical sales order data, created training documents and trained end users and developed software enhancement specs, test programing changes and bug fixes. I have worked with programmers and off-site consultants to ensure client project deliverables. Managed many ERP related projects through project life cycle and scheduled programming, consulting, IT resources for my clients. I have helped clients with small bug fixes to major go live projects, developed and submitted fiscal budget, business reviews, financial projections and assigned cost studies in an accurate and timely manner to support division and corporate requirements. Tracked project and client requests on a daily basis. I have gathered technical and functional client requirements and managed those requirements through clear and precise documentation. Provided leadership with respect to integration issues including process mapping, business process reengineering, SAP integrations and change management. I have developed, maintained detailed project plans with tasks, deliverables and resource allocation necessary for successful implementation. Created client implementation plans, maintained and managed project issues to resolution and set up weekly project meetings internally and with the client.
As a professional Informatica developer I have developed complex informatica mappings to load the data from various sources using different transformations, designed incremental loading process to load data into staging tables, created worklets, workflow and tasks to schedule the loads at required frequency and participated in user meetings, gathered Business requirements and specifications for the data warehouse design. I have translated the user inputs into ETL design docs, analyzed and quantified the impact of projects on upstream systems. Performed extensive analysis of new data to satisfy business requirements and was responsible for deploying the changes from logical data model to physical modeling. I have performed reverse engineering from Informatica codes, designed and implemented the core ETL methodologies, created unit test cases to test data loads and check whether the components adhere to the technical design, scheduled worklets and configured email notifications. I have participated in testing and performance tuning by identifying bottlenecks in mapping logic and resolving them, setting cache values and creating partitions for parallel processing of data.