CAREER SUMMARY

• 12 years of solid experience in numerous Data warehouse, Data mart, Client-Server Applications.
• Expertise level data architect with extensive database system analysis, design, and implementation experience.
• Hands on experience in leading data warehouse development teams and managing implementation. Solid experience with logical data modeling and the concept of an enterprise level business information model.
• Extensively worked on OLAP Data Analysis techniques Drill Down and Roll Up, Slice and Dice. Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology, using industry leading Data Modeling tools like ERWin.
• Expertise in all aspects of data management methods and practices including Data Modeling, creation of Logical and Physical Data Models LDMs/PDMs , Design of Data warehouse schemas, Forward engineering and reverse engineering , Data migration/conversion with ETL tools and data warehousing.
• Worked about 8 complete Data Warehouse projects. I have performed following specific responsibilites/ tasks in typical Warehouse project and consider myself expertise in these areas/skills.
• Information Modeling: Established and followed Information Management data warehousing architectural principles in the creation of star schemas and conformed dimensions that ensures usability and efficiency of the data warehouse presentation layer.
• Requirements Analysis:Provided project-specific data integration architectecture coordination to ensure adherence to defined project management and defined architecture processes.
• Architecture : Provided overall day to day data integration architectural expertise that supports integration efforts across a 3-tiered data architecture master data, operational/transactional, data warehouse . Resolved architecture related problems by developing cohesive solutions that benefit the project, department and the entire organization.
• Integration : Investigated appropriate core technology DBMS for each projects data integration needs. Defined data security architecture to provide guidelines for protecting data from damage, to ensure confidentiality and integrity, and to adhere to regulatory requirements. I was accountable for Architect related deliverables to ensure all project goals are met within the project time lines by working closely with project team. Acts as an architecture SME to provide guidance to projects.
• Mapping:Ensured mapping between source and target data, as well as performing logical model to physical model mapping and mapping from third normal form to dimensional presentation layer .
• Structured Query Language:Ensured generation of first cut physical model DDL and SQL for views for implementation by the DBA. The SQL must be written to optimize views based on the database engine was used.
• Documentation :Created, validated and updated the data dictionary by interviewing IS implementers, business users, querying data directly and analyzing documentation to make sure that the information captured is correct.
• Standards Process :Enforced approved Enterprise Architecture EA information-related standards and guidelines Maintains, modifies and creates new standards as necessary. Enforced data integration architect standards and guidelines that simplify implementation of data integration projects and ensure consistent data architecture practice. Ensured that the architecture team is working in conjunction with the Data Integration Analysts, ETL Developers and Database Analysts to produce data integrated project solutions.
• Knowledge Sharing :Acted as the key project representative for the team on projects with multiple data integration architects in order to provide one voice for the team. Provided knowledge transfer to other data integration architects on staff internal or external to ensure that they understand existing architectural policies, procedures and standards. Mentored Data Integration Architects and other department employees in understanding architectural designs to include advice, training and serving as point of contact for questions on tools and standards.
• Participated in several data warehouse architecture plans, including system partitioning and framework design. Established best practices for the design, development, and support of enterprise Data Warehouse and Business Intelligence solutions.
• Skilled in team leadership/mentoring/training, workshop facilitation, acting as a liaison between business users and technical staff, and coordination of offsite e.g. offshore development efforts regardless of the chosen development process e.g. waterfall , agile/extreme , or other iterative techniques .
• Extensive experience in requirements gathering and business rules analysis using a variety of techniques and artifacts, conceptual/logical/physical database modeling in ORM/ER/UML, model validation/business rules traceability analysis, as-is vs. to be software modeling and gap analysis, and meta-modeling.
• Designed and developed the architecture for Data Warehousing components across subject areas and various technical domains e.g. tool integration strategy, data massaging, data cleansing, data source ETL strategy, data staging, movement, and aggregation, information and analytics delivery and data quality strategy .
• Has been an integral part of every phase analysis, design, testing, implementation of database projects using every common type of data store transactional OLTP , data warehouse Kimball/Inmon , and Data Mart OLAP .
• Possess strong ER Modeling and Dimensional Modeling skills for OLAP, OLTP, Enterprise Data Management EDM , DSS, ODS using various databases like Oracle 10g/9i/8i, SQL Server 7/2000 and MS Access 97/2000/2002, very good knowledge of Teradata V2R5/V2R6. Experienced in configuration management.
• Hands on experience on database system construction experience to include stored procedure construction and testing, OLAP cube design and construction, persistence and business logic layer development, extraction/transformation/loading ETL design and implementation, report development, database system troubleshooting and performance tuning, database configuration and administration e.g. DBA tasks , and application testing.
• Primary focus always on bridging the business-technology gap that seems to appear in many companies by simultaneously acting as a liaison between the two worlds . Facilitating more formalized business functionality requests, building trust, focusing on delivering business value as quickly as possible, and developing/mentoring technical teams such that they are more aware of business needs and, often, the more advanced analysis/design/development techniques needed to meet those needs.
• Financial services other industry domain expertise in the following areas:
• o Credit Card, Debit Card, Anti-Money Laundering, Credit card Rewards System.
• o Insurance industry knowledge claims processing, Insurance Claim Healthcare, Insurance asset account, Insurance products and features are some of the subject areas for reference.
• o Customer within Banking and Mortgage, Auto, Insurance, Retail customer data.
• o Point of Sale POS system.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Position: Business Analysis Mentor, Data Architect

Responsibilities:

• Led requirements gathering sessions used to form a high level conceptual model for a Discover Bank system to support corporate sales and marketing efforts through campaigns.
• Did in-depth Analysis of business requirements for the IVR, Total contact DB history projects to translate business requirements into data elements.
• Provided frame work for the details collected from various sources.
• Analyzed and designed logical and physical data models and relational database definitions. Generated reports of data definitions.
• Created DMLs, ensured for approval of the same from related groups.
• Provided data element naming consistent with DFS standards and conventions and ensured that data dictionaries are maintained across multiple database environments.
• Consulted with database administration and other client areas in resolving questions during the translation of data requirements to a physical database design.
• Performed data modeling studies and developed detailed data models for CCS team after identifying the specific requirements and analyzed other group models like ODS marketing, other marts.
• Conducted source data analysis of various data sources and develop source-to-target mappings with business rules.
• Started attended meetings working on FSLDM LDM data elements in Discover Bank perspective
• Also brought on board to mentor staff developers, analysts, and designers in business analysis techniques to include use cases and ORM.

Environment: Multi-dimensional modeling, Data Warehousing, ERWin, ER/Studio 8.0/8.5/9.0, Meta Data Repository, SQL, Teradata, Oracle11g, DB2, Windows, Microsoft Project, Microsoft Office.

Confidential

Position: Lead Data Architect / Data Modeler

Responsibilities:

• Translated business requirements into data needs and developed detail E-R and dimensional models.
• Worked closely with Business Analyst to implement data loading specifications.
• Set standards for use of ERWIN for modeling and model management process using ERWIN.
• Identified and documented data definitions, business rules and business metrics.
• Conduct source data analysis of various data sources and develop source-to-target mappings with business rules.
• Maintained existing ETL procedures, fixed bugs and restored software to production environment.
• Played key part of the development of metadata standards and enterprise information dictionary.
• Developed enterprise data model management process to manage multiple data models developed by different groups.
• Created SQL scripts for database modification and performed multiple data modeling tasks at the same time under tight schedules.
• Trained end users or technical support staff to use programs.

Environment: ER Studio 8.5, Oracle 9i Application Server, Oracle Developer Suite, Oracle Workflow, TOAD 8.0, Model Mart database modeling repository , Visio Process flows , PL/SQL, T-SQL, DB2, SQL Plus

Confidential

Title: Data Architect/ Data Modeler

Responsibilities:

• Captured data extract requirements for multiple subject areas sourced from an external ERP system.
• Maintained existing ETL procedures, fixed bugs and restored software to production environment.
• Analyzed data which included investigation and analysis, documentation, filtering of bad data through generation of crystal reports.
• Designed 3rd normal form target data model and mapped to logical model.
• Worked with Data Warehouse Extract and load developers to design mappings for Data Capture, Staging, Cleansing, Loading, and Auditing.
• Developed, enhanced and maintained Snow Flakes and Star Schemas within data warehouse and data mart conceptual logical data models.
• Analyzed business requirements and translated them into detailed conceptual data models, process models, logical models, physical models and entity relationship diagrams. Gathered enterprise level data requirements.
• Communicated data needs internally and externally to 3rd parties. Analyzed and understood the data options and documented data dictionary.
• Designed and created Data Marts as part of a data warehouse. Effectively used triggers and stored procedures necessary to meet specific application's requirements.
• Participated in system integration, historical load, incremental load and parallel testing.
• Established auditing procedures to ensure continued data integrity.
• Researched data sources for new business data and better sources of data feeds.
• Developed and coordinated enhancements and maintenance of data warehouse and data mart logical models.
• Analyzed content and quality of data model s and databases.
• Work closely with the DBA team to translate the model s from logical design to physical implementation.
• Worked closely with the Infrastructure Architect and Application Architect to insure the EDM is integrated with development efforts.
• Reviewed new data development and ensured that it is consistent and well integrated with existing structures.
• Worked closely with the end users and trained them. Identified, documented and resolved any BIM issues.
• Recommended data management procedures.
• Conducted team meetings ensured project documentation is completed.
• Ensured all data has a complete and accurate definition.

Environment: Windows XP Professional, MS SQL Server 2000, Oracle 10g, PERL, UNIX Shell Scripting, MS Access 2000, PL/SQL, T-SQL, TOAD, DB2, SQL Plus, Data Modal Mart, OLAP, Data Warehouse, Data Modelling, Oracle warehouse builder, Data Architecture, ETL, Oracle, PL/SQL, ERWIN, MS Visio, Microsoft Tools.

Confidential

Title: Data Modeler

Responsibilities:

• Developed, enhanced and maintained data warehouse and data mart conceptual logical data models using ERWin and MS Visio.
• Aided and verified DDL implementation by DBAs, corresponded and communicated data and system specifications to DBA, development teams, managers and users, such as the Web-based 110-entity Trans Union Routing Facility TURF and the Cronus Products Architecture CPA using Oracle, SQL Server, DB2 and MS Access.
• Maintained and enhanced and determined impact to the Enterprise Data Model EDM , ODS Operational Data Source ODS and DSS Decision Support System and refined the EDM as needed as new applications or products were added.
• Established auditing procedures to ensure continued data integrity.
• Participated in business requirement definition and review business requests for data and data usage.
• Researched data sources for new business data and better sources of data feeds.
• Developed and coordinated enhancements and maintenance of data warehouse and data mart logical models.
• Participated in application design reviews to ensure data model adherence and data standards.
• Analyzed content and quality of data model s and databases.
• Worked closely with the DBA team to translate the model s from logical design to physical implementation.
• Worked closely with the Infrastructure Architect and Application Architect to insure the EDM is integrated with development efforts.
• Reviewed new data development and ensured that it is consistent and well integrated with existing structures.
• Worked closely with the end users and trained them.
• Recommended data management procedures.
• Defined data requirements to satisfy client business objectives.
• Ensured all data has a complete and accurate definition.
• Ensured a common business vocabulary for organizational use.

Environment: Windows XP Professional, MS SQL Server 2000, Oracle 9i, PERL, Crystal Reports, Business Objects, MS Access 2000, PL/SQL, T-SQL, TOAD, DB2, SQL Plus, Queryman, Visual Basic 6.0, ASP, .NET, ERWin Data Modal Mart, OLAP, Data Warehouse, MS Visio, Microsoft Tools,

Confidential

Title: Data Analyst / Data Modeler

Responsibilities:

Consulted with business partners and applications team to ensure conformance to established architectures.

• Performed data analysis and modeling for development and maintenance projects.
• Developed and maintained Entity Relationship Diagrams and associated data dictionaries.
• Assisted in the development of task lists, project plans and workload estimates.
• Participated in walk-through of work products such as data models, implementation architecture, documentation, etc.
• Performed impact analysis for requested changes and additions to data structures.
• Worked both independently and collaboratively with multiple project teams.
• Designed, developed, and implemented complex logical and physical databases across multiple platforms, technologies and computing environments.
• Provided project reporting to project manager.
• Performed research, prepared technical studies, and made recommendations.
• Prepared business requirements reports, feasibility studies, and cost justification statements.
• Articulated information architecture to management.
• Researched and evaluated alternative solutions and recommended the most cost effective design solutions.
• Worked closely with technical and client management to ensure implementation of database management and support tools for complex business application development requirements and processes in accordance with latest enterprise direction e.g., diverse development platforms, technological environments, software, hardware and tools .
• Consulted with the team and clients to determine the impact of new or revised applications on information architecture.
• Consulted with clients to determine information management requirements.
• Provided training and professional development on new technologies and applications to team.
• Executed custom queries and ad-hoc database queries using T-SQL and provided management with reports as needed.
• Provided support to end users for various database and application issues.

Environment: Oracle 8i, T-SQL, OLAP, PL/SQL, SQL Loader, Teradata, Windows NT/2000, Erwin 4.0,

UNIX, Microsoft SQL Server 7/ 2000, Crystal Reports, ERWin Data Model Mart ,

MS Access 2000, MS Excel.

Confidential

Title: Data Analyst / Team Lead

Responsibilities:

• Involved in reviewing business and functional requirements.
• Prepared test plans from the requirement documents.
• Created black box test cases and highlighted requirement gaps through review meetings. Used Test Director for logging issues.
• Developed white box test cases after review of technical design documents. Unit test results are verified for completeness. Early defects found were reported.
• Involved in smoke test and in setting up the test environment.
• Done extensive Integration testing and System Testing. Also performed end- end, regression and User Acceptance testing for new releases.
• Used XPEDITER for manual batch testing. Used FILEAID for working with sequential and VSAM file handling and also used SPUFI for querying DB2 database.
• Did postproduction support activity using CA7 and SAR for the newly developed production enhancements.
• Identified JCL issues, data problems and reported to development team with possible solutions. Tracked the tickets in the Clear quest tool and followed it up to closer.
• As an Offshore Project Leader, was responsible for the delivery and Quality of the deliverables and managing offshore team at India.
• Created Debit Card BIN database with MS Access, VBA to facilitate extraction and storage of repeatable debit card data for test environment.

Environment: VS COBOL II, Microsoft Office, Teradata, HOGAN, DB2, JCL, UNIX,VB6, IMS/DB, CA7, PEM, SAR, MQ Series, SQL Server 7, Oracle 8i, VSAM, TSO, OS/2, ISPF, SDF, SCLM, FILEAID, XPEDITER, SQL server, C/Unix, DB2Connect, TAO, HTML, Test Director, Clear Quest, HTML, XML,MVS, VBA, MS ACCESS.

Confidential

Title: Data Analyst

Responsibilities:

• Reviewed Business and functional requirement documents. Identified project requirements and test software functionality.
• Assisted in the execution of the application transition plan.
• Created test plans and managed test plans using test director.
• Conducted internal test plan and test case walkthroughs.
• Contributed to and assist in implementing improvements in test methods and strategies.
• Worked closely with developers to create and execute test scripts from specifications and product requirements.
• Supported the design, considering business requirements and system limitations. Some coding was required with COBOL and DB2.
• Created test data on mainframe system. Executed the test cases both manually and using mercury tools.
• Performed system and regression test for new releases using win runner scripts.
• Maintained traceability matrix for regression tests for software release builds.
• Reviewed and contributed to software program documentation
• - performed SQA
• - monitor and audit the software development lifecycle
• - making sure that the selected software development lifecycle is being followed and that
• The processes defined above are being properly executed.
• Worked with users and project teams to QA the documented use case scenarios
• To ensure proper coverage of functionality and required test case scenarios
• Performed database tests using SQL. Reported bugs and attended Bug review meetings.
• Developed Rexx tools for quick data maintenance. Data was extracted from production to test environment and loaded to test DB2 table for edition to suit to the test standards.
• Identified, analyzed and documented software program defects.
• - review job logs, identify program errors and
• - recommend program improvements or revisions to development team
• - Logged, tracked, and validated resolution of identified defects.
• Completed administrative reporting time tracking as required.

Environment: COBOL II, C, DB2, JCL, IMS/DB, CA7, ISIM, OMVIEW, UNIX, NED, SCLM, Easytrieve, SAS, CICS, JMR, Niku Project Workbench, VSAM, TSO, OS/2, ISPF, SDF, FILEAID, COOL:Gen, XPEDITER, TPM, MVS.

Confidential

Title: Production Support Analyst

Responsibilities:

• Monitored the daily batch schedule in all the 3 companies Dayton's, Target and Mervyn's using CA7.
• Solved production abends and scheduling problems with the batch jobs.
• Consulted with PSRs on the resolution of the production problems and coordinated with Ospec for the execution of problem resolution.
• Analyzed existing programs in COBOL, DB2, Telon, C, IMS, CICS, Cool: Gen with performance tuning perspective.
• Prepared low level specifications and did enhancements to the programs. Decreased run times of the many long running critical programs.
• Did Analysis, Coding and Unit testing of service requests by prioritizing daily inflow of tickets using Tivoli Problem Management bucket.
• Did Impact analysis for the new business strategies on the areas interacting with other systems.
• Created very detailed interface data, batch flow diagrams with HTML links.
• Fixed the data, scheduling problems and file fixing of production batch jobs for the smooth functioning of the business.
• Reduced production problems from over 90 per month to less than 6 per month. Metrics were regularly collected and presented to the project management.
• Involved in the team incorporated the Mervyn's processing logic to Target's information systems so as to make it possible for both the companies to use one information system.
• Developed Rexx tools for quick data maintenance.
• Fixed Code for issues and wrote new modules using COBOL/ DB2, Cool: gen, COBOL/IMS, C, Easytrieve, Telon skills.
• Did maintenance and support of 60 non-critical systems spanning all the three companies and introduced further enhancements to the existing functionalities.
• Received one of the two yearly service awards for stabilizing APX system.
• Provided training on accounts receivable, audit system's business process for all involved in the team.

Environment: IBM ES9000, WINDOWS NT, MVS, OS/390, COBOL, C, JCL, PLATINUM, NED, DATAVANTAGE, CICS, REXX, EZTRIEVE, IMS DB, DB2, FOCUS, VSAM, Softech, Abendaid, JMR, Insync, TPM, CA7, Info/x, ONCALL, MVS/COOL: GEN 5.1, TSO/ISPF