We provide IT Staff Augmentation Services!

Sr. Analyst / Project Manager Resume

Sunnyvale, CA

PROFESSIONAL SUMMARY:

  • Proactive and Goal oriented Senior Business System, Data Analyst & Project Manager professional, with 12+ years of I T (Information Technology) experience in field of Business Intelligence (BI), Data Warehouse, OLTP, ODS Big data, Decision Support System (DSS) & .Net/Java (Web/windows) applications.
  • 1+ year experience with Data analytics using Hive, Pig & Hadoop Eco system, with BI tools such as Tableau & BO
  • Elicit requirements using interviews, JAD sessions, document analysis, requirements workshops, surveys, business process descriptions, use cases, scenarios, business and workflow analysis
  • Experienced in solution feasibility study, Gap Analysis, analyzing existing / proposed systems solution and coming up with new business processes/ solutions and proposals. Liaison between the internal & external customers, business units, subject matter experts, technology, developers and support teams
  • Exceptional expertise in area of DW Solution, ETL, Database architecture & design or re - engineering, with ability to transforming business users and stakeholder’s need into Business/ Functional /Conceptual/Technical design requirement documents, Traceability Matrix and working solution/application
  • Successfully managed/ delivered several Program & large/medium scale projects, which are multi years, multimillion dollars, complex, enterprise division side and Multi-Site Operations Management - US & International.
  • 5+ Years of hands on experience in area of Project, Delivery, Risk and Resource Management such as managing project schedule, deadline, resources and collaborating with different teams and stack holders.
  • Demonstrated proficiency in Budget management, project initiation, planning, execution, controlling, effort estimation, time bound delivery, status reporting to Executive leaderships and identifying/planning for scope creeps
  • Developed and maintained project management artifacts such as Project/Program plan, Project charter, RACI matrix Cost benefit matrix, estimations, Forecasts, resource plan, release & deployment plan, Project financial (CPAX/ OPEX) tracking, change management, Risk/Issues tracking & status reports
  • Demonstrated proficiency in Project initiation, planning, execution,, controlling, effort estimation, time bound delivery and identifying scope creeps
  • Have strong analytical and management skills with excellent verbal and written communication skills with ability to interact a diverse group such as executives, managers, leads and subject matter experts professionally
  • Strong individual contributor in most of the projects with proficiency in diversified areas of application SDLC such as Reports and ETL requirement gathering, Database / ETL and report design, project management, ETL/ reporting solution development, performance tuning, testing, production rollout / implementations & support
  • Strong understanding of OLTP & Dimension (Start/ Snow flax schema) database schema and logical /physical data models designs created in Er-Win & Oracle SQL Developer Data modelling tools
  • Created data mapping, source Confidential mapping and data flow documents with strong understanding of Data warehousing design concepts also dig-in and understand the complex models with business processes and data profiling experience
  • Experienced in high/low level design of BI reports and SSIS / Informatica ETL packages, which integrates data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS / Informatica such as Data Conversion, Conditional Split, Lookup, Filter, Joiner, merge and union all
  • Rich experience in design of web and window based applications using C#.NET,VB.NET, ASP.NET, ADO.NET & WCF framework
  • Gained proficiency in software tools like M PP (Microsoft Project Plan), Visual Studio for SSIS,SSAS & SSRS, SQL Server 2008/05/00, DB2, RDBMS, Pl/SQL, AQT, Visual Studio for .NET, TFS, Various S/W tools, VISIO,OOAD and UML to achieve the project goals

TECHNICAL SKILLS:

Requirement Management: Clear Case, Clear Quest, Rational Rose, UML, MS Visio

Project Management: MPP (Microsoft Project Planning), Project Estimation/Cost / Timeline/Delivery/Release/Milestones/Resource and Risk management. Team Leadership, Task allocation and budget forecasting

Development Methodology: SCRUM / Agile / Water Flow

Big Data & Database Skills:

Big Data: (Hive, Big, Hadoop), Database Modeling using Er-Win & Oracle SQL-developer, RDBMS & Data warehouse concept. Performance tuning, Source / Confidential system analysis with SQL Server (2000/05/08), Oracle (10i) and Db2, and Teradata using AQT, TOAD, SQL Profiler

ETL/Reporting Development Tools & Version control tool: MS-Visio, ETL SSIS, Informatica Power Center

Reporting Tools: Tableau, Qlikview Microstrategy, SSRS, XSLT, and Crystal Report.

Version Control Tools: TFS, SVN Tortoise, Clear case, Visual Source Safe

Frameworks & Programming, Languages: RDBMS, Data Warehouse, ETL design, OLTP & Dimensional Data Modeling using Snow flake, Star schema, Facts and Dimension tables, C#.NET,VB.NET, ASP.NET, ADO.NET & WCF framework

S/W & database Mythology/ Testing Process: High/low level URS/FRS/DS designing & documentation, Oops, VISIO, OOAD & UML, Manual/unit/Integration testing & defect tracking with Quality center, rational rose, Analyzed and Developed Test Strategy, Test Approach, Test Scripts and Test Data

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Technology / Tools: Omni plan Project Management, Teradata, Vertica, Informtica Business object Universe, Java based frameworks, Oracle, STORM, Infomratica power center, Tableau, Confidential in-house tools like GSF,Radar,Espresso&Keynote.

Sr. Analyst / Project Manager

Responsibilities:

  • Worked with business users, source system SME, technical lead & testing team at onsite model to make sure all business needs getting implemented as expected and on time
  • Managing multiple large/ medium scale projects (as listed above) with total budget of around 3-4 million dollars
  • Worked with business, Source, technical & testing team at offshore/onsite model to make sure all business needs getting implemented as expected on time.
  • Extensively involved in requirements gathering from all users, experts and key personnel to understand the current functionality of the existing system with performing in-depth Gap analysis to ensure that the system initiatives are met.
  • Extensively gathered requirements/JAD sessions with all users, experts, and key personnel to understand the current functionality of the existing system with performing in-depth Gap analysis to ensure that the system initiatives are met.
  • Leading/managing 40+ resources team (cross vendors onsite / offshore team) for design, build, QA, deploy & support phase of the project who works in area of DB/ETL and BI reports using replication / Vertica / Infomratica / Tableau/ BO Universe/ Teradata .
  • Ensure the delivery of each milestones & project management of entire SDLC life cycle with preparing & controlling project /delivery / resource / effort estimations plans and Change Management process.
  • Managed BA, Technical and Testing team for Business / Functional requirements, traceability matrix, technical design, UI/ETL/Backend/Report development and Testing

Confidential, Addison, TX

Technology / Tools: Microsoft Project Management, Oracle, SSIS, Infomratica power centre, Er-win Data modeling, SQL Server 2008, VISIO, UML, TODD, SQL reporting services, Qlikview, Microstrategy & ZScaler

Sr. Business System Analyst

Responsibilities:

  • Deeply involved in proposing new process to achieve client goal efficiently with less budgets and in short time
  • Worked with business users, source system SME, technical lead & testing team at onsite model to make sure all business needs getting implemented as expected and on time
  • Perform analysis for proposed Confidential solution conceptual, logical & physical data model design and business rules for data flow and relationship between business objects
  • Deeply involved in new database design, ETL solution design, development, testing and implementation
  • Worked with business users, source system SME, technical lead & testing team at onsite model to make sure all business needs getting implemented as expected and on time
  • Developed and maintained project management artifacts such as Project/Program plan, Project charter, RACI matrix Cost benefit matrix, estimations, Forecasts, resource plan, Issue / Risk log & tracking, release & deployment plan, Project financial (CPAX/ OPEX) tracking & status reports
  • Manage and control project Scope, Schedule, Cost, Issues/ Risk, Quality and timely Delivery of the Project Deliverables
  • Leading/managing 30+ resource team (onsite / Cognizant offshore team) for design, build, QA, deploy & support phase of the project who works in area of DB/ETL and reports using Infomratica / Qlikview/ Microstrategy Oracle
  • Prepared the documents such as Business / Functional requirement, report design, traceability matrix, and Source/ Confidential data mappings
  • Manage and control project Scope, Schedule, Cost, Issues/ Risk, Quality and timely Delivery of the Project Deliverables
  • Leading/managing 30+ resource team (onsite / Cognizant offshore team) for design, build, QA, deploy & support phase of the project who works in area of DB/ETL and reports using Infomratica / Qlikview/ Microstrategy Oracle
  • Handled deployment/ release and Change Request process for new or modified business need long with post production support for defect fix
  • Prepared RACI matrix, Project charter, resource plan, Project delivery timeline and project plan based on detail analysis of current Specialty r
  • Report requirement /design and reporting legal contract and new reporting requirement for proposed Confidential solution
  • Deeply involved in the analysis of, current Confidential legacy source system & data structure, Specialty report requirement, source systems data flow analysis
  • Performed detail analysis on current Specialty report requirement /design and reporting legal contract also analyzed new data requirement, reporting requirement for proposed Confidential solution
  • Performed the analysis on existing 1000 + reports metadata, which belong to multiple Confidential departments or category such as payor, manufacture and dispense and based on reconciliation analysis Confidential able to reduced the number of reports to 400.
  • Performed report standardization, profiling and come up with detail report meta data analysis between multiple Confidential legacy source system to Confidential solution along with the business and technical data rules
  • Perform analysis for proposed Confidential solution conceptual, logical & physical data model design and business rules for data flow and relationship between business objects
  • Created UML diagrams such as use case diagrams, activity diagrams, and sequence diagrams also design the Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s) used in logical /physical data model

Confidential, Santa Ana, CA

Technology / Tools: Microsoft Project Management, DB2, SSIS, Micro-strategy, Infomratica power centre, Er-win Data modeling, PL/SQL,SQL Server 2008, AQT,VISIO,UML.

Sr. Business System Analyst

Responsibilities:

  • Prepared Business requirement documents, Functional design documents, Traceability matrix, Source/ Confidential Data mapping documents, Source system analysis documents along with data profiling
  • Prepared project plan, estimates, resource plan, RTM, Use case, Data flow, and activity diagram
  • Leading/Managing technical onsite/offshore team for design & building of DB/ETL/OLR using Infomratica/DB2/ MSTR.
  • Analyzed the reporting requirements and understand the data need and worked with Rx-Claims source system team for fulfilling Confidential data & report requirement
  • Worked with business, Source, technical & testing team at offshore/onsite model to make sure all business needs getting implemented as expected on time.
  • Deeply involved in design & build of database, ETL job using SSIS / Infomratica Power center, reports using MSTR also coordinated all related changes.
  • Involved in finalizing the logical & physical data model changes and worked with DBA to get those implemented in all database environments like production/Test/QA/Development.
  • Involved in development of database, ETL packages, stored procedures, function, triggers, new materialized views for the reporting functions which helped in improvement of application performance
  • Created UML diagrams such as use case diagrams, activity diagrams, and sequence diagrams, Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s) used in logical /physical data model.
  • Ensure the delivery of each milestone & project management of entire SDLC life cycle with preparing & controlling project /delivery / resource / effort estimations plans and Change Management process.
  • Perform analysis for logical/ physical Data Model, data dictionary as per universal data dictionary.
  • Utilized technical skills for the project in bug fixing during System integration testing and User Acceptance
  • Testing (UAT) defect fixing and tracking and updating code/documents as per changes required also involved in deployment of code in QA/UAT / Production as per Optum Rx CR process
  • Handled deployment/ release and Change Request process for new or modified business need / codebase along with post production support for defect fix
  • Created artifacts such as use cases, developed Use Case Diagrams, Activity Diagrams and Sequence Diagrams using Rational Rose and MS Visio along with effort estimations, BRD/FRS/DS/URS documentation,
  • Handling offshore/onsite team to apply the ETL/DB changes with leading team for project scope, delivery, timeline, and resource, risk management areas.
  • Conduct GAP Analysis in understanding how the upgraded system carries out the business functions and assists in ensuring the timely and effective implementation and conduct feasibility study and perform impact analysis for proposed enhancements and production support.
  • Involved in transforming the business requirements into ETL packages, procedures, functions and triggers using strong technical skills.
  • Identified sources / Confidential system also analyzed source data with data mapping documents and worked with sources as flat files, DB2, SQL server, Nateeza.
  • Production test Cases Preparation, QA process & Release Management. Defect fixing and tracking and deploying changes as required.

Confidential, Minneapolis

Technology / Tools: Microsoft Project Management, Data modeling (Er-win), SQL-Server2008, Oracle, SQL profiler, Red gate, SSIS,SSRS TFS, QC, Visual studio-2008.

Sr. Business System Analyst

Responsibilities:

  • Deeply involved in understanding business requirement and designing, which includes designing database & business layer.
  • Performed onsite coordinator and Module lead along with technical/process consultant at client side. Worked in all SDLC cycle of application.
  • Prepared high/low level Functional Requirement documents (FRD) and Technical Design documents (TDD).
  • Conduct GAP Analysis in understanding how the upgraded system carries out the business functions and assists in ensuring the timely and effective implementation and conduct feasibility study and perform impact analysis for proposed enhancements and production support.
  • Design Use Cases and create UML models such as Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and Flow Diagrams using MS Visio.
  • Build Logical & physical data model & worked with DBA to get those implemented in all database environments like production/Test/QA/Development.
  • Been involved in data migration/analysis using SSIS & Red gate, Schema compare tools, also worked in PL/SQL.
  • Worked in data conversion from PDX to Confidential also set up many test environments with production data with specific data requirement.
  • Created ad-hoc queries from SQL Server databases for custom reporting needs. Worked on querying data and creating on-demand reports using Report Builder in SSRS.
  • Mainly worked in HQ, patient, prescribe and Pharmacy Plan module. Also leading team of a common component, which used across application.
  • Worked on Performance tuning, and optimization of procedures and queries with Defect fixing, production rollout, Change request along with designing/building data warehouse on top of Redrock.

Confidential, SFO

Technology / Tools: ADO.NET C#.Net, MS SQL-Server 2000,DTS, VISIO,VSS

Sr. Business System Analyst

Responsibilities:

  • Prepared high/low level Functional Requirement documents (FRD) and Technical Design documents (TDD).
  • Was involved with requirements understanding as per Business need.
  • Design of the assigned modules (FAQ, Admin) which involves business logic understanding and understanding of Impact analysis.
  • Deeply involved in coding using C#.Net, ADO.Net
  • Developed reports using crystal and XSLT reports.
  • Have been involved in .Net coding, writing stores procedure, debugging code, bug fixing, testing etc as per user’s requirement.
  • Coding for entities, code reviews, stores procedure coding and reviews, test cases preparation, preparation of SP documents and XML schema documents.

Hire Now