We provide IT Staff Augmentation Services!

Sr. Systems Analyst / Etl Developer Resume

4.00/5 (Submit Your Rating)

Indianapolis, IN

OBJECTIVE:

  • Resilient, proactive, zealous, dynamic, attentive and pragmatic Senior Business Systems Analyst with more than 8 years of experience in business analysis, implementing a variety of projects in Banking, Healthcare, and Insurance domain.
  • Certified Scrum Master and ETL Developer with a proven track record of working in self - organizing and cross-functional teams.

SUMMARY

  • Extensive knowledge, expertise and involvement in various phases of Software Development Life Cycle (SDLC) in Waterfall, Scrum, Agile (Extreme Programming, Test-Driven Development) and Scrum-Waterfall Hybrid software development life cycle environments.
  • Proven experience in conducting GAP Analysis, Risk Analysis, Impact Analysis, SWOT analysis Cost-Benefit Analysis, Cash flow analysis and Monte Carlo Analysis.
  • Proficient in networking with individuals at various levels and facilitating elicitation techniques such as survey/questionnaires, interviews, brainstorming, focus group, requirement workshops, interface analysis, document analysis, and JAD sessions.
  • Successfully gathered SMART (Specific, Measurable, Attainable, Realistic and Timely) requirements and transformed them into Business Requirements documents (BRD), Functional Requirement Document (FRS), Use-Case Specifications and System Requirements Specifications (SRS).
  • Expert in working with Rational Rose and MS Visio to model UML diagrams, Flow Chart, Swim Lane Diagram. Also, involved in creating UI/UX wireframes and mockup screens.
  • Extensive years of experience in Business process re-engineering and Business process improvements.
  • Expert knowledge in Data Warehousing concepts such as Data Mapping, Data profiling, Data Mining. Extensively created Entity Relationship diagrams (ER Diagrams). Performed Data Modeling Conceptual and Logical Models.
  • Programmed SQL Queries, Functions and business logic Stored Procedures and exposer to various database platforms such as Oracle and Microsoft SQL Server.
  • Working experience of Data Mapping, Data Profiling & Transformation through Mapping Designer and Workflow Monitor via Informatica Power Center
  • Captained the breaking-down of epics into User Stories (INVEST format) and then prioritized user stories using various techniques like MoSCoW and Kano Model.
  • Expertise in facilitating the workshops for efforts estimation techniques for user stories such as Planning Poker and T-Shirt Sizing.
  • Managed requirement churn to minimize the impact on current or next sprints.
  • Well versed in facilitating Sprint Ceremonies (Sprint Planning, Daily Stand-ups, Sprint Review, Sprint Retrospective and Backlog Grooming) for each sprint in Agile Scrum Methodology.
  • Experienced in creating Test Strategy, Test Plan, Test Scripts, Test Scenarios, Test cases, Requirement Traceability Matrix (RTM), User acceptance Testing (UAT), and familiar with software testing and Regression testing.
  • Worked on Jira, HP Quality Center (HP QC/HP ALM) and Rational Clear Quest for Managing Requirements and Tracking Defects. Directed the Quality Assurance Life Cycle from Requirements Gathering and Documentations phase to Testing phase.
  • Highly Skilled in Microsoft Office tools like MS Visio, MS Excel, MS Word, MS PowerPoint, MS Project and MS SharePoint.
  • Extensive experience in creating Work Breakdown Structures (WBS), Capacity and Resource Planning, and Estimating, Scheduling. Performed Risk Planning, Change Management, Quality Management, Issue Resolution, Defect Tracking and Prioritization.
  • Worked in Three-Tier architecture, Service oriented architecture (SOA) that used Ajax, Web Services. Gathered requirements for Client-Side Validation, and Server-Side Validation.
  • Knowledge of Financial reporting, Budgeting, Forecasting, Valuation and Portfolio Investment Strategies, Banking, leasing and Loan Operations.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile-Scrum, Hybrid (Waterfall - Scrum)Process

Modelling Tools: MS Visio, Rational Rose, Mock Ups, Wire Frames, ER Diagram.

Business Skills: Change Management, Impact Analysis, Risk Analysis, Cost-Benefit Analysis, ROI Analysis, JAD Sessions, SWOT analysis, Financial Reporting, Valuation and Pricing, Budgeting

Requirement Management/ Testing: JIRA, Rational Requisite Pro, RTM, HP QC v10.0, HP ALM V11.5

ETL Tools: Informatica Power Center v9.x

Data Analysis / Reporting: Tableau, MS Excel, SAP BO Reporting

Advance MS Excel Skills: Excel Macro, Data table, Simulation, Integer & Goal Programing, Solver, Sensitivity Analysis, Pivot tables, Pivot reporting

Databases: Microsoft SQL Server, Oracle 9i, 10g,11g

Data Modelling: Erwin Data Modeler, Logical/Physical/Dimensional, Star/Snowflake schema

Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, Data Mining, Slicing/Dicing, Drill Down/Roll Up

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

SR. SYSTEMS ANALYST / ETL DEVELOPER

RESPONSIBILITIES:

  • Gathered requirements from the end users and conducted JAD Sessions. Analyzed the of Business Requirement Document (BRD) to create System Requirement Specification (SRS) and Data Mapping Document for ETL processes.
  • Analyzed feasibility of business requirements and defined scope, found out dependencies by interacting with Management Business Analysts, other Subject Matter Experts, Product Owner, Project Manager and Technical Lead and managed them.
  • Created a Macro Document incorporating components such as business, functional, non-functional, data, and Reporting requirements which would in turn serve as the centerpiece of the project.
  • Created UML diagrams such Use Case Diagrams, Activity diagram and Use Case Narratives and incorporated them in Macro Document.
  • Worked closely with the Data Warehouse Architect to understand the architecture and need for the Warehouse. Conducted extensive GAP analysis by identifying AS-IS and TO-BE process models.
  • Analyzed and managed requirement, design solution, development and project execution, Go-live and release activities, and handeling production support projects.
  • Performed Data Modeling using Ralph Kimball approach and populating the business rules into the target tables. Designed the Entity Relationship (ER) Diagrams, Data Models, and Database tables and constraints using Data modeling techniques using Erwin.
  • Analyzed Change request (CR) related to ETL and BI applications, as per requests from various team, and implement the request.
  • Worked as ETL developer to map data from different homogeneous/heterogeneous systems and perform data transformation, data sourcing, data mapping, data conversion, and data loading using Informatica Power Center.
  • Migrated repositories and connections to different environments and work on complex flat files to transform the data set.
  • Analyzed the source data coming from Oracle, Legacy Systems, XML, Flat files, Excel files, DB2, SQLSERVER and Flat Files and worked with business users and developers to develop the Workflows.
  • Performed Data Analysis and DataProfiling using SQLand Excel on the business requirements on large volume of datasets.
  • Identifed and resolved the performance bottlenecks in various levels such as sources, targets, mappings, and sessions. Implemented complex business rules by creating mappings, mapplets, reusable transformations, and Partitioning.
  • Extensively used an Informatica debugger to find the issues in the existing mapping. Also involved in troubleshooting for existingETLbugs. Used HP ALM to track down the defects and close them.
  • Performed various DDL and DML SQL commands to perform various operations. Extensively used PL/SQL and T-SQL to write Stored Procedures, Functions, Packages and Triggers.
  • Used Update Strategy, DD INSERT, DD UPDATE, DD DELETE and DD REJECT to insert, update, delete and reject items based on the requirement. Extensively used Various Data Cleansing and Data Conversion Functions like RTRIM, LTRIM, ISNULL, ISDATE, TO DATE, DECODE, SUBSTR, INSTR, and IIF functions in Expression Transformation.

ENVIRONMENT: Waterfall, Informatica Power Center 9.2 & 9.6, Informatica Debugger. Oracle 11g, SQL Server 2014, SQL Navigator 7.2, Erwin Data Modeler, HP ALM, MS Visio, MS Word, MS Excel, MS PowerPoint, MS Access, MS SharePoint.

Confidential, Warsaw, IN

SR. BUSINESS SYSTEMS ANALYST/QA LEAD

RESPONSIBILITIES:

  • Interpreted the defined scope of the project based on the project charter and other scope-related artifacts. Provided estimates on time for requirements elicitation, documentation and review activities.
  • Spearheaded Joint Application Development (JAD) sessions with IT groups, project managers, project sponsors, and business users to analyze requirements and seek clarification. Identified the Key Changes and participated in stakeholder management meeting to communicate effectively with them.
  • Created business requirement document (BRD) and functional requirement document (FRD) to capture detailed user requirements. Got the sign offs from the Business Process Owner and Other Stakeholders.
  • Created Data Mapping and ETL specification documents for the ETL development team and SAP HANA team. Assisted the technical team to understand the nitty gritty details of the requirements during the development phase.
  • Worked with the ETL and SAP HANA teams to migrate and transform data from the source ERPs to feed the data warehouse by using Informatica Power Center and further create SAP HANA view based on reporting requirements.
  • Worked on the ETL process to migrate and transform data from the source OLTP systems to feed the data warehouse. Worked towards the process improvement, data structure normalization/de-normalization, data extraction, data cleansing, and data manipulation.
  • Participated in system analysis and data modeling, which required advanced SQL skills to create tables, views, functions, and procedures to facilitate consistent data entry into the database.
  • Assisted in creation of Data Marts and Operational Data Stores. Involved in deploying the OLAP cube and performing various operations such as Roll-up, Drill-Down, Slice, Dice by using SAP BOBJ Reporting tool.
  • Worked with the Lead Data Warehouse Architect in creating Dimensional Model by using MS Visio to ensure that the historical data is properly stored in the dedicated data marts and the requirements are properly captured in the data model.
  • Coordinated with the development team leads to understand and document the current and future state of the project architecture. Provided insights to the team and help them remove technical impediments.
  • Mapped the requirements with test cases to ensure that all the requirements have proper coverage. Tracked the defects and created defect reports to improve transparency between teams.
  • Led the Quality Assurance team to ensure high quality deliverables using HP QC. Created test strategy, test scenarios, test cases, and test script for functional and non-functional requirements.
  • Initiated test planning activities for test case design, and encourage the team to hold the review meetings and ensure that the review comments have been incorporated.
  • Responsible for loading requirements, test scenarios, and test cases in HP QC. Monitored test progress to redistribute the work assignment among resources. Collaborated with team members to improve execution efficient and achieve higher productivity.

ENVIRONMENT: Hybrid (Waterfall-Iterative), Informatica Power Center 9.0, Oracle 11g, SQL Server 2014, SQL Navigator 7.2, HP QC, SAP HANA, SAP BOBJ Reporting, MS Visio, MS Word, MS Excel, MS PowerPoint, MS Access, MS SharePoint and MS Project

Confidential, Tampa, FL

BUSINESS ANALYST / SCRUM MASTER

RESPONSIBILITIES:

  • Facilitated JAD Sessions with users, developers, and database design team to deal with backend synchronization issues accompanied with interviews and document analysis.
  • Identified the requirements of the stakeholders and created the initial Product Backlog (BRD) and Functional Requirement Document (FRD).
  • Designed the prototype Portfolio Supervisory System, including trend analysis, forecasting returns and interfaces for risk management, financial advisors and financial analysts. Predicted Portfolio’s returns using Monte Carlo Simulation.
  • Developed good knowledge of Equities, Fixed Income, Futures, Bonds, Bond Pricing, Derivatives (Options), Credit Derivatives, Interest Derivatives and Equity Order Processing.
  • Created Use Case Diagrams, Activity Diagrams and Entity Relationship Diagram (E-R) using MS Visio and developed a better understanding of Business Processes involved.
  • Created SQL Queries for Portfolio Drill Downs to pull necessary data from data sources.
  • Used SharePoint as Content management system for maintaining documents.
  • Helped the product owner in prioritization of Product Backlog Items (PBIs) using planning poker including the process of breaking down EPICS into user stories using INVEST criteria (Kanban, Safe).
  • Lead and time-boxed Scrum ceremonies. Helped negotiating commitments and assured parallel understanding of requirements and deliverables amongst all stakeholders in Sprint Planning Meetings.
  • Handled requirement churn during the project by performing Impact Analysis by checking the feasibility in maintaining the triple constraint and discussing them in daily Scrum.
  • At the end of each sprint conducted Sprint Retrospective meetings creating the environment for each stakeholder to freely express their opinions and suggest improvement measures.
  • Used JIRA for tasks allocation, user story writing, backlog management, issue tracking, user story management and forward and backward requirement traceability.
  • Defined Acceptance Criteria for User Stories to perform User Acceptance Testing. Worked with the Product Owner during the Sprint Review Meeting for the Potential Shippable Product Increment (PSPI) and help decide which feature is DONE and satisfied using the acceptance criteria.
  • Timely assured development team has necessary resources to perform up to potential, tracked and removed impediments.
  • Maintained Sprint burn down chart and Product burn down chart. Managed Product Backlog with the help of Product owner and Scrum development team by using JIRA also generated reports to analyze the performance of the project.
  • Created various types of ad hoc reports and drilldown like standard and cross tab reports with bar chart, pie chart and line-chart graph representation reports for analytics using Tableau.

ENVIRONMENT: Scrum, JIRA, MS SharePoint, MS Word, MS Excel, Web Services, XML, SOAP, JAVA, IBM WebLogic, Wireframes, Mock-Up Screens, MS Outlook, MS SQL Server 2012, SSIS, SSAS, SSRS, HTML, CSS, JavaScript, HP QC, Tableau 8.2

Confidential, NYC, NY

BUSINESS SYSTEMS ANALYST

RESPONSIBILITIES:

  • Understood the processes by interacting with stakeholders and conducted documents analysis and performed GAP analysis to assist Product Owner and Project Manager in planning the transition.
  • Substantial experience in conducting structured walkthroughs using workflow diagrams to identify, understand and conduct process analysis for business process improvement (BPR) and modeling.
  • Conducted cash flow analysis and preparing a summarized report relating to cash in-flow and cash out-flow
  • Conducted Root cause, SWOT analysis for the analysis to fully understand the current state of the system.
  • Facilitated JAD sessions as Moderator and conducted interviews with various Subject Matter Experts (SMEs) and stakeholders, process reviews and policy & procedure reviews to elicit requirements.
  • Prepared Business Requirement Document (BRD/HLD) and assisted preparation of System Requirement Specification (SRS). Analyzed, modified and validated these documents.
  • Created Use Cases and built Use Case Diagram and Activity Diagram using MS Visio.
  • Managed and tracked requirements using HP ALM through Application Life-Cycle.
  • Timely tracked progress and reported it to Stakeholders and Project Manager.
  • Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
  • Assisted Data modeling process by creating conceptual and logical ER diagrams and designing database schemas to help development of an accurate Data Warehouse Structure.
  • Integrated various OLTP to the OLAP by using Informatica as an ETL tool and used SSRS as reporting tool. Also maintained the Bill Inmon and Ralph Kimball Paradigms.
  • Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data.
  • Performed SQL query operation such as DML and DDL commands and supervised the source to target mappings in Informatica Power Center.
  • Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
  • Involved in using Tableau for effective ad hoc reporting to provide Business Intelligence (BI) to facilitate expenditure tracking using various matrices critical to decision making.
  • Involved in implementation by assisting in the preparation of training module. Helped the end users getting accustomed to the system by live demonstrations and system tutorials.

ENVIRONMENT: Waterfall, Informatica Power Center, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), Tableau 8.1, MS Visio 2013, HP ALM 11.0, MSSQL Server, UML, UAT testing, MS SharePoint

Confidential

BUSINESS SYSTEMS ANALYST

RESPONSIBILITIES:

  • Assisted and worked with Project manager in creating and assigned task through WBS.
  • Interacted with the customers and internal stakeholders to gather user requirements and their expectations from the system to create BRD, FRD and SRS.
  • Documented, prioritized, managed and facilitated estimation of User Stories.
  • Involved in analyzing Business Requirements and developing System Specifications.
  • Created UML Diagrams using Rational Rose.
  • Tracked and reported timely performance against plans and forecast analyzed gaps and recommended corrective measures to improve productivity.
  • Assessed business priorities, and advised business units by performing Risk Analysis.
  • Participated in the development and preparation of the Test Plan with the testing team as well as ensuring testability, reliability, usability, maintainability and performance of the application.
  • Involved in incident reporting and change management procedures using Clear Case.
  • Maintained and shared documents using MS SharePoint.
  • Managed test cases and logged defects using HP QC tool.
  • Formed a bridge between the Project Manager and different teams with effective presentations.
  • Designed and Implemented SQL queries for QA testing and reporting and reporting data/validation.
  • Planned and organized team engagement activities to encourage self-organization among the team.

ENVIRONMENT: Waterfall, Rational Unified process), Rational Requisite Pro, Rational Rose, HP Quality Center, MS Project, MS Visio, SharePoint, Oracle, MS SharePoint, MS Office (MS Excel, MS Word, MS PowerPoint)

Confidential

BUSINESS SYSTEMS ANALYST

RESPONSIBILITIES:

  • Determined User,Business and Functional Requirements.
  • Preparation of HLD, LLD and their reviews.
  • Created vision, scope, and use case documents, Use Case Diagrams, and Activity Diagrams.
  • Utilized RUP to configure and develop process, standards, and procedures.
  • Performed GAP and Risk Analysis of existing system and evaluated benefits of new system.
  • Conducted Joint Application Development (JAD) sessions with stakeholders throughout SDLC to resolve open issues.
  • Experienced in Analyzing Feasibility and risk analysis to identify thebusiness-critical areas from the user's perspective.
  • Worked with gathering requirement from stake holders and SME (Subject Matter Expert) by interviewing them, also prepared questionnaires and receive their feedback.
  • Performed SQL queries operation such as DML and DDL commands for data extraction and manipulation.
  • Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
  • Coordinated work plans between project manager and client using MS Project.
  • Created documentation for training and Help Desk teams.
  • Production release Coordination & Implementation support.
  • Documentation of production support related procedures, tips and best practices.

ENVIRONMENT: Waterfall, MS Word, MS Excel, MS Visio, SQL, Oracle, Rational Unified Process (RUP), Rational Doors, Rational Clear quest, Rational Rose, MS SharePoint, HP QC

Confidential

ASSOCIATE BUSINESS ANALYST

RESPONSIBILITIES:

  • Implemented SDLC which included Requirements, Specifications, Design, Analysis and Testing.
  • Performed Gap Analysis to check the compatibility of the existing system infrastructure with the newbusinessrequirements.
  • Involved in developing and documenting of Software Requirements Specification (SRS) and using Rational Requisite Pro.
  • Modeled the detailed design of the system using UML and Rational Rose, Use Case Diagrams, Sequence Diagrams, and State Chart Diagrams.
  • Handled requests for proposals, making presentations to customers, and negotiating project timelines and deliverables.
  • A major part of the responsibility included interacting with the users andbusinessrelationship managers and implementing changes on the database to ensure approval
  • Responsibilities include analyzing and testing the user interface and constantly redesigning the system to increase its user friendliness for the clients.
  • Prepared Test cases and coordinated the test results with the design team to match the needs analysis
  • Mentored thebusinessusers of insurance and customer support departments about the new integrated system functionalities.

ENVIRONMENT: Waterfall, MS Word, MS Excel, MS Visio, SQL, Oracle, Rational Unified Process (RUP), Rational Rose, SharePoint.

We'd love your feedback!