SUMMARY:

• IT professional working as a Systems Analyst with 9+ years of experience in varying roles of Business Systems Analyst, Data and OBIEE Reports Analyst, ETL Developer and Support Analyst in Banking and Financial services. My experience includes but is not limited to:
• Strong experience in Risk Analytics, Regulatory Reporting (OCC and CCAR) and Data Warehousing / Data Marts / Enterprise Data Warehouse (EDW) involving Basel - II norms, knowledge of Basel-III accords, Real Estate banking and Business Intelligence.
• Creating Functional requirements for Risk and Regulatory reporting, and work with data bases for data mining.
• Conduct stakeholder interviews, deep dive and JAD sessions. Create and document process flows, Functional / Non-Functional requirements, physical data models, Use Case, UAT Test Cases, UI design reviews.
• Proficient with Data Analysis using SQL, Relational Databases, OBIEE Reporting, Data Modeling, QA Testing.
• Sound Project Management and Coordination competence with excellent written and verbal communication skills. Broad experience in all stages of software development life cycle, AGILE project methodology.
• Experience in working with fixed price engagement and T&M projects. Fixed price engagements estimating up to USD 2M.
• Ability to communicate priorities, statuses, risks, successes, changes to management on a timely basis. Worked on estimating tasks and effort with project teams.
• Liaising with Offshore and Onshore project teams, interacting with business clients and stakeholders.
• Support business SME’s functions on data analysis, provide fixes to enable their focus on value added business activities.

TECHNICAL SKILLS:

Technologies: Informatica Power Center 9.1.1 / 8.6.1 (ETL Tool), SQL (Oracle, SQL Server, DB2), Autosys Scheduling, Unix scripting, COBOL, JCL, VSAM, Geneva

Databases: Oracle 11g/10g, IBM DB2

BI Reporting: OBIEE 11g/10g (Oracle BI Administration, Oracle BI Dashboards, Oracle BI Publisher), Tableau, Jira

Operating/Computer Systems: Windows 98/XP/Vista/7, Unix platform, Mainframes

Software/Applications: HP ALM - 11/12 (Application Lifecycle Management), Mercury Quality Center ServiceNow, Infoman, Service Center, Serena ChangeMan DS, WSFTP*Pro Oracle OFSMRM, LINKS MS Office tools, MS Visio, MS Project File aid, CA7, Endeavour, CHANGEMAN TOAD for Oracle, SQL Developer, Toad Data Modeler, ERw

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Business Systems Analyst, Project Coordinator

Responsibilities:

• Delivering essential documentation in project’s discovery phase - Functional and Non-Functional requirements, Business Use Case/Data Validation Rules, Functional workflow and process flow documents, Gap Analysis and Reports using MS Office tools.
• Conducting workshops and deep dive sessions to understand the business needs and criticality.
• Application walkthrough with stakeholders and maintaining issues/feedback tracker.
• Assisted UI/UX design team to build wireframes, prototypes, and HTML pages. Helped them to create end-to-end design flow.
• Responsible for providing requirements and inputs to OBIEE report development team.
• Worked with other business accelerators and interfacing teams for the project.
• Estimated tasks and effort with technical team for various modules of application.
• Provide Use Case documents to development team.
• Supported data architect and technical lead on database mapping, HLD and LLD documentation.
• Performed smoke test, unit test on the application based on the requirements. For testing purposes HP ALM-12 (Application Lifecycle Management) was used.
• Helped in writing test cases for UAT purposes.
• Working with offshore design and development teams to help them understand the business requirements.
• Adopting AGILE methodology for the project, be part of daily stand up meetings.

Tools: LINKS Real Estate application, OBIEE-11g, OBIEE Answers, TOAD, ALM, ERwin, MS Office

Confidential, Pittsburgh, PA

Business Systems Analyst, OBIEE Reports Analyst and Project Lead

Responsibilities:

• Interacted with business users and stakeholders to understand the requirements.
• Delivering essential documentation in project’s discovery phase - Functional and Non-Functional requirements, Business Use Case/Data Validation Rules.
• Understanding of SOX and BASEL compliant models’ quantitative calculations.
• Conducting demos of the tool based on the requirements and maintaining issues/feedback tracker.
• Providing requirements and inputs to OBIEE report team.
• Harvesting business rules required to implement the tool.
• Performed smoke test, unit test on the tool based on the requirements. Utilized HP ALM-11 (Application Lifecycle Management) for testing purposes.

Tools: Oracle MRM 2.0, OBIEE-11g, OBIEE Answers, Putty, TOAD, ALM, ERwin, MS Office.

Confidential

Business Analyst and Informatica Developer

Responsibilities:

• Analyze user requirements, procedures and problems to improve and automate existing data submission processes. Take the technical details, document their process flow and suggest best possible alternate processes in automated environment.
• Analyzing and maintaining Source-to-Target data mappings, the document which defines the relationship between source and target fields, provides description and type of the fields.
• Be part of DFAST (stress testing) and help in providing results for the bank.
• Assist downstream with data elements and inputs to CCAR (Comprehensive Capital Analysis & Review) reporting requirements.
• Worked on ETL tool, Informatica to update existing mappings and workflow, to which Source-to-Target mappings are fed with data load from the database to generate the business/regulatory reports.
• Performed data analysis on source systems and mapped financial data, customer data, general ledger data and data to Data Mart.
• Utilized Mercury Quality center which was used to validate the report generation for the project and for test cases, defect tracking.
• Helped the testing team in creating the test plans and test scripts. Assisted the in UAT testing by providing test scenarios and test data along with data comparison reports across systems.

Tools: SQL Developer, Informatica Power Center, TOAD, MQC, MS Office tools.

Confidential

Business Analyst / Sr. Data Analyst

Responsibilities:

• Interacted with business clients, worked with upstream source systems, performing analysis and comparison of data attributes.
• Designed a process and playbook environment which can be leveraged for current processes and future acquisitions.
• Build a solution to convert RBCB history data and make it available for Business.
• As per the given requirements, coordinating to get the data into required format and provide the rules on which the fields should be processed.
• Analysis and comparison of the data flowing from various data sources.
• Analyzing and maintaining Source-to-Target data mappings, the document which defines the relationship between source and target fields, provides description and type of the fields.
• Worked on Mercury Quality center which was used to validate data for the project and for test cases, defect tracking.

Tools: SQL Developer, TOAD, Mercury Quality Centre, MS Office

Confidential, Cleveland, OH

Business Analyst / Data Analyst

Responsibilities:

• Interaction with business clients, working with source systems, performing analysis and comparison of data.
• Coordination with users, source systems to get the data into required format and provide the rules on which the fields should be processed.
• Analyzing source system data using SQL and relational database concepts.
• Analyzing business requirements and design Standard Interface Files for Basel II Asset Classes - Retail, Wholesale, Equity & Securitization and other financial report filings including OCC and Credit Risk Reporting.
• Preparing Source to Target Mappings and configuring ETL.
• Preparing test cases and validating data as part of the testing process.

Tools: SQL Developer, TOAD, Mercury Quality Centre, MS Office

Confidential, Cleveland, OH

Developer and QA Analyst

Responsibilities:

• Worked as ETL developer and QA analyst for the Enterprise Information Management, re-platform project from National City to PNC domain.
• Maintaining source to target mapping document.
• Assist business team with data elements flowing to EDW (Enterprise data warehouse).
• Responsible for code development, unit testing and scheduling of the jobs in CA7 system.

Tools: JCL, COBOL, SQL, CA7 Scheduler, TSO/ISPF, DB2, Rocket Shuttle, Endevor, Infoman.

Confidential, Cleveland, OH

Lead Support Analyst, Data warehouse Application Owner (Onshore), Support Analyst

Responsibilities:

• Maintaining and supporting the data warehouse applications, reviewing data/ETL codes, adding new features/enchantments.
• Coordinating with Source systems, downstream users of Data Warehouse, onshore and offshore teams.
• Analyze and resolve all production issues and ABENDS/on-call tickets generated.
• Representing the team in various project and business discussions.
• Resolving high priority issues and meeting of the SLA’s defined for the support processes.
• Involved in analysis for decommissioning of National City data warehouse legacy applications.
• Analysis to prepare for the re-platform for the National City applications based on the PNC environment.
• Enforcing successful completion of batch jobs scheduled to run daily/monthly/yearly and ensuring the expected data flow.
• Rolling out enhancements or new code codes to production environment.

Tools: JCL, COBOL, Rocket Shuttle, DB2, DB2 Connect, CA7 Scheduler, Serena Changeman DS, GENEVA, Peregrine Service Center, Operating System: MVS/XA, IBM 3090, Z-OS