Project Manager Management

Swapnita Shirsekar (US Citizen)

**** ******** ***** ****** ***** TX 75022 Tel: 925-***-**** Email: ********@*******.***

Objective:

Seeking a professional position as a Report developer that will apply my experience in Report Development, Business and data analysis, structured thinking in business requirement capture, user acceptance and corporate and senior management reporting.

Professional Summary:

Highly motivated with over 7 years experience in data and business requirement analysis.

Experience in ecommerce, Personal Credit, Inventory management business areas

Used Agile and waterfall Methodology

Worked closely with client as a solution analyst and report designer. Paired with technology team to communicate requirement uses cases, test plans and conduct user acceptance tested to deliver production systems.

Experience in creation of WebI Document to create Master/ details, breaks, filters, drill, calculation based on 2D and 3D Pie Charts, bar charts and Line charts reports.

Experience in BOXI- Web Intelligence report Authoring, CMC, Infoview and BO Designer.

Reporting and presentations using SAP BOBJ 4.0 clients as in Explorer, WEBI, Crystal Enterprise, Bex Analyzer and Dashboard Design.

On Projects supported Project Management team on business scope definition, Vision analyses, use case detailing and timeline planning.

A self starter, able to work independently with limited supervision.

Familiar with operations of multi reporting tools Hyperion/Brio, Prism GEMS and GROW (Global Relocation Operations & Workflow).

Strong knowledge on designing SQL queries, teradata with Oracle and Access databases

Worked on Crystal reports 2008 for creating complicated and detailed reports.

Worked on Dashboard for creating metrics, Analytics like speedometer, Barometer and graphs.

Certified SAP HANA in 2013.

Education and Certifications:

Bachelors in Commerce with Accounts major from University of Bombay - India.

Diploma in Computer Management from University of Bombay - India

Diploma in Oracle 8 and Developer 2000 from Boston Institute, Bombay - India.

Certified SAP consultant in SAP HANA1.0 SP3 and SP4.

Computer skills

Microsoft Word, Excel with Macros, Power Point, MS Outlook, MS Access, Visio, Lotus notes

FoxPro, foxtrot scripts, InformEnt (BRIO QUERY), Mainframe, Share point

Oracle8 with Developer 2000, SQL server 2005, Toad, teradata

SAP Business Objects: - Web Intelligence, Desktop Intelligence, Crystal reports, Xcelsius

Experience

Company Name: JPMorgan Chase & Co., Arlington/Dallas, TX Sept 2012 to Present

Role: Business Analyst / Report developer

Responsibilities:

Working in operations on a remediation project.

Using Mainframe technology to validate accounts in banks in two different systems.

Working on testing for a project, which calculates the NSF and late charge fees and also grace days.

Assisting team in SharePoint for document retention. Created a form for the team to help Customer Service Representatives with their requests. Form is in SharePoint for easy communication with workflows and for use in team metrics.

Worked with manager in creating various department reports and statistics for management.

Working on creating a data base for security Reclarification for the department using access.

Automating the reports for the department.

Company Name: Verizon Wireless, Lewisville, TX Jun 2012 to Sept 2012

Role: Business Analyst/ Reporting Developer

Responsibilities:

Worked on financial reports and helped Customer servicing with reporting. Created various reports in Microsoft SQL Server Management Studio for tracking various centers, various representatives and the calls handled by representatives. Report also tracks the month-over-month sales of various devices.

Information exported to Excel where the data was massaged and then Pivoted, with use of Pivot formulas. Information was compared and graphed for management purposes.

Helped management Automate reports.

Maintained various Score Cards and also the Dashboard for the reporting purposes.

Developed a Crystal Reports, which is used by management as a daily report and is grouped by various departments and also graphed by departments.

Helped users grant access to various reports in Crystal Reports.

Created Mapping for the areas.

Company Name: Fannie Mae Addision TX Nov 2011 - May 2012

Role: Business Analyst

Responsibilities:

Requirement gathering, documenting Scope Documents, scope requirements for Business users. Worked on Water Fall methodology

Executing Toad queries for seller and servicing information.

Created dashboards in Xcelsius for monthly metrics report for the team.

Created 2D, 3D, Pie and line graphs for metrics presentations.

Developed and designed reports in web Intelligence with breaks, sections, filters, drills for easy tracking of Failed Lender notification Queue.

Worked on ad hoc queries and reports

Created Business documentation, testing, test cases and also participated in UAT (User Acceptance testing) for the Business users.

Managed various SharePoint sites for the team.

Set up demo for the Business user on Share Point Forms.

Used SharePoint Designer to create workflow for the forms, set email confirmation on workflows, set up tracking on workflow for the management. Also worked on granting user access to the other Analyst.

Company Name: Citigroup Irving TX May 2011 - Nov 2011

Role: Business Analyst

Responsibilities:

Requirement gathering and report generation for various Vendors, Business groups and for Customer. Worked on Agile methodology

Worked of submitting jobs in Mainframe.

Executed teradata, SQL queries, Access and excel for various Daily Weekly and Monthly reports.

Documentation the processes for the reports.

Worked closely with the MIS team and the Line of Business to investigate issues and resolve any reporting discrepancies.

Identify data process improvements and leverage technology to automate and streamline existing processes.

Designed Web Intelligence, Desktop Intelligence,Crystal reports and Xcelsius reports

Company Name: Paragon Global Relocation Irving TX Sep 2008 - Mar 2011

Role: Business Analyst

Responsibilities:

Organize requirement gathering working session with Stakeholders, Business Sponsor, Risk and Business team to capture requirement. Worked on Agile methodology.

Document Project Vision and Business Use Cases, Business Process flows, Test Plans and Test Cases.

Executed changes, researching production Issues and follow-up on issues through resolution.

Provide clients and internal staff with high quality, accurate and timely Relocation Expense data via reviews by extensive use of Excel, Excel macros, graphs and Access, ad hoc & standardized reports.

Maintained SAP Business Object Web and Desktop Intelligence reports.

Designed SQL queries for data extraction from Oracle DB and port them to Access

Apply updates to customer expense tables with tax information in Excel and then converted them to PDF for client view.

Used SQL joins, Access and Excel macros to provide data to business users via dashboard by querying Oracle Database

Prepared various Reports Initiation, Imprest Reconciliations/Expense Detail, Budget versus Actual (Accruals), Exception, Ad-hoc, Tax Service (Global moves), and Closed File reports Client Reviews (Financial Pieces) by using GEMS, SQL, Access, Excel and Graphs and Power point for presentation

Funding Requests/Reconciliations/Payroll for 4 major clients

Working on the UAT or a new System, testing and creating various reports. Reports creation for migrating clients as per client needs by using Access or Excel

Prepare client audit reports; Tax summaries, Completed special projects as assigned.

Created a report form in Excel where the account manager assigned the new adhoc to reporting team. The report form had all data validations and Check boxes.

Well verse with Vlookup, Hlookup, Pivots tables and Charts.

Company Name: Trignos Frisco TX Jun 2008 – Sept 2008

Role: Business Analyst

Worked as a Business Analyst on a ecommerce initiative for a company leading transaction processor in payment Industry. The Corporate Order Tool is a web application to provide capability to sell gift cards in bulk for partner incentive programs.

Responsibilities:

Organize requirement gathering working session with Stakeholders, Business Sponsor, Risk and Business team to capture requirement. Use Water Fall methodology

Document Project Vision and Business Use Cases, Business Process flows using visio, Test Plans and Test Cases and document business process

Worked with 3rd party vendor for web page designs.

Worked with engineering team to interpret requirements and review project artifacts.

Co-ordinated System Integration Test with QA team. Prepare test and confirm test data. Plan and execute User Acceptance Test. Prepare and document test data.

Worked with project manager to support project scheduling, delivery co-ordination, and Go Live preparation and Pilot release testing.

Documented Supplemental requirements for application performance planning.

Post production risk monitoring and statistical reporting by using Excel and Access

Company Name: Verizon Irving TX Nov 2007 – Jun 2008

Role: Data Analyst

Worked as a Data Analyst for Inventory management project. Statistical records were kept for each part with the vendor supply information.

Responsibilities:

Assists in the analysis of statistical data and extracts and defines relevant information from the previous operational reports by using Access and Excel.

Created ad hoc tables, upload data from flat files and massage data using SQL queries to support customer reporting needs.

Prepare statistical analysis of data reported to the inventory management team. Data was all in Oracle Database

Prepare and Maintained management dash board by using high level formulas in Excel.

Create ad hoc reports documentation of business process and analysis plus perform other duties as requested.

Company Name: Fire Side Bank (California) Aug 2006 – Aug 2007

Role: Collection Specialist II in CSC System Support Department

Worked as a Collection specialist for a bank. Worked on Delinquent accounts. Fireside bank deals with Auto Reposition.

Responsibilities:

Perform requirement gathering, analysis; write business and functional requirements documents.

Develops reports for forecasting and trend analysis using Excel ad relational database and SQL. Also used Foxtrot scripts and InformEnt queries

Setup Customer Inquiry IVR process and script to collect customer account information. Worked with technology team to integrate IVR with CSC application and Call center application.

Provided customer delinquent reports periodically to management and execute blocked credit and late charge on accounts in Excel.

Create and Analyses month end reports of charge off and Charge Off summary accounts by using Access.

Worked on oracle Database. Use Hyperion as front end software for query writing, joining various tables to get precise information for the management.

Company Name: Safeway Inc. (California) Jan 2006 - Jul 2006

Role: National Promotional Pricing Specialist (HW department)

Worked as a National Promotional Pricing specialist by working on Health and wellness retail item promotions on Weekly basics

Responsibilities:

Create and setup retail items for promotional for advertised and unadvertised specials.

Identify promotional overlap and take corrective actions.

Proof ad vehicles for pricing accuracy, determining the club price in Mainframe system

Create and maintain coupons and attach them to correct resale items in Mainframe system.

Ensure coupon limits and purchase requirements are met for all company stores.

Role: Data Analyst in Corporate Bakery

Project: Migration - Eatec

Worked as a Data Analyst in Corporate bakery where the old systems were migrated to new Software.

Responsibilities:

Familiarized the Safeway's Bakery Mainframe application.

Conducted data analysis for the Nutrition and Ingredient Maintenance system -NIMS.

Configured and Test new 3rd party Eatec application to support bakery production

and monitor shink. Built recipes, inventories and linked finished product to recipes in Eatec.

Manage Safeway's custom bakery products list, generate reports in Excel.

Forecast on production and distress/loss.

Contact this candidate