SUMMARY:

• Senior IT Data Analyst with 14years of IT experienceincluding over 8 years of broad - based experience in defining, managing and delivering Enterprise-wideBusiness Intelligence (BI), AS400and Web application solutions.
• StrongBusiness Analysisbackground and have prepared Business Requirements, Functional Specifications, Use Cases, Use Case/Sequence diagrams. Trained in usingBlueprint tool.
• Expertise in preparation of effectiveBusiness Cases, strategic presentation documentsand have closely worked with Technology Steering Committee and business for their approval.
• Have been extensively involved inBrainstorming, Business Rules Analysis, preparation of Data Flow diagrams, Data Modeling, Decision and Document Analysis.
• Expertise in SQL report writing with deep knowledge in developing complex queries across multiple tables. Have sound understanding of database concepts and information models .
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, data profiling and corporate metadata definitions.
• Expertise in strategically aligning the technology solutions with the corporate goals by beingprimary liaisonbetween business stakeholders and technical teams.
• PMP (Project Management Professional) Certified with extensive experience in program management, technical management, team management and in leading enterprise wide large projects across geographies with diverse functional teams and multiple software development life cycle types (Waterfall/Agile/Iterative) to achieve objectives.
• Strongpresentations skillswith the ability to present findings effectively to senior management
• Excellent communication skillsand ability to multi-task and work well in deadline oriented situations.
• Expertise in Project Management tools likeMicrosoft Project Plan, Planview and EPIC
• Strong knowledge ofMicrosoft products including Excel, Powerpoint and Visio.
• Functional Expertise in multiple business domains likeMortgage-Loan Originations, Servicing,Collections, Regulatory Reporting,Cards,Retail Stores and Logistics.
• Worked with the business and technical teams for resolution of issues and their tracking during User Acceptance Testing.
• Have experience working with the HP Quality centerfor implementing Test Planning, Execution and Defect Management in projects.
• Highly proficient inProject Managementactivities likebudgeting, forecasting, scheduling, cost/benefit analysisand inplanning, delegating and managingdesignated projects and in ensuring that project objectives are accomplished in accordance with outlined priorities.
• Experience in handling different phases ofSoftware Development Life Cycle (SDLC)including requirement analysis, design, development, testing and implementation of projects.
• ITIL (IT Infrastructure Library) Certifiedin Service Management and experienced in implementing Release Management, Scope Management, Configuration Management, Change Management and Risk Management using ITIL methodologies.
• Extensive experience inMigration and Application Development projects.
• Involved inbug fixing,providing workarounds for priority issues, and enhancements to the current systems, its Interfaces and reporting systems.
• Experience in working with BI Reporting tools likeCognos, Spotfire, Tableau, Business Objects, QlikviewandSAS.
• Experience in working with Oracle, Teradata, SQL Server and DB2 databases.
• Experience in working with Microsoft Sharepoint.

TECHNICAL SKILLS:

Data Analysis Tools: PL/SQL, MS Office, Blueprint, Six Sigma, UML, Business SWOT Analysis

Business Intelligence Tools: Spotfire, Cognos, Tableau, Qlikview, Business Objects and SAS.

Project Management Tools/Methodologies: Planview, Microsoft Project Plan, EPIC, MS Visio, VSS, Sharepoint, Agile, Waterfall

Testing Tools: HPQualityCenter

Databases: Oracle, SQL Server, Teradata,DB2

Operating Systems: UNIX, Linux, Windows, AS400

AS400 Technologies: RPG, CL, COBOL, Synon

Web Technologies: Java, JSP, Servlets, HTML, Java Scripts, Iron Python Scripting

Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, Dallas,TX

SeniorData Analyst

Environment: and Tools: Microsoft Project Plan, MS Visio,Spotfire 5.x, Tableau 8.0, Business Objects, SAS, Oracle, MS Office, Sharepoint, HP Quality Center,Microsoft Project Plan

Responsibilities:

• Implemented projects for the development of the STAR Performance Scorecard on Spotfire, Business Objects and Tableau for internal use within Fannie Mae and for external access for theservicers.
• Facilitate Business Requirements discussions with Business and Senior Managementexecutives and authored the Business Requirements andFunctional Specificationdocuments.
• Developed flowcharts for current and future business processes using Visio.
• Developed a clear understanding of existing business functions and processes.
• Involved in preparation of Source to Target Data Mapping documents for the ETL team.
• Coordinated with BI-ETL and Modeling teams forapplied Dimensional data modeling concepts for creating the data model and the data tables required as per Reporting needs and installation of database drivers for connecting to database.
• Collect, organize, interpret large datasets originating from multiple sources, Implemented and supported daily, weekly, monthly, and quarterly reports and presented analytical findings to the management team and business customers.
• Coordinated withcross functional teamto developstandardize reporting solutionsthat align metrics and drivers with the associatedfinancials.
• Collaborate with theNSO Business, MIS and Technology teamsin prioritizing requirements and deliverables, providing maximum value to business.
• Work withIT Program managementto come up with aIT-Business Road Mapfor program deliverables
• Prepared and managedProject Plansfor the MIS deliverables for all the STARprojects and worked in coordination with the Program Manager for the overall management of the project.
• Worked in resolution of requirements related issues with User Acceptance team.
• Compiled and deliveredProject Status Reportsand presented findings effectively for the stakeholders and for Senior Management Reporting on a regular basis.
• Prepared Project Change Requests wherever applicable.
• Managed theRisksandIssues of the projects usingRisk Register, Status reportsand the Project Management tools.
• Conduct periodic meetings to reviewperformance, status, milestones andissues/risks.
• Involved in implementing a Spotfire solution for integrating a Spotfire dashboard on a Confidential External Website for STAR Metrics Reporting.
• Involved in sharing best practices to be used for development as part of these knowledge sharing sessions.
• Participated in meetings and projects with client staff, project managers and developers to automate, upgrade or expand applications that accomplish business operations of assigned work units.
• Supported the On-Demand Ad-Hoc reporting needs for the business users in Spotfire and Tableau and published some of the monthly reports in Business Objects and Tableau wherever applicable.

Confidential, Dallas,TX

Senior Data Analyst

Environment: and Tools: Planview,MS Visio, Cognos10.x, Abinitio, Erwin, Teradata, SQL Server,Sharepoint, HPQualityCenter

Responsibilities:

• Involvedin a project that involved migrationof Reporting/ETL Futrix ICube/SAS toolset to Cognos/Abinitio toolset andData Integrationfrom variousServicing /Origination /Collectionssource systems intoODS(Operational Data Store).The project involved analysis and definition ofsource and target elements,Field Mappingbetween the source and target,data cleansingand defining the migration process.
• Facilitate Business Requirements discussions with Business and Senior Managementexecutives and authored the Business Requirements andFunctional Specificationdocuments.
• RUP framework was used for implementation of each phase of the project.
• Developed flowcharts for current and future business processes using Visio.
• Developed a clear understanding of existing business functions and processes.
• Involved in preparation of Source to Target Data Mapping documents for the ETL team.
• Coordinated with BI-ETL and Modeling teams forapplied Dimensional data modeling concepts for creating the data model and the data tables required as per Reporting needs and installation of database drivers for connecting to database.
• Prepared abusiness casefor a Migration project, presented it to the Technology Steering Committee and went through several deep dive sessions before it was finally approved.
• Prepared and managed large scaleProject Plansfor all the major projects executed using Microsoft Project
• Compiled and deliveredProject Status Reportsand presented findings effectively for the stakeholders and for Senior Management Reporting on a regular basis.
• Prepared Project Change Requests wherever applicable.
• Managed theRisksandIssues of the projects usingRisk Register, Status reports and the Project Management tools like Planview.
• Conduct periodic meetings to reviewperformance, status, milestones and issues/risks.
• For theAgileprojects executed, have been involved in discussions with business for finalising
• Product Catalog,Sprint Planning, collaboration with the Scrum team, in facilitatingStand Up meetings,Sprint Review meetingsandSprint Retrospective
• Coordinated with cross functional teamto developstandardized reporting solutionsthat alignmetricsand drivers with the associatedfinancials.
• Collaborate with theData Management, Data Governanceand business executives in prioritizing requirements and deliverables, providing maximum value to business.
• Drive theBI solution strategy,integrating multiple disparate processes, andaddressingshort and long term organizational needs for Citi Mortgage.
• Work withIT Program managementto come up with aIT-Business Road Mapfor program deliverables
• Implementedprojects for Business functional areas involvingRepurchase, Financeand Accounting Risk Management, Loan ManagementSystems, Originations,Servicingand
• Collection systems.
• Have implemented BI solution by building centralized Datawarehouse for Finance, Repurchase and Collection-Foreclosure/Pre-Foreclosure department
• Worked with Project Manager for securing acceptance and approval of the timelines and deliverables from theProject Sponsor and all project Stakeholders.

Confidential, Dallas,TX

Project Manager/Business Systems Analyst

Environment: and Tools::IBM AS400, Synon, RPGLE, SQL400,DB2, Cognos 8.4, J2EE,Sharepoint

Responsibilities:

• Implementedprojects for Business functional areas involving Credit Risk Management, Loan Management Systems, Originations, Servicing andCollection systems.
• Worked closely with the customer and provided them the functional and technical support required for finalizing business requirements for projects
• Provided high level estimations for the projects executed inSynon, AS400andJ2EE.
• Waterfall methodology was used for the implementation of these projects.
• Delegated workforce practice related responsibilities to project team members
• Co-ordinated all customer-related activities including acceptance of the deliverables
• Participated in pilot efforts for improving processes
• Reviewed the code/processes followed and adopted suitable technologies,tools, techniques and best practices in the project wherever required for better results.
• PreparedProject Planand implemented the quality processes in the project
• Involved in identification ofRisks, Risk Analysisand providing mitigation plan afterdiscussing with the appropriate stakeholders processes in the project.
• Reported on progress against plan to the internal as well as external customer
• Initiated and facilitated sharing oflessons learntandbest practicesimplementedin projects.
• Involved in controlling the production, development, maintenance, use and security forganisational information as well as client information and systems that they use or have access to.
• Involved in controlling the production, development, maintenance, use and security oforganisational information as well as client information and systems that they use or have access to.

Confidential

Sr. Database Programmer / Modeler / Analyst

Environment: and Tools: PL/SQL, Citrix,Geneva, XML, Sharepoint

Responsibilities:

• Prepared Business Requirements discussions with Business and Senior Management executives and authored the Business Requirements and Functional Specification documents.
• Involved in System Analysis, Functional Decomposition, Business Rules
• Analysis preparation of Data Flow diagrams, facilitating Brainstorming discussions and Modeling.
• Worked closely with the customer and provided them the functional and technical support required for finalizing business requirements for the project
• Provided high level estimations for the projects executed in PL/SQL.
• Delegated workforce practice related responsibilities to project team members
• Co-ordinated all customer-related activities including acceptance of the deliverables
• Reviewed the code/processes followed and adopted suitable technologies, tools, techniques and best practices in the project wherever required for better results.
• Shared knowledge and best practices adopted/originated in the project with other projects.
• Involved in endto end testing of the code with BAL andGenevateam

Confidential

Business Systems Analyst

Environment: and Tools:MSOffice, MS Project, MS Visio, Java, EJB, EPIC, PL/SQL,SharePoint

Responsibilities:

• Analysis and understanding of the Business-T applications from the business users.
• Preparation of evaluation documents in which the Business functionality and
• Physical Architecture was clearly documented
• Identify compliance related gaps in the applications and have Review Calls with Program Governance Board
• Prepare Remediation plan for closing the gaps.
• Procuring High Level Design documents and timelines for various tasks for the project involved in remediation activity.
• Implemented Quality procedures Systems Analysis and Design Report
• Involved in preparation of test strategy, test plan, review of test cases, coordination for test environment and test data
• Project Status Reporting to Senior Management and to the business.
• Budgeting, Forecasting and managing the funds for theproject.

Confidential

Business Systems Analyst

Environment: and Tools: JSP,Servlets, EJB, Java Scripts, Websphere, EPIC

Responsibilities:

• Analysis and understanding of requirements from the business users.
• Preparation of Business Requirement and Functional Specificationdocuments.
• Procurement of High Level Design documents and timelines for various tasks for the project.
• Implementation of Quality procedures - Document control, Configuration management, Change management, Version control and Internal Quality Assurance
• Involved in preparation of test strategy, test plan, review of test cases, coordination for test environment and test data
• Project Status Reporting to Senior Management and to the business.
• Budgeting, Forecasting and managing the funds for the project.

Confidential

AS400 Technical Lead

Environment: and Tools: AS400, Synon, RPGLE, CL, Pl/SQL, J2EE, COBOL

Responsibilities:

• Requirement Analysis and estimation of effort for the module.
• Preparation of Low Level Design (LLD) and Program Specifications.
• Programming of the application.
• Unit and System Testing, Test Verification and thoroughness of testing
• Review of project documents as per ISO procedures.
• Quality Reviews - Internal and External
• Implementation of Quality procedures - Document control, Configuration
• Management, Change management, Version control. Internal Quality Assurance coordination.
• Supply Chain Management principles were used extensively in this project.
• Involved in the System Integration Testing of AS400 and Web Automated Item Setup application and defect fixing.

Confidential

AS400 Developer

Environment: and Tools: As400, Synon, RPGLE, CL, Pl/SQL

Responsibilities:

• Requirement Analysis & estimation of effort for the module.
• Provide a technical solution to meet the specified functionalities in Unitel21 (framework used by Excel for their day to day Logistics operations).
• Involved in coding the functionality and performing meticulous Unit and System Testing ofthe product before delivering to the client for User Acceptance testing.
• Preparation of Unit Test Cases and Systems Test Cases and carry out Peer Reviews of code and documents.
• Keep a track of defects entered to avoid rework and to improve the performance using Test Director.
• Involved in Six Sigma Projectto increase Review Effectiveness.
• Supply Chain Management for Logistics was used in this project.

Confidential

J2EE Developer

Environment: and Tools:Java, JSP, Servlets

Responsibilities:

• Implemented a Web based application using Servlets, JSP.
• Developed Signup Module and User Registration Module.
• Used the Java classes to interact with the database.
• Developed the code and deployed on the Tomcat server.
• Successfully prepared detailed strategic and technical product test plan for testing application.

Confidential

Research Analyst

Environment: and Tools:Computational Fluid Dynamics, FORTRAN

Responsibilities:

• Provided technical and procedural support to the Research team involved in this project
• Involved in publication of paper for this research work