OBJECTIVE

• To obtain a challenging position as E - Commerce Data Analyst/Modeler 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 Confidential 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 Modeler/Analyst

Responsibilities:

• Involved in Requirements gathering and gap analysis between current state and future state of the applications
• Acted as Liaison between managers, stakeholders and Architecture, Design and Development teams
• Created Logical/PhysicalDatamodels in 3NF in the Warehouse area of EnterpriseData Warehouse
• Catalog Search & merchandising in ATG Business Control Center.
• Developed and clarified functional specifications, Business Use cases to meet business requirements and design specifications.
• Involved in creating Business Requirement Document, Functional and Technical Design Documents.
• Developed Visio flow charts to depict the conceptual process flows and business process flows.
• Performed Source data analysis and created target mapping documents to meet the business requirements
• Eliciting and translating business and/or technical needs into relevant documentation for assigned initiatives/projects.
• Designed Dimensional data models by implementing Star and Snow dimension and Fact tables to migrate data from various sources to Enterprise Data Warehouse.
• Worked with EDW team and Data Architects to create reporting requirements for Operational Analytics.
• Involved in installation and verification of systems to ensure compatibility with user requirements.
• Worked with UNIX admins to open up firewalls and establish connectivity between application servers
• Prepared monthly status reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project.
• Performed feasibility, adaptability study and risk analysis to identify the business critical areas from the user perspective.
• Extensively interacted with ETL teams and developed data mapping documents to facilitate data loads from flat files
• Executed ETL jobs with Datastage Director to load data warehouse and data marts from disparate source systems.
• Interacted with DBA teams to run Teradata utilities such as tpump, multiload, Fastload, Fastexport
• Suggested and Implemented performance improvements by tweaking complex SQL queries
• Organized and code migration across different environments such as QA, Performance and UAT

Environment: Oracle 11g, Teradata, IBM Infosphere DataStage and QualityStage, Squirrel, Cognos 10.1, Autosys, UNIX, SQL Server 2008, ERwin, MS VISIO, Microsoft (Word, Access, Excel, Outlook).

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.
• Analyzed existing logical data model (LDM) and made appropriate changes to make it compatible with business logic.
• Created Physical Data Model (PDM) for the OLTP application using ER Studio.
• Created Data Models using IDEF1X methodology.
• Involved in data model reviews with internal data architect, business analysts, and business users with in depth explanation of the data model to make sure it is in line with business requirements.
• Worked Confidential conceptual and physical (using IE methodology) database level to implement and build corporate enterprise information strategies.
• Worked on analyzing source systems and their connectivity
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
• Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application.
• Interacted with users for verifying user requirements, managing change control process, updating existing documentation.
• Actively involved in JAR sessions to identify what kind of data we need, how the data is going to be manipulated, & what reports are in the old warehouse, & what reports the new warehouse needs to generate.
• Analyzed business and end-user needs to ensure that project data requirements are identified and deliverables are met.
• Performed gap analysis between the AS-IS process & TO-BE process. I referred to the data dictionary document to conduct this analysis.
• Used gap analysis to do the data mapping document which is most essential in determining the source table, source columns, destination table, destination columns, gaps and define any business rule changes in order to fill up those gaps.
• Handed off the requirements to the ETL (extraction, transformation, & loading) developers, & worked with them on any questions they had.
• Performed Data Analysis and Data validation and data cleansing by writing complex SQL queries using TOAD against the Teradata database.
• Performed report validation writing SQL queries using TOAD on an Oracle database.
• Created process documents, reporting specs and templates, training material and slideshow presentations for the application development teams and managements.
• Wrote complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse.
• Performance tuning of SQL queries for data warehouse consists of many tables.
• Created PL/SQL packages, procedures and extensively used Arrays, PL/SQL tables, cursors, user defined object types, exception handling.
• Identified data inconsistencies and provided with the best resolution
• Performed UATs by writing test plans, reviewing them, writing test cases, executing test cases, & got business approvals.
• Created and maintained various process flow documentation with data flow diagrams.

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

Confidential, Seattle, WA

Data/Business Analyst

Responsibilities:

• Accomplished experience through whole SDLC from requirement analysis till deployment, using highly efficient RUP process of software development
• Worked with different business users to develop vision document and Business requirement specifications
• Developed the business logic for the website using UML
• Involved in Gap analysis to eradicate any bottlenecks in the business processes
• Documented Use Case Specification Document, RTM (Requirements Traceability Matrix), Release Notes and Training Manuals
• Developed Use Case Diagrams and workflows in Rational Rose. Also Developed Use cases and the Use case Specification Document in Rational Requisite Pro.
• Responsible for defining the scope of the project, gathering business requirements and documenting them textually
• Final prioritization was based on an intensive analysis of both, product, and process requirements
• Participated in Business Modeling by understanding the needs of the business, and also documenting Business use cases(initial) as well as System Use cases
• Assisted the team in eliciting, organizing, and documenting required functionality and constraints
• Extensively worked on the RUP’s development cycle with four consecutive phases - Inception, Elaboration, Construction, and Transition
• Involved in preparing of the test plan and test strategy documents
• Assisted the Test Engineering Team in testing and tracking the defects in the application
• Defect tracking, submission, documentation, and change requests were carried out using Rational ClearQuest and ClearCase for version control
• Used Test-Director for testing requirements, test cases, reporting bugs, work completion status

Environment: Windows, J2EE, Web Services, Oracle, SQL, Microsoft Office suite, Microsoft Visio, Quality Center, Win-runner, Rational Requisite Pro, Rational Rose, Rational Clear Case, Rational Clear Quest, UML.