We provide IT Staff Augmentation Services!

Ba/bi/data Analyst Resume

New, YorK

SUMMARY

  • Around 9 Years of Professional Experience as Business Systems Analyst wif strong noledge of Finance, Mortgage Banking and Health Care Domains.
  • Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
  • Proven success as a business analyst through teh years, providing a well - balanced understanding of business relationships, business requirements, and technical solutions.
  • Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
  • Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
  • Excellent in Developing and evaluating business process Models.
  • Experienced in developing reporting application using ETL (Informatica) and Cognos Business Intelligence Suite wif multiple data sources like Oracle, MS SQL and DB2 database, BlueWorks live.
  • Design and review of various documents including teh Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
  • Proven success as a business analyst through teh years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
  • Professional experience in business analysis, operations management and development, design, documentation and testing.
  • Excellent Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business and system requirements.
  • TEMPEffective in executing multiple tasks and assignments ahead of schedule. Created and maintained TEMPeffective budgets.
  • AnalyzingBusiness Intelligence Reportingrequirements and translating them into data sourcing and modeling requirements including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas, Snowflake Schemas, Operational Data Stores
  • Comprehensive noledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
  • Advised management on improvement strategies, Competitive & Profitability Analysis.
  • Exposure to Client/Server, Web Application developmental tools and Software development and design.
  • Understand inter-relationships between people, process, and technology
  • Work wif business partners to develop appropriate business cases
  • Take end to end Enterprise Application ownership for appropriate applications.
  • Demonstrated ability to identify root causes of problems, consider both teh long and short-term impact of proposed solutions and develop workable solutions. Ability to manage (Multiple)
  • Expert in teh functional and technical aspects ofOracle E-Business Suite/ Applications 9i, 10g and 11ideployment Requirements, Coding/Development, Customizations, Testing, and Functional User Training.
  • Interact wif business stakeholders
  • Business process modelling (map "as-is" and "to-be" business processes) using BPMN
  • Possess noledge of UML, BPMN, Rational Unified Process and Agile Methodology project tasks wif changing priorities and tight deadlines. Ability to work well in a team. Open to Team related tasks, team meetings, team interaction and conference calls.

TECHNICAL SKILLS

  • OOAD (OOA/OOD)
  • RUP
  • UML
  • SDLC
  • Agile
  • Waterfall
  • QA
  • WAP
  • CVS
  • TEAMMATE
  • MS Access
  • SQL Server
  • MySQL
  • PL/SQL
  • Oracle DBA
  • Java
  • Windows 98/2000/XP/7 basic UNIX
  • HTML basic DHTML basic XML
  • MS Office Suite-Excel Macros
  • MS Project
  • MS Visio
  • Adobe Photoshop
  • Flash
  • Rational- Rational Rose
  • Clear Quest
  • Rational XDE
  • Cobol
  • Requisite Pro
  • CaliberRM
  • Omniture
  • Crystal Reports various NIKU products
  • C
  • C++
  • Sharepoint
  • Docushare
  • BASIC
  • Intermediate level-Visual Basic

PROFESSIONAL EXPERIENCE

Confidential - New York

BA/BI/Data Analyst

Responsibilities:

  • Attended teh workshops for CCC - Credit Conditions Committee.
  • Created business use case, functional (FRS) and technical specifications for trading system.
  • Extensively involved in teh modelling and development of Reporting Data Warehousing System.
  • Gatheird teh capacity planning for all team members.
  • Used to prepare Data Layout, Data Mapping like Mapping from Data Layout to CSV stage mapping - CMP CCC-HUB mapping - Silver View mapping - Fin Master HUB mapping.
  • Worked wif different external and Internal sources like Oxford Economics, Arrow Global and World Bank, CCC - CMP, Reference HUB and FinMaster HUB.
  • European Central Bank
  • TEMPEffectively participated in CCC estimation stand up meetings
  • Attended Daily Scrum meeting for 15 minutes.
  • Worked TEMPeffectively wifin teh DSD (Data Solutions Delivery) and D&O (Data and Operations) team
  • Will be TEMPeffectively participated in all teh team and cross functional meetings for better understanding of teh project.
  • Developed and created functional design and specifications in partnership wif HR Functions and Teams.
  • Data Inventory, Data Dictionary, Data Governance, Data Quality, Data Integration, Data Mining.
  • Created User Templates for Manual Commodities, Macro and Industries
  • TEMPEffectively participated in Sprint Retrospective which occurs for every 2 weeks
  • TEMPEffectively participated in Sprint Showcase wif Business Stake holders
  • Will be analyzing teh data and identify teh bugs, by which will be able to sort teh data and get teh sign off from teh Business Owners.
  • Working on Toad 11.6 and 12.1 version and has to write teh queries to pull teh data from teh data bases.
  • Currently working in very big Agile methodology team consists of 21 members
  • Our large Agile team had been divided into 3 teams by which I had got an opportunity to represent my team as a Scrum master.
  • Used Version one tool for Agile methodology
  • Extensively involved in teh modelling and development of Reporting Data Warehousing System.
  • Prepared Business Requirement Documents (BRD’ Confidential ) after teh collection of Functional Requirements from System Users dat provided appropriate scope of work for technical team to develop prototype, Use Cases, UML diagrams for overall system.
  • Aggregated financial and product measurements using Cognos, BlueWorks live to produce express reporting wif unique factures dat would be used for incentive plan calculations.
  • Wrote detailed specifications for various reports generated using Cognos.
  • Identified Data warehouse and staging tables, Informatica workflows/mappings and tasks related to Finance data and customized Informatica mappings to load historical data.
  • Documented and evaluated test cases/test results/feasibility study of ETL tool Informatica.
  • Designed, implement, and document new information security architectures, technical control standards and risk analysis methodologies.
  • Developed strategic plan for information security risk management to meet regulatory requirements and audit recommendations.
  • Working wif business owners, DBAs, and other stakeholders to determine best approach to ensure security compliance on all regulated data
  • AnalyzingBusiness Intelligence Reportingrequirements and translating them into data sourcing and modeling requirements including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas, Snowflake Schemas, Operational Data Stores, etc.
  • Gatheird requirements and modelled teh data warehouse and teh underlying transactional database
  • Interacted wif users for verifying User Requirements, managing Change Control Process, updating existing Documentation.
  • Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed teh test cases and finalized.
  • Performed extensive data modelling to differentiate between teh OLTP and Data Warehouse data models
  • Conducted Joint Application Development (JAD) sessions wif IT groups. Identified teh Key Changes, and participated in Stakeholder Management to communicate TEMPeffectively wif them
  • Defined teh test criteria, project schedules and base lined teh Test Plan wif teh halp of project meetings and walkthroughs.

Confidential, Greenfield, IN

Sr. Business Systems Analyst

Responsibilities:

  • Created business use case, functional (FRS) and technical specifications for trading system.
  • Extensively involved in teh modelling and development of Reporting Data Warehousing System.
  • Strong experience wif Content Management system.
  • Clear understanding of ILIT service life cycle
  • Responsible for implementing an ITIL based Release Management Methodology dat consolidates and improves quality and communication of infrastructure changes.
  • dis Methodology will has touch points to Development, Engineering, and Operations. I was also responsible for maintaining and expanding teh current Patch Management process.
  • Prepared Business Requirement Documents (BRD’ Confidential ) after teh collection of Functional Requirements from System Users dat provided appropriate scope of work for technical team to develop prototype, Use Cases, UML diagrams for overall system.
  • Develop detailed work plans, schedules, project estimates, resource plans, and status reports.
  • Facilitate all Agile ceremonies including Retrospectives, Daily standups, Story Grooming, Demo/Review and Sprint Planning.
  • Trained agile methodology best practice methods, tools and documentation deliverables.
  • Defined project scope and objectives and coordinated activities of a project team.
  • Interpreted functional requirements in teh context of existing systems
  • Conducted project meetings and is responsible for project tracking and analysis.
  • Wrote detailed specifications for various reports generated using Cognos.
  • Identified Data warehouse and staging tables, Informatica workflows/mappings and tasks related to Finance data and customized Informatica mappings to load historical data.
  • Interact wif business stakeholders
  • Business process modelling (map "as-is" and "to-be" business processes) using BPMN
  • Possess noledge of UML, BPMN, Rational Unified Process and Agile Methodology
  • Documented and evaluated test cases/test results/feasibility study of ETL tool Informatica.
  • Work wif business stakeholders to understand practices end to end business processes
  • Drive strategic road-mapping activities wif business stakeholders and align roadmap requests to associated business processes
  • Guide business leaders and support strategic planning of business direction based on an understanding and analysis of business problems, objectives and risks
  • Working wif business owners, DBAs, and other stakeholders to determine best approach to ensure security compliance on all regulated data
  • AnalyzingBusiness Intelligence Reportingrequirements and translating them into data sourcing and modeling requirements including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas, Snowflake Schemas, Operational Data Stores, etc.
  • Gatheird requirements and modelled teh data warehouse and teh underlying transactional database
  • Interacted wif users for verifying User Requirements, managing Change Control Process, updating existing Documentation.
  • Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed teh test cases and finalized.
  • Performed extensive data modelling to differentiate between teh OLTP and Data Warehouse data models
  • Conducted Joint Application Development (JAD) sessions wif IT groups. Identified teh Key Changes, and participated in Stakeholder Management to communicate TEMPeffectively wif them
  • Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
  • Worked on Documentum for Version Controlling, to maintain up to date changes in teh Documents.
  • Assisted to develop teh Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product noledge.
  • Conducted User Acceptance Testing, gatheird and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, RUP, SDLC, UML, Oracle, Informatica, Cognos, TestDirector, LoadRunner.

Confidential, Herndon, VA

Business Systems and Data Analyst

Responsibilities:

  • Extensively involved in every phase of teh RUP process starting from Inception to Transition
  • Interacted wif users for verifying User Requirements, managing Change Control Process, updating existing Documentation.
  • Creating and running Sessions & Batches using Work Flow Manager to load teh data into teh Target Database.
  • Extensively worked on Database Triggers, Stored Procedures, Functions and Database Constraints optimized for maximum performance.
  • Extensive technical and business experience inProcure-to-pay,Order-to-cash, Quote to CashandAssets to GL Record to Report.
  • Generate new business solutions and/or processes to increase efficiency and maximize business value
  • Facilitate ideation discussions and advance ideation activities
  • Designed and coded application components in an Agile environment utilizing a test driven development approach.
  • Created and maintained project tasks and schedules.
  • Provided programming estimates, identified potential problems and recommended alternative solutions.
  • Worked in close cooperation wif project managers and other functional team members to form a team effort in development.
  • Collaborated wif other members of teh product development team.
  • Utilized pair programming approach to ensure high quality code.
  • Coordinated configuration of back-end components in support of application development.
  • Provide direction to IT delivery teams to ensure solutions provide expected business value
  • Analyzed business needs, created and developed new centralized back office system for specific area including mortgage and commercial lending system.
  • Responsible for interacting wif business partners to identify information needs and business requirements for Cognos Reports.
  • Utilized Cognos in conjunction wif Excel for reporting and budgetary purposes.
  • Used different ad-hoc analysis, teh Reports assist in defining strategy for each customer category. Informatica was used for ETL process and Cognos was used for Reporting duties.
  • Conducted a comprehensive use case analysis to determine key abstractions such as loan underwriting, loan-closed, borrowers-info, mortgage-payments etc, and their mapping to teh standard analysis mechanism to enable maximum reuse.
  • Write Technical System specifications for Operational, Legal and Compliance enhancements or changes in Empower.
  • Expertise in Data modeling forData Warehouse/Data Martdevelopment, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
  • Exposure in overallSDLCincluding requirementgathering, development, testing, debugging, deployment, documentation, production supportand Extensive experience in Project Management methodologies, Microsoft SQL Server database management, OBIEE.
  • Involved in various projects related toData Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
  • Conducted Joint Application Development (JAD) sessions wif IT groups. Identified teh Key Changes, and participated in Stakeholder Management to communicate TEMPeffectively wif them
  • Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion
  • Evaluated business process requirements to ensure proper system configuration (i.e. identifying key decisions, process changes, pain points, interface issues, training considerations, etc.).
  • Create and maintain requirements, test cases and defects in Mercury Quality Center
  • Working wif clients to better understand their needs and present solutions using structured SDLC approach.
  • Establish documentation for agile methodology for implementation wif a very water-fall-centric development team.
  • Utilized Agile/ SCRUM and PMI methodologies to monitor steer and develop project objectives.
  • Conducted User Acceptance Testing, gatheird and documented User Manuals and Business Rules

Environment: Windows, Oracle/SQL Server, PL/SQL, Mercury Quality Center, Informatica, Cognos, RUP, UML, MS Visio, MS PowerPoint.

Confidential, Atlanta, GA

Business Systems Analyst

Responsibilities:

  • Involved in all phases of software development life cycle.
  • Followed teh RUP (Rational Unified Process) methodology for elicitation and representation of requirements.
  • Clear understanding of ILIT service life cycle
  • Conduct kick off meetings using teh approved IT security framework to categorize information and information system.
  • Consulted wif internal clients on design and development best practices while keeping teh focus on risk areas regarding information security and privacy.
  • Facilitated data requirement meetings wif business and technical stakeholders and resolved conflicts to drive decisions.
  • For identifying logging and tracking related we used some third party tools like Bontq, FogBugz, Mantis, Dev Track and Bugzilla
  • Worked extensively on Erwin and ER Studio in several projects in bothOLAP and OLTPapplications.
  • Practical understanding of theData modeling(Dimensional & Relational)concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Contributed in defining teh scope of teh project and defined functional specifications.
  • Analyzed and documented teh system specifications, Business requirements; used teh tool DOORS for documenting, tracking and analyzing teh requirements.
  • Was actively involved in teh design of BRD, FRD, Use Case diagrams and Activity diagrams using MS Visio.
  • Responsible for daily status meeting to discuss development plans, quality assurance test plans, and user documentation wif developers, users, and teh product management.
  • Worked wif MS Project (MSP) to distribute teh tasks and keep track of status.
  • Develop & execute test cases and test scripts designed to ensure application quality
  • Responsible for numerous decisions in respect to business policies, procedures, methods for implementation.
  • Formulated project plans including staffing, analysis, development, testing and implementation.
  • Used UML to produce Use-Cases, use case diagrams and Activity diagrams to explain process flows and functional specifications.
  • Involved in identification of business rules, business and system process flows, user administration, requirements and assumptions.
  • Regularly interacted wif onshore and offshore teams to communicate requirements and review test cases and test plans.
  • Used Mercury Quality Center to look up defects and issues raised by testing activities.
  • Worked closely wif QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down teh bugs.
  • Produced and managed documentation on release activities to support problem resolution.

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows, Oracle, PL/SQL, SQL, SQL Server, Sybase, SharePoint, Unix, Agile/Scrum, C#. NET, Business Objects, Test Director, Load Runner.

Confidential, CA

Business Systems Analyst

Responsibilities:

  • Responsibilities include gathering business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in DataStage, and creating ETL jobs in DataStage.
  • Analyze and manipulate a large data sets, trading, orders and allocation data.
  • Created a test plan and a test suite to validate teh data extraction, data transformation and data load and used SQL and Microsoft Excel.
  • Worked wif Cognos and micro strategy reporting systems to extract teh data for analysis using filters based on teh analysis.
  • Created reports and Dashboards utilizing Excel and Cognos.
  • Directly involved in discussions wif financial engineers as well as traders on teh Fixed Income Trading Desk to conceptualize their needs.
  • Worked wif developers to make sure dat they understood teh Use Cases.
  • Worked wif teh Business, Operations, and Engineering stakeholders to define teh functional integration and end-2-end test cases for teh CRM project.
  • Monitored Performance measurement, Risk Management and Asset management.
  • Conducted current state study which included data collection methodologies, data quality and data integration problems, data storage and infrastructure related issues.
  • Used Microsoft Visio for Business Process Modelling and Data flow diagrams.
  • Involved in Managing Data modelling project from Logical design and implementation of Sybase Database
  • Worked on data modelling and produced data mapping and data definition documentation
  • Used Informatica to extract and transform data from various DB2 database to teh data warehouse.
  • Conducted User Acceptance Testing, gatheird and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows, Oracle, SQL, SQL Server, Sybase, EVPN, RUP, XML, VBScript, CRM, SharePoint, Informatica, Unix, DB2, Adobe Photoshop, Caliber RM MIS-IP, C#. NET, ASP.NET, Business Objects, TestDirector, Load Runner.

Hire Now