Lakshmi Sree

Excel VBA - worked on Excel VBA based process automations (2 internal processes).
ECL Model - worked on IFRS 9 based ECL models for an Islamic bank in Bahrain.
Worked on chi square test, t-tests, paired t-test, binary test, KS test, descriptive and inferential statistical analysis.
Reporting writing of statistical inferences.
ECL Model analysis using Gini and Lorenz Curve, Population Stability Index (PSI, HHI), Pluto-Tasche Method, Merton’s model etc.
Oracle EBS/Dynamics CRM - system study, gap analysis and process documentation for a financial sector (IB Division) in Bahrain.
System studied Oracle Financials modules of Oracle EBS.

Taking care of start-up activities.
Complete HR activities (Recruitment, Shared Services, Pay-roll, Time Management, Performance appraisal etc).
Sales.
Operations.
Accounts.
Promotional activities.
LMRA.
Gosi.
Health Formalities.
Office Administration.
Software assessment and procurement.
Software installations.
Hardware procurement.
Computer peripherals procurement.
Employee Co-ordination.
Team Formation.
External and Internal Affairs of the business.
Generate sales leads.

Business Development activities.
Gained thorough hands-on of start-up strategic planning.
Business strategic planning.
Business roadmaps.
Technology roadmaps.
Competitor analysis.
Marketing strategy.
Brand strategy.
Digital marketing.
Usage of ML and AI in product advancement.
Product life cycle.
Product timeline management.
Visualization.
Investor analysis.
Pitch deck.

Develop and conduct training programs for employees of the software industry, and post-graduate educational institutions.
Confer with management to gain knowledge of work situations requiring training for employees to better understand the latest technology needs in the field of Business Analytics, Scrum, and Data Analytics.
Specialize in developing instructional software.

Worked as a Business Analyst consultant with an e-learning firm.
Placed as a BA End User, Product Development Trainer, and BA Consultant.
IIBA/PMI based Business Analysis and Process modelling certification training to end-users at Management and Executive level and Software professionals.
Providing user training in the field of Business Analysis, T-SQL, RDBMS, and Dataware house, MS Office Open Automation, BI, Reporting, and data visualization techniques.

Worked on customer data cleansing and data quality management.
Helped start-up projects create company portfolio, training modules, and business proposal documentation.
Actively participated in client/stakeholder meetings and product development meetings.
Helped with the pre-sales discussion of the product.
Worked on a few access/excel modelling and training projects relating to Business and data analysis.
Worked on creating MoU, RFP, and RFQ documents.
Participated in product/service pricing/deal generation activities.
Actively participated in Sales and marketing strategic planning and several start-up management initiatives.

Remote sql server programmer.
Web analytics and campaign event organizer.
Worked on Send Grid and internal tools to create web campaigns.
Data analysis and cleansing.
Business Analyst in analysing the existing processes and suggesting changes.
Data processing and log maintenance remotely from India.
Worked on open office automation and ETL (SSIS) process flow and data flow designs.
Wrote advanced T-SQL queries.
CRM system maintenance.
Extracted SKU data of the customer from the backend and also maintained the front-end GUI of the CRM systems.
CRM Management.
Web Management.
Data Management.
Reporting and BI were my job responsibilities.

Worked on Business Analysis.
Documentation.
VBA based model development.
Tableau working models.
Worked on Zoho Bigin, Zoho Analytics, Zoho CRM, Zoho Campaign, Zoho HR, Zoho Book & Zoho Desk.
Created roles, permissions, workflow automation, etc.

Completed project work pertaining to Software automation process and impact in the Information Technology Industry.
Rendered training pertaining to the arena of study as a part of the Professional Doctorate in Management, dissertation work.
Rendered training in specified areas of Business Analytics, Software Development Life Cycle, Data Analytics, Data Visualization, Scrum Master, Scrum Product Owner, Product Management and Quality Management.

Worked on customer data cleansing and data quality management.
Helped start-up projects create company portfolio, training modules, and business proposal documentation.
Actively participated in client/stakeholder meetings and product development meetings.
Helped with the pre-sales discussion of the product.
Worked on a few access/excel modelling and training projects relating to Business and data analysis.
Worked on creating MoU, RFP, and RFQ documents.
Participated in product/service pricing/deal generation activities.
Actively participated in Sales and marketing strategic planning and several start-up management initiatives.

Worked for Cisco Systems, California, USA as a Contractor pertaining to Headcount Management.
PR/PO processing/tracking/closure.
Budget/Allocation.
Spend Bucket Creation.
Allocation.
Spend Analysis.
Variance Analysis.
Gap Analysis.
Trend Analysis.
Pricing Analytic and Cost Optimization of Quarterly Spend.
To re-build the Spend Models.
Rebuild the Spend Analytics system.
Come up with new visualizations in terms of summary report presentation on a monthly, quarterly basis.
Graphical representation of the spend analysis, gap and variance analysis in comparison to the Budget and Allocation for various subunits within the main business unit.
Directly reported to the USA central finance team and worked during PST hours from India.

BMS Scorecard had to be automated starting from data extraction, data cleansing, data mapping, chart generation (from within excel and other BI Tools), and auto placement of the charts objects.
PowerPoint Presentations had to be automatically created and saved on the file repository portal.
Worked as a technical lead for the entire project.

Worked on creating cost models for the ITO cost modelling group.
Models were built using Excel VBA, Sharepoint, and SQL Server 2008.
Business Analysis and implementation or model development was my role.
Mentor the junior specialist and get the work done and deliver the cost models to the client regularly with accuracy.
Tasks involved +10 to -10 years seasonal forecasting and data analysis of 13 tower-based services provided by ACS, Xerox to the client.
Analysis involved budgeting for Staff based on the Labour Type (Contributory/Incremental).
Months of Transition staffing per employee.
Annualized Transition Staffing.
Transition Ramp Up.
Deal based Rates.
Employee Distribution Cost.
Standard FTE Count.
Base Salary Override.
Effective Rate Cost Per Month Per Unit Computation.
Labour Load Factors.
Headcount Efficiency Analysis.
Transition FTEs Analysis.
Directly reported to the Director of Cost Models, Denver - Colorado.
Interact with all daily to delegate tasks, see to the completion of tasks on time, and also address strategic management group queries relating to the new model development of existing model enhancements.
Received written appreciation from the Director of Modelling and Analytics group for my exceptional performance during my tenure with Xerox.
Worked during the USA PST time from India.

Excel, Access, PowerPoint, Word, and DOM Excel VBA programming.
Created tools and reports in Word VBA and Excel VBA.
Provided desktop macro support.
Electronic Distribution of reports created by analysts was the primary role.
Understand the domain-specific activities that the analysts performed on a day-to-day basis and create an automated tool to ease the task of chart generation, data extraction, and uploading the reports for publishing.
Worked on Word and Excel extensively daily along with VB6.0 applications.

Worked on projects that involved analysis of data on a statistic perspective relating to population-based deviation, variance computation, geographical location analysis based on the transportation, location adaptability for the crowd in the regional area, gender-wise analysis, goods commutation, and other natural resources impact of the site identified for building the Tesco Store or Hyper Market.
For geographical analysis, created a VBA code that can create a KML script that can be fed to Google Earth API as a query string to view the map-based output on the Google Earth application.
Written code to interact with Google’s Street View API.
Served both as a business analyst and a developer in analyzing the best locality for Tesco to build their store.
Worked during the UK timings from India.

Worked on Pre-Sales documentation (RFP/RFI), data analysis, and preparation of data to help the sales specialist share Reuter's capabilities in providing financial instruments data and information.
Stock performance calculation and modelling.
Ratio Computation.
What-If Analysis for Stock performance.
Worked on Reuters Code (RIC), Reference Data, Market Data, Time Series Data.
Worked on Data Scope Select, 3000 Xtra, PPPro, Data Scope Equities, IDN, NDA, Data Scope Fixed Income, Intraday Snaps, Stock Exchange data, Thomson Reuters Knowledge.
Comparison of Reuters Data with Bloomberg Quotes.
Worked on Data Mapping and Terms and Conditions for Equities, Fixed Income, Derivatives, Debentures, and warrants financial instruments.
Worked on creating data mapping and terms & conditions mapping on various Reuters products like 3000 Xtra, PPPro, Data Scope Select, Data Scope Equities, etc.
Worked on pricing Equity, Fixed Income Bonds, and FX instruments.
Worked in all areas of DMAIC.
Achieved Quality control in both process and software development projects.
Worked on creating a benchmark for various processes, matric creation, and assigning weights to each process in comparison to the previous year benchmark score assigned to each process.
Worked on automation processing as a part of the improvement and control phase of the process.
Implemented SPC and created various control limit charts.
Hands-on creating project charter, SIPOC, Swimlane Process Map, Tree Diagram, Data Collection, check sheet, Measurement Definition, Value Stream Map, Process Analysis, Data Analysis, Cause & Effect Diagram, Impact Effort Matrix, Weighted Criteria Matrix, To-Be Process Maps, FMEA, Control Plan, Response Plan, Control Charts, ISO Standard Documentation.