PROFESSIONAL SUMMARY:

• An IT professional from last 9+ years, an experienced business analyst in current role and also an experienced Support Analyst with a demonstrated history of working in the banking industry and getting exposure to all the phases of SDLC (Software Development Life Cycle) from ‘requirements gathering’ and ‘technical specification development’ to ‘testing verification’ and ‘implementation’.
• My determined attitude, problem solving skills, good communication and zeal to always learn helps me to be a person with personal and professional ethics.
• A good experience with Requirement gathering, Requirement analysis and then documenting the same into a Business Requirement Document (BRD) then a Detail Requirement Specifications (DRS) or System Requirement Specification (SRS), then also creating the Technical Specification Document (TSD) and the mapping specs for the development and testing team.
• Experienced in created project related documents like designing the change, activity diagrams and process flow using MS Word and Visio etc. to show the implication and adaptability of the new change or a new project.
• MS word is actively used for all project related documentation, reports. I am well aware of using bookmarks, hyperlinks, header - footer, page layouts etc.
• MS excel is used for data analysis using the in-built features / functions, pivot tables.
• Excellent experience with project stakeholders, SMEs and operational users/staffs to understand the requirements and specifications for new applications along with re-engineering the existing applications.
• Proficient in managing complex projects and situations there by fulfilling immediate and long-term goals for the project and the organization.
• Capable in adhering to organizational processes to streamline the project work.
• Good exposure to project planning and effort estimation.
• Excellent in performing Impact analysis and gap analysis
• Good problem-solving skills and communication
• Good knowledge about ETL processes using Ab-initio tool, Data Analytics, Data modelling and Shell scripting (UNIX).
• Have played crucial role in handling data quality issues which requires good analytical skill and quick response.
• Experience working in offshore /onshore model
• Good BANKING domain knowledge.
• Have good knowledge of Data Warehousing Concepts.
• Proven ability to work efficiently in both independent and team environment.
• Strong passion for learning new technology and improve on the existing ones.
• Ability to grasp new things easily and at a faster pace

TECHNICAL SKILLS

• Business Analysis Technical Analysis ETL
• Ab-Initio tool
• SDLC Agile Waterfall model Putty (UNIX)
• MS Word MS Excel
• MS PowerPoint
• Visio Netezza DB2 SQL
• Mainframe (for job scheduling and datasets)
• JIRA Confluence
• DB Visualizer AQT

PROFESSIONAL EXPERIENCE

Technical Business Analyst

Confidential

Responsibilities:

• Complete understanding of the applications.
• Thorough understanding of the requirements as per business perspective is important to have it accomplished through the change.
• In-depth analysis of the application with respect to the change and data involved is performed.
• Proper documentation in a TSD (Technical Specification Document) for team to understand the requirement and then do the code changes accordingly.
• Estimate the effort to meet project deadlines.
• Ensuring development and testing is per requirement and also as per schedule.
• Proper touch point meetings with the concerned people to ensure we achieve the desired results.
• Check the data in the QA environment to make sure the change / project is working as expected. If required we involve business users to verify the QA results.
• I have also helped out business partners by addressing their concerns with respect to any data they access for their reporting. Always provide logical explanation and support to their queries until they get satisfied.
• Experience to use confluence tool. It is leveraged to create a reference link / page for our business users to refer to for any access related queries for our database.
• Exposure of using Jira tool. Used it to track all the tasks handled within our team on a weekly basis. Jira is also used to raise requests / issues and assign to teams which are responsible for and helps in easy tracking and communication.
• Excellently manage team mailbox for addressing business user query like a data issue, access issue for the database or database performance.
• Ongoing effort to make sure there are no vulnerabilities on the database and also there are no OS level hardening issues.
• Being SME for an application, I had to work with multiple groups and performing analysis and how it impacts our applications.

Production Support Analyst

Confidential

Responsibilities:

• Understanding of the current processes and their schedules
• Making sure the critical applications met their SLA without any business impact.
• Working on production issues which involved -
• In depth process /code checks
• Data analysis
• Communicate with source teams or outside vendors concerning the files or dependent processes.
• Monitor the production environment for any issue and come up with preventive actions to avoid failures.
• Provide Ab-initio and UNIX support to the team whenever required.
• Actively involve for keeping our production environment in the best state. I have worked closely with the infrastructure teams to work on different patches / upgrades.
• In case of production incidents, depending on the criticality of the same actions are taken like EQF (emergency quick fix), expedited CR, data patch or contact the source team in case of issue from the source side.
• Provide full support to the downstream applications and also our business users for any concerns related to our process or data.
• Maintain the incident reports and other process trackers for the client.
• Updates the tickets history in REMEDY
• Have closely worked with offshore teams to maintain 24/7 support to the applications by helping them with all the required details like the pre and post steps for any change.
• Mentoring new team members till they get comfortable with the application.

Consulting Engineer

Confidential

Responsibilities:

• Project learning comprises of working with XML files and integrating data from various source systems.
• Developed graphs and plans to perform data quality checks based on the business requirement.
• Worked on connecting different tasks in a Plan for a required result.
• Performing transformations of source data with Transform components like replicate, reformat, filter-by-expression, rollup, fuse, sort, sort within group to implement logic as required by business.
• Handling of job schedules on their scheduled holidays.

Project Engineer

Confidential

Responsibilities:

• Developed graph to perform data quality checks based on the business requirement.
• Handling ‘ebcdic’ data.
• Worked with partition components like partition by key, partition by expression and efficient use of multi-file system which comes under data parallelism.
• Performing transformations of source data with transform components like Replicate, Reformat, filter-by-expression, rollup, fuse to implement logic as required by business.
• Use of lookup functions. Handling mail alerts in the Job.
• Creating files in XML format for the required server.
• Worked with vector form of Data.
• Transfer of files from one server to another.
• Developed generic graphs. It can load (insert/update/delete) data from the input source file (Serial/MFS) to target ORACLE table after doing transformations if needed.