SUMMARY:

• 5+ years of experience in Project Management, Business Analysis, Data Analysis with expertise in Business Requirements gathering, analyzing Business Work flows and translating requirements in specifications. Carrying out data extractions and executing data manipulations, Advanced Statistics (Mean, standard deviation, confidence interval, moving average).
• Experience in carrying out projects through all the phases of SDLC lifecycle.
• Proficient in creating Business Requirement Document (BRD), Functional Specification Document (FSD).
• Proficient in data mining and statistical techniques on small and large datasets.
• Excellent knowledge and working experience of relational databases.
• Experience in managing tasks and distributing assignments.
• Proficient in multitasking and prioritizing assignments effectively and work autonomously.
• Excellent knowledge of software development methodologies such as Waterfall and SCRUM/Agile.
• Participated in business and technical design sessions with multi - functional teams consisting of developers and QA analysts and have extensive experience in facilitating Joint Application Development (JAD).
• Extensive experience communicating with SME’s (Subject Matter Experts), performing requirements gathering, business analysis.
• Experience in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, and Business Process Flow diagrams using MS Visio.
• Skilled at reviewing test cases making sure they are in accordance with requirements, and assist the overall testing process by activities such as Change and Defect Management and conducting User Acceptance Testing (UAT).
• Hands on Experience in writing SQL, PL/SQL queries, Excel Formulas (VLookups, Concatenate, CountIf, Pivot Tables).
• Team player with excellent problem solving and analytical skills.
• Conducted Gap Analysis, Impact Analysis, Cost Benefit Analysis, and Risk Analysis.
• Possess excellent organizational, interpersonal, communication and documentation skills.
• Developed excellent professional skills in management decision tools like MS Project with proficiency in GANTT Charts and Project Tracking.

WORK EXPERIENCE:

Confidential, El Segundo, CA

Sr. Data Analyst/Project Manager

Responsibilities:

• Conducted user interviews for Data requirements gathering, analysis.
• Worked closely with the Team Manager in decisions for various tasks and distributing assignments among the team members.
• Provided business operations recommendations and changes based on analytical findings.
• Used Teradata to create databases to store DTV and ATT dataload.
• Managed project in the absence of project manager and successfully fulfilled all duties.
• As a team lead I was nvolved in decision making for setting up priorities and tasks.
• Used MS Powerpoint to do presentations for Leadership (SVPs, Directors) in different departments such as Entertainment, field engineering, marketing to support data driven decisions such as cost analysis, impact analysis.
• Served as the liaison between the business units, technology teams and support teams.
• Used MS Visio to create process flow diagrams to improve investigations approach for problem owners and data team.
• As a member of Agile/SCRUM TEAM, used KANBAN Board in JIRA to create an intake process to bridge gaps between data team and problem owners and speed up the investigations.
• Lead daily scrum standups and provided guidance to other analysts for creating user stories and managing tasks for the sprints.
• Used Cognos to develop high complexity reports with graphs.
• Connected Rcloud to Hadoop databases and did statistical mining like plotting, subsetting millions of record.
• Use Tableau to create dashboards for enginnering and network department.
• Created “Year over Year” reports using Teradata for cost calculations related to all products to Satellite and Residential Gateway (ISP modem/router).
• Played an important role in testing and identified potential issues with Data, related to system refresh, conversion, and reports.

Tools: and Technologies:Oracle SQL Developer, PL/SQL developer version,WebEx, MS SharePoint, MS Excel, MS Word, Adobe Acrobat, Cognos, Webforms, OBIEE, Business Objects, PUTTY, Agile/SCRUM, SAS, TERADATA, Statistics, R, RStudio, RCloud, Big Data, Hadoop, JIRA, KANBAN Board, Tableau.

Business Systems Analyst

Responsibilities:

• Conducted user interviews for requirements gathering, analysis, and design.
• Extensively communicated with SME’s (Subject Matter Experts) for business analysis.
• Elicited requirements in BRD (Business Requirement Document) using interviews, document analysis and followed Agile/Scrum methodology.
• Created User Stories using the requirements gathered in user sessions.
• Provided business operations recommendations and changes based on analytical findings.
• Configured application user interface according to functional specifications.
• Worked closely with the Team Manager in decisions for various tasks and distributing assignments among the team members.
• Extensively used PL/SQL queries in Oracle SQL Developer and PL/SQL developer for data mining.
• Created ERD (Entity Relationship Diagram) for the new system handshakes among different modules.
• Developed low complexity reports using SAS.
• Created Data Dictionary for different modules for new system Advance.
• Used Cognos to create “Quality Check” reports for eliminating data anamolies.
• Conducted Impact Analysis and solved complexities of data and provided solutions for better user experience for reports.

Tools: and Technologies:Oracle SQL Developer Version 3.2.20.09, PL/SQL developer version 10.0.3.1701, WebEx,MS SharePoint, MS Excel, MS Word, Adobe Acrobat, Sage Millennium, Ellucian Advance, Crystal Reports, Cognos, Webforms, OBIEE, Business Objects, Visual Source Safe, Agile/SCRUM, SAS, Constituent Database systems.

Data Analyst

Responsibilities:

• Extensively used SQL queries in SQLServer 2008 Management Studio for data mining.
• Solved complexities of data at all levels by implementing necessary solutions to help data meet required needs.
• Created mapping documents to map Post - Production data to the system and inserted using import functionality.
• Manipulated data in MS Access database used for tracking failed loans.
• Used MS Excel macros for doing mail checks and pdf checks for failed loans.
• Used Import/Export Wizard in SQL Server MS 2008 for importing and exporting necessary data to and from SQL server.
• Updated Post Production data proficiently if required using SQL queries in databases.
• Conducted live meetings using MS Live Meeting client with Production data team.
• Interacted with Product support team on timely basis to identify key issues related to Production data.
• Created Stored Procedures for joining two or more tables together, for inserting data from one table to another.

Tools: and Technologies:MS SQL server 2008, MS Live Meeting, MS SharePoint, MS Excel, MS Word, Adobe Acrobat, Mortgage information systems.

Business Systems Analyst

Responsibilities:

• Conducted user interviews for requirements gathering, analysis, and design.
• Used MS Visio for designing the application and created Kiosk Screen Prototypes, activity flow diagrams to help users and developers understand the user interface behavior.
• Worked closely with the IT Director in decisions for various tasks and distributing assignments among the team members.
• Followed Agile/Scrum methodology and interacted with system developers to resolve any questions related to Business requirements.
• Created Product Backlogs and prioritized the list of product backlog items (PBI’s).
• Conducted product planning meetings, sprint planning meetings, mid-week meetings.
• Extensively used SQL queries in SQLServer 2008 Management Studio to extract necessary data from five databases.
• Used MS SQLServer to manipulate and load data into an input data layout according to the system requirements.
• Created Change Requirement Document (Change Log) to capture all changes in requirements and new requirements for the system. .
• Created Defect Management Document to track defects in Kiosk and Administrative Module.
• Created Entity Relationship diagram for the new database.

Tools: and Technologies:MS SQL server 2008, MS Live Meeting, MS SharePoint, MS Visio, MS Access, MS Excel, MS Word, Adobe Acrobat, AccessHope CRM Software (Blackbaud Inc. ) Agile/SCRUM, Constituent Database systems.