Resume of

SATHYA CHRISTY

Contact Number: 385-***-****

Email : ac0uq1@r.postjobfree.com

SUMMARY

** ***** ** ** ********** .11 years in Data warehousing in Bank of America and 3 year in Retail in Winn Dixie

3 years as IT Lead - Coordinating work efforts and manage delivery for Winndixie Datawarehouse team and Bank of America PMRR Team.

10+ yeats of Business Systems Analyst experience.

10+ years of SQL (Teradata) experience.

Extensive experience as a Business Systems Analyst / Analyst with several projects for

Bank of America and Winn-Dixie.

Certified SQL Specialist TERADATA SQL V2R5 .

Strong Experience on managing and co-coordinating the projects throughout SDLC.

Proficient in Requirements Gathering and Business Requirements and Design documentation.

Experienced in creating Functional requirements and Use Cases.

Experienced in driving and aiding the project through a full end to end implementation process.

Expertise in creating Source to Target Mapping Documents.

Experienced in creation of other SDLC project deliverables that includes Project Charter / Scope,

Project Plan, BRD, High level and Low level Design Documents, Test Plan, Test Scenarios,

RACI and Others.

Proficient in creating Process Flows. Experienced in Data Modeling. Expertise in creating

Data Flow Diagram.

Proficient in creating and running SQL Queries .Proficient in using SQL to analyze and report on

production data . Experienced in Researching, analyzing and preparing data used in making

business decisions.

Expertise in creating Pivots and maintaining SharePoint reports for Senior leadership teams. Experience in using Hyperion for pulling Adhoc reports.

Teradata Certified SQL Specialist V2R5. 6 years of experience in Teradata (SQL and Mload, Bteq,

Fast Export, Fast load utilities). Experienced with Teradata, DB2 and MS SQL Server.

Experienced in planning and carrying out Teradata System Loading Processes, Data Warehousing,

and Large-Scale Reengineering.

9+ years of experience in Mainframes on Load processes.

Proficient with Performance tuning and analyzing Explain outputs. Exposure to tools like Visual Explain, DBQL Logs, Workload Manager etc.

Expertise in Testing Concepts. Worked as a QA Analyst for Think Soft Global Services for testing G.E credit card applications .

Facilitated and Tracked Migration projects like Datastage version upgrade from Version 8 to version 11.3, Database Migration from Teradata to MS SQL 2005 .

Good communication and interpersonal skills with the ability to interact with professionals at various levels.

EDUCATION

Bachelor of Engineering in Computer Science (B.E.), (1998- 2002) from Coimbatore Institute of Technology affiliated to Bharathiyar university, Tamilnadu.

TECHNICAL SUMMARY

Operating System

OS/390, MVS, WINDOWS

Languages

JCL, TERADATA-SQL, VS-COBOL-II, EASYTRIEVE

Data Base & File System

TERADATA (Teradata Certified SQL Specialist V2R5),DB2, SQL Server, Microsoft Access.

Utilities

TSO/ISPF, QUERYMAN, MS OFFICE

Hardware

IBM 390, A+ Certified

Tools

Microsoft SharePoint, File-Aid, NDM, Change Man, CA7, Microsoft Visio, Snag it, SAS

ETL Tools

Informatica, Datastage

Metadata Tools

EIO, MDS

Reporting Tools

Hyperion, OBIEE

Artifacts

Project Charter, Project Plan, Business Requirements Document (Use Case Document), High Level Design Document (HLD), Low Level Design Document (LLD), Test Plan, Test Conditions, Test Scenarios, Communication Plan, Control Plan, RACI Matrix, Standards and Guidelines Documentation, Process Documentations, etc.

SDLC Methodology

Proficient in Waterfall, Proficient in Agile

Test Tools

HP Quality Center

SDLC Tools

Six Sigma

PROFESSIONAL EXPERIENCE

Client: Bank of America, Jacksonville, FL August 2016 – April 2017

Team Description :

Performance Measurement Recognition and Reward (PMRR) team is responsible for creating and maintaining processes to measure the performance of financial center associates and create automatic triggers to reward them. This is an analytical application that resides on Enterprise data warehouse.

Role : Apps Prog Cnslt / Business Systems Analyst

Responsibilities:

Coding per requirements – Teradata, Cobol and Mainframe OS390 .

Manage and communicate a clear vision of the project objectives and motivate

associates to achieve them; create an environment that enables peak performance.

Communicate regular project status with appropriate team members.

Assist project manager with scoping, identification of project deliverables, risk,

mitigation strategies for a given project

Work with IT manager to proactively ensure that appropriate staffing resources are

assigned, put in place and effectively utilized at the appropriate time.

Create Technical designs and documentation and system flows .

Perform coding and assist / guide offshore resources

Work closely with quality assurance resources to create test plans and ensure

that issues are properly assigned, fixed and regressed.

Participate in developing project charters and financial business cases.

Design and implement business process changes in support of major IT projects.

Create source to target mapping documents and business architecture diagrams.

Recommend business processes and product improvements in partnership with the

functional business organization to improve efficiencies

Apply cost/risk/benefit principles and advocate for best approaches to implement

process improvement for business partners (e.g., technical and non-technical).

Act as a point of technical escalation and resolution during the project lifecycle as it

relates to technical decisions & issues.

Apply subject matter expertise to identify, develop and implement techniques to

improve engagement productivity, increase efficiencies, mitigate risks, resolve

issues and optimize cost savings and efficiencies for each client.

Determine and provide a necessary level of technical documentation during

requirements gathering, based on technical services group standards and

procedures and discussions with project staff, industry experience and technical

vendors.

Perform other job-related duties as assigned.

Client: Winn Dixie, Jacksonville, FL April 2015 – August 2016

Team Description:

Enterprise Data Warehouse (EDW) Projects will encompass maintaining and enhancing Enterprise Data Warehouse at Southeaster Grocers (Winn-Dixie). The team is also responsible for building and maintaining Business intelligence reports.

Role: IT Lead

Responsibilities:

Manage and communicate a clear vision of the project objectives and motivate

associates to achieve them; create an environment that enables peak performance.

Communicate regular project status with appropriate team members.

Assist project manager with scoping, identification of project deliverables, risk,

mitigation strategies for a given project

Work with IT manager to proactively ensure that appropriate staffing resources are

assigned, put in place and effectively utilized at the appropriate time.

Work closely with quality assurance resources to create test plans and ensure

that issues are properly assigned, fixed and regressed.

Participate in developing project charters and financial business cases.

Design and implement business process changes in support of major IT projects.

Create source to target mapping documents and business architecture diagrams.

Recommend business processes and product improvements in partnership with the

functional business organization to improve efficiencies

Apply cost/risk/benefit principles and advocate for best approaches to implement

process improvement for business partners (e.g., technical and non-technical).

Act as a point of technical escalation and resolution during the project lifecycle as it

relates to technical decisions & issues.

Apply subject matter expertise to identify, develop and implement techniques to

improve engagement productivity, increase efficiencies, mitigate risks, resolve

issues and optimize cost savings and efficiencies for each client.

Determine and provide a necessary level of technical documentation during

requirements gathering, based on technical services group standards and

procedures and discussions with project staff, industry experience and technical

vendors.

Perform other job-related duties as assigned.

Client: Winn Dixie, Jacksonville, FL June 2013 – April 2015

Role: Business Systems Analyst III

Project Description:

Project encompass all changes to Pricing application of the retail chain BI LO – Winn Dixie.

BI LO Holdings Inc is in the process of acquiring many new stores this year – Harveys, Sweet Bays and Reids . There are many enhancements that has to be implemented in the pricing applications which holds the regular and promotional prices of all products in Winn Dixie.

Responsibilities :

Engage in solutions design, configuration and/or development.

Maintain proficient working knowledge of use case writing and other requirements analysis techniques; make recommendations based on knowledge of new technology trends.

Assist in the development of project charters and financial business cases.

Develop and maintain solid partnerships with relevant personnel and departments.

Ensure adherence to and support of IT governance policies while maintaining strong customer service orientation.

Translate team member requirements into application functionality with sufficient technical background to define non-functional requirements.

Explore, identify and document business requirements (exposing root cause) understanding and prioritizing dependencies.

Perform business analysis, business process re-engineering, requirements gathering and problem solving in support of a specific business user community.

Develop gap analysis between existing and proposed functionality of business applications.

Develop functional requirements that represent business needs using UML and use cases.

Contribute to the usability and performance of applications employed within the user community by acquiring user feedback and cross referencing business processes with application usage.

Serve as a business systems knowledge source and collaborate with users to solve functional problems and create new business processes.

Consult with support and project teams to gather current processes and functional requirements to design systems improvements and optimize application/technology use.

Coordinate acceptance testing of new application systems and technology.

Assist PMO in the tracking and documentation of benefits attainment and process change.

Maintain proficient knowledge of and adhere to project management and software delivery methodologies.

Lead business process discussions.

Run Adhoc reports from Hyperion whenever required.

Assist in application testing.

Perform other job-related duties as assigned.

To gather requirements for all new enhancements have them documented and secure user sign off.

Co-Ordinate between user and Developer and the code developed and implemented

Update Test scripts in Quality Center.

To analyse on production related issues whenever required.

Run Adhoc reports from Hyperion whenever required.

Special Software: SQL Server V5.0, Microsoft Office .

Client: BANK OF AMERICA, Jacksonville, FL October 2012 – June 2013

Role: Early Project Engagement / Service Level Agreement – EPE / SLA Analyst

Project Title: Bank of America – Enterprise Information & Analytics –Tactical / Strategic Approach ECRIS Disaster Recovery

Project Description:

As part of Production support team, this team is responsible to review all changes and ensure production platform is out of risk by any new onboarding of applications.

Responsibilities:

Identify and document all new standards and guidelines for coding which includes – Teradata SQL, Mainframes, Autosys and Hadoop installs and SLA definitions.

To review all the changes coming into production platform to see if they are following the right guidelines and standards.

To review new applications for their SLA standards and renegotiate the SLAs if they don’t look correct.

To approve the changes for production if they satisfy all requirements.

To come up with reports for Production support management on new installs and other statics related to new additions to the platform.

Special Software: SQL Server V5.0, Microsoft Office .

Client: BANK OF AMERICA, Jacksonville, FL June 2011 – June 2013

Role: Business Systems Analyst III

Project Title: Bank of America – Datawarehouse - Resiliency Repository Tool

Project Description:

To develop an internal tool that can capture and display Datalineage details . In order to run a successful Disaster recovery exercise for bankofamerica datawarehouse, its important to hold datalineage details of where data is coming from, where is it stored and where does it flow from the warehouse

Responsibilities :

Conduct interviews with all the stake holders of Disaster recover exercises and collect all the ideas for the tool .

Organize JAD Sessions to come up with all the business reqirements for the tool.

Create artifacts like Project charter, Project Plan and Business Requirements Document (Use Case document if required) based on the inputs from JAD and other interviews and meetings with all the stake holders.

Co-ordinate with the development team to get the application developed and installed . Hold regular meetings to gather status of the project and ensure there is progress and make sure there is no risk to meet the deadline .

Provide Regular project status and Risks/ Concerns if any to project manager.

Come up with Test plans and schedule for testing.

Co-ordinate with the team and ensure the team follows the right process for testing and they adhere to the schedule.

Co-ordinate with the team for implementation and support.

Special Software: Microsoft SharePoint, Microsoft Visio, Microsoft office tools, Queryman, IBM OS 390, SQL Server V5.0

Client: BANK OF AMERICA, Jacksonville, FL Sep 2008 – June 2011

Role: SBA – Senior Business Analyst

Project Title: Bank of America – Enterprise Information & Analytics –Tactical / Strategic Approach ECRIS Disaster Recovery

Project Description:

To Plan on Disaster Recovery environment for Teradata Data warehouse

Bank of America. This was the first effort in the history in ‘The W’ Bank of America Data warehouse to reduce Operational risk of the Data Warehouse

Responsibilities :

Capture all the requirements and end goals for the DR exercise . Have them documented and signed off from the various stake holders.

Organize JAD Sessions / meetings based on the business requirements to further understand and get to the design.

Co-ordinate between different teams participating in the disaster recovery planning and exercise.

To Produce Pivots and Presentations for Overall performance of the project to Senior Leadership team.

Writing Teradata Sql queries according to Process needs.

To analyze the Capacity management of the disaster recovery environment based on the existing production environment using DBC tables.

Being a part of Design and Plan team for Backup and Data movement strategy.

Lead the TCS team with three offshore and two onsite members to provide data lineage information for the Disaster recovery environment.

Contributed to planning for the Disaster Recovery Exercise.

Contributed to conduct the Disaster recovery exercise by conducting meetings and providing overall update during the exercise.

Was spearheading a small team of three people in building an online semi automated tool -with online user interface (Backend SQL Server and Front end Dot net ) to store and retrieve datalineage details.

Contribute to Planning Implementation support.

Special Software: Microsoft SharePoint, Microsoft Visio, Microsoft office tools, Queryman, IBM OS 390, SQL Server V5.0

Client: BANK OF AMERICA, Charlotte, NC Nov 2007 – Sep 2008

Role: Business Systems Analyst

Project Title: Bank of America – Enterprise Information & Analytics – Data Reconciliation on W – Bankofamerica Warehouse

Project Description :

The project is an outcome of an Audit in 2006 to enhance the Quality of Data in the Bank of

America Data Warehouse. both in the Tables and the Metadata area.

The project was to create a new process to address the existing issues in the Load process to address quality and also to update the Metadata.

Project Size: 5 (2 SAs + 2 BAs + 1 Project Manager)

Responsibilities :

To conduct meetings with application managers from different arena of the Data warehouse to analyze the current status of data quality in Data warehouse. Team size: 5.

To understand the existing issues and the impact. Create reports on the existing issues.

To document functional requirements based on the information gathered.

To Write Teradata SQL Queries as required to understand the status of the applications.

To Create a New Process Flow to remediate the current issues.

Implement the process among the project teams to improve the Quality of Data entering into the Teradata Warehouse.

To plan the process on the remediation work on the existing Metadata (to correct the existing gaps in Metadata)

Special Software: Microsoft Visio, Microsoft office tools, Queryman, EIO Tool, MDS, MQR

Client: BANK OF AMERICA, Chennai, India Jan 2007 – Nov 2007

Role: Group Leader / Systems Analyst

Project Title: Bank of America – Data Warehouse Delivery – DW - Development

Group Size : 9

Project Description: The project’s objective is to provide Development, Maintenance and Enhancements to the Data Warehouse ‘The W’ of CK&DS division of Bank of America. The warehouse, The W, is a mainframe-based database, which is designed to handle Bank of America’s Customer Knowledge & Decision Support activities. The main objective of the Warehouse is to help the bank in decision & strategy making process.

Responsibilities :

To help the team understand business / functional requirements involved in the projects.

To Review the code developed by the team .

Develop and Execution of ETL load scripts based on the business requirement using Teradata client utilities Multiload, Fastload and BTEQ whenever required.

Writing Teradata Sql queries according to process needs.

Generated Reports using BTEQ.

Perform tuning and optimization of SQL Queries.

To help the team with critical issues

To train the freshers in the team

To guide the team with the projects that were handled.

To provide status reports to the management on a weekly basis.

Client: BANK OF AMERICA, Jacksonville, FL Jun 2005 – Jan 2007

Role: Business Systems Analyst / Onsite Coordinator, Module Leader

Project Title: Bank of America – Data Warehouse Delivery – DW - Development

Team Size: 3

Project Description: The project objective is to provide Development, Maintenance and Enhancements to the Data Warehouse ‘The W’ of CK&DS division of Bank of America. The warehouse, The W, is a mainframe-based database, which is designed to handle Bank of America’s Customer Knowledge & Decision Support activities. The main objective of the Warehouse is to help the bank in decision & strategy making process.

Responsibilities :

Gather new requirements.

To do impact analysis for new requirements and prepare the Low level design for new initiatives.

Analysis of requirements for finding any ambiguity, incompleteness or incorrectness.

Assign the task and get it done from the offshore team.

Help the team with any clarification on the code

Review the code and implement the same

Support the new systems till its warranty period.

Writing Teradata Sql queries according to Process needs.

Writing BTEQ Scripts for uploading data.

Establish Loading process using MLOAD, FLOAD, and BTEQ.

Perform tuning and optimization of SQL Queries.

Implementing adhoc techniques to achieve business needs.

Client: BANK OF AMERICA, Chennai, India Nov 2003 – Jun 2005

Role: ETL Developer / Team Member

Project Title: Bank of America – Data Warehouse Delivery – DW - Development

Project Description: The project objective is to provide Development, Maintenance and Enhancements to the Data Warehouse ‘The W’ of CK&DS division of Bank of America. The warehouse, The W, is a mainframe-based database, which is designed to handle Bank of America’s Customer Knowledge & Decision Support activities. The main objective of the Warehouse is to help the bank in decision & strategy making process.

Responsibilities :

To do impact analysis for new requirements and prepare the Low level design for new initiatives.

Analysis of requirements for finding any ambiguity, incompleteness or incorrectness.

Writing Teradata Sql queries according to Process needs.

Writing BTEQ Scripts for uploading data.

Establish Loading process using MLOAD, FLOAD, and BTEQ.

Involved in Enhancement of both Legacy system and development of new systems.

For Enhancement of Legacy system involved in the analysis and Enhancement of existing Cobol programs.

For Development of new systems involved in development of new Sql Scripts(Teradata) and setting up of Batch jobs to run those scripts.

Data extraction, file handling with the help of Fileaid tool.

Write SQL queries for generating the Extracts from the tables

Prepare unit test plan

To find out the testing coverage of the system after each enhancement by using Test Coverage Analyzer and to provide the percentage of codes tested and also the flows that are yet to be tested.

Conduct quality reviews of design documents, code and test plans

Ensure overall quality of all the deliverables

Operating System: IBM 390

Database: TERADATA (Tools – MLOAD, BTEQ, TPUMP, Fast load, Fast Export and SQL)

Languages: SQL, COBOL, JCL, EASYTRIEVE

Special Software: Microsoft office tools, Queryman

Tools: MDS (In-house tool for Metadata), EMIP (In-house customized tool developed from Rochade), Informatica, File-Aid, NDM, Change Man, CA7

Client: THINKSOFT GLOBAL SERVICES, Chennai, India Apr 2002 – Nov 2003

Role: Test Associate / Module Leader

Project Title: G.E PLCC- Credit Card Application

Project Description : The Project objective is to provide complete bug free implementation for PLCC credit card application enrolled by G.E

Responsibilities :

To find out the testing coverage of the system by going through the BRD.

Prepare Test Scenarios / Test Conditions / Test Scripts.

Conduct quality reviews of Test plans

Perform manual execution of the Test scripts on Mainframes.

Reviewing all the defects that are found.

Consolidating and Logging of the defects in Test Director.

Ensure overall quality of all the deliverables

Hardware: IBM OS 390

COURSES / WORKSHOPS ATTENDED

2013 Cloudera Manager Training

2013 Agile Training

2012 PMP

2009 Leadership Etiquette

2009 Session on ‘Who is a Business Analyst?

2006 Informatica Basics

2004 Teradata SQL Level certification

2004 Teradata Basics Certification

2004 Data warehousing

2004 Banking Session

2004 Process related training

SPC

TBEM iQMS, 2003, IBM Mainframe training

COBOL

MVS JCL

2003 Initial Training Program

2003 Basics on Banking

2003 Testing Basics

2003 Basics on Mainframes

2002 A+ Training

Contact this candidate