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.
