OBJECTIVE

• To obtain a challenging position as Data Analyst with an emphasis on Data Warehousing to utilize my qualification and experience in Data Modeling.

SUMMARY

• 6+ years of experience in IT Industry and serving as a Data Analyst for 3+ years.
• Experience in data modeling, data profiling, designing and data analysis with Conceptual, Logical and PhysicalModeling for OLTP & OLAP.
• Working noledge of Bank, Insurance, Finance, Credit, Wholesale, Trading and Investment domains.
• 3+ years of experience in teh Banking domain.
• Extensive experience on interaction with system users in gathering business requirements and involved in developing projects. Chaired and conducted JAD sessions with business and technical teams.
• Experience in Data profiling and Data cleansing.
• 2+ years extensive experience in Data mining.
• Vast experience of working in teh area of data management including data analysis, gap analysis and data mapping.
• Worked extensively with Relational Modeling and Dimensional Modeling.
• Experience in Data Transformation, Data dictionary, Data Loading, Data Modeling, Data analysis, Metadata and Performance Tuning.
• Experience with SQL, PL/SQL objects. Involved in creating Packages, writing Procedures and Functions. Tuning using various types of Partitioning and Indexes.
• Proficient in both SQL and DB2.
• Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments.
• Efficient inDimensional Data ModelingforDataWarehouse /Data Martdesign, identifying Facts and Dimensions, creation of cubes,Star SchemaandSnowflake Schema.
• Exposure toTop Down (Inmon), Bottom Up (Kimball)andMixed Approaches.
• Experience in DBMS/RDBMS implementation using object - oriented concept and database toolkit.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of teh data.
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary and Interface requirements documents.
• Worked on integration and implementation of projects and products, database creations, modeling, calculation of object sizes, table spaces and database sizes.
• Experience with creating reports using Business Objects.
• Worked closely with Data Architect in creating data models.
• Coordinated and prioritized outstanding defects and system requests based on business requirements. Acted as a liaison between teh development team and teh management team to resolve any conflicts in terms of requirements.
• Experience in providing Production Batch support.
• Interacted with all levels of teh project development team, from end users to Software Architects, Technical Lead, Database Administrators, and System Administrators.

TECHNICAL SKILLS

Database: Teradata, DB2, Oracle, SQL Server, My SQL, MS Access

Data Warehouse Concepts: ODS, Star Schema, Snowflake schema, OLTP, OLAP

Operating Systems: UNIX, Linux, Windows 8/XP

Design: Entity-Relationships, Data Flow Diagrams

Languages: C, C++, SQL, PL/SQL

Tools: Erwin, MS-Visio, E-R Studio, QlikView, SAS, SQL developer, SQL Loader, TOAD, VBA.

Desktop Software: Microsoft Word, Excel and PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Irvine - CA

Data Modeler/Data Analyst

Responsibilities:

• Participated in requirement gathering session with business users and sponsors to understand and document teh business requirements.
• Worked on logical and physical model using Erwin based on requirements.
• Experience on working with Agile Methodology and involved in Sprint 1, 2, 3 & 4.
• Good working noledge in normalizing teh tables up to 1NF, 2NF & 3NF and maintain referential integrity by using triggers and primary keys and foreign keys.
• Implemented forward engineering and reverse engineering techniques.
• Worked with DBA to create teh physical model and database objects.
• Worked closely with ETL team in loading and mapping teh data.
• Worked on developing Enterprise data warehouse.
• Created Source-to-target (S2T) mapping document as part of Data Analysis.
• Designed tables for staging and integration layers.
• Involved in data migration from staging to integration.
• Worked on profiling source data to determine teh key consistency, data type, size, etc.
• Implemented teh standard naming conventions and created domains in teh data model.
• Demonstrated that tables are appropriately modified.
• Updated EIW database objects like tables and views.
• Strategies were designed to cater initial and incremental load.
• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Database triggers etc).
• Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
• Dealt with different data sources ranging from flat files, Excel, Oracle, Sybase, and SQL Server.
• Widely used reviewing and validation of final data models.
• Good communication with teh project team throughout all stages of design, managing time TEMPeffectively, and work on project timelines simultaneously in demanding deadline driven environment.

Environment: Oracle 11g, Windows 7, Erwin9.0, MS Office, HP ALM, JIRA, Oracle SQL Developer.

Confidential, Dallas - TX

Data Analyst

Responsibilities:

• Performed data analysis for teh existing data warehouse and changed teh internal schema for performance.
• Participated in Designing and development of teh application.
• Used user stories approach for describing teh requirements using teh user story template.
• Performed Gap Analysis to check teh compatibility of teh existing system infrastructure with teh new business requirements.
• Extensively used SQL for accessing and manipulating database systems and profiling
• Gathered requirements and created Use Cases, Use Case Diagrams, Activity Diagrams using MS Visio.
• Prepared business flow diagrams and defined teh workflows.
• Worked with Data modelers and ETL teams as part of Data analysis.
• Involved writing teh stored procedure for 14 days Mailers.
• Worked extensively on teh MS-SQL environment to run out teh queries and explore teh Databases.
• Identified relationships and trends in data, as well as any factors that could effect teh results of research.
• Analyzed and interpreted statistical data to identify significant differences in relationships.
• Reported results of statistical analysis including information in teh form of graphs and models.
• Developed and tested experimental designs, sampling techniques, and analytical methods.
• Created and executed SQL queries (using Rapid SQL and MS Access) and scripts to validate data movement and generate expected results for UAT.
• Conducted User Acceptance testing (UAT) and worked with users and vendors who built teh system.
• Involved in Manual Testing by checking of various validations.
• Created, maintained, and executed manual test scripts.
• TEMPEffectively used defect management process using ClearQuest.
• Maintained a close and strong working relationship with teammates and management staff to achieve expected results for teh project team.

Environment: Windows XP, Power Pivot, UNIX, SQL Server, MS Office, UML, Rational Clear Quest, Teradata, SAS, MS Access, QlikView, MS Visio, Zhou.

Confidential, Cleveland, OH

Data Analyst

Responsibilities:

• Worked with business requirement analysts/subject matter experts to identify and understand requirements. Conducted user interviews and data analysis review meetings.
• Resolved teh data related issues such as: assessing data quality, data consolidation, evaluating existing data sources.
• Worked closely with Data Architect to review all teh conceptual, logical and physical database design models with respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds teh logical data models.
• Analyzed teh source data coming from various data sources like Mainframe & Oracle.
• Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
• Developed and ran Unix shell scripting.
• Involved working on different set of layers of Business Intelligence Infrastructure.
• Performed Data cleansing and scrubbing while finding teh quality data.
• Worked on integration workflows and load processes.
• Dealt with Oracle Hyperion Financial Management tool for financial consolidation and reporting.
• Worked extensively in Data consolidation and harmonization.
• Worked extensively on teh MS-SQL environment to run out teh queries and explore teh Databases.
• Defined key facts and dimensions necessary to support teh business requirements.
• Worked with OLAP tools such as ETL, Data warehousing and Modeling.
• Managed and supported teh warehouse with teh halp of CRM tool.
• Meeting with user groups to analyze requirements and proposed changes in design and specifications.
• Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data.
• Flat file conversion from teh data warehouse scenario.
• Created Fact and Dimension tables in Mart.

Environment: Mainframe, MS-SQL, UNIX, SAS, Mainframe, DB Visualizer, OLAP, MS Office, PeopleSoft CRM, Oracle Hyperion, E-R Studio, PL/SQL, and Putty.

Confidential

Data Modeler

Responsibilities:

• Involved in teh entire System study, analysis and Design.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer.
• Developed teh logical and physical data model for teh proposed solution.
• Worked with DBA’s to create a best fit physical data model from teh logical data model.
• Created 3NF business area data modeling with de-normalized physical implementation data and information requirements analysis using Erwin tool.
• Extensively used star schema methodologies in building and designing teh logicaldatamodels into dimensional model.
• Used Erwin Database Generation for generating DDL, stored procedure and trigger code for you're target database.
• Defined best practices for project support and detailed documentation.
• Ensured delivery of results as per pre-defined quality parameters and customer satisfaction metrics. dis involved teh right kind of data analysis that in turn leads to close ended action plans.

Environment: Oracle, Erwin 7.38, SQL, TOAD, MS Excel.

Confidential

Business Analyst

Responsibilities:

• Requirements management and analysis through regular meeting and sessions with Stakeholders.
• Conducted JAD sessions with stakeholders in coming up with user requirements.
• Acquired user requirements and utilized Rational Unified Process (RUP) to configure and develop processes, standards, and procedures for Banking Applications.
• Performed Gap Analysis to check teh compatibility of teh existing system infrastructure with teh new business requirements.
• Conducted Functional Requirement Specification and User Requirement Specification Analysis/reviews and walkthroughs with teh designers, developers and stakeholders.
• Documented Business requirements and processes, and came up with process redesign.
• Used and created Customized Templates in coming with SRS and Functional Requirements Documents.
• Data analysis and reporting using SQL.

Environment: MS Project, Rational Rose, MS Office, SQL, UML.