PERSONAL SUMMARY

An enthusiastic, self-motivated Business Systems Lead/data analyst, who has good organizational skills, is highly efficient and has a good eye for detail. Has extensive experience of assisting in the development and upgrading of data warehouse Application systems and has received accolades from the clients, worked so far. Able to play a key role in analyzing problems and come up with creative solutions as well as producing methodologies. A quick learner who can absorb new ideas and can communicate clearly and effectively.

WORK EXPERIENCE

• Business Systems /Data Analyst with 6 plus years of diverse experience in Information Technology with focus on Business Analysis, Technical Analysis, Business Modeling, Requirement Gathering, Systems Analysis, Technical Documentation, System architecture, Software Validation, Development Design.
• Six years of progressive experience working with various peers of Banking, Retail, Pharmacy/Health Care domains with focus on Data Warehousing/Database Application Analysis and ETL Development using Ab-Initio ETL , UNIX and Teradata/Oracle RDBMS SQL .
• In-depth understanding of all phases of Software Development Life Cycle SDLC , with focus on translating business requirements into viable technical solutions.
• Rich Experience in requirement analysis, client interaction, development, testing and maintenance of the Data warehouse applications.
• Thorough understanding of the issues involved in Data mappings, creation of technical specifications documents and design process diagrams and also development and integration of warehouse Applications.
• Extensive experience in developing Use Cases and documenting AS-IS and TO-BE scenarios, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis and Impact analyses.
• Experience implementing operational and dimensional logical and physical design for Data Marts, Data Warehouse and Business intelligence solutions.
• Experience in Creating Database Change Requests DBCR and Data Modelling Artifacts to define the mapping between persistent design classes and persistent data structures, managed by the system.
• Served as a point of Contact for Teradata Migration 12 to 14 projects.
• Hands-on experience in end-to-end Data warehousing process methodologies, which includes developing warehouse SQL scripts, ETL Ab Initio Routines, stress testing, and data quality processes.
• Proficient in Functionality Testing, System Testing, Integration Testing, and Regression Testing and UAT.
• Extensive experience in working collaboratively with Senior Quality Assurance Analysts to develop and implement quality assurance standards, procedures. Determined testing measures for monitoring the business functions of new or enhanced systems.
• Team lead skills encompassing user interviews, coordination with Tech Lead, DBA's, Developers, QA/QC Analysts during the Lifecycle of the Application deployment.
• Expertise in Problem solving and generating Bug Reports using Defect Tracking Tools. Strong knowledge of MS Office product suite.
• Hands-on Experience in developing UNIX shell wrapper scripts. Practical experience working on multiple environments like production, development, testing.
• Conducted PCI compliance awareness sessions across the organization.
• Experience Working on Agile development methodologies
• Worked with Scrum Team in developing the Artifacts such as Product Backlog, Sprint Backlog, Sprint Burndown and Release Burndown.
• Certified ITIL Professional.
• Expertise in ITIL based Remedy Change and Release Management Systems to document, track, authorize, and record implementation details of production code deployments
• Participated in Change Advisory Board CAB meetings on the implementation of Production Changes. Assessment of risk and business continuity, Change impact, resource requirements and Change approvals.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools and Data Warehousing concepts.

Technical Skills:

PROFFESSIONAL EXPERIENCE:

CONFIDENTAIL

Role: IT Systems Analyst

CONFIDENTAIL is considered as one of the top 3 Pharmaceutical Retailers in CONFIDENTAIL. As per consultation with Teradata Corporation, WAG DWBI team has decided to build a newly designed Data Warehouse Framework called IDL-ADL-FDL Architecture. IDL Layer comprises loading of data in to central Data Warehouse that are primarily sourced from IC , LDB, Promise, Loyalty, AARP, Ecomm, and Photo etc. ADL acted as an Application Layer for down streams and FDL is the Data interface for Business community. The purpose of the Enterprise Data Warehouse was to provide business users a consistent, complete, integrated, accurate, and timely core business data to support information needs across the enterprise. This EDW data also acted as a source for WAG Para Legal teams.

Responsibilities:

• Analyzed the Business requirements by conducting extensive interactions with users and reporting teams and assisted in developing the low level design documents.
• Worked with business owners to identify key data elements that will be monitored on an on-going basis to ensure a high level of data quality within the Warehouse.
• Worked closely with the functional departments and IT Analysts to attain an in-depth knowledge of business processes and procedures
• Analyzed the data mapping and developed scenarios to verify the data migration from different data sources.
• Designed and created Data Quality baseline flow diagrams, which includes error handling and test plan flow data
• Performed requirements gathering, process mapping, Business process reengineering, Release management, test, and end-user support.
• Conducted Workshops, Elicitation sessions with Teradata Co while designing the artifacts for the newly build IDL-ADL-FDL architecture.
• Assisted Development Team in implementing the inquiry and error functions like is valid, is error, is defined of ETL Ab Initio routines in order to perform data validation and data cleansing while loading in to warehouse.
• Created Test Plans, Test Cases, and Test Scripts for all testing events such as System Integration Testing SIT User Acceptance Testing UAT .
• Documented frequent problems into ISSUE LOG REPORTS with solutions to help support teams reduce average response times.
• Provided warranty support for POS, Rx production deployments from systems Analyst view.
• Converted user defined functions and complex business logics of an existing application process into SQL Scripts and ETL Routines using Teradata BTEQ functionalities and Ab Initio components such as Reformat, Join, Transform, Sort, Partition to facilitate the subsequent loading process.
• Facilitated Change Coordination and represented DWBI production deployments in Change Advisory Board CAB meetings.
• Worked as the Liaison for WAG para Legal teams in resolving POS transactional issues by providing the requested data from EDW on a timely manner.
• Responsible for deploying production ready Teradata Scripts and Ab Initio graphs and running them through the UNIX environment and responsible for automating the ETL process through ESP Schedulers.
• Worked on improving the performance of Teradata SQL Scripts and ETL Ab Initio Routines by optimizing the join operations in the scripts and by using Various Ab Initio performance techniques like using lookup s instead of joins , In-Memory Joins and rollups to speed up various Ab Initio Graphs.
• Coordinated a team of total 20 15 offshore, 5 near shore and worked heavily with business staff to document process/needs/requirements.

CONFIDENTAIL

Role: Systems Analyst

CONFIDENTAIL one of the top 3 Pharmaceutical Retailers in CONFIDENTAIL has decided to have aggregated databases created to analyse the customer behaviour which was further accessed by Business End Users/Analytics users for enhancing insight and decision making. As part of this project, raw set of requirements were received through various BRD, LLD, HLD and SPD and the same has been reconciled with the design documents. Later, a set of customer attributes would be identified to segment the customer population in to groups that are most likely to respond to specific offers and a kind of customer specific reports are made for the business users which in turn results in more efficient marketing methodologies and larger ROI.

Responsibilities:

• Created Business Requirements and converted them into detailed Use Cases, Report Specifications and Non Functional Requirements.
• Analyzed Requirements and created Use Cases, Activity Diagrams using Visio.
• Developed business flow and Sequence diagrams using MS Visio so that developers and other stakeholders can understand the business process.
• Researched upstream data sources and ensured all source data sources were attested by its owners.
• Extensively worked with business owners, SMEs, PMs, Consultants and other team members to define and design new business processes.
• Worked as an Agile Business Systems Analyst for
• a BUYOUT Acquisitions Mergers Project
• b Rx Retention, AARP and EPSILON projects.
• Played a Key Role in defining methodologies for the above mentioned agile projects.
• Collaborated with Product Owner, Stakeholders, Subject Matter Experts SMEs and developers to understand the enterprise-wide integration of re-engineering efforts and translated them into the product backlog.
• Assisted Product Owner in keeping the story backlog effectively groomed and prioritized.
• Provided guidance to teams on user story and acceptance criteria development and management, including story slicing, story mapping and backlog management.
• Owned estimation, forecasting and outward coordination and communication for CDM projects.
• Elicited requirements using interviews, document analysis, requirements workshops, business process modeling, scenarios and use cases, user stories, business analysis, task and workflow analysis.
• Implemented ITIL service strategy standards across the Projects and gained customer Confidence through desired outputs.
• Provided feedback to users in determining appropriate course of action for system problems and enhancements, requiring thorough knowledge of applications supported by Benefit Systems.
• Extensively used SQL Scripts and ETL tools in designing implementing Extract Transformation Load processes.
• Involved in Analyzing complex systems to perform validation on the data, comparing the history data with the new data, assigning unique keys, performed various transformations and finally updated base tables.
• Coordinated and facilitated End User training sessions.

CONFIDENTAIL

Role: Data Quality Analyst

CONFIDENTAIL, one of the leading Banks in CONFIDENTAIL has sought to implement an Enterprise Wide Data Quality environment to validate the Data Warehouse loads and to reconcile the requirements with the Technical designs. The scope of the project was to validate the loads from various development teams across different LOBs like Deposits, Cards, Loans, and Ecomm etc. and to provide the Developers with various performance hindrance and validation reports that will be further enabled to develop an error free scripts and graphs for warehouse loads.

Responsibilities:

• Analyzed user requirements, understood business rules in order to build the Enterprise wide data quality environment.
• Identified the different sources from which the data is coming as feed to the Warehouse
• Prepared High Level Logical Data Models and BRD's Business Requirement Documents supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Conducted extensive Joint Application Development JAD sessions for all business related issues.
• Developed a good understanding of existing business requirements and also questioned the design requirements when needed.
• Prepared questionnaire based on the System Analysis Performed for all entities.
• Provided System Metadata Architecture for the purpose of query enhancement and clarification of data relationships.
• Involved in Logical Physical Data Modeling , Database Schema design Script development in TERADATA RDBMS
• Developed High level SQL scripts to validate the data for the applications built up using Teradata.
• Designed various Test Scenarios and Test Cases to validate the integrity of the data passing to the Data ware house.
• Suggested Tuning measures of the designed queries to optimize the runtime of the process.
• Exported the data validation results of the Teradata scripts that are ran through Teradata SQL Assistant Tool in to files.
• Created various Excel reports based on the data obtained from the test results.
• Suggested measures and recommendations to improve the current application performance.
• Designed Validation process to validate the unloading process with the row count of the landed file with that of the source table row count captured in the system summary statistics.
• Worked with ODS and OLAP systems. Also worked with Data Extraction, Transformation and Loading

CONFIDENTAIL

Role: Jr. Business Analyst

CONFIDENTAIL is one of the leading banks in . The firm is a leader in investment banking financial services for consumers and businesses, financial transaction processing, asset and wealth management and private equity. As part of this initiative, all the transactional data received would be decoded in to various delimited fields, and would be cross verified with the standards laid by the bank and all the passed/failed transactions would be loaded into the warehouse for strategic analysis and for future decisions of the business.

Responsibilities:

• Worked with SME, PM, Consultants and other team members to define, analyze and design new business processes
• Identified and defined detailed requirements
• Served as a Point of contact and connection to the business community
• Worked with various Business Users in Asia Pacific, EMEA, Latin America, Japan and North America for various requirements on reporting.
• Loaded new requirements into HPQC, corrected any requirement specific defects identified by the AMEX QA Team
• Gathered core requirements of the system and developed functional specifications, which includes:
• Business and technical requirements
• Business Use cases
• GUI wireframes and sitemaps
• Rectified the defects identified by the business and AMEX QA Team
• Analyzed Claims System and conducted interviews with SMEs to understand the external system interfaces and user interfaces
• Rectified the defects identified by AMEX QA team and Maintained technical documentation and proper change control procedures
• Involved in the preparation of Interface, Screen and Reports documentation
• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions
• Conducted JAD sessions, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Micro Soft Visio
• Assisted the testing team in developing the Test plans for quality assurance based on functional requirements.
• Assisted the PM in performing Risk Assessment, Management and Mitigation