SUMMARY

• 6 years of Database Analyst of experience on source to target mapping, gathering business requirements from business/user, creating source to target mapping document, creating process flows, and DFD.
• Worked on various Domains like Banking, Financial, Parma and Telecommunications.
• Excellent understanding of Data warehousing Concepts - Star and Snowflake schema, SCD Type1/Type2, Normalization/De-Normalization, Dimension & Fact tables.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Worked with heterogeneous relational databases such as Teradata Oracle, MS Access and SQL Server.
• Experience in working third party tools like WinSQL, TOAD and SQL Developer.
• Experience in Other Utilities/Tools/Scripts like Korn Shell Scripting, SQL Plus, SQL Loader, Export and Import utilities, TOAD 9.1 and Visio 10.0.
• Experience in complete Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Bug Life Cycle (BLC).
• Well versed with Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS, PL\ SQL Scripts
• Experience in designing and developing Data Warehouse applications using ETL and Business Intelligence tools like Informatica Power Center, Datastage, Mainframes SAS, SSAS, SSIS, OLTP,OLAP, Business Objects.
• Experience with Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS and Bulk Insert (BCP).
• Experience with Relational Databases like Oracle 10g/9i/8i, DB2 ESE, MS SQL Server 2005/2010, DTS, Sybase, Teradata V2R5, MS Access and formats like flat-files, CSV files, COBOL files and XML files
• Good command in modeling using case tools like ERwin, Oracle Designer, Power Designer & E-R/Studio.
• Involved in preparation of Traceability Matrix based on High/Detail requirements and Test Cases.
• Experienced in handling concurrent projects and providing expected results in the given timeline.
• Excellent communication, documentation and presentation skills with clear understanding of business process flow.

TECHNICAL SKILLS

Database Systems: Oracle 11g, 10i 9i/8i, SQL Server 2008/2005/2000 , IBM DB2, TeraData 12, Sybase ASE 12, MS Access 2007.

Data Modeling Tools: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Conceptual, Logical Data Physical Modeling, Erwin r7.2/3/4,Visio, Sybase Power Designer.

Reporting: Crystal Reports and SQL Server 2000/2005 reporting services

ETL Tools: Informatica 9.0/8.1/7.x/6.x/5.x., Data Stage, SSIS, SSAS

Database Development: T-SQL and PL/SQL

Office Applications: MS Office (Word, Excel, Visio, PowerPoint, Project)

Web Development: HTML, XML and FrontPage, Visual Basic 6.0

Operating Systems: Windows 7/Vista/2000/XP/2003, Unix 5.2/4.3,Sun Solaris7

Programming Languages: C#, Visual Basic.NET and C++, VB 6.0

PROFESSIONAL EXPERIENCE

Confidential, Knoxville, TN

Data Analyst

Responsibilities:

• Worked with business requirements analysts/subject matter experts to identify and understand requirements. Conducted user interviews and data analysis review meetings.
• Defined key facts and dimensions necessary to support the business requirements along with Data Modeler.
• Created draft data models for understanding and to help Data Modeler.
• Resolved the data related issues such as: assessing data quality, data consolidation, evaluating existing data sources.
• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Performed Data Validations using SQL developer.
• Responsible for loading, extracting and validation of client data.
• Worked closely with Data Architect to review all the conceptual, logical and physical database design models with respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds the logical data models.
• Analyzed the source data coming from various data sources like Mainframe & Oracle.
• Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
• Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups.
• Tested the data using the Logs generated after loading the data in to Data warehouse.
• Prepared Traceability Matrix with requirements versus test cases.
• Worked on Master Data Management (MDM) for maintaining the customer information and also for the ETL rules to be applied.
• Involved working on different set of layers of Business Intelligence Infrastructure.
• Worked extensively in Data consolidation and harmonization.
• Worked extensively on the T-SQL environment to run out the queries and explore the Databases.
• Worked with OLAP tools such as ETL, Data warehousing and Modeling.
• Used Informatica / SSIS to extract, transform & load data from SQL Server to Oracle databases.
• Meeting with user groups to analyze requirements and proposed changes in design and specifications.
• Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data.

Environment: Informatica 9.1, Oracle 11g, SQL Server 2008, SSIS 2008, PL/SQL, Erwin 4, TOAD, MS Excel, MS Access.

Confidential - Seattle, WA

Data Analyst

Responsibilities:

• Gathered and Translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality
• Developed project plan with project manager’s assistance for the first two phases of the project.
• Worked closely with Data Architect to review all the conceptual, logical and physical database design models with respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds the logical data models.
• Modify existing Informatica mappings to utilize Power Exchange sources and Oracle and Netezza targets.
• Responsible for Data mapping testing by writing complex SQL Queries using TOAD.
• Incorporated the Informatica Velocity approach for Mapping design, development and Data Governance
• Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the forward engineering ERWin tool.
• Designed and Administered Teradata Scripts, Tables, Indices and Database Objects
• Effectively analyzed business requirements, technical specifications and technical issues to generate test plans and test cases.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Develop complex Teradata SQL queries to generate ad-hoc reports for the business analysts of BCBS to implement complex business rules.
• Experience with Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS and Bulk Insert (BCP).
• Used Universal Data Modeling Techniques to assist Novell Inc, in designing their Data Warehouse/Data Marts and Metadata Management Solution that will integrate Oracle Financials.
• Assisted the IT team to develop service oriented architecture (SOA), and data warehouse system to utilize data mining for data analysis.
• Worked closely with Testing team and helped in testing the Informatica mappings, workflows, Abinitio Graphs and Teradata scripts
• Develop and maintain sales reporting using in MS Excel queries, Visual Basic 6.0, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Participated in writing data mapping documents and performing gap analysis to verify the compatibility of existing system with new business requirements
• Worked on Master Data Management (MDM) for maintaining the customer information and also for the ETL rules to be applied.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Use of data transformation tools such as DTS, SSIS, Informatica or DataStage.
• Responsible for the collection of functional requirements, nonfunctional requirements, data mapping, and light data modeling.
• Created DTS and SSIS packages to load data from different file sources, such as text file, excel sheets.
• Created Informatica mappings with PL-SQL procedures to build business rules to load data.
• Performance tuned the database which includes indexes and optimized SQL statements, after monitoring the SQL server using the Profiler.

Environment: Informatica 9.6.1, Teradata, SQL Server 2000, XSD, SOA, Sybase, ETL, Oracle, SSIS, Unix Shell Scripting,, Analysis Services, Teradata, Crystal Reports7.5/8.0, VB 6.0, Windows 2003, ERWin, XML

Confidential, Columbus, Ohio

SQL Data Analyst

Responsibilities:

• Gathered the business requirements by conducting a series of meetings with business users.
• Involved in business process modeling using UML through Rational Rose.
• Created logical data model from the conceptual model and it’s conversion into the physical database design.
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models.
• Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
• Created reports using SQL Server Reporting Services (SSIS).
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Responsible for creating mapping documents required for the ETL team.
• Created SQL, PL/SQL, SQL Loader control files, functions, procedures, and UNIX Shell scripts.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
• Experience on Extraction Transformation and Loading (ETL) process using SSIS
• Conduct data mapping sessions, and write the required business requirements documentation including use cases.
• Created entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• Used Star Schema and Snow flake Schema for data marts / Data Warehouse.
• Prepared the Joins/Filter logic documents that would help the ETL design team perform the Joins on the tables that are in the form of flat files before loading them to FDS or any downstream systems.
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Used SQL Server 2005 tools like Management Studio, Query Editor, Business Intelligence Development Studio (BIDS) including SSIS and SSRS.
• Created job schedules to automate the ETL process
• Normalized the database up to 3NF to put them into the star schema of the data warehouse.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Reduced labour intensive manual processes like job entry, approval and invoicing by exposing well-defined SOA interface allowing B2B integration with Financial Clients
• Worked on building load rules and transformation logic for Extraction, Transformation and Loading (ETL) of the data into the data warehouse.

Environment: Windows NT, Sybase, SOA, Sybase Power Designer, SSIS, DTS, XSD, Oracle, ETL, Rational Rose, Unix shell Scripting, Teradata.

Confidential, Columbus, OH

Data Analyst

Responsibilities:

• Gathered business requirements through interviews, surveys, prototyping and observing from account managers and UI (User Interface) of the existing online accounting system.
• Prepared Business Intelligence reports development efforts by working closely with business Object, Teradata, and ETL teams.
• Involved in testing data mapping and conversion in a server based data warehouse.
• Conducted JAD sessions with management, SME (Subject Matter Expert), vendors, users and other stakeholders for open and pending issues to develop specifications.
• Defined the calculations based on the reporting needs and the source data available
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Organized Joint Application Development (JAD) sessions with data steward and ETL teams while having walkthroughs for mapping documents.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Performed data modeling to correct problems with the current Sybase database. In addition, optimized current stored procedures and triggers to expedite the loading process.
• Database table review and data mapping for large scale data conversion project Oracle database to Mainframe.
• Created Data Dictionary and ER diagrams for data mapping purposes.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Use of data transformation tools such as DTS, SSIS, Informatica or Data Stage.
• Parsing high-level design specification to simple ETL coding and mapping standards.
• Developed business requirement specification documents as well as high-level project plan.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Experience with data migration (ETL development), document data manipulation processes and scripts
• Created job schedules to automate the ETL process.
• Conducted User Acceptance Testing on the application - resolved issues from the participants, prepared and submitted Test Analysis Reports and participated in Product Readiness Review.
• Worked with a fellow team member to train them on the use of the software.
• Prepared the documentation of Data Acquisition and Interface System Design.

Environment: Windows NT 4.0, Oracle 9i, ETL, Teradata, Oracle Designer, PL/SQL, XSD, SSIS, DOS and UNIX shell scripting, Sequential Files.

Confidential, Denver, CO

Data Analyst

Responsibilities:

• Involved in requirement gathering along with the Business Analysts Group
• Designed the data marts using the Ralph Kimball’s Dimensional Data Mart modeling techniques
• Involved in Object Modeling in UML Using Rational Rose 2000
• Gathered all the Sales Analysis report prototypes from the business analysts belonging to different Business units
• Conducted Design discussions and meetings to come out with the appropriate Data Mart
• Designed for the various reporting requirements
• Researched, Analyzed, designed, developed Java Web Services Service Oriented Architecture (SOA).
• Developed Functional and Regression Testing scenarios based on XML and XSD schema validations.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Designed, developed and tested data mart prototype (SQL 2005), ETL process (SSIS) and OLAP cube (SSAS) for Computer Maintenance Management System (CMMS)
• Use of data transformation tools such as DTS, SSIS, Informatica or DataStage.
• Conducted Design reviews with the business analysts, content developers and DBAs
• Designed, developed, and maintained Enterprise Data Architecture for enterprise data management including business intelligence systems, data governance, data quality, enterprise metadata tools, data modeling, data integration, operational data stores, data marts, data warehouses, and data standards.
• Designed different type of STAR schemas like detailed data marts and Plan data marts
• Researched, Analyzed, designed, developed Java Web Services Service Oriented Architecture (SOA).
• Monthly Summary data marts, Inventory data marts using Erwin (with various Dimensions Like Time, Services, Customers, Sales Hierarchy, Orders Snow flake Dimensions and various FACT Tables)
• Responsibilities include gathering business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in DataStage, and creating ETL jobs in DataStage.
• Worked on data modelling and produced data mapping and data definition documentation
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically
• Worked on SQL Server 2005 concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase

Environment: SQL Server 2000, Windows NT, ERWin 4.0, MS-DTS, SQL*Loader, XSD, SSIS, Data Junction, Oracle, Rational Rose 2000.