SUMMARY

• Over 8 years of Industry experience as a Data Modeller/Analyst with solid understanding of Business Requirements Gathering, Data warehousing, Business Intelligence, Data Mapping and Data Modeling.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Experience with IBM WebSphere Business Modeler to understand and transform business through superior business modeling.
• Experience in dealing with different data sources ranging from Flat files, Oracle, Sybase, SQL server, Teradata, Ms Access and Excel.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Microstrategy Data Warehouse Data Modelling and Design.
• Performed overall project Management, Analysis, Architecture, design, development and implementation of data warehousing / business intelligence.
• Worked on data warehousing projects from inception to implementation and delivered high quality solutions in timely manner meeting and exceeding the business requirements.
• This involved working with top management and executives business sponsors and IT department.
• Responsible for defining the information architecture and technology infrastructure along with the design of multi dimensional data models and the Business Intelligence delivery solutions.
• Responsible for managing the data analysis, data sources, data mapping along with defining the metadata repository.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

Programming Languages: C, C++, C#, VC++, VB, VB.NET, C#.NET, ASP.NET, Java, SQL

Development Methodologies: RUP, AGILE, Waterfall

Databases: MS - Access, MySQL, SQL Server, Oracle, Teradata

Application Servers: IBM Websphere, ATG Dynamo, BEA WebLogic

Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)

Data warehousing Tools: Informatica, Business Objects, Cognos, Erwin

Testing Tools: Quick TestPro (QTP), TestDirector, Win Runner, Load Runner

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

Business Data Architect / Analyst

Responsibilities:

• Responsible for identifying, assessing, and documenting business requirements, recommending business priorities, and advising business on options, risks, and costs.
• Organized Joint Application Development (JAD) sessions with data steward and ETL teams while having walkthroughs for mapping documents.
• Designed the dimensional Data Model of the data warehouse
• Worked as a member of the Data lineage Team in the Enterprise Data Program division to create the Data Functional Design Documents.
• Conducted research to determine if solutions to business requirements currently exist within or outside the business unit, and if not, whether new solutions are feasible.
• Facilitate implementation of new functionality through training sessions, demos, and the development of appropriate documentation.
• Provided and/or created relevant test scenarios for the testing team.
• Worked with test team to develop system integration test scripts and execute testing - all to ensure the testing results correspond to the business expectations.
• Conducted Introduction session for SEC, Regulatory reporting and SOX Compliance tool and set up a SharePoint site to keep track of data.
• Gathered information session required for designing the new data elements by attending the requirement sessions
• Worked as a member of the Data lineage Team in the Enterprise Data Program division to create the Data Functional Design Documents.
• Supported new business requirements by making changes in the Conceptual model.
• Understanding of the processes and activities on SOX controls.
• Collaborated with Compliance team at the bank on risk analysis and issue resolution.
• Designed test scripts to perform Data validation
• Communicated the implementation of the tool with third party vendor and the stake holders.
• Responsible for creating mapping documents required for the Trintech team.
• Developed high level milestone plan, detailed project plan, and communication plan.
• Prepared work session guides and gathered HR org tables and schedule work sessions.
• Reviewed and analysed existing data models.
• Responsible for enhancing existing Logical and Physical data quality check to in corporate to the compliance tool.
• Developed test cases, test plans and prepared for UAT testing. Also developed and reviewed training plan and materials.

Confidential, Madison, WI

Data Analyst

Responsibilities:

• Gathered information required for designing the new data elements by attending the requirement sessions
• Designed the dimensional Data Model of the data warehouse
• Worked as a member of the Data lineage Team in the Enterprise Data Program division to create the Data Functional Design Documents.
• Supported new business requirements by making changes in the Conceptual model.
• Responsible for making changes in existing logical and physical data models using ERwin, to support newly provided services.
• Understanding of the processes and activities of loan origination and closers.
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Designed script to perform Data validation by using Teradata SQL Assistant, SQL scripts.
• Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II
• Responsible for creating mapping documents required for the ETL team.
• Played a major role in identifying the source and target elements implementing SQL queries.
• Worked on building load rules and transformation logic for Extraction, Transformation and Loading (ETL) of the data into the data warehouse.
• Reviewed and analyzed existing data models.
• Responsible for enhancing existing Logical and Physical data models to accommodate the new data requirements.
• Organized Joint Application Development (JAD) sessions with data steward and ETL teams while having walkthroughs for mapping documents.

Environment: Windows NT 4.0, UNIX, Teradata, Oracle, SQL Server 2000, ERWin, JAD, Sequential Files

Confidential, Charlotte, NC

Data Modeller / Analyst

Responsibilities:

• Reverse-engineer production Teradata databases into logical & physical data models in Erwin (includes views for end user access).
• Add relationships, keys across structures.
• Format the models accordingly so it is easy to read & follow.
• Follow established model-management processes to keep data models current
• Actively participate in peer review sessions and exchange information regarding modelling activities.
• Seek proper approvals from team leads and corresponding managers after each database is successfully reverse-engineered and ready for presentation.
• Publish these models in PDF, HTML or another acceptable format.
• Collaborate with Business Analysts, End Users, Data Architects, other Data Modellers, DBA’s, and Database Designers.
• Worked on building load rules and transformation logic for Extraction, Transformation and Loading (ETL) of the data into the data warehouse.
• Create Data Flow/data Lineage Diagrams (DFD/DLD) to depict the source-to-Target Mapping and Data Lineage Analysis.
• Wrote Teradata scripts for data manipulation, data inserting millions of records into tables.

Environment: Windows NT 4.0, Teradata, SQL Server 2000, Erwin, JAD, Sequential Files, Ab-initio

Confidential, Indianapolis, IN

Data Modeller

Responsibilities:

• Developed a Financial Systems Datamart and a Customer Information System (CIS) Datamart as components of the data warehouse.
• Systems analysis experience in mortgage lending (loan origination, loan processing, underwriting, closing, funding, post-closing, loan servicing, compliance and regulatory reporting).
• Created Logical/Physical data models from the conceptual model identifying the cardinality between the tables.
• Generated DDL scripts for the developed physical model
• Updated the CDM Metadata Tool (Data Dictionary) for the changes coming up with the new requirements.
• Development of reporting solutions which include MS Access MS Excel and OLAP reporting via HyperionEssbase.
• Developed script to perform Data validation on Account level by using Teradata SQL Assistant, SQL scripts.
• Configured the Data mapping between Oracle and SQL Server 2005.
• Tested Performance & Accuracy related queries under SQL Server
• Designed and implemented basic SQL queries for testing and report/data validation
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Produce performance reports and implement changes for improved reporting. Interface with internal customers.
• Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata
• Establish documentation for agile methodology for implementation with a very water-fall-centric development team.
• Designed, developed, and maintained various data reports by using Teradata, SQL, and Ms Excel.
• Extract data from Teradata, Excel and flat files into SAS Datasets.
• Performed numerous Ad-hoc requests, financial reports involving SQL scripts, UNIX, SAS and Teradata.
• Tested Performance & Accuracy related queries under SQL Server.
• Compiled Weekly, Monthly, Daily Financial analysis reports as per Business Groups requests with help Teradata SQL Assistant, UNIX.
• Managed and drove continuous improvements in HyperionEssbasedata cubes performed UAT testing and lead migration effort.
• Tracked UAT issues/bugs and prepared reports.
• Designed and developed project document templates based on SDLC methodology
• Used Balance Scorecard approach for developing program strategy in order to manage the grants program and development of metrics for monitoring success of program.
• Used Microstrategy dashboards for data analysis and custom reports.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.

Environment: MS Project, Excel, PowerPoint, Outlook, Access, MS Office, UNIX, Teradata, FrontPage, Visio, Documentum, UAT, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, EVPN, OLAP

Confidential, Seattle, WA

Data Modeller

Responsibilities:

• Involved in the story board discussion of portal design and usability
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Extensively used data mapping from source to target and target to source for Sun to Oracle migration of database.
• Conducted Architectural Discussions to prepare the Proposed Architecture and provided insight in the Business Case to the Architecture Review Board (ARB).
• Wrote Business Cases for the Stakeholders to understand the functioning of the new System.
• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
• Creating, Process Flow Diagram, Context Diagram and Activity diagrams using UML.
• Created RUP activity diagrams and sequence diagrams to analyze the requirements and recommend solutions.
• Gathered user and business requirements through open-ended discussions, brainstorming and prototyping
• Identified Use Cases from the requirements. Created UML Diagrams including Use Cases.
• Interact with business users and provide Business Requirements, including identification of opportunities for Improvement and Optimization of Business Processes.
• Created automated Load test scripts using Load Runner.
• Analyzed system requirements and developed Test Plans, involved in developing Test Script for manual testing
• Developed test plans with QA team and helped to develop test cases for system testing,
• Maintained a close and strong working relationship with teammates, developers, testers and management staff by conducting regular one-to-one sessions and group meetings.
• Adhere to the firm’s SDLC process and represent as the application business analyst
• Developed Business Requirement Documentation, Functional Specification Documentation, High Level Testing Plan, etc
• Involved in preparing a simple and detailed User manual and assisted training session of the new and improved system.