● Coordinated 2 US regions account receivable and payable accounts
● Processed 2 to 3 large batches of checks, credit card payments, electronics transfers daily and carried our documentation on wrong payments, delayed payments, etc.
● Generated customer-specific reconciliation report at the end of the month and carry out adjustment upon approval by corporate accounts
● Extracted data From Various location such as Excel, CSV

● Developed, implemented, and monitored product plan with the business case and consistently achieved 10% year-on-year revenue growth
● Performed data extraction and transformation using advanced excel
● Using new customer analysis, Improved occupancy rate to 30%
● Used pivot tables to visualize data, create dashboards, and present as a report
● Ensured data accuracy through the creation and implementation of data integrity queries
● Created data models, solution designs, and data architecture documentation for complex information systems

● Using sales analysis, developed & executed integrated marketing strategies, defined customer buying behaviors, segmentation & profiling, and achieved a yearly revenue target of $2 million with a 10% yearly growth
● Extracted data, cleansed data to identify problems with low performing sales units, products, promotion, and recommend corrective measures regularly
● Created business reports to compare with projection and actual achievement, and helped taking timely decisions
● Effectively articulated reasoning for data model design decisions and strategically incorporated team member feedback to produce the highest quality data-models
● Gathered software requirements/business rules, and ensured alignment with development teams
● Designed and developed visualization solutions like Dashboards, Standard Reports, Scorecards, charts, and Ad-hoc Reports using MS Excel and Power-Point

● Developed and executed integrated marketing strategies including retail and wholesale channels to build brand equity and enhance the consumer experience at all touchpoints
● Managed both retail and wholesale portion of A&P Marketing budget of $10 million including annual financial plans
● Periodically reported and presented accurate Sales & Operational Planning (S&OP), monthly and yearly forecasts, accruals, and quarterly reporting with a detailed action plan for the near future
● Spearheaded the citycell.com platform marketing activities and worked with both the creative agency and IT experts to develop digital marketing elements for the e-commerce sites
● Maintained continuous communication with sales and merchandising team to support them to meet seasonal goals, tactical campaigns, and trade marketing collaterals
● Provided key updates based on market research to develop integrated campaigns including but not limited to online/digital, events, activation, media, PR, demand generation, social, and engagement programs

● Extracted data from the CRM system and analyzed trends and target a specific group of guests and recommend outreach programs
● Used performance data against set KPI to assess how different departments in the hospital was performing and recommend measures
● Prepared reports on business performance and presented during monthly meeting based on the CRM data
● Prepared product business case and compared against the industry average and prepare periodic review report based on data

The business request for this data analyst project was an executive sales report for sales managers. Based on the request that was made from the business we following user stories were defined to fulfill delivery and ensure that acceptance criteria were maintained throughout the project.