Data Analyst Warehouse Delivery
Resume:
Lanka Srihari
Senior Business & Data Analyst
*******.*****@*****.***
Educational Qualification:
Certified ScrumMaster (CSM) from Scrum Alliance (2021).
Master of Computer Applications (MCA) from Osmania University (2005).
B.Com (Bachelor of Commerce) From Osmania University (2000).
VB.Net, C# & ASP.Net Trained in Impetus Solutions.
PGDCA from NSIC Technologies Training Centre.
Work Experience:
Working as a Sr. Software Engineer from Entellects Corporation (DBA) Bee Data Technology, United States of America from June 2022 to Till Date
Worked as a Senior Business Analyst / Data Analyst/ Project Lead/ Sr. Software Engineer with Jay Gee Enterprises, Singapore from June 2009 to June 2022.
Worked as a Sr. Software Engineer with Compo 2000. Singapore from 12/05/2008 to 16/06/2009
Worked as a Sr. Software Engineer with Mitra IT Solutions (MSC Status). Malaysia from 05/01/2006 to 21/12/2007.
Professional Summary:
Evaluating business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions.
Leading ongoing reviews of business processes and developing optimization strategies.
Staying up to date on the latest process and IT advancements to automate and modernize systems.
Conducting meetings and presentations to share ideas and findings.
Managing complete Life Cycle of the Products.
Documenting and communicating the results of your efforts.
Gathering critical information from meetings with various users and producing useful reports.
Generating reports in Excel Macros / Crystal Reports / Power BI
Working closely with clients, technicians, and managerial staff.
Providing leadership, training, coaching, and guidance to junior staff and end users.
Allocating resources and maintaining cost efficiency.
Ensuring solutions meet business needs and requirements.
Performing user acceptance testing.
Managing projects, developing project plans, and monitoring performance.
Gathering user requirements, documenting, coding, testing, and deploying the projects.
Maintaining the Database, Creating Tables, Writing SQL, MYSQL Procedures.
Updating, implementing, and maintaining procedures.
Prioritizing initiatives based on business needs and requirements.
Serving as a liaison between Management and users.
Managing competing resources and priorities.
Monitoring deliverables and ensuring timely completion of projects.
Project Management, Project Engineering, Program Management, Strategy Development, Process Improvement
Project details
Plexus worldwide
Phoenix, AZ, USA June 2022 to Feb 2023.
Technology Modernization Discovery and Implementation
Business Technical Analyst
Responsibilities
Identify the details on what Applications and NextGen Cloud Environments will be involved .
Gather Plexus & Vendor API requirements and milestones as well as DW data ingestion requirements .
Communicate & Collaborate on Consolidated Requirements with Plexus IT and Vendor technical SMEs for alignment.
Design a scalable architecture and Service Layer for the NextGen Platform for end-to-end functional and data integration to allow Plexus to grow and expand internationally with a focus on Security.
oDesign Decisions based on Requirements .
oIdentify key scoring criteria for Enterprise Services Platform
oEngage Product Vendors to gather costs and capabilities .
oIdentify Short list of recommendations .
oCapture key non-functional requirements in availability, through put, highwater marks, DR, mock services, API Mgmt. etc.
oCollaborate with Plexus IT and Vendor technical SMEs for alignment.
Design Documents
oEnterprise Architecture Design Document
oService Layer Design Document
oReview & Collaboration with Plexus IT
Enhancing the Current website.
Document all installation and configurations for Plexus IT and Operationalize & Support
Documenting all API Services
Jay Gee Enterprises, Singapore June 2009 – June 2022
Technical Business and Data Analyst / Power BI & Excel Macro Report Developer
Analytics & Reporting
Responsibilities:
Built out the Architecture, data and reporting infrastructure from the ground up using Power BI and Oracle, SQL to provide real-time insights into the product, promotions, marketing, and business KPI’s.
Co-ordinate with Accounts team to generate Yearly, Quarterly Monthly, Daily Sales report, Management reports, Sales Vs Bank Reconciliation repots and many more.
Co-ordinate with Sales and Marketing time and providing sales and promotional reports and many more.
Co-ordinate with all levels of business users to gathering and understanding the requirement of the business and the user’s requirement and generate reports based on their requirements.
Worked as a liaison between business and technical teams to communicate requirement prioritization and implementation level of effort to make sure highest value features were given higher priority.
Create Comparison reports based on Year to Year, Month to Month etc.
Used Power BI, Power Pivot, Power View, and Power Map to visualize reports and dashboard.
Imported data from various data sources, excel, Oracle, SQL DB into Power BI and Excel.
To design, develop, and deploy Power BI scripts and perform efficient detailed analysis.
Conducted 30+ complex business problem analyses to reduce operational and financial risk as part of the company compliance strategy.
Explore data in a variety of ways and across multiple visualizations using Power BI
Implemented long-terms promotion experiments that improved sales value by 20%.
Used Power BI Gateways to keep the dashboards and reports up to date.
Published reports and dashboards using Power BI.
Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.
Created DAX Queries to generated computed columns in Power BI.
Generated computed tables in Power BI by using DAX.
Developed C-level and market reports using DAX functions and measures.
Created complex filters, quick filters, table calculations, calculated measures, and parameters in Power BI.
Creating new stored procedures, functions, views and optimizing existing queries and stored procedures.
Developed analysis reports and dashboards by customers and products.
Very good analytical and problem-solving capabilities.
Conducting meetings and presentations to share ideas and findings.
Automation and process improvement initiatives within a data and reporting environment.
Creating automated sales reports, target reports which triggers daily via email.
Providing end user training.
Documenting all the reports what exactly the reports represents and how to utilize or execute them.
To make technical changes to existing BI systems in order to enhance their working
Jay Gee Enterprises, Singapore June 2009 – June 2022
Technical Business and Data Analyst / .Net Lead / Developer
Warehouse Delivery Management
Warehouse Delivery Management allows the users to fetch the GTA Documents (Goods Transfer Advice) and pushes the GTA document details to third party application through Web API’s and receives the unique number from the third-party application as received and updated to the respective GTA Documents.
Responsibilities
Gathering and Understanding the Requirement of the Business and the Users.
Conducting meetings and presentations to share ideas and findings.
Communicate with clients and evaluate their needs and specifications.
Design and Created design documentation and data modelling for the entire project.
Created Database in Oracle, Created Stored procedures, View, Triggers, Functions in Oracle database.
Environment .Net Framework 4.8, .Net Core, C#, Web API, Oracle 11g, Visual Studio 2017, C#.Net, Involved in Coding, Testing, Deployment.
Created and consumed services in .Net Core, Web API to perform CRUD operations using HTTP methods (GET, POST, PUT, DELETE and PATCH).
Used AJAX for faster interactive web experiences with AJAX control toolkits.
Created .Net Services and implemented with different applications.
Used LINQ to manipulate data in ASP.Net UI and developed WCF for SOA
Work closely with warehouse team to ensure the stock are arranged properly and ensure the delivery of the goods are met time to time.
Generating Crystal Reports / Excel Reports (Macros) / Power BI reports as per user’s request. analyze and interpret data.
Provide training, supporting, and guiding to the front-end Users.
Identified risk and potential issues and solve problems without delay.
Jay Gee Enterprises, Singapore June 2009 – June 2022
Technical Business Analyst / .Net Lead / Developer
Jay Gee Workflow
Jay Gee workflow is a series of steps related to processing data and 3 levels of Approvals. Its closely related concept of a business process. However, workflows specifically focus on data and often are driven by documents and reports. At any level they can download the documents to cross check the information pertains to approvals. Jay Gee Workflow gives you regular insights into what is occurring within your processes, the people involved, and a sense for how effectively your organization meet its deadlines.
Responsibilities
Gathering and Understanding the Requirement of the Business and the Users.
Conducting meetings and presentations to share ideas and findings.
Design and Created design documentation and data modelling for the entire project.
Created Database in Oracle, Created Stored procedures, View, Triggers, Functions in Oracle database.
Environment .Net Framework 4.8, .Net Core, C#, Web API, Oracle 11g, Visual Studio 2017, C#.Net, Angular 10, Involved in Coding, Testing, Deployment.
Used TypeScript, Components extensively in front-end client interfacing Angular 10 application.
Used ADO.Net extensively for retrieving, querying, and manipulating data in the database.
Designed and developed Entity Framework Code-First approach with Repository-Pattern based backend and used RESTful and Web API as transaction and communication technology to the client-side.
Created and consumed services in .Net Core, Web API to perform CRUD operations using HTTP methods (GET, POST, PUT, DELETE and PATCH).
Used AJAX for faster interactive web experiences with AJAX control toolkits.
Used LINQ to manipulate data in ASP.Net UI and developed WCF for SOA
Worked closely with Accounts, Marketing, Merchandise teams to understand their process.
Generating Crystal Reports / Excel Reports (Macros) / Power BI reports as per user’s request. analyze and interpret data.
Performing T-SQL, tuning and optimization of queries for reports that took longer execution time using MS SQL, Index Tuning Wizard and SQL Query.
Provide training, supporting, and guiding to the front-end Users.
Identified risk and potential issues and solve problems without delay.
Jay Gee Enterprises, Singapore June 2009 – June 2022
Technical Business and Data Analyst / .Net Lead / Developer
New STARS (Stock Tracking Accounting & Retail System)
New STARS is an integrated ERP solution which has various modules to manage the processes of the business. The information comprises of details about purchase, warehouse, sales, Inventory & CRM. It takes care of the entire life cycle of all the products which starts with the Purchase Order (PO) placed by the marketing/Merchandise team. After the shipment reaches the warehouse, the software system takes care of routing the package to the appropriate boutique. Many minor modules help in tracking the Current Stock, Sales, Defective/Returned items, Excess/Shortage from the manufacture, costing, wholesale/Concessionaire orders, Promotions.
Responsibilities
Gathering and Understanding the Requirement of the Business and the Users.
Conducting meetings and presentations to share ideas and findings.
Communicate with clients and evaluate their needs and specifications.
Designing the User interface, Database, Coding, Testing.
Environment .Net Framework 3.5, .Net, Vb.Net, Oracle 11g, Visual Studio 2010, Involved in Coding, Testing, Deployment.
Identify risks, control gaps and process break through sampling and testing for Process Controls assignments, complete with root cause analysis.
Analyse and validated data by running SQL queries in Oracle database.
Involved in financial analysis and other portfolio management duties to ensure the budget is met with in the project.
Generating Crystal Reports / Excel Reports (Macros) / Power BI reports as per user’s request. analyze and interpret data.
Provide training, supporting, and guiding to the front-end Users.
Lead, document and distribute results of the management and the users after the completion of each module.
Standardized trade life cycle workflows across all the modules and projects.
Worked as a liaison between Business and Technical teams to communicate requirement prioritization and implementation level of effort to make sure highest value features were given higher priority.
Communicative and facilitative - Able to communicate well with all levels of the organization.
Engage in refinement process of user requirements.
Constructed SQL queries to extract & analyze data in Oracle database responding to
data requests from the Management.
Identified risk and potential issues and solve problems without delay.
Day to Day Functional and Technical support including applying periodic patches, reporting requirements, ad-hoc requests from business and production system support.
Creating stored procedures, views, functions, triggers in the oracle database
Gather historical market data VIP customers purchase history and interpret the future sales based on the promotions.
Jay Gee Enterprises, Singapore June 2009 – June 2022
Technical Business and Analyst / .Net Lead / Developer
JGPOS (Point of Sales)
POS consists of various modules namely Sales, Goods Receipt, Goods Transfer, Stock Take, Stock Management and Alteration. POS is fully equipped with managing several types of promotion mechanisms. This POS is tightly integrated with backend system (New STARS). The information flows from POS to backend system and vice versa.
Responsibilities
Gathering and Understanding the Requirement of the Business and the Users.
Conducting meetings and presentations to share ideas and findings.
Communicate with clients and evaluate their needs and specifications.
Designing the User interface, Database, Coding, Testing.
Environment .Net Framework 3.5, .Net, Vb.Net, SQL Express, Visual Studio 2010, Involved in Coding, Testing, Deployment.
Identify risks, control gaps and process break through sampling and testing for Process Controls assignments, complete with root cause analysis.
Analyse and validated data by running SQL queries in SQL Express.
Generating Crystal Reports / Excel Reports (Macros) as per user’s request. analyze and interpret data.
Provide training, supporting, and guiding to the front-end Users.
Lead, document and distribute results of the management and the users after the completion of each module.
Worked as a liaison between Business and Technical teams to communicate requirement prioritization and implementation level of effort to make sure highest value features were given higher priority.
Engage in refinement process of user requirements.
Identified risk and potential issues and solve problems without delay.
Day to Day Functional and Technical support including applying periodic patches, reporting requirements, ad-hoc requests from business and production system support.
Creating stored procedures, views, functions, triggers in the SQL Express
Gather historical market data VIP customers purchase history and interpret the future sales based on the promotions.
Jay Gee Enterprises, Singapore June 2009 – June 2022
.Net Developer and Support
STARS / ETP Software
STARS is an ERP system which the company was already Using while I joined. I Was supporting the application both backend as well as front end POS.
ETP is an enterprise-class Omni-channel Retail Solution that seamlessly integrates point of sale (POS), customer relationship management (CRM) and loyalty management, merchandise and inventory management, assortment and OTB planning, marketing, and promotions planning, and business intelligence (BI).
Responsibilities
Generate Excel reports.
Coordinate with the vendor to report the issues and to fix the issues and bugs in the software.
Train the front-end staff with the new software (ETP) (POS)
Knowledge Transfer to the ETP developers (third party vendor) for certain modules in ERP as well as in POS
Compo 2000, Singapore May 2008 to June 2009
.Net Developer
Non-Conforming Wafer Tracing (NCWT)
Quality Visual Inspection (QVI)
Responsibilities
Interacting and Understanding the Requirement of the Users.
Designing the User interface, Database, Coding, Testing
Documentation for the functional specifications for the application
Technologies used .Net Framework 3.0, C#, Oracle 9i, Crystal Reports.
Creating Tables, stored procedures, views, functions in the SQL Server 2005
Generating the Crystal Reports.
Involving in complete SDLC.
Mitra IT Solutions (MSC Status), Malaysia Jan 2006 to Dec 2007
.Net Developer
Quality Visual Inspection (QVI)
Online Traveling Reservation System (OTRS)
Master Integration Import and Export Utility
Responsibilities
Interacting with the Users and Understanding the Requirement of the Users.
Design the interface, Coding, Integration, Testing, Documentation, Installation
Environment used, .Net Framework 3.0, C#, VB.Net ASP.Net, Web Services, XML, SSIS, SSAS, SSRS, SQL Server 2000/2005, Oracle 8i.
Generating the reports in SQL Server 2005.
Understanding the requirement and modifying the current application with latest technologies.
Working closely with DBA team for Creating the Tables, Stored Procedures and produce efficient Data Model on SQL Server
Generating the Reports in SQL Server 2000.
Creating Scheduler is windows application used to schedule the day and time for every Sub Modules for Import or Export the data.
Contact this candidate