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

• 8+ years of experience in IT Industry and serving as a Data Analyst for 6+ years.
• Experience in data modeling, data profiling, designing and data analysis with Conceptual, Logical and PhysicalModeling for OLTP & OLAP.
• Working knowledge of Bank, Insurance, Finance, Credit, Wholesale, Trading and Investment domains.
• 3+ years of experience in the 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 the 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 (Kimbal)andMixed Approaches.
• Experience in DBMS/RDBMS implementation using object - oriented concept and database toolkit.
• Good knowledge on ACORD.
• Worked in IBMs eServer iSeries (AS400) environment.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the 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 the development team and the management team to resolve any conflicts in terms of requirements.
• Experience in providing Production Batch support.
• Interacted with all levels of the 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, Hive, Informatica, MS-Visio, E-R Studio, Qlikview, SAS, SQL developer, SQL Loader, TOAD, VBA, Quality Center.

Desktop Software: Microsoft Word, Excel and PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Irvine - CA

Data Modeler

Responsibilities:

• Participated in requirement gathering session with business users and sponsors to understand and document the 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 knowledge in normalizing the 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 the physical model and database objects.
• Worked closely with ETL team in loading and mapping the 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 the key consistency, data type, size, etc.
• Implemented the standard naming conventions and created domains in the 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 the project team throughout all stages of design, managing time effectively, and work on project timelines simultaneously in demanding deadline driven environment.

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

Confidential, Dallas - TX

Data Analyst

Responsibilities:

• Performed data analysis for the existing data warehouse and changed the internal schema for performance.
• Participated in Designing and development of the application.
• Used user stories approach for describing the requirements using the user story template.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the 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 the workflows.
• Worked with Data modelers and ETL teams as part of Data analysis.
• Involved writing the stored procedure for 14 days Mailers.
• Worked extensively on the MS-SQL environment to run out the queries and explore the Databases.
• Identified relationships and trends in data, as well as any factors that could affect the results of research.
• Analyzed and interpreted statistical data to identify significant differences in relationships.
• Reported results of statistical analysis including information in the 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 the system.
• Involved in Manual Testing by checking of various validations.
• Created, maintained, and executed manual test scripts.
• Effectively used defect management process using ClearQuest.
• Maintained a close and strong working relationship with team mates and management staff to achieve expected results for the project team.

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

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 the data related issues such as: assessing data quality, data consolidation, evaluating existing data sources.
• Worked closely with Data Architect to review all the conceptual, logical and physical database design models with semantic layer with respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds the logical data models.
• Analyzed the 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 the 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 the MS-SQL environment to run out the queries and explore the Databases.
• Defined key facts and dimensions necessary to support the business requirements.
• Worked with OLAP tools such as ETL, Data warehousing and Modeling.
• Managed and supported the warehouse with the help 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 the 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, San Diego-CA

Data Analyst

Responsibilities:

• Interacted with the Users for collecting the requirements to design and format reports. Documented the creation and maintenance of the Business Objects Universe/Reports and Standard Operating Procedures.
• Wrote requirements for various reports to be generated and migrated.
• Worked on writing functional specification for reporting module that handled credit and consumer risk management services.
• Worked in AS400 environment.
• Planned and defined Use Cases. Created Use Case diagrams, Scenarios and Use Case Narratives.
• Created RTM (Requirements traceability matrix) for mapping Requirements to Design Artifacts to SIT Cases to UAT Cases.
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
• Analyzed Business Requirements, performed gap analysis and segregated them into high level and low level Use Cases, Activity Diagrams/State Diagrams and Class Diagram.
• Documented and maintained RTM to ensure that all requirements are traceable from top to bottom and to provide a basis for test plan.
• Performed Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.
• Maintained documentation related to difficulties, complexities and anomalies that may arise during the ETL process.

Environment: Windows XP, Qlikview, SQL*Plus, Oracle, TOAD, OLAP, UNIX, MS Office, SQL Navigator, Business Objects.

Confidential

Data Modeler

Responsibilities:

• Involved in the 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 the logical and physical data model for the proposed solution with semantic layer.
• Worked with DBA’s to create a best fit physical data model from the 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 the logicaldatamodels into dimensional model.
• Used Erwin Database Generation for generating DDL, stored procedure and trigger code for your 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. This involved the 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 the compatibility of the existing system infrastructure with the new business requirements.
• Conducted Functional Requirement Specification and User Requirement Specification Analysis/reviews and walkthroughs with the 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.