PROFESSIONAL SUMMARY:

• 9.7+ years of experience as a Business and Data Analyst with strong banking & financial domain knowledge in high paced DWH projects and similar applications to contribute excellent Quality and expertise to support the employer in achieving the goals.
• Business & Data Analyst - ETL/BI Business System Analysis and SQL
• Confidential -Financial markets certified analyst in BFS domain
• Good knowledge on Data Warehouse concepts and writing complex SQL queries
• Good knowledge on dimension modelling to identify dimension & fact tables and associated data elements
• Co-ordinating with customers to collect use cases and convert into useful business requirements
• Hands-on preparation of source to target Data Mapping documents along with SQL logics
• Hands-on preparation of wireframe of report along with SQL logics for each data elements
• Hands-on conducting in-depth data analysis on the reports/dashboards to identify gaps
• Involves in data governance to find authoritative source
• Involves in data profiling to validate data quality issues
• RPA developer -Worked on a Confidential to implement RPA solution to reduce operation costs / risks, by building automation solutions
• Adept in Robotic Process Automation from requirements gathering, Solution designing, coding, testing, debugging, documentation and implementation
• Working within project planning constraints, communicating any identified project risks and issues to the delivery/project manager accordingly and providing inputs to the change control process
• Having hands on experience with commands Excel, database, image Recognition, Manage Window, controls & exception handling
• Experience in analyzing business requirements, current and future state process designs, translating them into process flows and Visual Business Objects within the Blue Prism object studio, Blue Prism process studio
• Good experience in working with different spy modes like html, Win-32 and Region modes
• Experience in usage of Control Room, Credential Manager
• ETL/Reporting Tester -- ISTQB certified analyst
• Good knowledge in preparing Test plan & strategy documents
• Involves in preparation of Test scenarios & cases
• Involves in end to end testing in a DWH project
• Hands-on validating ETL jobs to load data into target tables
• Involves in test data preparation if needed
• Involves in report and dashboard testing using SQL queries
• Hands-on using all modules including defect capturing in ALM
• Comprehensive experience in complete SDLC and STLC life cycles
• Extensively worked in AGILE and Water Fall methodology
• Good knowledge on creation of user stories in JIRA
• Worked extensively on on-time delivery, process improvement, regular interaction with client and mentoring the team

TECHNICAL SKILLS:

Data Profiling Tool: Informatica Analyst

ETL/Reporting Tools: Informatica, Datastage, Cognos, Microstrategy

Databases: Oracle, Teradata

Scheduling Tools: Control-M

Defect Tracking Tools: ALM 11, JIRA

RPA tool: Blue Prism

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Data Analyst

Responsibilities:

• Co-ordinating with customers to collect use cases and convert into useful business requirements
• Involved in dimension modeling to identify the dimension & fact table and associated fields
• Preparing Source to Target Data mapping document along with SQL queries
• Involving in discussion with dev team during the ETL designs phase
• Involving in result walkthrough with testing team during System and SIT phases
• Involving in UAT testing to validate high level test scenarios
• After data loaded into DataMart’s, involve in preparing the wireframe of the report along with SQL logics for each data elements
• Involving in conducting in-depth data analysis on the reports to identify gaps
• Involving in raising defects/issues/clarifications in ALM if any
• Involving creating user stories in JIRA and maintaining backlog stories effectively

Confidential

Blue Prism Developer

Responsibilities:

• Understand SDD and TDD documents
• Preparing ODI & PDI documents based on SDD & DD document
• Developing reusable actions in object studio and calling them in process studio
• Dashboard reporting
• Preparing Impact Analysis by analyzing the existing system for automation development.
• Preparing the design document about the automation process.
• Develop objects and integrate in process.
• Executing process from control room
• Implement Recover, Resume and Exception logic.

Confidential, NA

Data Analyst

Responsibilities:

• Had involved in preparing of Source to Target data mapping documents for ETL requirements
• Had involved in coordinating with the dev team during ETL designs phase
• Had involved in result walkthrough with the testing team during System and SIT phases
• Had involved in preparing wireframe of the report along with SQL logics for each data elements
• Had involved in conducting in-depth data analysis on the reports & dashboards to identify gaps
• Had involved in data governance to identify the Authoritative Source of the critical data elements identified by data steward used in the governance reports
• Had involved in data profiling to identify data quality issues of a data element using informatica analyst and SQL queries
• Had involved in discussion with SME & dev’s to come-up with remediation plan if there are any issues

Confidential

ETL/Reporting Tester

Responsibilities:

• Had involved in requirement gathering for test requirements
• Had involved in test scenario & case preparation
• Had involved in validating source to target table validations
• Had involved in IST, UAT & regression testing
• Had involved in cognos report testing by validating each data field against data source
• Had involved in report schedule testing
• Had involved in ad-hoc report testing
• Had involved in raising defects and defect tracking in QC

Confidential

ETL/Reporting Tester

Responsibilities:

• Had involved in requirement gathering for test requirements
• Had involved in test scenario & case preparation
• Had involved in verifying the ETL jobs as per the requirements
• Had involved in data loading of target tables using Control-M tool
• Had involved in source to target table validation
• Had involved in Initial and Incremental load testing
• Had involved in IST, UAT & regression testing
• Had involved in report and dashboard testing
• Had involved in raising defects and defect tracking in QC

Confidential

ETL Tester

Responsibilities:

• Had coordinated with developers for design documents to understand the business
• Had evaluated all requirements of business through mapping document and high-level design documents
• Had involved in verifying the ETL jobs designed as per the requirements
• Had involved in target tables data validation w.r.t source tables data
• Had involved in preparing and executing test cases
• Had analyzed tests results and identified areas where regression tests should be conducted
• Had involved in Defect tracking using QC