We provide IT Staff Augmentation Services!

Senior Business Analyst Resume

PROFESSIONAL SUMMARY:

  • IT professional with 10 years of rich experience in IT service and consulting industry, currently working as a Senior ETL Consultant at Confidential .
  • Expertise on data integration, data quality, data cleansing and data processing using SAP BO Data Services (BODS) , business reporting using WEBI, Dashboard and Crystal Reports.
  • Extensively worked in the field of data warehousing with ETL tools such as SAP BO DATA Services(BODS),Informatica 9x,, integrating with Oracle11g, MS SQL server 2008 & 2012, DB2, VSAM, XML, Mainframe - flat files to design and develop high-quality product and solution for the business need.
  • Well versed in various programming languages such as Windows- Power shell scripting, Mainframe - COBOL, JCL.
  • Used different service management tools and change management tools for entire SDLC process of project as well as providing support and maintenance for product after go-live: Service Now, IBM Lotus PTM, HP Service Centre and BMC Service desk, JIRA.
  • Sound domain knowledge on Banking, Finance, HealthCare, Government Labor Department.
  • Created and maintained project document like, detailed design document, Test Plan and implementation document, code review, migration document and so on.
  • Involved in various phases of projects including Requirement analyzing, Designing, prototyping, development, documentation, review and testing.
  • Experience in working with multiple vendors, Offshore and cross functional team in various project management methodologies including Agile and Waterfall models.

SKILL:

ETL Tools: SAP BO Data Services (BODS), WEBI, Dashboard and Crystal Reports, Informatica Power center, Informatica Power Exchange, B2B Data Transformation, Pentaho, Data Flux.

Databases: Ms SQL Server 2008 and 2012, Oracle 11g, IBM DB2

Autosys, Control: M,CA 7

Service Management tools: Service Now,JIRA,INFOMAN

Mainframe Skills: COBOL, JCL,VSAM, DB2, SDF, Z/OS

Window Scripting, VSCOBOL: II, JCL

Operating systems: MVS/390,Z/OS, WINDOWS

Domain Experience: Banking, Finance & Healthcare, Government Department of Labor

Project Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential

Senior Business Analyst

Responsibilities:

  • Understanding business requirements and converting them into technical requirements and creating the requirement documents.
  • Designed the solution, creating/modifying the Data Models, defining the Data Dictionary and data mapping specs
  • Worked hands-on on the complex mapping and scripting for the quality and timely delivery of the product using the SAP BODS.
  • Effectively communicated with the stakeholders to understand the changing requirements, plan the release, building the solution and testing the quality of the solution with the third-party vendors, implementation plan through meetings as in required.
  • Plan the SIT and UAT and facilitate the same throughout life cycle before release of the product.
  • Provide the after go-live support and resolve the production issues.
  • Preparing the project artifacts such as Test plan, Implementation plan & Schedule and Recovery manual.

Environment: SAP BO Data Services (BODS), WEBI, Dashboard and Crystal Reports

Confidential

Senior Business Analyst

Responsibilities:

  • Understanding Client business requirements and converting them into technical requirements and creating the requirement document for the team members
  • Prioritize the user stories and backlogs to initiate the design and execution phase of the project in each sprint/release
  • Designed the solution around the ETL Informatica Tool integrating with the client provided resources
  • Provided the direction and solution to the offshore team by regular day to day communication
  • Worked hands-on on the complex mapping and scripting for the quality and timely delivery of the product.
  • Effectively communicated with the stakeholders to understand the changing requirements, plan the sprint, retrospective of sprint and sprint release, implementation plan through daily standup and meetings as in required.
  • Plan the SIT and UAT and facilitate the same throughout the sprints before release of the product.
  • Interact with the change control board to implement the product smoothly into the Production environment.
  • Maintained the defect life cycle to improvise the product quality.
  • Provide the after go-live support and resolve the production issues as per the SLA.
  • Facilitate any customer level escalation through proper channel by interacting with the onsite management and offshore team as in required.
  • Provide the project progress and forecast the risk to the upper management.

Environment: Informatica power center, B2b data /transformation. UNIX, Oracle

Confidential

Senior Business Analyst

Responsibilities:

  • Identified and assessed areas of functionality by leveraging existing tools, applications and services.
  • Participated in Requirement Gathering, Understanding Customer Requirements & documenting the complexity of the ETL system integration with application.
  • Mapped these Requirements to the Product Functionality
  • Participates in all phases of the development lifecycle including analysis, design, development, testing, code reviews and documentation throughout all the iteration and releases.
  • Integrated the developed component to the existing environment.
  • Participated in Test case building and execution for validating the ETL system.
  • Provided implementation plan for smooth transition into the Production environment
  • Represented the changes in the Change control Board
  • Closed the defects following the defect lifecycle
  • Provided the support for the further optimization of the ETL products

Environment: Informatica power center, B2B Data Transformation, UNIX, Oracle

Confidential

Senior Business Analyst

Responsibilities:

  • Interacted with the onshore coordinator on daily basis to understand the business requirements.
  • Worked with project teams to refine business requirements to technical specification that produce well-designed and developed solutions.
  • Worked on different sources like Mainframe files, DB Tables, flat files and FTP sources.
  • Analyze the data flow requirements and develops a scalable architecture for staging and loading data.
  • Prepare/implement data verification and testing methods.
  • Worked with multiple pipeline mappings.
  • Created complex workflows with more than 50 sessions including decision and event tasks.
  • Created Mapping documents, Production Implementation Documents.
  • Providing KT sessions to new joiners on the system overview and useful process being followed.
  • Co-ordinate the release activates before and on the day of release.

Environment: Informatica, SQL Server, PL SQL, IBM Initiate Inspector, UNIX

Confidential

Senior Business Analyst

Responsibilities:

  • Gathered requirements for the new applications on mainframes and mid-range systems from Functional & nonfunctional document received from onsite counterpart.
  • Developed code in COBOL as well as Informatica ETL mappings as per requirement.
  • Providing extract for UAT, jobs scheduling and implementing the jobs in production using version control tool ENDEVOR.
  • Using tool PTM (Production Turnover Management) to put the jobs in production along with
  • Assessed the Impact of change on component level.
  • Test the NDM scripts with third party vendors to assure successful transmission of datasets.
  • Production Support for CCH application maintaining the defined SLA.
  • Resolve user tickets and productions issues.
  • Continuous Improvement for the Application, Project releases and support.

Environment: Mainframe, COBOL/DB2, JCL, VSAM, CA7, FILAID, CHANGEMAN, Informatica 9.5.1 Power Center, UNIX shell Scripting.

Confidential

Senior Business Analyst

Responsibilities:

  • Interacted with business users and onshore team for requirements gathering of new enhancements.
  • Provide status to the upper management on the progress of tasks.
  • Maintenance and Enhancement of ETL Interfaces for data extraction into SDR.
  • Extensively used Informatica for loading the data from sources involving flat files to target as relational table.
  • Designing various mappings as per the business requirement.
  • Unit testing workflows at in DEV & QA.
  • Peer reviewing the mappings.
  • Batch Jobs Monitoring & Reporting for ETL workflows.
  • Escalation process in the event of Job failures according to severity and SLA.
  • Monitoring of Service Centre Tickets .

Environment: Informatica, SQL Server, PL SQL, IBM Initiate Inspector, UNIX

Confidential

Senior Business Analyst

Responsibilities:

  • Involved in understanding the existing system and providing a suggestion for redesigning the existing process and finding an opportunity for Performance tuning in jobs.
  • Performed Mainframe coding using COBOL/DB2, JCL and EASYTRIEVE.
  • Used CA7 Scheduler to schedule and execute the jobs based on the calendar schedule.
  • Used SDSF/SAR to run and monitor status of the jobs.
  • Unit testing workflows at in DEV & QA.
  • Batch Jobs Monitoring, Minor Enhancements.
  • Monitoring of Service Centre Tickets.

Environment: COBOL, JCL, VSAM, DB2, SPUFI, File-Aid, CA-7, CHANGEMAN, EXPEDITER, EASYTRIEVE

Confidential

Senior Business Analyst

Responsibilities:

  • Involved in understanding the existing system process and providing a suggestion for redesigning the existing process and finding an opportunity for Performance tuning in jobs.
  • Requirements gathering from business analyst and creating technical specifications.
  • Prepared detailed design for new interfaces, programs, jobs, DB2 tables.
  • Created Common module and routines to get better performance and reusability.
  • Used SPUFI to write SQL queries for extensive backend testing and to ensure proper backup and restoring of data.
  • Production Support to maintaining the defined SLA.
  • Resolving user tickets and productions issue.
  • Continuous Improvement for the Application, Project releases and support.
  • To develop and code all the elements JCL, COBOL, CONTROL CARDS, DOCs as per standard.
  • Testing after the development of code and to upload the test results in Mercury for Audit purpose and to send the code for UAT using version control tool ENDEVOR.
  • Monitoring of Service Centre Tickets.

Environment: COBOL, DB2, SDF, JCL, FILE-AID and ENDEVOR

Confidential

Senior Business Analyst

Responsibilities:

  • Analyze the ASSEMBLER codes and rewrite them in COBOL.
  • Migration of Easytrieve components to COBOL-Reporting Programs.
  • Prepare the migration standard Document which followed in project development process.
  • Good experience with relational databases DB2.
  • Experience in analyzing the entire system and the impact with the other backend and front-end systems.
  • Contributed in Project Requirement Analysis meetings with the onshore team.
  • Coordinated with the Onsite counterpart during production moves and support.
  • Participated in weekly status meetings and contributed views in project proceedings with Onsite counterpart.
  • Coordinated with the testing team for QA testing.
  • Experience in adhering to coding standards and finishing on time.
  • Capable team player who works well with people at all levels.
  • Scheduling/allocating/monitoring work among the team and being responsible for the successful delivery of the entire project/sub-project(s).

Environment: COBOL, ASSEMBLER, EASYTRIEVE, JCL, NET EXPRESS.MAINFRAME EXPRESS

Hire Now