Marketing Database Analyst Resume
San Francisco, CA
SUMMARY
- 4+ years of IT industry experience which includes SAP Functional, Testing, Implementation, Support, maintenance and management working with MNCs like Confidential, Alcatel - Lucent and Confidential .
- 2+ years of Project and Internship experience with private firm industries including project management, database analysis, Risk Analysis, Data mining and Business intelligence.
- Proficient in gathering functional requirements, Technical and Business Writing, Business Process Flow documentation and other Requirement Engineering processes.
- Excellent analytical skills, problem solving, decision-making and presentation skills with ability to manage activities in a fast paced team environment.
- Good experience of Agile/ waterfall models.
- Participated in Requirement gathering, and preparation of Application flow diagrams, High Level and Low Level Designs throughout the Software Development Life Cycle.
- Involved in client meetings to study and analyze the requirements for the new requests, coordinating with the offshore team members.
- Excellent communication skills and is able to work individually and as Team member.
- Expert in Business/Technical document preparation with MS-Office, MS-Project.
TECHNICAL SKILLS
Project Management: Agile, SDLC, Six Sigma, SharePoint, MS Office, Adobe Photoshop
Business Intelligent Tools: SAS, Quicken software, ERP, ITSM, Citrix, Pivot tables, Vlook-ups File Zilla, Edit plus
Operating systems: Windows 7/Vista/XP/, UNIX, Android, IOS, LINUX, Blackberry OS
Programming languages: SAP (ABAP/FICO/CRM/SD), C, HTML, Putty
Database System: SQL, Epic (ALU specific), Ms Access, IBM Unica Campaign
PROFESSIONAL EXPERIENCE
Marketing Database Analyst
Confidential, San Francisco, CA
Responsibilities:
- Gathering the Business requirements from the Marketing managers and documenting it according to the criteria’s, conditions and the priorities.
- Act as a key liaison between line of business and campaign management team
- Play a key role in helping the Management build a Process workflow depending on the business requirements
- Extensively used SQL to design simplified flowcharts for complex campaigns.
- Generated reports in Microsoft Excel and presented the same to all stakeholders to show results
- Used advanced features in MS Excel like Pivot Tables, vlookup function and Macros
- Analyzed reports to generate meaningful insights so as to fine tune campaigns according to target audience
- Attended and lead Campaign Decision Tree meetings to understand and document the criteria’s.
Program Manager/Business Analyst
Confidential, Texas
Responsibilities:
- Worked through the various phases of SDLC, right from drafting the technical requirements to assigning them to developers and chasing it until it’s implemented.
- Maintained Program/Project plan, obtained project plan updates, monitoring project plan, setting up tasks in MS-Project.
- Analyzing the Agile and Waterfall customer project issues, which are failing in production or not working properly to find the root cause and fix the issue.
- Getting involved and initializing the test calls, SMS and end to end site installation process.
- Co-ordinate weekly meetings and track the issues to resolving and creating the weekly meeting updates with presentations.
- Worked in developing the SharePoint for more specific and detailed flow within the team.
- Proactively identify and escalate issues to ensure they are resolved as early as possible.
- Approving and authorizing the materials and shipments in between the vendors to the customers.
- Tracking all the details for different projects within the team and alerting the deadlines.
- Point of contact for internal and external partners/vendors.
- Used ALU specific tools like Epic to generate the data related to the materials and Lawson for approving the timesheets.
- Manage and track development schedules by Identifying and prioritizing the project tasks and risks. Gathered and collaborated the monthly reports.
- Interaction with stake holders and customers immediately in escalation issues.
Business Analyst/Quality Assurance
Confidential, Texas
Responsibilities:
- Experienced testing of web and mobile (Android, IOS, Blackberry OS) software applications.
- Written Test scenarios and Test cases. Helped in Test plan documentation.
- Have knowledge in testing methodology, tools, and techniques.
- Develop software test plans based on User and System Requirements documentation.
- Locate software problems and report them in a clear and easy-to-reproduce manner
- Write bug reports in clear and concise manner (using BUGMANTIC).
- Used the HP Quality center 10 and HP QTP for the purpose of testing the cases.
- Worked with Testing Team to facilitate comprehensive Quality Assurance Verification and Validations to ensure minimal post-implementations defects.
- Successfully coordinated System Integration Testing(SIT) and coordinated the efforts till User Acceptance Testing(UAT)
- Involved in Go live activities.
- Status Reporting - Facilitated for status meeting, including creation of agendas and recording of action items for meetings, received, consolidated and produced status reports for Projects using MS-Office.
- Issue, Scope, Management - Created and maintained issue logs, facilitated escalation and resolution of issues with appropriate participants, created a disciplined, well-coordinated process to manage changes in scope of projects.
Senior Business Analyst/Engineer
Confidential
Responsibilities:
- Worked for both Functional and Technical team in helping solve the Defects and Issues.
- Identified as a core resource to fast track production flow by operating the CITRIX Tool.
- Collaborate as a team lead for the Production Domain Team (This team deals with the Functional team as well as the Developers).
- Have done Debugging in SAP ABAP and solved the critical issues.
- Created and analyzed the critical issues using Excel, Word, PowerPoint and MS. Project which helped the project members solve the issues without further effort.
- Communicated the status to onshore and offshore clients in concise emails also direct contact.
- Experience deadline but was successful in Problem solving within the time span.
- Recognized for quality work, team performance and techno-functional capabilities with ' Confidential Celebrating Performance' award as well as ' Confidential Reward Points ‘for the extra-curricular activities
Business Analyst/Associate Software Engineer
Confidential
Responsibilities:
- Managed production domain in a SAP implemented project TOTAL Helios and solved the incoming critical issues.
- Worked and coordinated for the critical issues with the teams of different SAP modules.
- Reported and solved the bugs in different SAP Modules.
- Was trained and worked on SAP ABAP programming.
- Worked on tools like ITSM, Lotus, Citrix and many other Confidential specific tools.
Project Coordinator
Confidential
Responsibilities:
- Create and update databases as per client requirements also provide application support.
- Provide flawless data update for weekly databases, bi-weekly and Monthly databases.
- Applications supported are generally created in-house, and require heavy interaction and liaison between the development teams and the Clients to facilitate incident resolution and software enhancement.
- Take ownership of operational issues and perform both short-term resolution, and development of preventative measures for the longer term
- Management of multiple vendors developing custom applications using both agile and waterfall methodologies; as well as off the shelf configurable systems
- Primary contact and responsibility for global change management and application rollout of supported applications, including control of the production, disaster recovery, testing and in some cases development environments.
- Provide insights and observations that answer client business concerns, actively involved in handling business situations.
- Provide monthly, weekly reports with analysis highlighting and trends. Provide insights and added value inputs through internal research.
- Review effort, work dates and resource updates with project managers weekly.
- Provide end to end solution to customer business question through in-depth data validation.