SUMMARY:

• 8 years of IT experience in the field of Data/Business analysis, ETL Development and Data Management.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration, Data governance and Metadata Management, Master Data Management and Configuration Management.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Knowledge in Business Intelligence tools like Business Objects, Cognos, SAS, Tableau and OBIEE.
• Experience with Teradata as the target for the data marts, worked with BTEQ, Fast Load and MultiLoad.
• Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Strong experience in all phases of Software Development Lifecycle (SDLC) using Waterfall, Agile/Scrum, RUP (Rational Unified Process) and Software Testing Life Cycle (STLC).
• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Multi - table queries, Source to Target mappings, SQL Joins.
• Experience in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis, design and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project’s exposure to the forces of change
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
• Worked with Hadoop platform, Greenplum database and Datameer.
• Extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 8.0 and 8.1 as an Analyst.
• Knowledge in Guidewire Product.
• Worked on different platforms such as Windows 95/windows/98/NT and UNIX, Tableau, Sun Solaris, AIX, HP.
• Knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Some knowledge about HDFS (Hadoop Distributed File System) in Hadoop platform.
• Experience in Working with different industries like private banking, wealth management, financial, retails.
• Implemented Optimization techniques for better performance on the ETL side and also on the database side.
• Experience in the creation of Test Plan and Test Cases from the Requirements document. Documentation of Test Plans, Test Cases and Test Data for various applications.
• Experience in creating functional/technical specifications, data design documents based on the requirements.
• Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

PROFESSIONAL EXPERIENCE:

Confidential, Auburn hills, MI

Sr. Business Application Analyst

Responsibilities:

• Managed risk through development, design, testing and implementation of criteria applied on large populations of accounts.
• Monitor and measure performance of existing systems and corresponding parameters/settings and make adjustments as needed to improve existing parameters/settings.
• Worked on complete and thorough understanding of specific methods, systems and technologies used to control risk, including utilizing programming/database query tools such as SQL, Cognos, and SAS or the equivalent, and complex databases such as Oracle.
• Created card fraud detection rules/parameters, specifically PIN, Non-PIN and Card Not Present fraud, as well as ATM Deposits.
• Assisted with the management of card compromise events and the identification of points of compromise.
• Worked on Actimize Tool to create rule to stop Fraud.
• Experience on various tools to gather, analyze and interpret data from various sources, including fraud losses, transactions, authorizations and financial data, presenting findings in a clear and concise presentation format to management.
• Worked on Master card Fico tools to create a strategy to stop day to day fraud trends.
• Managed risk through development, design, testing and implementation of criteria applied on large populations of accounts.
• Identified and analyze emerging patterns of fraud that may create new risks and take appropriate action steps to protect Comerica's assets and minimize losses with little to no supervision.

Environment: SQL, Master card FICO Tool, PowerCenter, MS-Office, Oracle, UAT, Portfolio Viewer Tools, Actimize Tool, Toad, SSIS, SSRS.

Confidential, Auburn hills, MI

Sr. Business/Data Analyst

Responsibilities:

• Worked on different sources like Loans, Deposits, Leasing, Retail, Bonds etc.
• Performed data profiling in the source systems that are required for each banking source.
• Defined the mapping conversation and mapping rules based on 2052a Report.
• Responsible for defining the functional requirement documents for each source to target interface.
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL.
• Worked with Moody’s Analytics Team to create 2052A report
• Extensively interacted with ETL teams and developed data mapping documents to facilitate data loads.
• Experience with various ETL, data warehousing tools and concepts.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked on Moody’s Analytics Tool and Oracle.
• Dealt with ETL (extraction, transformation, and load) processes using Oracle and Informatica.
• Wrote regression test cases, did smoke testing with users.
• Provide help to testing team to do some complex testing on sources.

Environment: SQL, Moody’s Analytics Tool, PowerCenter, MS-Office, Informatica, Oracle, UAT, Data Quality, Toad, SSIS, SSRS.

Confidential, Wilmington, DE

Sr. Business/Data Analyst

Responsibilities:

• Performed data profiling in the source systems that are required for Enterprise Customer Hub (ECH).
• Involved in defining the business/transformation rules applied for WISD Data.
• Worked on Master Data Management standards in data conversion, mapping and migration .
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables and columns as part of Data Analysis responsibilities.
• Always patient in analyzing the root cause of data issues and clarifying it with the data owners.
• Performed data cleansing, data validation and mapping as described in the business requirements.
• Data analysis and reporting using MY SQL, MS Power Point, MS Access, Oracle SQL developer and SQL assistant.
• Designed and implemented complex SQL queries for QA testing and report/ data validation.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Created naming and system standards for lookup, transformation and target tables.
• Worked on Manual test cases for UAT testing and use SQL for querying and analysis purposes on various source tables and conditions applied.
• Extensively interacted with ETL teams and developed data mapping documents to facilitate data loads from flat files.
• Dealt with ETL (extraction, transformation, and load) processes using Oracle and Informatica.
• Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data profiling on source Data.
• Organizes review meetings with various Stakeholders and the end users and finalizing the Business Requirement specifications (BRD / Use cases), pilot and deployment schedules, meeting deadlines, Release notes UAT.
• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Responsible for defining the functional requirement documents for each source to target interface.

Environment: SQL, PowerCenter, MS-Office, Teradata, Informatica, Oracle, HPQC, MDM, RDM, Data Governance, UAT, Data Quality, IDD, IDQ, SSIS, SSRS.

Confidential, Alpharetta, GA

Sr. Data/Business System Analyst

Responsibilities:

• Performed data profiling in the source systems that are required for Dual credit report Data mart.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Created import job, workbook and export job into datameer.
• Created HDFS file into hue via datameer.
• Involved in defining the trumping rules applied by Master Data Repository.
• Define the list codes and code conversions between the source systems and MDR.
• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Applied Master Data Management standards in data conversion, mapping and migration.
• Developing data analytical databases from complex financial source data.
• Worked on creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Monitoring the automated loading processes. Advising on the suitability of methodologies and suggesting improvements.
• Familiar with HDFS files system in Hadoop platform.
• Involved in defining the source to target data mappings, business rules, business and data definitions.
• Responsible for defining the key identifiers for each mapping/interface.
• Reverse engineered all the Source Database’s using Embarcadero.
• Document 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 and Data mart design.
• Worked with Green plum database.
• Experience with various ETL, data warehousing tools, SQL server reporting service and concepts.
• Documented Test Plans, Test cases in Test Case Design Documents for different scenarios of the (User Acceptance Testing) UAT.
• Worked On BI Tools Tableau, Qlikview Dashboard Design, and Spotfire.
• Gathered and documented MDM application, conversion and integration requirements.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Worked on some impact of low quality and/or missing data on the performance of data warehouse client.

Environment: SQL/Server, Oracle10 &11g, MS-Office, Embarcadero, Netezza, Teradata, Enterprise Architect, Informatica, Hadoop, ER Studio, XML, Informatica, OBIEE, Greenplum Database.

Confidential, Topeka, KS

Senior Business/Data Analyst

Responsibilities:

• Work with users to identify the most appropriate source of record and profile the data required for sales and service.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Involved in defining the business/transformation rules applied for ICP data.
• Define the list codes and code conversions between the source systems and the data mart.
• Worked with internal architects and, assisting 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.
• Involved in defining the source to target data mappings, business rules, business and data definitions.
• Applied Master Data Management standards in data conversion, mapping and migration .
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Involved in configuration management in the process of creating and maintaining an up-to-date record of all the components of the development efforts in coding and designing schemas.
• Developed the financing reporting requirements by analyzing the existing business objects reports.
• Interact with computer systems end-users and project business sponsors to determine, document, and obtain signoff on business requirements.
• Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling.
• Responsible in maintaining the Enterprise Metadata Library with any changes or updates.
• Document data quality and traceability documents for each source interface.
• Establish standards of procedures.
• Generate weekly and monthly asset inventory reports.
• Evaluated data profiling, cleansing, integration and extraction tools (e.g. Informatica).
• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Remain knowledgeable in all areas of business operations in order to identify systems needs and requirements.

Environment: SQL/Server, Oracle 9i, MS-Office, Teradata, Informatica, ER Studio, XML, Business Objects.

Confidential, Denver, CO

Sr. Business/Data Analyst

Responsibilities:

• Performed data profiling in the source systems that are required for Billing System.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Involved in defining the trumping rules applied by Master Data Repository.
• Define the list codes and code conversions between the source systems and MDR, MDM.
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures.
• Responsible for creating weekly and monthly reports for management based on Cognos data.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Involved in defining the source to target data mappings, business rules, business 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.
• Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team..
• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Document 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 warehousing tools and concepts.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Good Experience with Mainframe enterprise billing systems Involved in defining the business/transformation rules applied for sales and service data.
• Worked with internal architects and, assisting 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 Dish enterprise data warehouse (EDW).
• Worked on some impact of low quality and/or missing data on the performance of data warehouse client.
• Identified design flaws in the data warehouse.

Environment: SQL/Server, Oracle10&11g,MS-Office,Embarcadero,Netezza, Enterprise Architect, Informatica, ER Studio, XML, Informatica, OBIEE.

Confidential, Cincinnati, OH

Sr.Data Analyst

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,

Business Analyst

Responsibilities:

• Involved in PolicyCenter customization with BA/SME's and in validating according to the Auto Business process of American Family Insurance.
• The major business jobs of a PolicyCenter is storing information about a policy and managing a set of processes.
• Used Rational Clear Quest to track Project Status, monitor workload and detect issues for Prototying Guidewire applications as per the requirements.
• If completed successfully these jobs might trigger an action in other products like Claims Center, BillingCenter and Contact Management System with other applications/products like On Base .Reviewed and analyzed functional Requirements, system requirements and business requirements.
• Responsible for the collection of functional requirements, non functional requirements, data mapping, and light data modeling.
• Database table review and data mapping for large scale data conversion project Oracle database to Mainframe.
• Involved in designing and maintaining testing process documentation, strategies and plans.Communicated with BA/SME's and turned project requirements and Business Process Flows into apt user stories.
• Created Test Cases for user interface, functionality and system using user stories based on product backlog.
• Actively participated in daily scrum meetings, sprint backlog planning and in evaluating user stories in points.
• Applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams.
• Involved and participated in introspective sprint review meetings with other agile team members.Involved in estimating burned down chart for measuring the progress of the project with stakeholders.
• Synthesized test data through various sources, Records/enusers/SME/BA/meetings and facilitated Testing Performed functional, integration, system, UAT and regression testing Identified problems and isolated software defects, data issues and user issues.
• Queried database using SQL queries to ensure data integrity and to validate the inserted and updated data.
• Involved in creating the frame work for automation testing.Executed test scripts in QTP for regression testing to ensure the quality of the system.
• Maintained RTM to check if all the requirements are implemented and Tested according to entry/exit criteria.

Environment: Microsoft Office, Oracle 9i(SQL), and Manual Testing, Guidewire Application suite.