SUMMARY:

• 7 years of Business System and Data Analyst experience in various Domains like Information Technology, Airlines/Aviation, Healthcare, Financial, and Insurance.
• Hands on experience on SDLC project using methodologies like Agile (SAFe/Scrum), Hybrid, and Waterfall.
• Extensive knowledge in gathering requirements including; Business Required Document (BRD), and Functional Required Documents (FRD) through user interviews, workshops and existing systems documentation and procedures.
• Experience in complete Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Bug Life Cycle (BLC).
• Excellent understanding of Data Warehousing Concepts - Star and Snowflake schema, Slow Changing Dimension (SCD) Type1/Type2, Normalization/De-Normalization, Dimension & Fact tables.
• Analyst with diverse experience in all stages of the Software Development Life Cycle with emphasis on Business/Systems Analysis, Data Analysis, Gap Analysis and Quality Assurance.
• Experience in Data Profiling, Data Manipulating and Data Parsing using complex SQL queries against various Database Environments.
• Experience working with Excel functions like Pivot, V-lookup and a working knowledge of VBA.
• Experience in creating Source to Target Data Mapping documents using excel spreadsheet to capture all the business requirements.
• Worked closely with SMEs, Product Owners, Project Managers, and Data Architect to answer outstanding Business-related questions.
• Experience in working with large datasets for Data Management team for exceptional data handling.
• Worked in different relational databases environments such as Teradata, Oracle, SQL Server, IBM DB2 and MS Access.
• Involved in preparation of Test data to test the functionality of ETL Sources Mappings and Targets.
• Worked closely with Data modelers and Architects extensively on Data Modeling and Data Migration.
• Acted as a liaison between the development team, business stakeholders and product owners, to get the better understanding of the requirements.
• Interacted regularly with the development team, database designer, system administrator and the management, to meet the deadlines of Project milestones.
• Worked in close coordination with the testing team in developing test plan and test cases from functional and business requirements.
• Excellent communication, analytical, and presentation skills. Successful in meeting deadlines and handle pressure coordinating multiple tasks.
• Demonstrated strong interpersonal skills with the ability to work effectively with management and excellent leadership skills in motivating others.

TECHNICAL SKILLS:

Teradata, Oracle, MS: SQL Server, Microsoft Access, IBM DB2

ETL Tools: IBM DataStage, Informatica 10.1/9.1/8.6.1, SSIS 2005/2008, Pentaho

Reporting Tools: IBM Cognos, Tableau, SSRS 2005/2008, Business Objects (BO)

Database Tools: Toad for Data Analyst, Oracle SQL Developer, SQL Server Management Studio (SSMS), Teradata SQL Assistant

Data Modeling: Toad Data Modeler, MYSQL Workbench, ER Studio, Erwin, MS Visio

Management Tools: SharePoint, HPSM, HP ALM, ClearQuest, LiveLink, Confluence

Operating Systems: Windows 7, 10 /Vista/2000/XP/2003, Linux, Unix 5.2/4.3

PROFESSIONAL EXPERIENCE:

Confidential . Lafayette, LA

Consultant | Systems Analyst

Responsibilities:

• Analyze and document business requirements using Release Application Architecture (RAA), Logical Solution Architecture (LSA), Use Cases, and Architectural diagrams.
• Work with product owner, Subject Matter Expert (SME), and Architects to identify and understand business requirements.
• Work with product owner to prioritize the backlogs and to define user stories so that we can come up with business and functional scenarios.
• Collaborate with System Analysts, Development Team, Data Architects, Data Modelers, to clearly articulate specifications, business and functional scenarios, and approach for solving, based on analysis.
• Work with development team to create source to target mapping documents.
• Facilitate the meeting between technical teams, product owner and business stakeholders.
• Responsible for developing SQL queries, analyze the data, user stories, and confluence page with Functional Specification Documents (FSD).
• Translate business requirements into functional/non-functional requirements to support design and architectural changes.
• Responsible for creating business demo to demonstrate the current project capabilities and its solutions to the business stakeholders.
• Accountable for ensuring Quality Assurance Team is adequately prepared to test new functional components and the associated requirements. Involve in testing using different testing environments.
• Coordinate with third party vendors in order to complete development tasks.
• Hold weekly status call with vendors (offshore/onshore) and update the higher management accordingly.

Environment: TOAD for Oracle, SQL Server Management Studio, Oracle SQL Developer, HPSM, Rally, Informatica Power Center 10, MS Visio, MS Excel, Confluence, SharePoint Portal.

Confidential

Data Analyst

Responsibilities:

• Worked with business stakeholders/project managers to identify and understand requirement. Conducted user interviews and data analysis review meetings.
• Accountable for understanding established architectural decisions, technical standards, data governance processes, and defined analysis methodologies.
• Gathered business and functional requirements using various requirements techniques, including; interviews and workshops.
• Collaborated Architects, Data Modelers, and ETL Developers to clearly articulate specifications, business/system scenarios, and approaches for solving requirements, based on analysis.
• Worked with the business stakeholders to rationalize and prioritize the business/software requirements. Translated business requirements into software requirements specifications documented functional/non-functional requirements to support design and architectural changes.
• Worked with business stakeholders to conducted UAT testing to verify whether all the Requirements were catered to by the application.
• Worked as a liaison between the technical team (Data governance and ETL team) and the business operation team to plan the sequence of the workload and to prioritize the work based on the requirement for creating a Data Management Application.
• Strictly followed and meet designated governance rules, data architects’ rules, artifact standards and delivery timelines.
• Prepared source to target mapping (in-house/third party vender applications) document from the source system to the staging layer and then to the target system. Incorporated all the Business Logic Transformation (BLT rules) as well as Data validation rules to maintain the data quality and to maximize the data integrity.

Environment: Teradata SQL Assistant, SQL Server Management Studio, Oracle SQL Developer, IBM Cognos, Tableau, MS Excel, SharePoint Portal.

Confidential

Systems Analyst

Responsibilities:

• Highly accountable for understanding established architectural decisions, technical standards, governance processes, and defined analysis methodologies.
• Worked with Subject Matter Expert (SME) and business analysts to identify and understand requirement.
• Gathered requirements using various requirements techniques, including; one-on-one session, surveys, project team meetings, and workshops.
• Analyzed and documented business requirements using Business Requirements Templates, Use Cases diagrams.
• Conducted weekly requirements review sessions with Business Stakeholders, Project Managers, Development Team, and Quality Assurance team.
• Collaborated with Business Analysts, Enterprise and System Architects, Data Modelers Designers, Developers and Quality Assurance to clearly articulate specifications, business/system scenarios, and approaches for solving, based on analysis.
• Analyzed business operation processes and requirements; defines system process, data requirements and flows, service interfaces, and user interface requirements to meet the defined business requirements.
• Worked with development team to create source to target mapping document from various applications.
• Formulated and define systems scope and objectives based on both users’ needs and a thorough understanding of business systems and industry requirements.
• Worked with the business stakeholders to rationalize and prioritize the business/software requirements.
• Translated business requirements into software requirement specification documented functional/non-functional requirements to support design and architectural changes.
• Strictly followed and meet designated governance gates, artifact standards and delivery timelines.
• Documented solution requirements using process flows, functional specifications, data/entity flow diagrams, storyboards, User Interface specifications, and requirements traceability matrix.
• Acted strategically with a big view of the end-to-end solution requirements to implement technology.
• Worked with third party vendors on daily basis in order to complete the SDLC process.

Environment: TOAD for Data Analyst, SQL Server Management Studio (R8), Oracle SQL Developer, IBM DB2, HPALM, HPSM, MS Excel, MS Visio, SharePoint Portal.

Confidential, Columbus, OH

Business Data analyst

Responsibilities:

• Involved in requirement gathering from the stakeholders by conducting interview, one on one meeting session with the business users to create a Business Requirement Document (BRD), create Functional Specification Document (FSD) based on the BRD’s to provide it to different LOBs to source the data.
• Involved in creating a data model with the data architects for the staging layer which sources data from more than 15 different source system LOBs. Involved in data modeling of the inventory management domain to capture inventory of the files received from various LOBs on a daily basis.
• Ran SQL reports to provide it to the data inventory team for their daily operation.
• Involved in creating strategies to remediate the exception data by creating workflow to reach out to the appropriate LOBs.
• Ran analysis using different Excel functions and Pivot tables on the ad hoc basis as per required by the data operation team.
• Worked as a liaison between the technical team and the business operation team to plan the sequence of the workload and to prioritize the work based on the requirement for creating a Data Management Application.
• Involved in preparing S2T document from the source system to the staging layer and then to the target system incorporating all the Business Logic Transformation (BLT rules) as well as Data validation rules to maintain the data quality and to maximize the data integrity.
• Involved in creating mock-ups and wireframes of the to-be created Data Management Application to provide it to the application development team.
• Conducted JAD session with the technical team and the business operation team and drive the meeting to discuss about the roadblocks and brainstorming remediation plans.
• Performed gap analysis on the requirement of the Data Management Application versus the staging environment and work with the technical as well as business team for remediating the gaps appropriately.
• Involved with the reporting team to build universe in Business Object for ad hoc reporting purpose.
• Involved in preparing a user manual for the Data Management Application for the operation team.

Environment: Oracle 11g, TOAD, ALM, UNIX, Windows, Ab Initio, Business Objects XI R3.1, Share Point, MS Excel, MS Visio, SharePoint Portal.

Confidential, Columbus, OH

Business System Analyst

Responsibilities:

• Brainstormed with the analysts’ team to prepare a mapping document template to include all the required parameters for the development team as well as for the management team for capturing the progress status.
• Performed gap analysis on the functional requirement of the new application versus the legacy system data.
• Involved in preparing S2T mapping document from the legacy system to the new system incorporating the entire business requirement as well as data validation requirement for the developers. Also, provided pseudo codes to the developer to better understand the requirement using SQL.
• Worked on analyzing, remediating and suggesting for the issues logged by the QA team on the ETL codes and provide sample data set to support the validation.
• Involved in gathering requirement from the business team to in corporate it in the mapping document, worked with data quality team to prepare rules to be applied during ETL process to maintain the data quality and data integrity.
• Involved in preparing the document migration document and organized and conducted cross-functional meetings to ensure linearity of the phase approach.
• Involved in creating workflow process to remediate the exceptional data as a result of the migration process.
• Performed Data Cleansing, Data Mining and Data Mapping for change requests and new requirements.
• Conducted UAT to verify whether all the Requirements were catered to by the application.
• Assist developers in loading the data from the staging layer to the destination object and analyze the process time, run errors and discuss with the development team to enhance and expedite the process.

Environment: IBM DB2, AQT, SharePoint, Toad, Toad Data Loader, Pentaho, MS Excel, UNIX and Windows.

Confidential, Dallas, TX

Data Analyst

Responsibilities:

• Analyzed incoming feeds from different data source, conduct data profiling and creating a field-to-field source to target mapping document incorporating data validation rules and business validation rules to integrate the data into the target system.
• Actively involved in preparing Test plan, test case according to the Source to target mapping document.
• Performed gap analysis on staging environment versus the business requirement.
• Involved in creating BO universe design to provide ad hoc reporting facilities to the end users as per the reporting requirement.
• Monitored deterioration in data quality of incoming feeds through dashboard and by analyzing feed processing results. Conduct root cause analysis of the errors found in feed processing and report them
• Involved in the data reconciliation process between the data source and central data warehouse repository.
• Analyzed the impact of new requirements on existing system and request changes to existing data model and sub modules to accommodate new requirements.
• Worked directly with the data architect to design the data model for the staging layer.
• Review implementation techniques suggested by development teams for potential scalability, performance, maintenance or data quality problems
• Responsible for the analysis the source and the target system to initiate the data migration process effectively.
• Conducted data analysis using SQL & Excel as part of requirements analysis and to assist data quality teams.
• Involved in upgrading, designing, reports for the automation of XML files downloaded from website, using Business Objects/ Web Intelligence as front end and Oracle as backend.

Environment: Oracle, Toad, Business Objects XI R3.1, Windows XP, SharePoint, XML, MS Excel, MS-Visio.