SUMMARY

• Results - driven professional with 11 years of experience in product management, analysis, design, development, modeling, testing & launch of Web based and Data Warehousing applications.
• Worked in different industries like Entertainment, Marketing & Research, Automotive, Insurance, Banking & Finance services.
• Expertise in understanding and supporting the client with project planning, project management, stakeholder & vendor management, release management, risk management, requirements definition, analysis, design, testing and user training.
• Strong experience in all phases of Software Development Lifecycle (SDLC) using Agile/Scrum, Waterfall, RUP (Rational Unified Process) and Software Testing Life Cycle (STLC).
• Expertise in taking real customer requirements & developing products that are innovative, valuable, cost effective & successful.
• Strong experience with Scrum framework and well versed in maintaining & prioritizing product backlog.
• Experience with estimating level of effort, resource allocation & performance analysis. Managed teams of 4-12 resources.
• Proficient in writing user stories, creating UML diagrams, use cases, acceptance criteria, data flow diagrams & screen mockups.
• Emphasis on requirements gathering through research, formal-informal sessions, JRP and JAD sessions with SMEs (subject matter experts), senior management, stakeholders and end users.
• Experience with conducting GAP analysis, Impact analysis, SWOT analysis, Cost Benefit analysis, ROI, and Risk analysis.
• Excellent analytical skills to understand the business process, functionality and requirements in order to translate them to system requirement specifications and technical specification document.
• Hands on experience in using ETL and Business Intelligence tools like Informatica, Tableau, Business Objects, Microstrategy with data sources like Oracle, MS SQL Server, Cassandra & SOLR etc.
• Strong experience in writing complex SQL queries/scripts for data profiling, data analysis and QA testing.
• Professional with extensive experience in the development, implementation and integration of strategies within a team oriented environment, utilizing quantitative and qualitative analytical skills.
• Proven record of Team Management and Leadership skills. Excellent communication and presentation skills in regards to communicating with both business and technical teams. Strong problem solving skills.
• Ability to quickly assimilate new concepts, technologies and apply software methodologies as per business needs.

TECHNICAL SKILLS

Project Management: Microsoft Project, Microsoft Office and Microsoft SharePoint.

Business Modeling Tools: Rational Rose, Microsoft Visio.

Requirements Mgmt Tools: Rally, VersionOne, TFS, Rational Requisite Pro.

Testing Tools: HP Quality Center.

Change Management Tools: Rational ClearCase, Github.

Methodologies: Agile, Scrum, RUP, CMM, Waterfall, XP.

ETL Tools: Informatica PowerCenter 9

Business Intelligence Tools: Tableau, Microstrategy, Business Objects XI, Crystal Reports.

Databases: DB2, Oracle 11g, SQL Server, Cassandra, SOLR, MS Access, MySQL, Teradata.

DB Utilities: SQL Query Analyzer, TOAD.

Programming Languages: PL/SQL, VBA, Visual Basic, JAVA, ASP.NET, UNIX Shell Scripting.

Web Technologies: PHP, Perl, JSP, JavaScript, HTML.

PROFESSIONAL EXPERIENCE

Confidential, Westlake Village, CA

Sr. Consultant/ Technical Product Owner

Responsibilities:

• Collaborate with various stakeholders & researchers from Auto, Insurance, Banking and Hotel industries to gather business requirements and design an analytical tool that provides JDPA an edge over its competitors in marketing & research field.
• Partner with business to plan product roadmap; work with other POs to assess competitive applications.
• Work with other product owners to build, maintain, estimate & prioritize product backlog and plan incremental releases to meet expectations of various stakeholders. Conducted quality checks on deliverables prior to their release.
• Responsible to analyze & document the requirements and making sure prototypes meet requirements across all clients.
• Work closely with Scrum Team (UX designers, developers and testers) to deliver the stories per release schedule.
• Responsible for multiple modules on VoX platform like Alerts & workflows, MDM (master data management), automating different interfaces with VoX, standardize print & export, mobile app etc.
• Collaborate with management, scrum team, product managers and support specialists on new requirements/production issues.
• Communicate status of automating data load project to CTO, Sr. VPs and Directors.
• Work closely with technical architect and leads to build a data warehouse that will support near real time data load to VoX.
• Analyze data from client survey to determine what functionalities/tools we could provide to end users in front end.
• Responsible to articulate & manage risk, prepare Release notes. Work with technical writer on user training docs (wiki).
• Support VoX operations, Research group and Configuration Leads throughout the Study life cycle.

Environment: Rally, SOLR, Cassandra, DataStax, NoSQL, MDM, Alfresco, Java, Github, Google Analytics & Scrum.

Confidential, LA, CA

Business Intelligence Manager/Sr. BSA

Responsibilities:

• Partnered with customers (Enterprise Finance Group, Sales & Marketing, and Auto & Home Product Management etc.) to develop analyses that lead to actionable insights that accelerated profitable growth.
• Worked on multiple BI reporting projects related to Auto & Home insurance.
• Facilitated scrum ceremonies and act as both Scrum Master and Analyst on small sized projects.
• Prioritized the sprint backlog to meet the expectations of business stakeholders.
• Identified opportunities for process improvement and developed proposals for implementation.
• Automated the development of usage summary report that saved nearly $40K every year.
• Managed and mentored onsite and offshore resources.
• Gathered and performed analysis on BI requirements, worked with onsite & offshore cross-functional teams & subject-matter experts from various teams to translate requirements into ETL mappings and BI reports.
• Responsible to deliver monthly data usage summary, scorecards, trend report & analysis to VP & Director of Enterprise data warehouse business intelligence team in a clear & concise manner.
• Performed impact and root cause analysis on defects discovered by internal and external groups; lead the team to resolve the issues per agreed SLA.
• Supported daily, weekly and monthly ETL load processes by providing oversight and SLA governance.

Environment: DB2, SQL Server, Informatica, SAP Business Objects, SAS, HP Quality Center, MS Excel Pivot Tables.

Confidential, Torrance, CA

Manager/ Sr. Business Analyst

Responsibilities:

• Developed & maintained project plan, action item list & process flows.
• Responsible to complete the scope, business requirements documents for both DPC and R&R projects and to deliver the improved functionalities as per the project timelines.
• Organized and participated in release and sprint planning, daily stand-up meetings, reviews, retrospectives and demos.
• Planned Sprints, prioritized the sprint backlog, lead teams, managed the development process & ensured crystal clear communication among the scrum team.
• Documented current & to-be business process, worked with stakeholders to prioritize the functional requirements for different iterations. Collaborated with business and cross-functional teams to remove any impediments for developers & QA team.
• Tracked and communicated team velocity and sprint/release progress.
• Identified risks, dependencies & issues and communicated risk mitigation & contingency plans.

Environment: MS Visio, UML, Oracle, Oracle Apps, Oracle ADF, Scrum, Quality Center.

Confidential, LA, CA

Manager/ Sr. Business System Analyst

Responsibilities:

• Served as a lead facilitator/partner to the TV marketing business clients and in conjunction with Functional Architect interfaces with other SPT business groups and outside vendors as needed.
• Responsible for Planning/ Estimating Resource and Budget per release to ensure On-time delivery of project
• Worked with the business users and thoroughly analyzed user requirements, conducted business process analysis and re-engineering activities, and developed functional requirement documentation.
• Monitored the project activities on daily basis & created weekly status report for business users.

Environment: MS Project, Oracle 11i, Informatica, Business Objects XI, SharePoint, VBA, HP PPMC, ServiceNow, JAVA.

Confidential, LA, CA

Sr. Business Analyst

Responsibilities:

• Facilitated meetings with Dealer Credit, Commercial and Legal stakeholders to elicit business requirements and define scope & timeline of the project.
• Worked with external vendors to find out the cost & effort estimation to implement Enterprise Content Management system.
• Designed and presented a presentation to BTS internal group that outlines the cost benefit analysis, ROI & viable options with breakdown of core business benefits vs. cost trade-offs.
• Assisted Sr. PM in designing of various documents like Project Agreement and deriving work/effort estimates.

Environment: Documentum, MS Project, MS Visio, SnagIt, MS Word and Excel and SaaS, HP PPMC, SharePoint.

Confidential, LA, CA

Sr. Business System Analyst

Responsibilities:

• Facilitated meetings with Residual (Financial) users & stakeholders to elicit business requirements & define scope of the project.
• Analyzed and documented the business requirements using use case diagrams, use case narratives, process flow diagrams, ensuring that the requirement statements are complete, traceable, unambiguous and conform to standards.
• Re-design the new Pension report and enhance the Guild Report to support the new Foreign Guilds requirements.
• Designed SOX test plans & test cases. Used MS SQL Query analyzer to design SQL Queries for data validation.

Environment: MS Project, MS Visio, SQL Server 2008, Informatica, SQL Query Analyzer, SAP BO, Scrum, TFS.

Confidential, LA, CA

Test Analyst/Lead

Responsibilities:

• Organized joint planning sessions with our business owners & SMEs from ecommerce, Customer Care, Sales & Marketing during the planning stage to ensure that all the business test requirements are covered in the IT SQA test strategy.
• Worked with large-scale e-commerce & call center systems like DOTCOM, Order Services, OMS & RIO. The DOTCOM application was B2C web application & Order Services was B2B system to place orders for new/existing customers/clients.
• Participated in weekly Assessment Meetings with Business Analysts, Subject Matter Experts (SMEs) and Developers to understand the business requirements in order to plan the testing process.
• Analyzed Business & System Requirements to create Traceability Matrix, Test Plans & cases using Quality Center.
• Assigned tasks and monitored the progress of resources. Reported progress to management by collecting test status from the test team, created daily/weekly status reports for business users and PMO.

Environment: HP Quality Center, Siebel CRM Call Center, STMS Billing system, OMS, TAOS, OS, ITIL ITSM, SCRUM.

Confidential, LA, CA

Business System Analyst

Responsibilities:

• Gathered requirements from various business groups. Developed data mapping documents for ETL development team indicating the source tables, transformation required, business rules and target table’s columns and data types.
• Point of Contact for Enhancement and Defect Change Requests. Involved in data model enhancements.
• Checked the reports for adherence to standards and quality before delivery.

Environment: Oracle 9i, Informatica, MS Access and Excel, Microstrategy.

Confidential, LA, CA

Business Intelligence Developer

Responsibilities:

• Created ETL mappings and SQL procedures to extract data from Mainframes and load data into TRM Data warehouse.
• Designed Universe & various reports for user verification like Cross Tab Reports and Sub Reports, various charts and graphs like Bar chart, line graphs, and Pie charts by using Business Objects and exported reports into formats like PDF & Excel.

Environment: Informatica 7.1, Oracle 9i, MySQL, Teradata, Shell Scripting, Business objects XI, Mainframes.

Confidential, MO

ETL Developer

Responsibilities:

• Interacted with Business Analyst to understand the business requirements and created Technical Design Document.
• Created ETL Procedures using Informatica for extracting data from Mainframes (COBOL), transforming into staging area and then loading data into Oracle Central Region Data warehouse (CRDW) using PowerCenter.
• Tuned performance of Informatica sessions by determining bottlenecks at various points like targets, sources, mappings, sessions.

Environment: Oracle 9i, Informatica, MS Visio, Shell scripting, AIX.

Confidential, TX

Web Developer

Responsibilities:

• Developed user interface and backend database. Developed a workflow management that will allow different levels of management to approve or disapprove a form.

Environment: MS SQL Server 2000, Dream weaver 8, MS Visio, ASP, ASP.NET, Java, JavaScript.

Confidential

Business Intelligence Trainee

Responsibilities:

• Extensively used PowerCenter Designer to create ETL mappings to load, transform and load data.
• Used Workflow Manager for creating, validating and running the workflows.

Environment: Informatica, Oracle 8i, XML files, MS Excel, Unix.