SUMMARY:

• Expansive knowledge and understanding in executing Data Warehouse and Client - server applications.
• Extensive experience to analyze and document business requirements and system functional specifications.
• Strong Knowledge of Business Intelligence, Data Warehousing and Business Architecture.
• Worked and extracted data from various database sources like Oracle, MS SQL Server, Teradata, XML and Flat Files
• Extensive experience in data transformation, data mapping from source to target database schemas.
• Extensive experience in providing technical support and preparing technical documents for the end user.
• Experience with MVS/JCL/TSO/ISPF/UNIX/Windows, ETL/Data warehousing tools, Oracle/Teradata/DB2 databases.
• Strong knowledge of Teradata RDBMS Architecture, Applications and Tools & Utilities.
• Experience in utilizing Teradata utilities FastLoad, MultiLoad, BTEQ scripting, FastExport, and Queryman.
• Involved in data merger/ migration projects.
• Performance tuning, Application Development and Application Support on UNIX, MVS and WINDOWS NT Environments.
• Well versed in conducting GAP analysis, User Acceptance Testing (UAT).
• Identified and performed field level compression on Teradata tables.
• Performed single value and multi value compression.
• Proficient in SQL, PL/SQL, and SQL*Loader.
• Adept at working with diverse technical groups and end users to develop technical solutions that meet or exceed expectations along with good analytical, communication and problem solving skills.
• Self starter, multi tasking, attention to detail, ability to work with minimal supervision and manage time and task efficiently.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS:

Operating Systems: MVS (OS/390), Unix, Windows XP, Windows 2000 and Windows NT 4.0

Database: TeraData (9.x/12.x), Oracle (8.0.x/8i/9i/10g), SQL server, DB2

Teradata Tools & Utilities: Query Facilities: SQL Assistant, BTEQ Load & Export: FastLoad, MultiLoadFastExport

Data Modeling: Erwin (7.0/7.3), Visio 2007

Languages: C, C++, C#, SQL

Scripting Languages: UNIX Shell, JCL, Java Script

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

Data Analyst

Responsibilities:

• Identified sources, gather requirements and communicate solutions.
• Gathering the business requirements and analyzing the requirements.
• Matched source to target file layouts, perform gap analysis, design process flow of the data from source to target structure and analyze sample data using SQL Assistant or Access database.
• Prepared Process analysis and the data analysis documents.
• Documented all phases of the project for three major subject areas: business requirements, technical requirements, system and feature design, design document, requirements traceability matrix, interface agreements and data acquisition document.
• Used Visio to draw the existing process and the proposed process Analysis.
• Communicated with data modelers, database administrators, ETL personnel and clients to come up with solutions for the requirements, analysis, design and testing processes.
• Attended status meeting to discuss various design issues and possible solutions to meet target dates for the production release.
• Assisted the developers in designing the overall ETL strategy.
• Assisted with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Coordinate connectivity testing to upstream sources and report any issues.
• Managed files transmission schedules for upstream and downstream vendors.
• Validated files transmitted from source vendors for correctness in file layout and data quality validation.
• Assisted in testing strategy and UAT queries for replication data.
• Assisted in testing strategy and capture test files from source production systems and store on development as test bed.
• Loaded working tables on Teradata using Fastload utility.
• Created Connect: Direct jobs to transfer files from Mainframe to Mainframe and Mainframe to UNIX box.
• Identified business requirements and analyzing the requirements.
• Documented all phases of the project high level design, application design, application interface document, table level specifications and requirements traceability matrix.
• Attended status meeting with Lead DA to discuss various design issues and possible solutions to meet target dates for the production release.
• Developed and reused data models that required entity and attributes definitions, entity relationship, sourcing information, and other data artifacts necessary for creating robust, flexible and extensible databases.
• Responsible to provide baseline standards for logical and physical data modeling, as well as data administration.
• Worked directly with the client user community to define and document data requirements as the foundation for database design, data extraction analysis and cleansing.
• Worked closely with the development organization to transition logical models to physical implementation while occasionally being responsible for quality control and auditing of databases, resolving data problems and analyzing system changes for quality assurance.
• Created logical data model from the conceptual model and it’s conversion into the physical database design using Erwin.
• Worked with the DBA to get the databases created using the DDL from Erwin.
• Assisted the developers in designing the overall ETL strategy, as well as, supported testing of systems, developing and maintaining quality procedures.
• Maintained warehouse metadata, naming standards and warehouse standards.

Environment: Mainframe, MS Office Tools 2007, Erwin 7.3, UNIX, FTP Client, SQL Assistant 12.0, Oracle 10.2, Teradata 12.x, Visio.

Confidential, Columbus, OH

Data Analyst

Responsibilities:

• Met with Project Manager weekly to provide team status.
• Developed applications, methodologies, and reports for analyzing and presenting data using Visual Studio.
• Delegated analysis workload after initial assessment and provided supervision and guidance as required to analysis team.
• Identified all the source copybooks and created mapping documents to in corporate cleansing and transformation rules of the source data.
• Imported, cleansed, transformed and validated all historical data.
• Created specifications based on detailed analysis and profiling source data, including data from mainframe systems.
• Met with SME's and the businesses to collect and update business requirements and convert those rules into data requirements.
• Coordinated with Data Modelers and Data Architects to provide information required to create logical and physical Models.
• Worked closely with ETL developers to provide Load Specifications and Data Mapping Documents as well to remove knowledge gaps.
• Performed complex data analysis in support of ad-hoc business requests.
• Participated in User Acceptance Testing and System Integration Testing.
• Created and maintained the EDW Data Dictionary.

Environment: Oracle 9i, SQL Plus, PL/SQL, MS Office Tools, MS Access, Visual Studio.