We provide IT Staff Augmentation Services!

Data Analyst Resume Profile

5.00/5 (Submit Your Rating)

Summary

  • Over eight 8 years of experience in the consumer packaged goods industry and banking sector.
  • Excellent knowledge in development, customization, maintenance and integration of the Electronic Data Interchange EDI application.
  • Proficient on B2B, Gentran Integration Suite GIS , Sterling Integrator and EC Electronic Commerce systems.
  • Expertise on business process development and trading partner on boarding, creating technical and mapping specification documents.
  • Very strong hands on experience with EDI translators, EDI standards, ANSI X12/EFIDACT and XML.
  • Expertise in Integration with SAP iDoc, EDI, EDIFACT, XML, Flat files.
  • Extensively worked on production support and EDI transactions 810, 850, 855, 856 and 997.
  • Comprehensive knowledge on AS2, FTP, SFTP, FTPS, HTTP, HTTPS protocols.
  • Strong knowledge in creating envelopes and schedulers trouble shooting data quality issues, reprocessing of files and restoring the halted business process and error handling in business process.
  • Experienced in data analysis and reporting, reconciliations, business analytics.
  • Strong technical expertise in systems and tools like Business Objects, Crystal Reports, SAP and Oracle.
  • Ability to accept challenges and produce results in a fast paced, multi tasked environment.
  • Highly motivated team player having team mentoring skills with strong communication, analytical and organizational skills.
  • Technical Expertise
  • Industry Standards: EDI, EDIFACT, ANSI X12, XML, iDoc
  • Mapping Tools : SI 5.1, GIS4.3/4.2/4.0, Gentran 6.0 UNIX , Mapping Editor 4.1
  • Tools: XMLSPY, Open Source Ticket management tools.
  • Networking: FTP, FTPS, SFTP, HTTP, HTTPS, VAN, AS2, PGP, Sterling File Gateway
  • Database Reporting: MS SQL, Business Objects and Crystal Reports
  • Financial Systems: SAP Business Warehouse
  • Software Applications: MS office suite Access, Project, Visio, Excel VBA and Adobe Creative suite

Work Experience

1. Confidential

Role: Sr. EDI Consultant

Responsibilities:

  • Mapping of 810, 832, 850, 856, 860, 940, 945, 990 transactions for various trading partners.
  • Designed and developed inbound and outbound maps.
  • Worked with SAP adapter to retrieve the iDocs.
  • Communicated with trading partners for onboarding and created envelopes.
  • Developed the business process for trading partner using AS2, SFTP, FTPS, and FTP protocols.
  • Developed business process for both inbound and outbound flows.
  • Prepared schedulers to pass values and change the behavior of the business process.
  • Created code list in maps and business process in the internal application as requested by trading partners.
  • Traced and corrected problems with transmissions and worked on fixing data quality issues.
  • Cleaned up any halted business process in the admin dashboard.
  • Resolved all production issues and performed transaction tests according to specification file s .
  • Prepared all documents as per the guidelines and coordinated with customers to develop all EDI applications.
  • Participated in knowledge transfer of assigned business areas on EDI applications.

2. Confidential

Role: EDI Consultant

Responsibilities:

  • Worked on X12 map developments for 850, 860, 870, 856 transactions.
  • Development and unit testing of the translation maps.
  • Creation of new partners and successfully helped the Go Live of EDI Production Support.
  • Worked in inbound and outbound maps using SAP iDoc.
  • Created MFT routes for FTP, FTPS, SFTP protocols.
  • Debugging of the maps in unit testing phase.
  • Integration testing using Sterling Integrator 5.0 with backend CRM apps.
  • Participated in client meetings for issues and queries of map development.
  • Acted effectively as point of contact on status of EDI transactions for customers.
  • Involved in handling SI related production ticket.
  • Documentation and maintenance of all EDI solutions for system development life cycle to develop various transaction specifications as per requirement.

3. Confidential

Role: EDI Analyst

Responsibilities:

  • Interacted with the client to obtain the requirements.
  • Used Map Editor for developing maps.
  • Created the source and target structures according to the specification provide by the client.
  • Involved in mapping 810, 850, 875 transactions.
  • Worked on production support and SI related issues.
  • Involved in unit testing by using various test case scenarios.
  • Developed and prepared EDI documentation for internal use.
  • Evaluated all business processes and monitor transactions to resolved errors on EDI maps.

4. Role: Data Analyst Confidential

Responsibilities:

  • Performed weekly and monthly reconciliations between various sources of data such as bank statements, store accounts and banner wise accounts in T Recs Financial System and report to the senior management.
  • Prepared variance analysis report using the previous period's data, identify the reason for the variance, and document the explanation.
  • Upload the journals on a weekly basis in Oracle Financial system and send for the approval to the Regional Director.
  • Identify the problem store accounts, escalate and recommend appropriate course of action to senior management.
  • Gather all the fraudulent transactions from various bank websites and file the proof of the transaction in a timely manner to prevent the company from losing money.
  • Manage day to day accounts of stores related to electronic transactions and document any queries raised by store, bank or various regional directors.

1. Confidential

Role: Data Analyst

Responsibilities:

  • Single of point of contact for all data mapping issues, developing reporting validation errors.
  • Perform monthly reconciliations between internal data against market data Bloomberg financials and model data flow patterns to monitor trends in daily trading.
  • Perform thorough analysis on trade data and prepare reports for weekly meeting.
  • Manage and manipulate high volume trade data from Bloomberg, FITCH, Moody's and ODY sources, develop performance reports using Crystal Reports.
  • Present weekly trade data dashboards to the senior management and be the liaison between compliance, audit and finance teams.
  • Develop dynamic templates using Excel VBA and macros to reconcile data from primary and secondary sources of information.
  • Develop reports using Business Objects to cater Ad hoc reporting needs for bank's static data.
  • Coordinate cross functional teams involving finance, compliance and IT to ensure timely availability of data needed for reporting and implementing quality control.
  • Conduct monthly trainings to new recruits on data management, reporting and reconciliations.

5. Confidential

Role: Analyst Wealth Management

Responsibilities:

  • Track and review sales groups' performance, examine revenue trends and assess market conditions.
  • Conduct weekly meetings with senior management to evaluate key indicators, including market conditions, sales projections and emerging opportunities based on competitive analysis.
  • Develop forecasting models to examine short and long term growth based on sales projections, cash flow analysis, asset valuations, liabilities, and credit risks.
  • Manage the MIS reports on Sales data.
  • Evaluate, research and share market performance reports to help clients choose the correct portfolio of assets through investments, insurance and savings.
  • Ensure compliance with the company and regulatory requirements and guidelines. Report any noncompliance incidents to the immediate manager.

We'd love your feedback!