Skills

Employment History:

Confidential

Data Analyst

Responsibilities:

• Participated with IT Business Analyst with focus in requirement gathering necessary to analyze data, with SME's, and business users to understand and document the business requirements as well as the goals of the project.
• Worked on building the data model using ER Studio as per the requirements, discussion and approval of the model from the BA.
• Analyzed the source system DB2 and Oracle Databases to understand the source data relationships along with deeper understanding of business rules and data integration checks.
• Preparation of Source to Target Mapping documents STM for the ETL team with all the required information to load the data to Target tables.
• Had a Detailed knowledge of data warehousing concepts and experience in working with data architects in the design of database schemas.
• Creation of DDL and DML scripts are per the standards.
• Involved in reviewing and creating functional and technical requirements documentation.
• Experience in developing reports using business intelligence tools like crystal reports, business objects.
• Extensive experience in data extraction and conversion, analyzing, compiling, converting data, validating data and identifying data inconsistencies and errors, report design and implementation, creating metadata/data dictionaries on multiple Projects.
• Expertise in designing several reporting services like SQL queries used in dashboard applications creation, i.e. with charts, KPIS, tables, etc.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Experience in designing reports and creating database views.
• Directed all phases of the SDLC including the requirements analysis, architecture design, development, and testing, deployment and ongoing support for all web-based applications, services and managing small IT projects with minimal oversight.
• Developed UNIX scripts required for the DB2 Data Warehouse deployed on UNIX platform.
• Creation of data flow diagrams as per the requirements of the projects.

Confidential

Data Architect/Business Analyst

Responsibilities:

• Participated with IT Business Analyst with focus in requirement gathering necessary to analyze data, with SME's, business users and Sprint Teams to understand and document the business requirements as well as the goals of the project.
• Worked on enhancements to the Data Warehouse model using Erwin as per the Business reporting requirements.
• Analyzed the source system Progress Databases to understand the source data relationships along with deeper understanding of business rules and data integration checks.
• Implemented the Slowly changing dimension scheme Type II for most of the dimensions.
• Reviewed the logical model with Business users, ETL Team, DBA's and testing team to provide information about the data model and business requirements.
• Had a Detailed knowledge of data warehousing concepts and experience in working with data architects in the design of database schemas.
• Worked with Data Quality Team in defining and configuration of Rules, Monitoring and preparation of Data Quality Analysis and Dashboards.
• Extensive experience in data extraction and conversion, analyzing, compiling, converting data, validating data and identifying data inconsistencies and errors, report design and implementation, creating metadata/data dictionaries on multiple Projects.
• Worked on Agile development methodologies like Scrum, coordinating with different Sprint teams.
• Worked in the preparation of XML files mapping to Database tables as per the application development requirements.
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Experience in developing reports using business intelligence tools like crystal reports, business objects.
• Creation of LDM and PDM for database using Erwin, coordinating with business to document proper metadata, definitions, UDP's as per the corporate standards.
• Expertise in designing several reporting services like SQL queries used in dashboard applications creation, i.e. with charts, tables, etc
• Involved in reviewing and creating functional and technical requirements documentation.
• Extensively worked on SQL in analyzing the database and querying the database as per the business scenarios.
• Used Model Manager Option in Erwin to synchronize the data models in Model Mart approach.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Experience in designing reports and creating database views.
• Integrated Data Quality routines in the Informatica mappings to standardize and cleanse Account and Contact data.
• Experience in developing reports using business intelligence tools like crystal reports, business objects.
• Directed all phases of the SDLC including the requirements analysis, architecture design, development, and testing, deployment and ongoing support for all web-based applications, services and managing small IT projects with minimal oversight.
• Extensively worked on Informatica Data Explorer in creating data profiles with comparative profiling analysis and accuracy of mapping logic.
• Worked with DBA to create the physical model and tables. Scheduled multiple brains storming sessions with DBAs and production support team to discuss about views, partitioning and indexing schemes, case by case for the facts and dimensions.

Confidential

Data Modeler/Analyst/Business Analyst

Responsibilities:

• Participated with Business Analyst with focus in requirement gathering necessary to analyze data, and business users and sponsors to understand and document the business requirements as well as the goals of the project.
• Directed all phases of the SDLC including the requirements analysis, architecture design, development, and testing, deployment and ongoing support for all web-based applications, services and managing small IT projects with minimal oversight.
• Extensive experience in data extraction and conversion, analyzing, compiling, converting data, validating data and identifying data inconsistencies and errors, report design and implementation, creating metadata/data dictionaries on multiple Projects.
• Created and reviewed the conceptual model for the EDW Enterprise Data Warehouse with business users.
• Had a Detailed knowledge of data warehousing concepts and experience in working with data architects in the design of database schemas.
• Analyzed the source system JD Edwards to understand the source data and JDE table structure along with deeper understanding of business rules and data integration checks.
• Identified various facts and dimensions from the source system and business requirements to be used for the data warehouse.
• Created the dimensional logical model with approximately 10 facts, 30 dimensions with 500 attributes using ER Studio.
• Implemented the Slowly changing dimension scheme Type II for most of the dimensions.
• Reviewed the logical model with Business users, ETL Team, DBA's and testing team to provide information about the data model and business requirements.
• Involved in reviewing and creating functional and technical requirements documentation.
• Created the DDL scripts using ER Studio and source to target mappings S2T- for ETL to bring the data from JDE to the warehouse.
• Worked with DBA to create the physical model and tables. Scheduled multiple brains storming sessions with DBAs and production support team to discuss about views, partitioning and indexing schemes, case by case for the facts and dimensions.
• Worked on the model based volumetric analysis and data based volumetric analysis to provide accurate space requirements to the production support team.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Experience in designing reports and creating database views.
• Worked on Mercury Quality Center to track the defect logged against the logical and physical model.
• Expertise in designing several reporting services like SQL queries used in dashboard applications creation, i.e. with charts, tables, etc
• Worked as an onsite project coordinator once the design of the database was finalized in order to implement the data warehouse according to the implementation standards.
• Worked with client and off shore team to make sure that the reports and dashboards are delivered on time.
• Participated in UAT sessions to educate the business users about the reports, dashboards and the BI System. Worked with the test team to provide insights into the data scenarios and test cases.
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.

Environment : ER Studio 8.0.3, Microsoft SQL 2008 Server, Microsoft SQL Management Studio, Microsoft SQL 2008 Integration Services, Tera Data, Microsoft SQL 2008 Reporting Services, Microsoft SQL 2008 Analysis Services, Mercury Quality Center 9.

Confidential

Data Modeler/Data Analyst/Business Analyst

Responsibilities:

• Participated with Business Analyst with focus in requirement gathering necessary to analyze data, and business users and sponsors to understand and document the business requirements as well as the goals of the project.
• Directed all phases of the SDLC including the requirements analysis, architecture design, development, and testing, deployment and ongoing support for all web-based applications, services and managing small IT projects with minimal oversight.
• Had a Detailed knowledge of data warehousing concepts and experience in working with data architects in the design of database schemas.
• Extensive experience in data extraction and conversion, analyzing, compiling, converting data, validating data and identifying data inconsistencies and errors, report design and implementation, creating metadata/data dictionaries on multiple Projects.
• Participated in JAD session with business users and sponsors to understand and document the business requirements in alignment to the financial goals of the company.
• Created the conceptual model for the data warehouse with emphasis on mutual funds and annuity using EMBARCADERO ER Studio data modeling tool.
• Reviewed the conceptual EDW Enterprise Data Warehouse data model with business users and Information architects to make sure all the requirements are fully covered.
• Analyzed large number of COBOL copybooks from multiple mainframe sources 16 to understand existing constraints, relationships and business rules from the legacy data.
• Worked on rationalizing the requirements across multiple product lines.
• Involved in reviewing and creating functional and technical requirements documentation.
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
• Experience in developing reports using business intelligence tools like crystal reports, business objects.
• Created the logical model for the EDW with approximately 75 entities and 1000 attributes using ER Studio. The logical model was fully attributed till 3rd normalization and contains both current and history tables. Data model is divided in number of sub models for the ease of understanding and comprehension.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Experience in designing reports and creating database views.
• Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
• Worked with ETL to create source to target mappings S2T .
• Expertise in designing several reporting services like SQL queries used in dashboard applications creation, i.e. with charts, tables, etc
• Worked with DBA to create the physical model and tables. Worked on Informatica Data Quality tool for data cleansing, conformance and freshness of data.
• Had brain storming sessions with application developers and DBAs to discuss about various de-normalization, partitioning and indexing schemes for physical model.
• Worked on Requirements Traceability Matrix to trace the business requirements back to Logical model.

Environment: ER Studio 7.1.1, Quest Central for DB2 v 4.8, COBOL copybooks, Mainframe DB2, MercuryQualityCenter9,InformaticaPowerCenter8.1.

Confidential

Data Modeler/Data Analyst/Business Analyst

Responsibilities:

• Participated with Business Analyst with focus in requirement gathering necessary to analyze data, and business users and sponsors to understand and document the business requirements as well as the goals of the project.
• Directed all phases of the SDLC including the requirements analysis, architecture design, development, and testing, deployment and ongoing support for all web-based applications, services and managing small IT projects with minimal oversight.
• Extensive experience in data extraction and conversion, analyzing, compiling, converting data, validating data and identifying data inconsistencies and errors, report design and implementation, creating metadata/data dictionaries on multiple Projects.
• Had a Detailed knowledge of data warehousing concepts and experience in working with data architects in the design of database schemas.
• Had brain storming sessions with application developers and DBAs to discuss about various de-normalization, partitioning and indexing schemes for physical model.
• Analyzed existing logical data model LDM and made appropriate changes to make it compatible with business requirements.
• Involved in reviewing and creating functional and technical requirements documentation.
• Expanded Physical Data Model PDM for the OLTP application using Erwin.
• Involved in data model reviews with internal data architect, business analysts, and business users with explanation of the data model to make sure it is in-line with business requirements.
• Created rationalized domains to bring consistency in the tables.
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application.
• Worked at conceptual/logical/physical data model level using Erwin according to requirements.
• Involved in exhaustive documentation for technical phase of the project and training materials for all data management functions.
• Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Erwin after analysing the database systems currently in use.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Developed the required data warehouse model using Star schema for the generalized model.
• Experience in developing reports using business intelligence tools like crystal reports, business objects.
• Used forward engineering approach for designing and creating databases for OLAP model.
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
• Collaborated with ETL, BI and DBA teams to analyse and provide solutions to data issues and other challenges while implementing the OLAP model.
• Expertise in designing several reporting services like SQL queries used in dashboard applications creation, i.e. with charts, tables, etc
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Experience in designing reports and creating database views.
• Collaborated with the Reporting Team to design Monthly Summary Level Cubes to support the aggregated level of detailed reports. Worked on the Snow-flaking the Dimensions to remove redundancy.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase

Environment: Erwin 4.0, Erwin 3.5.2, Toad, PL/SQL, Oracle 9i, SQL Server 2000, SQL Loader, UNIX, Windows 2005

Confidential

Data warehouse design/Business Analyst

Responsibilities:

• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
• Participated with Business Analyst with focus in requirement gathering necessary to analyze data, and business users and sponsors to understand and document the business requirements as well as the goals of the project.
• Directed all phases of the SDLC including the requirements analysis, architecture design, development, and testing, deployment and ongoing support for all web-based applications, services and managing small IT projects with minimal oversight.
• Received training on SQL Server 2000. Created number of tables, functions, triggers, stored procedures, views etc. in SQL server.
• Involved in reviewing and creating functional and technical requirements documentation.
• Worked on identifying facts, dimensions and various other concepts of dimensional modeling which are used for data warehousing projects.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Experience in designing reports and creating database views.
• Expertise in designing several reporting services like SQL queries used in dashboard applications creation, i.e. with charts, tables, etc
• Worked on Normalization and De-normalization techniques.
• Trained on building Conceptual, Logical and Physical data model.
• Defined relationships and cardinalities among entities.
• Developed queries using PL/SQL and many stored procedures to do the validations.
• Created and maintained Database Objects Tables, Views, Indexes, Partitions, Database triggers etc .