SUMMARY

• Over 6 years of experience in IT as Data Analyst/Modeler in Banking, Financial, Insurance Telecom and Healthcare industry.
• Experience in OLTP, OLAP Data warehouse and Business Intelligence modeling.
• Expertise in creating Conceptual, Logical and Physical data models in OLTP and dimensional models, star schemas data marts and cubes for data warehouse.
• Experience in working with Logical and Physical data mapping from source to target.
• Experience in gathering and validating reporting requirements and designed optimized reports.
• Experience in working on the testing and condition of data and validation of the data.
• Experience in gathering business requirements and writing business and functional requirement documents
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution
• Worked on the data architecture framework implementation for Informatica ETL environment.
• Defined distribution keys for Erwin data model Implementation
• Experience in Gap analysis and Gap Resolution process succeeding the Logical data mapping.
• Expert in writing SQL queries and analysis of the data patterns.
• Experience in working on the testing and condition of data and validation of the data.
• Experience in Data Augmentation, Data Scrubbing, Data Quality, Data Profiling and Data Cleansing.
• Experience in the implementation of the Data Management Standards for the projects.
• Facilitated the model walkthrough sessions with Business users and Developers.
• Experience with data modeling tools like Power designer and Erwin.
• Experience in working with the SDLC methodologies.
• Possess excellent communication skills and team player.

TECHNICAL SKILLS

MODELING TOOLS: ERWIN and POWER DESIGNER.ER STUDIO

ETL TOOLS: INFORMATICA, DATASTAGE, SAS 9.1.3, Ab Initio GDE 1.15, Ab Initio ACE/BRE

REPORTING TOOLS: BUSINESS OBJECTS, MICROSRTAEGY

RDBMS: ORACLE 10g, SYBASE ASE 12.5, MS SQL SERVER 2005/2008, TERADATA, NETEZZA

LANGUAGES: SQL, PL/SQL, XML

PROJECT MANAGEMENT: MS OFFICE, VISIO

DEV TOOLS: AQT

ERP: SAP R/3 and SAP BW 3.0

OPERATING SYSTEMS: WINDOWS 2000, HPUX, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Data Analyst

Responsibilities:

• Designed Logical and Physical data model for RXTRACK data warehouse.
• Actively participated in the design sessions with the Business users.
• Performed data profiling and detailed data analyses to understand the information available in existing systems and the business users' data and information requirements.
• Worked on the design and implementation of physical data model.
• Worked on the design of the DataMarts based on Teradata.
• Worked on the creation of the metadata for the data warehouse data model.
• Developed Functional specifications for Data and source system analyses, source to target mappings, transformation rules, complex derivations, data and system flows, data validation.
• Assisted in the development of data quality dimensions and measurement thresholds that are aligned with strategic business objectives and key performance indicators.
• Facilitated the requirements gathering sessions to define the reporting requirements.
• Understood the data anomalies, data issues and provided resolutions to resolve them.
• Worked on the analysis of the source and target data model.
• Involved in GAP analysis of source systems and target systems.
• Profiled data across the Data ware house to identify the data quality issues.
• Identified and analyzed the source system to load master data in to target in Teradata.
• Performed data investigation to find out the data issues in the underlying feeds and databases
• Worked in the development of end to end data flows for the application
• Worked on source to target mapping between source and target data model for ETL team.

Environment: Teradata, ERWIN, Oracle 11g, PL SQL, Cognos, UNIX

Confidential, Charlotte, NC

Data Analyst/Data Modeler

Responsibilities:

• Designing Logical and Physical data models for Data Acquisition and Product Risk Rating system.
• Working with the Business and Development team members and the Data Architect of the various components.
• Developed data validation and file validation rules for application.
• Developed Data quality completeness and policy rules for the application and ETL team to cleanse and transform the data.
• Created logical data models based on requirement and captured metadata
• Involved in the documentation of the use cases and interacted with the business intelligence team, management team and user community.
• Involved in the creation of the report prototypes with the reporting team.
• Worked with QA team to write test cases and fixed the data errors and data quality issues, documented the user manuals for the reporting team.
• Worked on Gap analysis and Gap Resolution process succeeding the Logical data mapping.
• Worked on source to target mapping between source and target data model for ETL team
• Work with offshore team to handle data warehouse, ETL and Business Intelligent development.
• Created and updated metadata in the data model repository.
• Involved in creation and maintenance of ER Diagrams.
• Involved in the ETL/data modeling architecture and Oracle data structures compatibility.
• Defined distribution keys for Informatica data model Implementation.
• Facilitated metadata walkthrough sessions with application and data governance team.
• Worked in the development of end to end data flows for the application
• Developed QA Plans for Retails distribution of investment products
• Developed rules for data cleansing and for transformations
• Worked on Design, report and layout with Reporting team
• Worked in the validation of test data and data conditioning to support the testing.
• Worked on the documentation of entities and attributes and metadata.
• Worked with quality centre tool for defect tracking and resolution
• Involved in creating the data naming conventions and standards and implemented them.
• Worked with QTP tool to identify defects and generated reports.

Environment: Oracle 10g, PL SQL, Erwin, Visio, Cognos, HP quality center10.0, UNIX, QTP 10.00,MicroStrategy 9.0, Informatica Power Center.

Confidential, Overland Park, KS

Data Analyst

Responsibilities:

• Designing Logical and Physical data models for collateral management application.
• Working with the Business and Development team members and the Data Architect of the various components.
• Worked with project teams to collect database requirements and scope them to create logical data model
• Developed data quality rules for the application and ETL team to cleanse and transform the data.
• Facilitated JAD sessions for data requirements.
• Involved in Data migration of legacy customer accounts, products data into the new collateral management application.
• Worked in the Data migration approach of loading into target on incremental approach.
• Designed staging tables for Data migration to load and transform legacy data.
• Interacting with the customers to understand the requirements.
• Involved in Creation of Data dictionary for collateral management application
• Worked with users and DBA to grant user access
• Developed integrated MDM solutions for operational efficiency and data quality standards for customer, product and locations.
• Created scripts to modify database structures
• Worked with test team for writing scripts and validate data and fix database errors in database
• Creating the data requirements for the shared program data stores and generate the Necessary DDLs for creating the database objects (tables, views, stored procedures, triggers)
• Worked on source to target mapping between legacy and target data model
• Work with offshore team to handle data warehouse, ETL and Business Intelligent development.
• Create scripts and execute them to perform data migration between environments.
• Work with the Change Management team for migrating database objects to production environment
• Performed data investigation to find out the data issues in the underlying feeds and databases
• Created and updated metadata in the data model repository.
• Facilitated metadata walkthrough sessions with application and data governance team.
• Worked in the development of end to end data flows for the application
• Worked on Design, report and layout with Reporting team
• Developed Quality Assurance plans as data cleansing and data quality rules.
• Worked in the validation of test data and data conditioning to support the testing.
• Worked on the documentation of entities and attributes and metadata.
• Worked with the data governance team to establish new processes and procedures like data standardization and data quality
• Worked with quality centre tool for defect tracking and resolution
• Worked on creating the test cases and UAT process
• Worked in evaluating and implementing tool sets for data profiling
• Worked with data conditioning and test cases for supporting testing phase

Environment: Oracle 11g,PL SQL Erwin, informatica 8.6.1,MSSQL Server 2005, IDE, IDQ, DB2, Business Objects, TOAD.

Confidential, Bridgeport, CT

Data Analyst/Data Modeler

Responsibilities:

• Involved in the logical and Physical data mapping between Confidential ’s United Bank Legacy system and New Core Banking system.
• Prepared the detailed Data mapping specification documents between the source and target data structures.
• Involved in the designing of the ETL (DataStage / Informatica) mappings from source to target and extensive data analysis.
• Worked on data quality standards, data profiling and data transformations to deliver quality data
• Worked as a liaison between the source systems and the ETL team to resolve data problems.
• Documented end-to-end data flows and created data flow diagrams.
• Worked with RUP methodology and created artifacts based on methodology.
• Designed new transactions data mart for Peoples Bank Online Trading System. Designed daily and monthly snapshot of Customer transactions.
• Involved in designing models based on 3NF
• Designed the daily nightly batch extracts for Data staging and Data warehouse.
• Experience in writing data related test cases to support the application testing.
• Worked to improve the data quality during various stages of the projects using data profiling and data transformation.
• Worked with the data governance team to establish new processes and procedures like data standardization and data quality.
• Worked on the documentation of entities and attributes and metadata.
• Worked in the resolution of data issues during testing phases.
• Designed summary tables for credit card transaction to support reporting requirements.
• Experience in writing ETL (Data Stage/ Informatica) specification documents including data cleansing and transformation.
• Involved in the design of aggregate and summarized reports using SQL.
• Create a data structure to support reporting functionality
• Estimated the space and storage requirements for the database for the project enhancements.
• Involved in creating the data naming conventions and standards and implemented them.
• Prepared the Impact Analysis document to compare the current and future state data models.

Environment: Oracle 10g, Data Stage, ER studio, ERWIN, TOAD, Teradata, informatica, SAS 9.1.3, Data Integrator, Sybase 12.5, MYSQL, Cognos

Confidential, DFW, TX

Data Analyst

Responsibilities:

• Creating & delivering data structures via logical & physical designs for IT Project teams based on a through understanding of application requirements, business requirements and database constraints.
• Creation of the logical & physical database design for small & complex application across multiple projects and applications.
• Worked on the Consolidation data of the Call center specific for all the call center applications
• Developed the Customer Global data stores to share among the different applications across the company that focus on the customer specific data.
• Responsible for identifying, and negotiating of the corporate wide technologies to purchase, deploy, and Implementation.
• Used SQL for Clarify data manipulation in the custom application.
• Review test cases for accuracy. Validate User Acceptance results confirm to requirements.
• Manage project plans and the deliverables including all artifacts for SDLC.
• Working directly with System Analysts, Application Analysts and Database administrators to ensure data efficiency and integrity.
• Capture and document detailed data requirements for the strategic Initiatives and Projects.
• Facilitating the model walk thru sessions for the business and application users.

Environment: Oracle 8.1.7, Erwin 4.1, Power Designer 9.5, Business Objects, Siebel. UNIX