SUMMARY

• 8 years of IT experience as a Data / Business Analyst including project planning, management, software design and development.
• Involved in complete Project Life Cycle including requirements gathering and Analysis, Database design, Database & application development, Testing, Implementation and Support of the application software.
• Solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling, Data Analysis and Data Mapping.
• Strong experience in all phases of Production troubleshooting, Production Support Analyst.
• Experienced in the use of AGILE /Scrum methodology which includes team work, quick deliverables, prioritizing multiple tasks.
• Strong experience in conducting User Acceptance Testing (UAT), documentation of Test Cases and designing and developing Test Plan and Test Scripts.
• Proficient in Data Analysis on Oracle, MS SQL Server & MS Access with sound knowledge in extraction of data from various database sources like Oracle, MS SQL Server, DB2 and Flat files.
• Good in Normalization (1NF, 2NF, 3NF and BCNF)/De - normalization techniques for effective and optimum performance in OLTP and OLAP environments.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Strong knowledge in oracle programming using PL/SQL (stored procedures, functions, triggers) and standard built-in Oracle packages.
• Experience in working with UNIX shell scripting.
• Strong knowledge in gathering and translating business information using BI tools like Business Object to create reports and analysis for customers.
• Experience with office applications like Microsoft Word, Excel, and Power Point.
• Good interaction with developers, managers and team members to coordinate job tasks.
• Handled high priority calls during Production Support.
• Experience in providing technical support and preparing technical documents for the end user.
• Adept at working with diverse technical groups and end users to develop technical solutions that meet or exceed expectations along with good analytical, communication and problem solving skills.
• Self-starter, Multi-Tasking, Attention to detail, ability to work with minimal supervision and manage time and task efficiently.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, T-SQL, XML, HTML, ASP.net, VB.net,C#

Database Languages: Oracle 11g/10g/9i/8i, MS Access, Teradata

Tools: UML, Rational Rose, MS Project, MS Visio, SQL Loader, Toad, Clear Quest, WinSCP, Ascential Datastage, ExtraPutty, Informatica, SSRS,ER Studio, Business Objects, Power BI, Crystal Reports, Erwin, Teradata SQL Assistant, BTEQ, JIRA

Operating Systems: UNIX, Microsoft Windows, OSX

Computer Technologies: Microsoft Office Suite 2010, Microsoft Project (WinProj)

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Data Analyst

Responsibilities:

• Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams.
• Created Technical specifications documents based on the functional design document for the ETL coding to build the data mart.
• Conduct data analysis, needs assessments in order to align information technology solutions with business initiatives.
• Develop or modify information systems, including analysis of business and user needs, documenting requirement and revising existing systems.
• Load data in excel and run analysis for data migration.
• Experienced in the use of AGILE/ Scrum methodology which includes team work, quick deliverables, prioritizing multiple tasks.
• Capture technical metadata through data modeling tools.
• Ensured the feasibility of the logical and physical design models
• Develop SQL queries for Data Cleaning and Data Mapping.
• Perform data validation and testing over different databases.
• Reverse engineered all the Source Database's using SQL queries.
• Construct and review test plans, scenarios, cases and scripts, ensuring that requirements coverage is adequate.
• Review the ETL code on Informatica before data get loaded on to the database.
• Participate in requirement and design review. Maps business requirement, functional and technical specifications to test scenarios and test cases.
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing enterprise data warehouse (EDW).

Confidential, Des Moines, IA

Data System Analyst

Responsibilities:

• Perform the following activities: requirements definition, design, development, testing and implementation.
• Support internal stakeholder to ensure data is processed and sent within agreed SLA.
• Using C# to generate monthly reports for Business Users.
• Created UAT plans with several test cases for each production release to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
• Created SQL scripts to transfer the data from Oracle to Teradata.
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams.
• Generate Adhoc SQL query to create reports for downstream partners.
• Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of ETL logic.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Ascential Datastage.

Confidential, Claymont, DE

Business Analyst

Responsibilities:

• Create and update Business Requirement Documents and Functional Requirement Documents.
• Act as a liaison between the business units, QA and the technology teams. Lead JAD sessions and act as the lead facilitator for various projects from start to finish through the SDLC.
• Participate in Code Reviews, System Testing and UAT followed by production verification, post production testing and support.
• Conduct BRD walk thru session with the entire finance team, business, testers and developers after the completion of the BRD.
• Organize meetings with the SMEs of the dependent systems. Conduct weekly issue meetings with customers.
• Assisting in writing efficient and effective Test Plans, Test Strategy, System testing, End-to-End testing and User Acceptance testing.
• Participating in the planning, development, coordination and presentation of specific testing needs as appropriate to the quality assurance needs of the end user.
• Providing the required test data for the developers in order to fix the defects.
• Participating in QA team meeting and bug tracking meetings.

Confidential, Atlanta, GA

Data Modeler/ Data Analyst

Responsibilities:

• Review Functional and Technical requirements for clarity.
• Assist with the Application design and analysis as well as provide input to the Database design.
• Assist with the Integration design for data exchange, import and export.
• Build applications as directed by the Enterprise Development Team Manager.
• Report creation and validation
• Produced wireframes, mock-ups, task flows, prototypes, and design specifications as needed to assist with business socialization and approval, as well as implementation and testing using Visio.
• Design, develop and deploy platform code and applications content for the Confidential Commerce platform
• Responsible for application analysis, design, coding, testing and documenting of new interactive web applications as well as maintaining, supporting and upgrading of existing web applications
• Development of forms for data entry/ transaction system.
• Deployment of Forms to web.
• Used triggers on source schema to move the change to the stage environments
• Developed PL/SQL procedures to move data from stage environments to the data warehouse.

Confidential, Washington, DC

Business Analyst

Responsibilities:

• Experienced in the use of AGILE/ Scrum methodology which includes team work, quick deliverables, prioritizing multiple tasks.
• Performed analysis and reporting for the Fraud Operations team.
• Coordinated with cross-functional teams in different locations for quality data and analysis.
• Created and automated scripts in Teradata that runs on a daily, weekly, or monthly basis.
• Developed numerous SQL and shell scripts to get the data from the flat files in different formats and load it in Teradata tables.
• Created ETL scripts to transfer the data from Oracle to Teradata.
• Used Business Intelligence technology like Business Objects and Teradata to create reporting and analysis for the business customers so that they can make better business decisions.
• Knowledge in developing, designing data mining models for the customers' forecasting and budgeting.

Confidential, Dallas, TX

Business System Analyst

Responsibilities:

• Worked on UAT testing and took signoff from the Commercial line of Property & Casualty business users.
• Created Wireframe diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Helped with Data Mapping between the data mart and the Source Systems.
• Extensively used Test Director to review and update the status of entire testing process.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements
• Developed automated Test Scripts in Win Runner using Test Script Language (TSL) for Functional Testing, Regression Testing, Data Driven Testing, Usability Testing, and Verifying Specific content through using Checkpoints
• Developed, managed and updated data repositories, i.e. operational data store, data warehouse, data marts.