Professional Summary:

• Around 6 years of professional experience working as a Data Modeler/Analyst, business system analyst with diverse industry verticals like insurance, banking and service domains.
• Extensive experience in developing logical and physical data models for both transaction as well as analytical systems.
• Proficient in Enterprise Data Warehouse. Worked extensively in several projects in both Forward Engineering as well as Reverse Engineering using data modeling tools.
• Experience with Business Process Modeling, Process Flow Modeling, Data flow modeling.
• Experience in analyzing the business requirements and creating Business Requirement Document BRD . Expertise in interacting with stakeholders, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Proficient in requirement gathering, Organizing JAD sessions, one to one interviews, and focus groups.
• Well versed in Kimball/Inmon data warehouse Philosophies. Experienced in Normalization/De-normalization techniques for optimum performance in OLTP and OLAP environments.
• Expertise in Data Modeling using tools likes ERwin, ER Studio and Power Designer.
• Experience with Teradata using database commands and Teradata utilities such as BTEQ, SQL Assistant, Fast Load, Multi Load, Fast Export etc. Worked extensively on XML Schema designs.
• Hands on experience with modeling using ERwin in developing Entity-Relationship, modeling Transactional Databases and Data Warehousing, Dimensional Data Modeling for Data Marts and Fact Dimensional Tables.
• Hands-on knowledge of enterprise repository tools, data modeling tools, data mapping and data profiling tools.
• Extensive Experience working on SQL Queries along with good experience in development of T-SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers for business logic implementation.
• Good Understanding and Knowledge with Agile and Waterfall Environments.
• Involved in performance optimization of DWH solutions, both on ETL as well as Database side.
• Experience in preparing project cutover plan, test plan with test cases for unit test, regression test and User Acceptance Testing UAT .
• Excellent in verbal and written communication, organizational skills combined with the ability to work in a fast paced environment as an individual and/or as a team member.

Technical Skills:

Professional Experience:

Confidential

Data Analyst

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Worked is close coordination with the PM and the Business owners to developed project vision and define the scope of the project.
• Developed Project Plan with Project manager's assistance for the first two phases of the Project.
• Worked with DBAs to create a best fit physical data model from the logical data model using forward engineering in ERwin.
• Extensively used ERwin to model and transform date requirements in to data models and maintaining the database schema.
• Widely used Normalization methods and have done different normalizations 3NF .
• Created databases, tables, views schemas. Performed users access authorization, defined locations, populated tables with data and performed unload/copy/replicate data from one database into another after detail analysis and design.
• Involved in the Database design and application development to support the creation and management of online business units for business users and customers usage.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms and documented the purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes as and when necessary.
• Generated the DDL scripts by forward engineering the physical model and interacted with DBA to implement the physical database.
• Involved in the process of loading data into SQL Server and creating Process Flow Diagrams using MS Visio.
• Analyzed the performance of the job during the project. Utilized standard techniques for enhancing the performance.
• Authored User reference documents on all the deliverables created for future reference by Business Users and conducted training sessions.
• Documented and delivered Functional Specification Document to the project team.
• Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents and analyzing the database using SQL queries.

Environment: ERwinr7.3, MS Visio, SQL Server 2012, Oracle 10g, SQL, PL/SQL, HTML, MS OFFICE

Confidential

Data Analyst

Responsibilities:

• Working with the Business Analyst and DBA, conducting team meetings and JAD Sessions for technical requirements gathering, business analysis, testing and project coordination.
• Analyze and evaluate existing system for assessing how it supported functions from the Use Case diagrams and UML diagrams.
• Developed Logical data model using ERwin 7.2 and created physical data models using forward engineering.
• Performed reverse engineering for a wide variety of relational DBMS, including Microsoft Access, Oracle and SQL Server, to connect to existing database and create graphical representation E-R diagram using Erwin 7.2.
• Used BTEQ for SQL queries, and TPump for loading data from source into SQL Server tables
• Used Teradata utilities such as Fast Export, MLOAD for handling various tasks.
• Participate in updating the dimensional model, and identify the Facts and Dimensions.
• Employed process and data analysis to model a Customer Information Business System.
• Produced functional decomposition diagrams and defined logical data model.
• Coordinated with ETL team for analysis and reporting needs.
• Developed data migration strategies and impact analysis for database.
• Design, plan and program data conversion procedures from old to new databases.
• Responsible for data lineage, maintaining data dictionary, naming standards and data quality.
• Model a database to store customer demographic and other data.
• Design complex reports like aging analysis, invoices generation, profit/loss, balance sheet etc.
• Involved in design and development of standard and ad-hoc reporting using SQL.
• Design and developments of the changes and enhancements. The existing submission and refining programs were enhanced to incorporate the new calculations.
• Involved in overall data mart testing and different team review meetings.

Environment: SQL Server 2008/2005, Oracle 11g, SQL, PL/SQL, ERwin 7.2, XML, Microsoft Access, Microsoft Excel.

Confidential

Data Analyst

Responsibilities:

• Involved in gathering business requirements by conducting a series of meetings and brain storming sessions with the business users.
• Gathered and translated business requirements into detailed, production-level technical specifications, new Features, and enhancements to existing technical business functionality.
• Involved in identifying the process flow, the work flow and data flows of the core systems.
• Worked extensively on user requirements gathering and gap analysis.
• Created Conceptual, Logical Modeling and Physical Database design for OLTP and OLAP systems.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Monitored the Data quality of the daily processes and ensure integrity of data was maintained to ensure effective functioning of the department.
• Conducted logical data model walkthroughs and validation.
• Worked with DBA's to create a best fit physical data model from the logical data model.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the reverse engineering ER/Studio tool.
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models.
• Created Design Fact Dimensions Tables, Conceptual, Physical and Logical Data Models using ER/Studio.
• Involved in designing the integrated Data Warehouse for the company to store the data from the OLTP systems.
• Involved in implementing and testing of the developed application data standards.
• Involved in Data analysis for data conversion - included data mapping from source to target database schemas, specification and writing data extract scripts/programming of data conversion, in test and production environments.
• Data Warehouse - Designed and programmed ETL and aggregation of data in target database, working with staging, de-normalized and start schemas and dimensional reporting.

Environment: SQL Server 2008, Oracle 10g, ER/Studio, PL/SQL, UNIX, Windows NT.

Confidential

Data Analyst

Responsibilities:

• Involved in interactions with Subject Matter Expert, Project Manager, Developers, and the end-users in more than one JAD sessions to gathering the new requirements.
• Involved in all phases of SDLC from requirement, design, development, testing and rollout to the field user and support for production environment.
• Translated business requirements into data design requirements used for driving innovative data designs that meet business objectives.
• Developed Business and Subject Area Logical Data Models, Physical Data Models, Physical Staging area Data Models and Data Flow Diagrams.
• Extensively used ERwin to design Logical/Physical Data Models, forward/reverse engineering, publishing data model, applying DDLs to database, Data Modeling and restructuring the existing data Model.
• Applied Discover Financial Data Naming Standards, created new naming standards, checked models in and out of ERwin Model Repository, and documented data model translation decisions.
• Generated database objects such as Table, Views, Synonyms, Database Link by executing the script generated from ERwin with appropriate privileges
• Responsible in designing and introducing new FACT and Dimension Tables to the existing Model.
• Used various levels of triggers and procedures to validate the data at each level.
• Extensively involved in writing PL/SQL stored procedures, functions and packages.
• Created database tables with complex constraints applicable to the business rules.
• Involved in Optimizing SQL queries involving large tables.
• Created Indexes and Materialized Views to improve the overall system performance.
• Tested the application to ensure proper functionality, data accuracy, and modifications had no adverse impact on integrated system environment.
• Involved in the maintenance and support of existing applications with the users.
• Involved in training and production support at various client locations

Environment: Erwin, Oracle 10g, SQL Server2008, Business Object Data Integrator 6.X, SQL, PL/SQL, Microsoft Project/Office.

Confidential

Data Analyst

Responsibilities:

• Involved in designing physical and logical data model using ERwin Data modeling tool.
• Designed the relational data model for operational data store and staging areas, Designed Dimension Fact tables for data marts.
• Extensively used ERwin data modeler to design Logical/Physical Data Models, relational database design.
• Created Stored Procedures, Database Triggers, Functions and Packages to manipulate the database and to apply the business logic according to the user's specifications.
• Created Triggers, Views, Synonyms and Roles to maintain integrity plan and database security.
• Creation of database links to connect to the other server and Access the required info.
• Integrity constraints, database triggers and indexes were planned and created to maintain data integrity and to facilitate better performance.
• Used Advanced Querying for exchanging messages and communicating between different modules.
• System analysis and design for enhancements Testing Forms, Reports and User Interaction.

Environment: Oracle 9i, SQL Plus, PL/SQL, ERwin, TOAD, Stored Procedures.