Experience Overview

• Over seven years of experience involving data warehouse, database implementation and database design in client/server environment. A Sr. Data Analyst with extensive experience in data transformations, conversion and interface, data loading, database modeling and performance tuning.
• Designed and developed data warehouse ETL applications and data warehouse databases.
• Extensive data extraction from numerous Teradata data tables
• Experience with star schema modeling and knowledge of snowflake dimensional modeling.
• Involved in entire life cycle (SDLC) of the project.
• Conducted Joint Application Development (JAD) sessions/meetings to coordinate with everyone involved in the project.
• Extensive experience in writing stored procedures/functions, database triggers/packages.
• Prepared Interface Agreement Documents (IA Doc.). Also, extensively used the Data Dictionary.
• Experience with Star schema modeling and knowledge of Snowflake dimensional modeling.
• Experience with SQL, PL/SQL objects. Involved in creating Packages, writing Procedures, and Functions. Tuning using various types of Hints, Partitioning, and Indexes.
• Used Explain Plan to monitor execution paths and to decide which hints to use.
• 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.
• Experience with various technologies such as Oracle database, PL/SQL SQL*Loader, MS SQL Server 2000 and TOAD.
• 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.
• Involved in database monitoring activities, capacity planning, and SQL tuning.
• Used Explain Plan to monitor execution path and to decide on which hints to use.
• Extensive experience in loading high volume data, worked extensively with data migration, data cleansing and ETL processes.
• Extensive experience with UAT and various other test efforts in a data warehouse environment like data validation, data analysis, functional testing, integration testing and system testing.
• Technologies used Oracle database 8/9/10g, Business Objects, TOAD, SQL Develolper, ERWIN and MS Visio 2000.
• Excellent knowledge of UNIX shell script on Sun Solaris 2.8/2.7 and HP UNIX 12.x/11.x.
• Excellent communications skills, analytical skills, logical reasoning skills, interpersonal skills, great work ethics and a great team player.

Technical Skills

Operating Systems:

UNIX, MacOS X. Linux, MS Windows 2000/XP & NT, MS DOS.

Languages:

SQL, PL/SQL, Java, C++.NET, VB.NET, XHTML, XML, CSS, Coldfusion MX 7, JavaScript, VBScript, Perl, AWK, C/Bourne Shell.

Databases:

Oracle 8/9i/10g, MySQL, MS SQL Server 2000, MS-Access.

Tools:

Erwin, ER Studio, Power Designer, VBA(Excel), IBM Rational Rose and UML Design, Microsoft Visio, Visible Analyst, Microsoft Project.

Reporting Tools:

Testing Tools:

Mercury Quality Center, Test Director, Quick Test Professional, LoadRunner.

Web/App Servers:

Weblogic, Java Web Server, Tomcat Apache, IIS 5.0.

Protocols :

TCP/IP, HTTP, Telnet, FTP, SMTP, POP.

Others :

TOAD, SQL DEVELOPER, PVCS, FTP Edit, OFFICE 2003, Quick Books Pro, Maple 9.0, Macromedia Studio 8, Adobe CS2 Studio, 3dMax Studio 6.0, UltraEdit - 32 Text Editor.

PROFESIONAL EXPERIENCE:

Environment: Oracle, SQL, PL/SQL, Export/Import, SQL*Loader, SQL Developer, Windows XP, Linux - SLES 10, ER Studio, Advanced Query Tool, Cygwin X, F Secure SSH Client, VBA(Excel), Rational Software (Clear Quest), Clear Cube.

Worked as a Data Analyst/Developer in a Contact Management Project. Aim was to migrate Janna Contact databases to the Wachovia implementation of the NexJ contact management system. 82 Janna databases exist in this field; for Phase 1, the scope of conversion was to migrate 35 branches which translate into 27 distinct Janna databases. Janna Conversion affected only 2 production systems: NexJ and T1A. Janna database was loaded into NexJ staging environment to process clean data in order to meet format and validation requirements of NexJ and T1A. Once the data had been parsed, it moved from staging into NexJ from where it was synchronized into T1A. Janna Attachment files were processed and saved in a branch file share, with only a link to the file loaded into NexJ. The extraction of Janna attachments were performed by NexJ Studio installed on a separate (JDE) environment located in the Wachovia TZ. NexJ only contain a link to those attachments.

Responsibilities:

• Worked as a data analyst, interviewing clients to understand their business and functional requirements, gathering their future needs and transforming them to functional specifications.
• Created UI and Schema mapping documents using Excel spreadsheets.
• Validated and Confirmed NexJ functionality.
• Assist user with UA testing
• Used Power Designer 9.0 for data analysis, data modeling and database design process
• Coordinated Jana Data Conversion Communication Plan
• Obtained business signoff for Jana Data Conversion
• Coordinated and validated Production Deployment
• Used Rational Rose to create various UML diagrams like sequence and class diagrams
• Provided Production Support
• Used IBM Rational Requisite Pro to write various use cases
• Determining the derivation logic for each attribute that is being mapped.
• Project duties included multiple task project assignments, scheduling, and tracking; facilitating meetings with all levels of the business community for requirements gathering, project development, design considerations, impact and risk analysis, and quality control of client acceptance testing.
• Created Technical requirement and design documents. Conducted walk through for requirement and system design. Interacted with Business users, gathering and analyzing requirements.
• Conducted walk through for the conversion rules with Business users.
• Analyzed and produced UML diagrams to reflect existing business models.
• Created Run Book.
• Writing complex SQL scripts and PL/SQL packages, procedures to extract data from various source tables of data warehouse.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Used ER Studio for Logical and Physical database Modeling.
• Always made the deliverables on time, in proper quality and to the user satisfaction.
• Was part of code review, test reviews and design reviews meetings to identify bottlenecks in the system and to suggest enhancement.

Environment: Oracle, SQL, PL/SQL, Export/Import, SQL*Loader, SQL Developer, Windows XP, ER Studio, Business Objects and PVCS.

Worked as a Data Analyst in ODS Data/Requirements and IDB group. Responsible for logical and physical design of components, data mapping (source to target), query optimization, automating data extraction and cleansing from data warehouse. Had to generate weekly and monthly reports of customers, promotions data that are used by executives and several departments.

Responsibilities:

• Worked as a data analyst, interviewing clients to understand their business and functional requirements, gathering their future needs and transforming them to functional specifications.
• Managed, designed, and implemented various projects for customers using the Teradata relational database system
• Acted as primary liaison between the client departments and the Information systems IT department; performed analysis, review, and estimation of client requests; prepared and reviewed system requirements, and client documentation, prepared and executed detailed test plans and test cases.
• Created mapping documents using Excel spreadsheets for the ETL team for the changing IDB to ODS Environment.
• Writing SQL queries to find the proper source to target for the attribute mapping.
• Used IBM Rational Requisite Pro to write various use cases
• Determining the derivation logic for each attribute that is being mapped / derived / ETL generated.
• Creating logical and physical models according to business requirements for the ODS environment.
• Worked as a team lead to assign work among the subordinates to finish task on a limited time constraint.
• Analyzed financial impact of short run production alternatives.
• Updated the existing CDM Meta Data Tool (Data Dictionary created using Microsoft Access) on a changing environment for data quality and data consistency.
• Worked with IT department in business analyst role for implementing various software upgrade for financial reporting for procurement efforts, setting business rules for module development, business data validation and integrity of generated database during various stages of SDLC.
• Project duties included multiple task project assignments, scheduling, and tracking; facilitating meetings with all levels of the business community for requirements gathering, project development, design considerations, impact and risk analysis, and quality control of client acceptance testing.
• Analyzed requirements, design of Data Warehouse using Star-Schema methodology and convert data from various sources to oracle tables.
• Created Technical requirement and design documents. Conducted walk through for requirement and system design. Interacted with Business users, gathering and analyzing requirements.
• Writing complex SQL scripts and PL/SQL packages, procedures to extract data from various source tables of data warehouse.
• Performance tuning of SQL queries for data warehouse consisting of many tables with large amount of data.
• Used Power Designer 9.0 for data analysis, data modeling and database design process
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Analyzed and produced UML diagrams to reflect existing business models.
• Designed UML Models (Visio) and Relational data Models for applications.
• Worked on Business Objects (BO) to deploy various reports onto production.
• Developed ETL for Data Extraction, Data Mapping and Data Conversion for various application and processes.
• Created complex universes with Designer to give adhoc-reporting capability to the users.
• Used ER Studio for Logical and Physical database Modeling.
• Used Rational Rose to create various UML diagrams like sequence and class diagrams
• Always made the deliverables on time, in proper quality and to the user satisfaction.
• Was part of code review, test reviews and design reviews meetings to identify bottlenecks in the system and to suggest enhancement.

Confidential,Boston, MA Apr 2005 – Jun 2006
Role: Data Analyst / ETL Developer

Environment: Oracle 10 g/9.2, SQL, PL/SQL, Export/Import, SQL*Loader, Korn Shell Script, HP UNIX, Sun Solaris, TOAD, Windows 2000, VBA(Excel), Erwin, Business Objects and PVCS.

This Project involved conversion of Deutsche Bank\'s Global Securities Services (GSS) data into present system. Involved in building an interface to convert/migrate legacy customer data to Oracle financials AR tables also involved in Data warehouse/development for Oracle 10g/9i databases. Worked on multiple projects in Product Development, Data Migration, Deployment, validation in Production and Development environments for various applications on UNIX and Windows NT/2000 platforms.

Responsibilities:

• Performed analysis, review, and estimation of client requests; prepared and reviewed business requirements and client documentation
• Produced functional specifications and led weekly meetings with developers and business units to discuss outstanding technical issues and deadlines that had to be met.
• Analyzed the business requirements and involved in writing Test Plans and Test Cases
• Executed SQL Queries to verify the dataflow from the backend
• Performed testing on a data warehouse platform, including data integrity and data validation.
• Wrote requirements for designing data marts that were used as the source for the various reporting systems in the company.
• Conducted JAD Sessions with the subject matter experts, stakeholders and other management teams in the finalization of the User Requirement Documentation.
• Used IBM Rational Requisite Pro to write various use cases
• Performed Data Modeling by creating logical and Physical models of the database system.
• Developed conversion mapping that maps legacy customer master data (customer accounts, profiles, contacts and telephone data) to Oracle financials customer interface.
• Created SQL*Loader scripts to load legacy data into Oracle staging tables.
• Created staging tables necessary to store validated customer data prior to loading data into customer interface tables. Created PL/SQL Packages, procedures and functions necessary for customer record validations before loading records into customer interface tables.
• Validation includes organizations, customers and addresses validation like duplicates and nulls, ship to and bill to validation, checking customer profile classes are setup in oracle and site use code exists in oracle etc.
• Created system design document with high-level design and requirement document. Conducted walk through for requirement and system design.
• Interacting with Business users, gathering and analyzing requirements. Analyzed Data and mapped Source Systems Data to Finance data warehouse.
• Involved in design of logical and physical data model of the components.
• Using Oracle Export utility Exported Oracle financials data into export dump files. Using Oracle Import utility imported source tables and data from export dump files on daily basis.
• Using UNIX shell scripting created batch jobs to create Index and Analyze tables once the Imports are done.
• Writing complex SQL queries and PL/SQL procedures to extract data from source tables of data warehouse.
• Designed star schema using dimensional modeling and created fact tables and dimensional tables. Used ERWIN for Logical and Physical database Modeling.
• Worked on table partitioning (Range) and deploying various methods of indexing like local indexes on portioned tables.
• Developed views, functions, procedures, and packages using PL/SQL & SQL to transform data between source staging area to target staging area. Extensively used PL/SQL tables, cursors and exception handling.
• Loading data from flat files into to database tables using SQL* loader.
• For Optimization Process actively involved in performed database capacity planning, created materialized views. Tuned and optimized SQL statements.
• Designed and developed ETL to extract external data source (Oracle, Excel file).
• Used Rational Rose to create various UML diagrams like sequence and class diagrams
• Used various Testing tools, such as LoadRunner, QuickTest to ensure the conversion was successful.
• Created Data Mart for Management reporting accessed by higher executives via Web Application and also for Business Objects reporting.
• Used Power Designer 9.0 for data analysis, data modeling and database design process
• Responsible for production support, troubleshooting and fixing any production issues.
• Analyzed and produced UML diagrams to reflect existing business models.

Confidential,Southfield, MI Dec 2003 - Apr 2005

Environment: : MS-Office, MS-Visio, Oracle (9i/10g), VBA(Excel), TOAD, Erwin, SQL*Loader, SQL, PL/SQL, Ab-Initio, Windows NT

Catered to Development of Data warehouse/ETL application involving Database development, managing the database (mainly included creating users, table spaces, PL/SQL, Packages, Stored procedures, Triggers, Functions and database Triggers), export, import and tuning of the database.

Responsibilities:

• User Requirements gathering by interacting with the stakeholders and other management personnel to get a better understanding of the business process.
• Managed, designed, and implemented various projects for customers using the Teradata relational database system
• Worked as a Data Analyst for the various systems of BCBS.
• Worked on Logical Database Design for large scale systems using ORACLE.
• Used IBM Rational Requisite Pro to write various use cases
• Performed testing on a data warehouse platform, including data integrity and data validation.
• Wrote requirements for the designing data marts that were used as the source for the various systems in the company.
• Performed Analysis and design of implementing a Star Schema Data Mart with Facts and Dimensions.
• Conducted JAD Sessions with the subject matter experts, stakeholders and other management teams in the finalization of the User Requirement Documentation.
• Performed Data modeling by creating logical and Physical models of the database system.
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.
• Worked with the DBA and Database developers to convert the functional specification to technical specification.
• Worked with the DBA and developers to identify performance issues of the ODS population and work together to resolve the issues.
• Created Data Flow Diagrams and Process flow diagrams for various load components like FTP Load, SQL Loader Load, ETL process and various other processes that required transformation.
• Prepared Business Requirements Documentation including Business Rules, Workflow diagrams and Activity diagrams.
• Used MS Visio to represent system under development in a graphical form by defining use case diagrams, activity diagrams and workflow diagrams.
• Responsible for streamlining business processes through analysis, design, documentation of new processes and applications including risk assessments and mitigations, creations of process flows (VISIO flow design), change enablement, quality controls.
• Gathered Business Requirements, interacted with the Users, Designers and Developers, Project Manager and SMEs to get a better understanding of the Business Processes, and analyzed and optimized the process.
• Conducted review meetings with development, QA and data team to communicate business requirements.
• Designed UML Models (Rational Rose, Visio) and Relational data Models for applications.
• Used Rational Rose to create various UML diagrams like sequence and class diagrams
• Used Power Designer 9.0 for data analysis, data modeling and database design process
• Worked closely with quality assurance and development teams to clarify and understand the functionality to resolve issues and provide feedback in terms of the test matrices and to nail down the bugs.
• Participated in System Test reviews, development design reviews and usability studies.
• Coordinated and prioritized outstanding defects and enhancement/system request based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.
• Provide strong direction to development team in understanding and implementing requirements.
• Participated in Code and Design Reviews for the ODS project for backend Data population and reporting system.
• Participated in status meeting and walkthroughs.

Confidential,Ryazan, Russia Jan 2002 - Nov 2003

Environment: ERWIN, Microsoft SQL Server 2000, MS-Office, MS-Visio, SQL, PL/SQL, VBA(Excel), Windows NT.

Worked as Data Analyst to analyze, design and develop Megafon Reporting Services. Worked in a Data Warehousing project, to analyze source data, designing the data mart target schema mappings, testing transformations and worked as primary functional production support for any reporting issues from the ODS system.

Responsibilities:

• Involved in Data Analysis for the data warehouse and data mart system.
• Managed, designed, and implemented various projects for customers using the Teradata relational database system
• Designed and developed Data Models using ERwin to support business functionality.
• Wrote requirements for various reports to be generated and migrated.
• Used IBM Rational Requisite Pro to write various use cases
• Participated in writing data mapping documents and performing gap analysis on the systems.
• Worked as a data modular: my job was to interview clients to understand their business and functional requirements.
• Performed Analysis and design of implementing a Star Schema Data Mart with facts and dimensions.
• Reviewed Business Requirement Documents and the Technical Specification.
• Coordinated with System Analyst and Project Manager to setup the pre-validation and validation environment to execute the scripts.
• Used ERWIN for Logical and Physical database Modeling.
• Maintained documentation related to difficulties, complexities and anomalies that may arise during the ETL process.
• Analyzed user statement of requirements to develop new reports.
• Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes.
• Planned, scheduled, and controlled projects based on plans and requirements outlined by the business.
• Interacted with developers to report data related bugs and re-tested the fixed issues.
• Gave valuable input in terms of Modification Requests and Enhancement Requests.
• Involved in design, code, test and various other review meeting.
• Responsible for weekly status.
• Used Rational Rose to create various UML diagrams like sequence and class diagrams
• Analyzed and produced UML diagrams to reflect existing business models.
• Used Power Designer 9.0 for data analysis, data modeling and database design process

Education

MS in Computer Science

Bachelor’s in Computer Science