OBJECTIVE:

To obtain a challenging position as E - Commerce Data Analyst with an extensive knowledge of Data warehousing, requirement analysis and Quality assurance and to utilize my qualification and experience in Data validation, Data mapping, Data modeling, Data profiling, Data cleansing, Data manipulation, performance tuning and GAP analysis.

SUMMARY:

• Highly motivated Data Analyst/Modeler with 8 years of experience in Information technology industry in different environments such as E-Commerce, Healthcare, Mortgage, Backed Securities, Derivative, Equities, Corporate Bonds and Credits domains.
• Strong knowledge of all phases of the Software Development Life Cycle (SDLC) including requirements gathering, analysis, design, implementation, testing and deployment as well as software engineering methodologies like Rational Unified Process (RUP), Agile.
• Experience in business process analysis/modeling, business requirements, and developing High level Designs for the Business applications.
• Extensive experience in creating Business Requirement Documents (BRD), Use Cases, Business Systems Designs (BSD), Application Information Document (AID), Project Plans, Requirements Traceability Matrix (RTM) throughout the Life Cycle of a project.
• Experience in Performance Management to support strategic planning, goal setting, strengthen accountability, enhance decision making and to improve client satisfaction.
• Ability to interact with individuals at all levels with exceptional skills in forming and facilitating Joint Application Development (JAD) and Rapid Application Development (RAD) sessions.
• Expertise in requirement analysis, gap analysis, impact analysis, cost/benefit analysis, risk analysis, testing, development of functional specifications and project planning.
• Experience in test Data Management using IBM optimization tool for performance management.
• Experience in SOA analysis and design, for data quality analysis to influence service implementation services.
• Experience as BI Data Analyst, analyzing facts and dimensions as per client’s requirements.
• Experience with working with Oracle database 11g, Teradata database, My SQL server, MS Access
• Exceptional Documentation Skills for writing Use Cases and Functional Requirement Documents as well as for creating Use Case diagrams, Activity diagrams, and Data flow diagrams based on UML Methodology and business process flow diagrams using MS Visio.
• Experience writing analytical SQL queries to perform data analysis and data validation and quality check.
• Proven track record in troubleshooting on Technical areas of Database Architecture, Design, and Optimizing ETL jobs and addressing production issues with respect to performance tuning and enhancement.
• Experienced in BI Reporting tools such as Business Objects, COGNOS and Oracle Discoverer.
• Experienced with querying databases using SQL 2005/2008.
• Experienced working with offshore vendors and establishing offshore teams and processes.

TECHNICAL SKILLS:

Databases: Teradata V2R5/ V2R6/ V2R12, Oracle 9i/10g/11g, IBM DB2, MS SQL Server 2000, MS Access.

ETL Tools: Informatica, IBM Infosphere DataStage and QualityStage, SQL Server Integration Services (SSIS).

Analytics & Reporting: Unica, Cognos, MicroStrategy, Business Objects XI R3, SSRS.

Database Tools/SQL Tools: TOAD, Squirrel, Oracle SQL Developer, PL/SQL Developer, SQL Explorer, Teradata SQL Assistant.

Methodologies: Star schema database design, structured systems analysis and design.

Repository Tools: Microsoft SharePoint, Rational Rose, Requisite Pro, C

Testing Tools: QTP, Load Runner.

Documentation: UML Diagrams, Data Mapping Document, Data dictionary, User specification document, Technical Specification Document, Process Documents.

Defect/Test Management Tool: Quality Center, Test Director.

Programming Languages: SQL, C, C++., Matlab

Operating Systems: UNIX, Mainframes, Microsoft Windows (1997/2000/XP/NT/Vista, 7 &8).

Microsoft Tools: Microsoft Office Visio, Microsoft Office Project Office Suite (Word, Excel, Outlook, Publisher, PowerPoint, Desktop Deployment.

PROFESSIONAL EXPERIENCE:

Confidential, Bothell, WA

Sr. Data Analyst

Responsibilities:

• Working with business teams and developers to identify the changes needed.
• Modifying the schema, updating the various tables in database for eg the pricing changes, sku launch.
• Adept in formulating Test plans, Test cases, Test Scenarios, Test Approach, Setting up testing environment in conjunction with the Testing team
• Deep understanding of Database management system and Data warehousing concepts
• Working on Oracle ATG Merchandising v 9.3 to fulfill business requests.
• Writing and executing Oracle and PL/SQL queries as needed along with database tuning.
• Experience in testing Business Intelligence reports generated by various BI Tools.
• Proficient in performing Gap Analysis, by evaluating the key differences between the As-Is and the To-Be system and identifying the key requirements for system reengineering.
• Innovative, excellent team player and possess good requirement and data analysis skills
• Extensive experience with databases like Oracle, Teradata, SQL Server, DB2, and MS Acces, IBM AS400
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Proficient in preparing Business and System Use Cases and supporting all the documents with UML Diagrams such as Use Case Diagrams, Class Diagrams, Activity Diagrams, Data Flow Diagrams, Sequence Diagrams, Process Flows (Business and System) using UML modeling tools such as MS Visio.
• Worked with the Business Analyst, QA team in their testing and DBA for requirements gathering, business analysis, testing and project coordination.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetchdata from legacy Oracle and SQL Server database systems
• Used ERWIN for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Used Model Mart of ERWIN for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Involved in Data Mapping.
• Developed test plans and test cases for QA Unit Testing, System Testing and Enterprise testing.
• Involved in the daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.

Environment: Windows 7, Teradata 14, ERWIN r9.1, SQL server 2005/2008, Business Objects XI, MS Excel 2010, Informatica, SQL, Oracle, TOAD for Data Analysis, Teradata .

Confidential, Miami, FL

Data Modeler/Analyst

Responsibilities:

• Identifying database objects to be modified as per ICD 10 code requirements by table analysis, column analysis and data analysis.
• Analyzing current position of schemas and documenting needs of schema for modification.
• Preparing data modeling requests to create table structures, to change existing tables as per requirement and renaming existing tables.
• Transferring data from Prod environment to Dev and QA environment using FTP and SFTP for unit testing and QA testing.
• Writing SQL scripts for creating views, triggers and sequencers.
• Working with ETL developers and providing them data mapping specifications to develop ETL jobs to load the data into target databases.
• Preparing test cases for Quality assurance testing, QA testing new tables and documenting test results.
• Creating table views for BI reporting purposes.
• Used MS Office suite (Word, Excel, Access, Visio, Power Point, Outlook, and Project) for project tracking, documentation, and presentation.
• Maintained legacy Perl scripts while refactoring the code and migrating it to a new environment
• Developed programming standards and custom Perl modules to increase script resilience and maintainability.
• Facilitating meetings with different technical groups such as ETL developer, business requirements collection team and BI reporting team to collected and documented business processes as well as business rules.
• Identified, organized, and documented the changing requirements of the project

Environment: Windows 2000, IBM Rational Suite (IBM Rational Requisite Pro, IBM Clear Case), SQL Server, SQL, Test Director.

Confidential, Concord, CA

Data Modeler/Analyst

Responsibilities:

• Involved in requirement gathering, analysis of the requirements from the business owners and users.
• Performed data analysis and profiling of source data to better understand the sources.
• Created logical data model from the conceptual model and it's conversion into the physical database design using Erwin.
• Worked with DBA's to create a best-fit Physical Data Model from the logical data model.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Interacted with the database administrators and business analysts for data type and class words.
• Conducted design sessions with business analysts and ETL developers to come up with a design that satisfies the organization's requirements.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created ER Diagrams, Data Flow Diagrams, grouped and created the tables, validated the data, identified PK/ FK for lookup tables.
• Created 3NF business area data modeling with de-normalized physical implementation data and information requirements analysis using Erwin tool.
• Developed Star Schema and Snowflake Schema in designing the Logical Model into Dimensional Model.
• Ensured the quality, consistency, and accuracy of data in a timely, effective and reliable manner.
• Involved in ETL mapping documents in data warehouse projects.
• Created high level ETL design document.
• Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions.
• Assisted the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.
• Involved in extensive data analysis on the Teradata and Oracle systems querying and writing in SQL and TOAD.
• Assisted the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.
• Used SQL joins, aggregate functions, analytical functions, group by, order by clauses and interacted with DBA and developers for query optimization and tuning.
• Conducted several Physical Data Model training sessions with the ETL Developers. Worked with them on day-to-day basis to resolve any questions on Physical Model.

Environment: Oracle 11g, Erwin, Windows XP, MS Excel, Business Objects XI, SSIS, MS Access, Teradata, Excel, Informatica.

Confidential, Norfolk, VA

Data Modeler/Analyst

Responsibilities:

• Created and review Requirement specifications and process flow diagrams including context and dataflow diagram.
• Defined the data sources, data loads and data transformation using ER Diagrams. Used MS-Visio for model diagrams, MS-Word for documentation and used Unified Modeling Language for visual modeling.
• Authored Data Flow diagrams, Sequence diagrams and Business Process models with special detail to Sub-Processes.
• Developed a logical Integration model detailing the flow of information through the various components, including definition of external and internal message contents.
• Did Gap analysis from beginning of the project till the end, to ensure the project is heading towards right direction.
• Responsible for creating Data mapping document,
• Designed message formats, queues, systems interfaces, and worked with the business users though interviews and JAD sessions.
• Facilitated the analysis and design phase, documented customizations, wrote test scripts for all processes and customizations, coordinated system test and tracking issues, and coordinated the cutover process to Production.
• Analyzed, collected and prepared user requirements, definition, scope and expectations for deliverable plans. Delivered system documents, processes, diagrams, and test cases.

Environment: Rational Suite (RequisitePro, ClearQuest, Clearcase),Enterprise Architect, MainFrame, COBOL, Informatica, MS Excel, MS Project, MS SQL Server 2005, Visual Basic