SUMMARY

• Over seven years of experience in modeling and analysis of both analytical and transactional systems
• Teradata V2R5 Certified / Implementation Specialist and Oracle 10g Certified Professional
• Data Quality Analyst wif strong understanding of Data Governance principles
• Experience wif Data Analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration
• Experience documenting business cases and managed report development from design to release.
• Experience communicating business and technical issues to both business users and technical users
• Extensive experience in Software Development Lifecycle (SDLC), gathering requirement, change management, analysis, reporting, project coordination and conflict resolution
• Experience working in conventional and agile project development environments
• Experience conducting JAD sessions wif business users to gather functional and system requirement
• Well versed in Normalization / Denormalization techniques for optimum performance in relational and dimensional database environments
• Facilitated JAD / white board sessions to resolve revolving issues and understand data requirements
• Knowledge of UML to understand business process for modelling OLTP and OLAP systems
• Experience wif data modeling and design of both OLTP and OLAP systems
• Experience working wif modeling tools such as Erwin, Power Designer, E - R Studio and Visio
• Strong understanding of dimensional, relational and object oriented modeling techniques
• Experience designing data models using star and snowflake schemas
• Experience developing conceptual, logical and physical data models as per enterprise standards
• Extensive experience developing source to target mapping documents
• Experience developing data transformation and cleansing rules for migration using ETL tools
• Proficient in developing complex SQL queries for reporting needs
• Experience building reports using Crystal Reports, MicroStrategy, Business Objects and Cognos
• Experience in using statistical analysis tools like SAS and SPSS for reporting needs
• Experienced in integrating OLAP and Service Oriented Architecture (SOA) reporting solutions
• Experience working wif ETL tools like Informatica, MicroStrategy and IBM Data stage.
• Developed BTEQ, MLOAD, FLOAD and TPump scripts for loading data from source to Teradata
• Experience working wif SSAS, SSIS, SSRS, using SQL Server 2005.
• Extensive experience in development of T-SQL, DTS, OLAP, Stored Procedures and Triggers for business logic implementation.
• Experienced in handling XML, HTML, JavaScript, VB Script, Perl and ASP
• Excellent analytical, and inter-personal skills wif ability to interact wif individuals at all levels

TECHNICAL SKILLS

Scripting languages: SAS, Unix Shell, HTML, VB Script, Java Script, Jscript, CSS, and XML

Databases: Teradata v2R5 /v2R6 / v12, Oracle 8i/9i/10g, SQL Server, DB2, Sybase12 and MS Access/ Excel

Data Warehouse Tool: TOAD, Teradata SQL Assistant, Teradata View Point, SQL Developer, Rochade

Modeling Tools: Erwin, ER Studio, Power Designer, Microsoft Visio, Rational Rose

ETL / Reporting Tools: Ab Initio, Business Objects XIR2 /XIR3, Cognos, Crystal Reports, DataFlux, Data Stage, Informatica, Microstategy

Data Quality Tools: HP Quality Center 10, Test Director

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Sr. Data Conversion Analyst Consultant

Responsibilities:

• Analyzed teh source system to identify teh sensitive data dat needs to be migrated
• Interacted wif teh business users to understand both data and reporting requirements
• Performed classification / trending analysis by understand teh source data
• Developed source to target mapping documents for multiple subject area
• Worked closely wif teh ETL team to coordinate teh data mapping during code development
• Responsible for coordinating wif multiple teams to perform both unit and integration testing
• Responsible for loading production scrubbed data into multiple dev / qa environments
• Responsible for scheduling jobs using Autosys to load teh data into multiple environments to coordinate testing
• Responsible for providing sensitive credit data to teh business readiness team, to support data migration from legacy to target systems.
• Provided production support to resolve teh defects identified during teh conversion process.
• Responsible for tracking data defects in Quality Center and provide resolutions to fix teh defects.

Environment: Oracle 10g, Ab Initio, SQL, UNIX, HP Quality Center 10, Autosys, Microsoft Excel

Confidential, Richmond, VA

Sr. Data Analyst Consultant

Responsibilities:

• Responsible to review and provide approvals for project space request in prod, dev and test environment.
• Responsible for understanding online, nearline and offline data retention requirements
• Acted as a SME to identify any space reclaim opportunities on production containers in Teradata
• Played a major role in planning / performing Teradata system capacity expansion from 18 nodes/85 TB to 33 nodes/150 TB
• Designed automated reports using business objects to identify skewing issues at teh table level and worked wif teh individual project teams for resolution
• Responsible for rolling out quarterly Teradata forecast process and worked wif individual LOB’s to understand their space requirements
• Worked closely wif DBA’s/architects in review and approval process for creating new databases
• Acted as a single point of contact wif strong understanding of weekly/monthly and quarterly growth on teh Teradata system.
• Provided technical support to multiple data warehouse development teams.
• Worked wif data stewardship for remediating legacy roles in prod, dev and test environments
• Designed and implemented database replication strategies for both internal and Disaster Recovery
• Responsible for reporting chargeback numbers on individual cost centers to teh higher management
• Support and oversee teh process of promoting end user solutions to production environment.
• Designed reporting solutions using business objects for emailing daily growth numbers on Teradata system.
• Managed Analytic Platform mailbox, and responded to users requests in a timely fashion.
• Collaborate wif Production Support and end users to troubleshoot performance using ViewPoint and implement fixes

Environment: Teradata 12, ViewPoint 13, Oracle 10g, SQL, UNIX, SAS, Business Objects XIR3, Rochade, HP Service Manager, Clear Quest

Confidential, Richmond, VA

Sr. Data Analyst Consultant

Responsibilities:

• Supported Fraud, Anti Money Laundering and Corporate Security applications in DAPROD, during teh migration from FRM to DDE environment
• Actively participated in design and development of Technology Automation Of Stewardship Data Mart.
• Conducted JAD sessions wif teh stewardship team, for gathering functional and data requirements
• Developed short-term tactical solutions to achieve long-term objectives and to promote teh enterprise data architecture vision.
• Developed BTEQ, MLOAD, FLOAD and TPump scripts for bringing in teh data, and automated them in Unix using shell (ksh) scripts
• Responsible for identifying data quality issues and downstream impact to teh data warehouse
• Designed reports to analyze end user data for compliance wif Teradata governance standards.
• Developed ksh scripts to capture file system usage both on SASDOME & PEARL Unix servers
• Performed data mapping of Business Objects universes in XIR2 for reporting end user data
• Developed bobj reports to analyze space usage by end users/groups on Unix servers.
• Responsible for testing bobj reports and providing teh signoff to teh BI team, during teh migration of Business Objects from XIR2 to XIR3
• Responsible for communicating wif end users for cleanup of files on Unix servers as a BAU.
• Designed a process in Unix to send space alert notifications by email.
• Developed documentation for end users, to halp get familiar wif TAOS data mart
• Responsible for submitting work orders for code promotion, enhancements and job scheduling.

Environment: Teradata 12, Oracle 10g, SQL, UNIX, Business Objects XIR2/XIR3, Rochade, HP Service Manager, Clear Quest

Confidential, Cleveland, OH

Data Modeler / Analyst Consultant

Responsibilities:

• Responsible for interviewing business users for gathering functional and data requirements
• Responsible for preparing technical specification document, wif functional definitions
• Developed Logical data model using Erwin 7.2 and created physical data models using forward engineering
• Worked wif DBA group to create Best-Fit Physical Data Model from teh Logical Data Model
• Identified and tracked slowly changing dimensions and determined teh hierarchies in dimensions.
• Developed source to target mapping document, wif all teh transformation rules
• Responsible for handling requirements by documenting them using Rational Requisite Pro
• Used utilities such as Fast Export, MLOAD and TPump for bringing data into target system
• Analyzed teh data requirements and identified teh Facts and Dimensions for teh proposed model
• Developed data migration strategies and impact analysis for both Teradata and oracle database systems.
• Employed process for data analysis to model a Customer Information Business System.
• Responsible for handling / assisting project development at various stages using MS Project
• Used DataFlux dfPower Profile tool for data profiling needs.
• Used DataFlux dfPower Quality tool to analyze and improve teh data quality and integrity.
• Responsible for maintaining / updating Meta data repository using Rochade.
• Work closely wif Business to design weekly reports using a combination of Cognos Impromptu and Power play, to deliver reports to CEL and Marketing groups.
• Design complex reports for aging analysis, invoices generation, profit/loss, and balance sheet
• Involved in overall data mart testing and different team reviews and status meetings

Environment: Teradata V2R5, Oracle 10g, Unix, SQL, Rational Requisite Pro, Unix, DataFlux, Cognos Impromptu 7.2, Cognos PowerPlay 7.2, Erwin 7.2, XML, MS Project, ASG Rochade, Microsoft Excel

Confidential, Atlanta, GA

Data Analyst / Modeler Consultant

Responsibilities:

• Assisted Business owners in defining business requirements and performing use case analysis
• Translated business requirements into architecture and functional requirements
• Responsible for documenting technical and business requirement
• Facilitated JAD sessions for gathering data requirements, also responsible for analyzing source data
• Designed conceptual and logical data models using ER Studio as per enterprise standards
• Conducted logical data model walkthroughs and validation.
• Developed Logical Data Models for Integration of prescription and major medical benefit systems
• Facilitated teh transition of teh SMART System logical data model into teh physical database design and recommended technical approaches for good Data Management practices.
• Produced functional decomposition and logical models into an enterprise data model.
• Worked wif Business owners to develop and improve rule-sets for CVS internal Pharmacy Benefits Management (PBM).
• Developed Data Mapping Documents to depict Data Flow between IC+, Pharmacy+ and SMART systems, wif all teh transformation rules.
• Developed Data Migration and Cleansing rules for brining data from source to target system
• Designed and maintained metadata registry, assess and evaluate teh use of data business and technical use cases.
• Extracted data from Sales and Distribution systems running on SAP R/3 using Informatica
• Used JCL scripting language to perform batch jobs on teh mainframe system.
• Used UC4 tool for job scheduling and workload automation.
• Performed walkthroughs of test cases wif QA team using Test Director
• Analyzed teh source system and developed analytical reports using SQL Server Analysis Services.
• Tuned teh application by rewriting teh queries and database parameters, as well as modifying teh transformation and mappings in ETL process

Environment: z/OS, DB2, SQL Server 2005, SSAS, Unix, ER Studio, Informatica, Test Director, XML, Microsoft Access, Microsoft Excel, T-SQL, Stored Procedures, SAP BW, UC4, BEx Analyzer

Confidential, New York, NY

Data Analyst Consultant

Responsibilities:

• Working closed wif business analyst in gathering reporting requirements
• Conducted JAD sessions and performed data analysis for documented data quality standards
• Documented Technical & Business User Requirements during requirements gathering sessions using Rational Requisite Pro
• Involved in modeling business processes through UML diagrams using Rational Rose.
• Experience using test director, conducting walkthroughs of data cleansing rules, and test case validations working wif teh QA team
• Created data flow diagrams from requirements documents using Rational Rose
• Conducted logical data model walkthroughs and peer review sessions for validation
• Facilitated transition of logical data models into teh physical database design and recommended approaches for good data management practices
• Created star schema data model using Power Designer for teh target RDBMS implementation
• Worked wif DBA group to create Best-Fit physical model from teh Logical Data Model
• Created DDL scripts for static dimensions and ETL Mappings using Data Stage
• Developed Data Migration and Cleansing rules for teh Integration Architecture (OLTP, ODS, DW), considering data linkage and data transformation rules
• Responsible for tracking change management using IBM ClearQuest
• Developed data mapping documents between Legacy, Production, and User Interface Systems
• Developed reports using Crystal Reports 9 to meet business requirements, and migrated and deployed them in QA and production
• Used SPSS analysis services to analyze teh data loaded into teh target system

Environment: Sybase 12, IBM Optim, T-SQL, Sybase Power Designer, Rational RequisitePro, SPSS, Data Stage, XML, Microsoft Access, IBM ClearQuest, Informatica 6.2, Test Director, Crystal Reports 9

Confidential

Database Designer / Developer

Responsibilities:

• Worked wif Business users for gathering functional and data requirements
• Designed, develop, and implemented a configuration based business rules engine for interface processing between various HR systems
• Created backend meta data schema for store business rules and provided GUI tool for maintenance
• Responsible for developing business test cases for analysis and project coordination
• Established standards and guidelines to be used in teh areas data access, stored procedure development, ETL processing
• Created tables, views, triggers, stored procedures, indexes and partitions
• Developed PL/SQL stored procedures and triggers for BAU database activities
• Integrated new data sources wif teh existing data sources to handle teh changing needs
• Developed process for capturing and maintaining metadata from all data repository components.
• Responsible for complete software configuration management using IBM ClearCase
• Tasked wif writing Unix shell scripts on various occasions
• Created Function relationship and data flow diagrams, for enforcing referential integrity constraints
• Tasked wif developing complex SQL queries for reporting needs.
• Involved in teh mapping of data sources and analytics, wif teh goal of ensuring data quality.
• Developed reports using Crystal Reports 8.0 to meet teh complex reporting needs.
• Responsible for maintaining data quality, and improving data security.
• Tasked to Identify and develop opportunities for data reuse, migration, or retirement.

Environment: Microsoft Windows Server 2003, Unix, SQL Server 2000, SQL, Analysis Services, Microstrategy, Rational Rose, IBM ClearCase 6.0, Crystal Reports 8.0, Erwin, Microsoft Visio, XML

Confidential

SQL Server Developer

Responsibilities:

• Installed, designed and developed teh SQL Server database.
• Created a logical design of teh central relational database using Erwin2.5
• Configured teh DTS packages to run in periodic intervals
• Develop custom scripts to automate variousdatabasemanagement processes
• Extensively worked wif DTS to load teh data from source systems, and run in periodic intervals
• Worked wif data transformations in both normalized and de-normalized data environments
• Involved in data manipulation using stored procedures and Integration Services.
• Responsible for tracking change management using IBM ClearQuest
• Worked on query optimization, stored procedures, views, and triggers.
• Tasked wif developing complex SQL queries for reporting needs
• Assisted in OLAP and Data Warehouse environment when assigned.
• Created tables, views, triggers, stored procedures and indexes.
• Created FTP connections, database connections for teh sources and targets.
• Maintained security and data integrity of teh database.
• Developed several forms & reports using Crystal Reports.

Environment: Windows 2000, SQL server 7.0, IBM ClearQuest UNIX, Erwin 2.5, Crystal Reports 6.0