SUMMARY

• Having Seven years of extensive IT experience in Data Modeling, development and testing using ETL for online transaction processing(OLTP) and online analytical processing(OLAP) /BI applications and data warehouse designing
• Expertise in ER modeling, dimensional modeling and CASE tools like ERWIN, ER Studio, power designer and implementing RDBMS features.
• Efficient in implementing Normalization to 3NF/ De - normalization techniques for optimum performance in relational and dimensional database environment
• Experience in all phases of the development life cycle coherent with data cleansing, data conversion, data profiling, performance tuning and system testing.
• Well versed in data analysis, developing data warehouse designs, working with staging, star schema and snowflake schemas, and dimensional reporting.
• Comprehensive knowledge on High and Low level ETL designs.
• Experience in data mart designing, identifying facts and dimensions and creation of cubes
• Data Acquisition strategies to extract data from different source systems, created data mappings using different transformations and executed workflows for data loads to target systems
• Expertise in dealing with different data sources ranging from FLAT FILES, EXCEL, SYBASE, ORACLE AND SQL SERVER.
• Proficient in design reviewing and validation of final data models. Involved in JAD sessions with developers, user interface personnel and end users.
• Practical understanding and experience in querying the database using SQL and quest tools like TOAD.
• Worked extensively in creating and documenting both business and technical metadata documents from metadata repositories and good knowledge on UNIX Shell scripting (Bourne Shell, CSH, KSH and Bash)
• Very good understanding of object oriented programming and professional GUI designing. Strong performance tuning abilities. During tuning process, developed various indexes and partitions as needed.
• Familiarity and experience in both DDL and DML commands including joins, functions, indexes, views and constraints.
• Quick starter with ability to master and apply new concepts. Ability to meet deadlines and handle pressure in coordinating multiple tasks in a project environment.
• Strong communication and presentation skills, organizational and inter personnel competencies along with detail oriented and problem solving skills in technology arena.

TECHNICAL SKILLS

Programming Languages: SQL, PL\SQL (Triggers, Stored Procedures and Functions, Packages), C, SAS.

DBMS: Oracle 8i/9i/10g, Teradata, DB2, SQL Server 2005, MS Access

Analysis/ Modeling Tools: Erwin, Sybase Power Designer, ER /Studio, MS Visio (2000, 2007, 2010)

Scripting: UNIX Scripting

Operating System: Windows NT, 2000 & XP, Vista, AIX, UNIXLinux.

Web Development Tools: HTML,XML,PHP,Java Script

Reporting Tools: Oracle Reports, Business Objects

ETL Tools: Data stage 8.1

PROFESSIONAL EXPERIENCE

Confidential, Morton Grove, IL

Sr. Data Modeler/Data Analyst

Responsibilities:

• Worked with Business Partners and the Business Intelligence development teams to design and develop a retail-specific BI Platform consistent with industry standards, best practices, and methodologies.
• Part of team conducting logical data analysis and data modeling JAD sessions.
• Involved in the complete life cycle of the product from requirements gathering to end of system testing.
• Designed the relational and dimensional models for Search Engine Optimization, Credit and Customer Services projects and Integrated Data Managements team for multiple requests.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Created Indexes, Partitioning and Materialized views to optimize the queries.
• Contributed to the development of standardized process and procedure norms related to the successful operation of the BI data architecture team
• Developed the data dictionary for various projects for the standard data definitions related data analytics and ecommerce BI data consumption.
• Tuned the reporting queries to optimize the performance of the reports.
• Developed the technical specification documents for the data flow from source to target.
• Worked closely with Tableau reporting users to provide/design the ad hoc reports.
• Performed pre and post production data validation for the entire call center data and agent performance metrics.
• Provided the solution for the data quality framework.
• Supported end users for UAT.

Environment: SQL Server, DB2, Windows XP, ER studio, ERWIN, Aqua data studio.

Confidential, Charlotte, NC

Data Modeler/ Data Analyst

Responsibilities:

• Interacted with End user community to understand the business requirements and in identifying data sources.
• Closely worked with Business Users and acted as the source for IT with the complete business knowledge of the Projects.
• Understood the Business requirement documents and involved in the development of Logical data model from the business requirement using the power designer. Also worked with the team in the generation of Physical data model.
• Involved in gathering functional requirements interacting with Business Analyst.
• Also acted as the Business Analyst of the team creating the mock-up’s based on the business requirements for different projects.
• Provided analysis documents for initial programs to migrate data sources from Teradata
• Involved in the modeling of the missing dimensions on the existing data model.
• Modeled new tables and added them to the existing data model using Power Designer as part of data modeling.
• Prepared documentation for all the analysis done and extensively used MS Office to prepare presentations.
• Performed extensive Data Analysis and Data Validation on different systems like Teradata, and DB2.
• Worked closely with offshore team to help them understand the system to analyze the data as part of my role.
• Involved in the process of loading data from Teradata.
• Extensively worked with Teradata SQL Assistant 12.0 to analyze the table structures on both the systems and figured out the missing dimensions.
• Helped in preparing the mapping document for source to target.
• Designed and developed ETL processes using DataStage designer to load data from Teradata, MS SQL, Flat Files (Fixed Width) to staging database and from staging to the target Data Warehouse database.
• Efficient in all the faces of the SDLC, coherent with data cleansing, data conversion, data profiling.
• 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 in corporate the changes as and when necessary.
• Worked as QA in the team for testing the Microstrategy reports data Vs databases (Source and Target).
• As a whole got to work on different areas in different roles like a Data Analyst/ Business Analyst/ Data Modeler and ETL

Environment: Teradata SQL Assistant 12.0/13.11, Data stage 8.1, Sybase Power Designer 15, UNIX, MS OFFICE, DB2.

Confidential, Winston-Selam, NC

Data modeler/ Data Analyst

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.
• Developed the UML class diagrams for the proposed system using ER/Studio Software Architect.
• Performed data modeling using data modeling tool Embarcadero Data Architect.
• Created the data models for OLTP and Analytical systems.
• Performed in depth data analysis on Oracle systems.
• Extensively worked with the Teradata SQL Assistant and Toad.
• Involved in data profiling to integrate the data from different sources.
• Extensively performed the gap analysis and impact analysis.
• Interacted with SME, developer to gather database requirements, actively participated in functional requirement gathering, system requirement gathering, application design
• Created the data mapping document from source to target and the data quality assessments for the source data.
• Worked with DBAs on support needs and provide guidance on architectural issues.
• Assisted development teams with loading data, extracting data (ETL) etc.,
• Assisted QA for developing test plans and test cases for Unit Testing, System Testing and Enterprise testing.

Environment: Oracle 11g, Windows XP.TOAD 9.6, ER/Studio Data Architect 8.5.3, ER/Studio Software Architect 1.0, ERStudio.

Confidential

Data modeler

Responsibilities:

• Involved in the entire life cycle of the project starting from requirements gathering to end of system integration.
• Interacted with the client for business requirements gathering. Worked with MS Access.
• Identified the Entities, attributes and designed a relational database system.
• Built the application according to the requirements (wrote some PL/SQL procedures, functions, database triggers, created some forms and reports) and Created views and index views.
• Developed PL/SQL stored procedures and packages for validation purpose.
• Developed the batch program in PL/SQL for the OLTP processing and used Unix Shell scripts to run in corn tab.
• Interacted with DBA to discuss database design and modeling, index creations and SQL tuning issues.
• Used SQL*Loader to load the database from flat files.
• Converted Data stored in flat files into Oracle tables.

ENVIRONMENT: SQL Server 2000/2005, SQL, MS Access, PL/SQL, SQL*Loader, Import/Export.

Confidential

Report Developer

Responsibilities:

• Developed Stored Procedures and complex Packages using PL/SQL.
• Developed Triggers, Functions, Cursors, Materialized Views and Procedures.
• Created and used DB- links to connect to other local and QA databases.
• Developed new functionality in the existing application as part of change requests.
• Performance tuned DB queries.
• Defect Analysis and bug fixes.
• Complex enhancement requests.
• Provided hands on support to the users.
• Developed and customized several forms including Tabular, Mailing Label, Matrix, and Matrix with groups.
• Developed various UNIX Shell Scripts to generate ad hoc reports.
• Performed manual testing on the application and involved in defects fixing team.
• Involved in developing Extraction-Transformation-Loading (ETL) process, using SQL*Loader and PL/SQL package UTL FILE.
• Used ERWIN to develop logical and physical database models.

Environment: Oracle 9i, Oracle Forms 6i, Oracle Reports 6i, Perl Scripting, PL/SQL TOAD, UNIX.