PROFESSIONAL SUMMARY

• Over 8 years of IT experience in the field of Business/Data analysis, ETL Development and Data Modeling.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Good experience in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle.
• Experienced in developing accurate business process requirements for Banks, Insurance and State government projects.
• Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
• Good Data Warehousing concepts including Meta data and Data Marts.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME’s), Development and QA teams.
• Extensive experience in project management best practices, processes, & methodologies including Rational Unified Process (RUP) and SDLC
• Excellent communicator focused on customer service.
• Ability to understand current business processes and implement efficient business process.
• Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks.
• Strong background in support documentation.
• Analysis and review of Software and Business Requirement Documents.
• Conducting requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.
• Gathering business and Technical requirements that would best suit the needs of the technical architectural development process.
• Team lead skills encompassing user interviews, coordination with Tech Lead, DBA’s, Developers, QA/QC Analysts during the design phase.
• Interviewing Subject Matter Experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.
• Having application testing experience with working knowledge of automatic testing tools like Mercury Quick test Professional and Load Runner.

EDUCATIONAL QUALIFICATIONSM.S in Computer Science 
Master in Computer Application (M.C.A.),

PROFESSIONAL EXPERIENCE

Confidential, Thousand Oaks CA Mar’12-Till date Sr. Data AnalystWorked as a Sr.Data analyst, to create a sales and service data mart required for Business Intelligence and reporting purposes. The Existing RML system which allows the agents to enter, modify new sales/service data is used as one of major source systems.Responsibilities:

• Performed data profiling in the source systems that are required for RML System
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Reverse engineered all the Source Database’s using Erwin.
• Documented data quality and traceability documents for each source interface.
• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
• Involved in data warehouse design.
• Experience with various ETL, data warehousingtools and concepts.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked with internal architects in the development of current and target state data architectures
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing Amgen enterprise data warehouse (EDW).

Environment: Oracle 10g/11g, MS Access 2007, MS Excel 2007, MS Word 2007, MS Outlook 2007, Erwin, Crystal Reports, PowerPoint 2007, SharePoint

Confidential, Tucson AZ Jul’11-Feb’12 Sr. Data AnalystThe "customers" of Information Technology Department are the other Pima County departments, and the services cover the spectrum of information technologies; data processing services include programming, operating, and maintaining County computer systems. I worked as a Sr. Data Analyst for Information Technology Department in generating about 200 reports to the county’s other departments (Project Management, Finance and Budgeting). Data Warehouse is developed from the operational source system’s after consolidating into a Decision Support System for analyzing data. The Data Warehouse was scheduled to get data from different databases of operational system, which then is loaded into staging area using Informatica.
This is a huge Data warehousing Implementation involving ETL Informatica, Oracle 11g, MS SQL Server and Business Objects. 
Responsibilities:

• Gathered requirements, analyzed and wrote the design documents.
• Providing End-user Training and documentation for customer reporting services.
• Attended JAD sessions and created reports for Budgeting, Finance and Project Management departments of Pima County.
• Participated in the Analysis, Design and Development Phases of report development, performance tuning and production rollout for every report of Information Technology Department.
• Queried the databases, wrote test validation scripts and performed the System testing.
• Worked with the developers during coding and while doing the remediation of the software.
• Worked with the users to do the User Acceptance Testing (UAT).
• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements
• Created Technical specifications documents based on the functional design document for the ETL coding to build the data mart.
• Created data trace map and data quality mapping documents.
• Performed Data Profiling and Data Quality.
• Used ERwin for data modeling.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center 7.1
• Designed and implemented report layouts according to reporting standards of the department.
• Owned the assigned reports, worked on them and updated the Report Development Scheduler for status on each report.
• Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic.
• Adhered to the reporting standards laid down by Pima County ITD.
• Have taken initiative to drive the report development process.
• Worked on exporting reports in multiple formats including MS Word, Excel, CSV and PDF.
• Responsible for making the report available for scheduling or viewing on demand.
• Worked with Technical Experts to Improve Report Performance and performed System testing.

Environment: Oracle 11g, SQL Server 2008, Windows XP, Microsoft Project 2000, Informatica, HTML, Business Objects, Erwin, MS Excel, SharePoint 2010, PowerPoint, MS Visio and MS Outlook

Confidential, OH Jan’10 – June’11 
Sr. Data AnalystDescription:
Stucky Application SoftwareStucky Application software is being used by the Structured Finance Group of Fifth-Third Bank, in both Chicago and Cincinnati. Stucky’s Application is to track Commercial collateral on Asset Based Lending loans, monitor their Borrowing Based of Aging, Receivables and Inventory.William Stucky & Associates provided 2 software applications to the bank; Stuckynet & Stucky NTABL. Both systems have been used by the bank for over 5 years. They are used for Asset Based Lending - for structured finance deals. This will ensure that the bank does not loan more money than what the customer can support. In this particular project we have added new fields to the existing screens and have generated several new reports.
As a Sr.Data Analyst, I was involved in documenting the business process by identifying data required in determining the Asset Based Lending loans that are eligible for financing and securitization, from multiple sources and the method of obtaining and storing data.
Responsibilities:

• Worked according to the software development life cycle.
• Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users (who are also Fifth-third employees).
• Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder
• Wrote the test cases and technical requirements and got them electronically signed off.
• Created new reports based on requirements.
• Utilized simple methods like PowerPoint presentations while conducting walkthroughs with the stakeholders.
• Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements.
• Interacted with teams in AFS, ACBS and infolease to extract the information for the reports.
• Involved in defining the source to target data mappings, business rules, business and data definitions
• Created Report-Models for ad-hoc reporting and analysis.
• Created Logical/physical Data Model in ERwin and have worked on loading the tables in the Data Warehouse
• Worked extensively with the ERwin Model Mart for version control
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Provide 24 x 7 problem management support to the development team.
• Document various Data Quality mapping document.
• Perform small enhancements (data cleansing/data quality).
• Performed data analysis on the existing data warehouse’s of AFS, ACBS and infolease.
• Worked on daily basis with the main frame team and lead data warehouse developers to evaluate impact on current implementation.
• Communicated with the third party vendor to do the programming.
• Upgraded the present application by adding new functionalities and adding new reports.
• Wrote regression test cases, did smoke testing with users.
• Coordinated (with business users, data base administrator, mainframe team and testing team) in mirror to production testing.
• Conducted User Acceptance testing (UAT) and worked with users and vendor who build the system.

Environment: MS Office 2007, MS Visio 2003, Windows XP, AFS, MS Excel, SharePoint, PowerPoint, MS Project, UML, SQLServer, Erwin, Business Objects, MS Outlook

Confidential, AZ Jul’08 – Dec ‘09 
Business / Data AnalystDescription:The certification unit is an integral part of the state of Arizona Department of Education. This unit is responsible for carrying out the rules and statues for the licensure of certified school professional. The product of this unit is the legal document that enables the professional educator to work in Arizona. Arizona law states that all the teachers who intend to teach in Arizona (except in charter schools) should have a valid teaching certificate from the Arizona department of Education (ADE). The present application is being used by the evaluators at the certification unit. There are many different types of certificates issued by the certification unit of ADE. There are evaluators in the certification unit equipped with many complex state laws and rules. The evaluators provide different services including evaluation of applications, issuance of certificates, answering questions over the phone and many other quick services. 
Applications are submitted by candidates for the various services for which they qualify. They also provide all the required supporting documentation. If the applicant meets the qualification guidelines a certificate is issued (or a service is rendered) and if the applicant doesn’t qualify, a letter is issued stating the reason for denial or holding the file.Responsibilities:

• Analyzed the business and wrote Business Rules Document.
• Implemented and followed a Scrum Agile development methodology within the cross functional team and acted as a liaison between the business user group and the technical team.
• Gathered requirements and created Use Cases, Use Case Diagrams, Activity Diagrams using MS Visio.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and documented them in a format that can be reviewed and understood by both business people and technical people.
• Used MS Visio for business flow diagrams and defined the workflows.
• Performed data analysis for the existing data warehouse and changed the internal schema for performance.
• Participated in Designing and development of the application.
• Used user stories approach for describing the requirements using the user story template.
• Wrote technical papers, gathered technical requirements, and compiled them to help the design system.
• Created Use Case specifications, business flow diagrams and sequence diagrams to facilitate the developers and other stakeholders to understand the business process according to their perspective with possible alternate scenarios.
• Interacted with the software development team and executive team to liaison the business requirements to ensure that the application under development confines to the business requirement.
• Performed data mapping from source to target.
• Extensively used SQL for accessing and manipulating database systems
• Participated in Design walk-through with SMEs to baseline the business architecture.
• Facilitated in the overall management of the project including and mitigation, status reports, client presentations, defining milestones, deliverables and establishing critical success factors.
• Was jointly responsible for monitoring the progress of the development and QA team.
• Worked closely with QA team and developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
• Created Use Case Diagrams using UML to define the Functional requirements of the application.
• Performed Acceptance Testing (UAT), Unit Testing and Documenting.
• Maintained a close and strong working relationship with team mates and management staff to achieve expected results for the project team.
• Organized meetings with the development teams to elicit use cases and document them.
• Wrote manual Test Cases for checking the application.
• Used Agile methodology for repeated testing.
• Involved in Manual Testing by checking of various validations.
• Created, maintained, and executed manual test scripts.
• Developed Functional Specifications and Testing Requirements using Test Director to conform to user needs.

Environment: MS Office 2007, MS Visio 2003, Share Point, PowerPoint, MS Project, Windows XP, UML, SQL, Test Director, MS Outlook

Confidential, Mellon, PA May ’07 –Jun ‘08 
Business/Data AnalystDescription:
As a Business/Data Analyst of E-commerce, an online banking application that enables customers to access their checking and savings accounts, and credit card account through the internet. This project involved developing the application using Servlets and JSP’s under the Struts framework.
Responsibilities:

• Involved in gathering business requirements from the end users and management
• Analyzed Requirements and created Use Cases, Use Case Diagrams, Sequence Diagrams using Rose.
• Used Rational RequisitePro for Managing and Configuring the Requirement Analysis effort.
• Extracted the business requirements for E-commerce from various sessions with business leads and maintained them using Requisite Pro, tracing them all the way to the system artifacts.
• Planned, coordinated, and monitored project levels of performance and activities to ensure project completion in time.
• Prioritized requirements to be developed according to Agile methodology.
• Performed extensive requirement analysis and gap analysis.
• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.
• Used sessions, workforce for running and loading the data from source to target data warehouse.
• Followed established formats and procedures, created new formats, as well as researched, created, edited technical and business data documents.
• Extensively used SQL for accessing and manipulating database systems
• Participated in Design walk-through with SME’s to baseline the business architecture.
• Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
• Effectively implemented defect management process using ClearQuest.
• Maintained a close and strong working relationship with teammates and management staff to achieve expected results for the project.
• Involved in writing Manual Test Cases and Test Scripts for checking the application.
• Assisted the database modelers in preparing the logical and physical data models and ascertained that requirements have been met.
• Developed Functional Specifications and Testing Requirements using Test Director to conform to user needs.
• Was involved in UAT testing.
• Prepared user training manuals and successfully conducted user training sessions.

Environment:Windows XP, Rational Rose, MS Visio, Rational Requisite Pro, UML, MS Project, Oracle 9i, MS Office, UML, MS Word, SQL, Clear Quest, Test Director

Confidential, Warren NJ Feb’06 –Mar ‘07 
Business AnalystDescription:Worked as a Business Analyst was involved in implementing a centralized web-based SOA application infrastructure to save time, provide online data access, reengineer the credit card process in order to expand the company’s business. It was a 24-hour online access to credit card holders, where customers can login and view the account information (Current and Previous Account history), can make online payments, change their contact information (Such as Contact Address, Phone Number, Email Address if available), and can contact customer service representatives for questions.Responsibilities:

• Interacted as a liaison between Users and the different teams (including Deposit/Withdrawal, Customer Service, and Loan) involved in the application development for better understanding of the business and IT processes.
• Responsible for analysis and functional specifications of “As-Is” and “To-Be” business model to conduct GAP analysis in comparison to the proposed system to enhance the functionality of the application.
• Gathered business requirements through interviews, surveys and observing from account managers and conducted controlled brain-storming sessions with project focus groups and documented them in the Business requirement Document.
• Planned and defined system requirements to Use Cases, Use Case Scenarios and Use Case Narratives using the UML methodologies. Created Use Case Diagrams, Activity Diagrams, and Sequence Diagrams using MS Visio.
• Conducted a comprehensive use case analysis to determine key abstractions such as loan underwriting, loan-closed, borrowers-info, mortgage-payments etc, and their mapping for standard analysis.
• Identify different types of users (brokers, borrowers and loan officers) and analyze several important human engineering factors and guidelines and incorporated them into a design of a user interface using MS Visio
• Managed and coordinated the QA team to create the test approach and determine test needs, test environment, test data, resources and limitations.
• Provide 24 x 7 problem management support to the development team.
• Create various Data Mapping Repository documents as part of Metadata services (EMR).
• Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
• Provide support in developing and maintaining ETL processes that extract data from multiple SOR’s residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.
• Performed manual and automated tested related to the graphical user interface, functionality testing, security testing, and testing related to data sources.
• Helped to develop test strategies, test cases, test plans, defect reports, Traceability Matrices and test environments and managed the testing process, bug reporting and analysis of test results.
• Tracked the progress of system testing, and provided a daily status report to the Test Manager.
• Used Test Director to house all test documentation and report/track all issues and defects.

Environment: Rational Suite (Rational Rose, Requisite Pro), Rational Unified Process (RUP), Windows 2000, UML, MS Project, MS-Office Suite, MS Visio, WinRunner, Test Director

Confidential, Kansas City, MO Feb ’04 – Dec ’05
Business Analyst Description:
Allstate Corporation is the nation’s largest publicly held personal lines insurer. Allstate Financial Group includes the businesses that provide life insurance, annuity, retirement, banking and investment products through distribution channels. The aim of the project was to enhance SOA (Service Oriented Architecture) web-based policy management system, which integrated Allstates five policy management systems (life insurance, annuity, retirement, banking and investment products) and extended the functionality to provide anywhere, anytime, access to information to Allstates countrywide network of producers. 
Responsibilities:

• Analyzed consumer surveys and gave technical inputs in Business meetings.
• Involved in the meeting with Business process owners, SME (subject matter experts) and Marketing Team for Requirements gathering in Definition Stage.
• Facilitated the Customer in defining the high-level Functional Requirements and needs.
• Gathered the Requirements, Develop Process Model and detailed Business Policies and modified the business requirement document.
• Utilized RUP to create use cases, activity, class diagrams and workflow process diagrams.
• Prepared the Prototype and mockup screens.
• Involved in the Data Movement between Systems and validated the Business Requirements.
• Wrote test cases based on test strategies.
• Involved in Functionality testing during the various phases of the development
• Verified the correlation between the UML diagrams and developed detailed diagrams
• Validated the system End-to-End Testing to meet the Approved Functional Requirements.
• Blueprinted technical and operational training manuals and led Power Point/Visio presentations for the development of financial and technical applications for the departmental user base and for audit purpose.
• Responsible for providing fiscal and economic solutions through financial modeling and cost basis analysis
• Lead an entire QA Team comprising of 5 senior QA testers. Managed their activities through daily and weekly status reports
• Hands-on QA Analyst, responsible for coordinating and performing functional testing.
• Analyzed team performance with the QA manager and implemented the changes if any w.r.t. raising the efficiency of the entire team.
• Conducted the Final Customer Acceptance Testing (UAT).
• Increased process efficiencies and reduced development cycle time across department by spearheading the implementation of the full lifecycle software development methodology.
• Participated in weekly meeting and discussed modification request with management team.
• Interacted with the developers to report and track bugs using Rational Clear Quest.

Environment: Windows 2000, Microsoft Project 2000, Java, HTML, Oracle, MS Visio, Rational Unified Process and Rational Clear Quest