SUMMARY:

• Over 7 years of professional IT experience in Data Analysis/Modeling for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Experience in understanding the business needs and gathering user requirements by conducting and participating in JAD sessions, interacting with end - users and training them on the applications developed for the organization. Participated in Infrastructure requirements using ITIL.
• Worked with Data Center team and was responsible for collecting, preparing and cleaning data before or after it is collected in a database.
• Expert knowledge in SDLC (Software Development Life Cycle) and was involved in all phases in projects.
• Experience in Design, Development and implementation of the enterprise-wide architecture for structured and unstructured data providing architecture and consulting services to Business Intelligence initiatives and data driven business applications. Services in overcoming traditional IT show stoppers for managing information on an enterprise level.
• Have experience in Dimensional Modeling using Star and Snowflake schema methodologies of Data Warehouse and Integration projects (Worked on UNIX & Mainframe)
• Extensively worked on Confidential tool with all features like REVERSE Engineering, FORWARD Engineering, SUBJECT AREA, DOMAIN, Naming Standards Document etc.,
• Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering Confidential diagrams, analyzing data sources and creating interface documents.
• Experience with Business Process Modeling, Process Flow Modeling, Data flow modeling
• Experience in working with creating ETL specification documents, & creating flowcharts, process work flows and data flow diagrams.
• Worked with ETL processes to transfer/migrate data from relational database and flat files common staging tables in various formats to meaningful data in Oracle and MS-SQL.
• Performed extensive data cleansing, data manipulations and date transforms and data auditing.
• Experience in using Oracle, SQL*PLUS, SQL*Loader, TOAD, Win NT/2003.
• Developed database objects like PL/SQL packages, Oracle tables, stored procedures, triggers that are used for meeting the business objectives.
• Developed Data dictionary and maintained Metadata for each model.
• Used the tools like TKPROF and SQL*Trace to tune the query performance.
• Used various Hints and Database links to write effective programs across various databases.
• Knowledge in using EXPLAIN PLANS for query optimization.
• Coordinated with other developers in tuning long running SQL queries to enhance system performance.
• Involved in debugging and developing exception-handling procedures whenever required
• Extensive knowledge in software testing methodology and developing Test Plans, Test Procedures, Test Case Design and Execution, Modification Requests.
• Strong in conceptualizing and communicating enterprise data architecture frameworks for global enterprises for inter operation of data warehouses, middleware, and web applications.
• Good documentation skills and was involved in making functional and technical documentation.
• A strong team member with good Communication and Analytical skills.

TECHNICAL SKILLS:

Data Modeling Tools: Toad, MS-Visio

Reporting Tools: Business Objects, Crystal Reports

Programming Languages: Oracle PL/SQL,MS-SQL,VB 6.0, VB, ASP.NET

Databases: Oracle, SQL Server, MS-SQL, MS-Access

Network Security Technologies: Ethernet and VLAN - WINS, DHCP, DNS, Firewalls, Active Directory Services, TCP/IP, FTP, Telnet, VPN, TAS

Virtual Environments: Citrix Terminal Server v 3.x and VMware v2.5.2 Deployment

Web technologies: HTML, DHTML, XML

Scripting Languages: VBScript, JavaScript, UNIX Shell Script.

Application Servers: Web Sphere 6.0.

Web Servers: IIS 6.0, Apache Tomcat 5.5, Personal Web Server

Framework: DOTNET

Configuration Tools: Visual Source Safe (VSS)

Operating Systems: Windows-95,98,2000/XP/NT/Vista, Advanced-Server 2003, Unix v5.0, Linux-Red Hat v5.0 and VAX/VMS v5.2

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Business Data Analyst

Responsibilities:

• Involved with Business Analysts team in requirements gathering and in preparing functional specifications and changing them into technical specifications.
• Conducted and participated JAD sessions with the Project managers, Business Analysis Team, Finance and Development to team gather, analyze and document the Business and reporting requirements.
• Analyze the Business information requirements and research the OLTP source systems to identify the measures, dimensions and facts required for the reports.
• Responsible for using different analytical techniques in collecting, preparing and cleaning data before or after it is collected in a database.
• Involved in making screen designs, Use Cases and ER diagrams for the project using Confidential and Visio.
• Coordinated with the Business Analyst and prepared Logical and Physical Data-models as per the requirements
• Designed and developed the data dictionary and Meta data of the models and maintain them.
• Coordinated with DBA on data base build and table normalizations and de-normalizations
• Developed triggers, stored procedures, functions and packages using cursors and ref cursor concepts associated with the project using Pl/SQL
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary evolve and change during the project
• Used various features of Oracle like Collections, Associative arrays, Bulk processing methods to write effective code.
• Generated user and technical documentation for individual processes
• Developed the performance tuning of the database by using EXPLAIN PLAN, TKPROF utilities and also debugging the SQL code.
• Identified and streamlined complex queries which were causing iterations and effecting database and system performance
• Identified database inconsistencies like orphan objects, duplicate objects and coordinating with various teams to decide on the appropriate action to be taken.
• Coordinated in database changes needed for the front end development team, explained and guided them on the database architecture and objects for effectively accessing the database.
• Work directly with non-IT business analysts throughout the development cycle, and provide post-implementation support, once developed including investigation of data and report issues identified by customers.
• Maintain change log for each data model. And solve the production issues by debugging the code.

Environment: Confidential, Oracle, MS-SQL Server, MS-Visio, MS Office, BO, Crystal Reports 2008

Confidential, Glendale, CA

Business Analyst / Data Analyst

Responsibilities:

• Worked extensively along with business analysis team in gathering requirements and understanding the work flows of the organization
• Involved in preparing Business model diagrams, flowcharts, process/work-flow diagrams, data flow and relationship diagrams using MS-Visio and data-models showing process mappings, screen designs, use case diagrams
• Implemented Dimensional model for the Data Mart and responsible for generating DDL scripts using Confidential
• Prepared documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Generated user and technical documentation for various processes in the project
• Designed Metadata Repository to store data definitions for entities, attributes & mappings between data warehouse and source system data elements.
• Worked interactively with Business Analyst in understanding and manipulating changes in business requirements
• Coordinated with DBA for implementing business rules, database changes and specifying user-roles for various processes in the project
• Extensively used oracle packages, stored procedures, sequences, ref-cursors, dynamic queries, UTL files, bulk inserts, exception handling, DB Links etc.
• Involved in data profiling and data cleansing to eliminate data redundancy and enhance performance of the database.
• Involved in auditing, tuning and optimizing databases using TKPROF and SQL*Trace tools for efficient performance.
• Involved in data migration of various data sources from several platforms to Oracle
• Have coordinated multiple small and large Data Integration, Data warehousing and Oracle development projects.

Environment: Confidential 4.0, Oracle, MS-SQL 2000, Visio, MS-Excel, MS-Access

Confidential, Madison, WI

Business System Analyst

Responsibilities:

• Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using Confidential
• Validated and updated the appropriate Logical Data Models to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change
• Generated user and technical documentation for processes in all phases of the project
• Conducted all data model reviews as appropriate during project lifecycle
• Coordinated with project DBA to update the physical database models to in corporate design changes (table de-normalization, type-code column additions, etc.) as they occur
• Involved in data profiling and cleansing to remove redundant data
• Provided input to resolve data limitation/constraints and issues
• Developed stored procedures, triggers, functions and packages in PL/SQL
• Reviewed processes and provided input into project plan
• Extensively used tracing methods to troubleshoot various time consuming queries.
• Helped in data migration from various applications to Oracle and MS-SQL 2000/
• Participated in development, UAT testing and implementation of pilot and real-time for the application development
• Provided other data analysis services, as required

Environment: Confidential 4.0, SQL Server 2000, MS-Excel, Visio, MS-Access, Oracle, SQL, PL/SQL

Confidential, Atlanta, GA

Data Analyst

Responsibilities:

• Worked as Data Modeler, Involved in requirements gathering to study the existing system which will help in the designing process for the proposed systems.
• Gathered requirement for the management of user’s credentials and performed gap analysis and facilitated JAD sessions.
• Assessed Credit Risk strategies with various internal credit tools and implemented Basel II strategies to augment Credit availability.
• Created an Enterprise data model for the company. Systems within project scope were marketing, sales, customer care, service order processing, billing, etc.
• Produced functional decomposition and logical models into an enterprise data model.
• Analyzed the Business Requirements, Functional Specification Documents to prepare conceptual model.
• Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the logical and physical data model.
• Modeled a database to store customer demographic and other data like click stream data, Meta data.
• Performed Data Analysis using procedures and functions in PL/SQL.
• Worked on Reverse Engineering the data models in Confidential .
• Designing by effective data modeling, implementing database standards and processes.
• Was responsible to test the metadata and synchronize the data.
• Developed Logical data model using ER diagrams in Confidential .
• Designed and implemented a physical data model in Confidential to handle marketing strategies and to satisfy reporting needs.
• Produced functional decomposition diagrams and defined logical data model.
• Created SQL tables with referential integrity, constraints and developed queries using SQL, SQL*PLUS and PL/SQL.
• Conducted team meetings and JAD sessions with the SMEs, stakeholders and other management teams.
• Created a DDL scripts based on physical design of the central relational database.

Environment: - Confidential 4.1, Informatics Power center, Oracle 9i, Sybase, Toad, Windows, UNIX Shell Scripts, MS-Visio

Confidential, Phoenix, AZ

Data Modeler

Responsibilities:

• Involved in understanding the need and gathering business requirements for developing a client-server based intranet application involving N-tier business logic at client-end, middleware and server-end.
• Involved in coordination with development group and preparing prototype and interactive screen designs, use cases, process work-flow and data flow diagrams
• Participated in developing web-based modules using VB
• Have extensively used datasets and connect to database using ADOs
• Developed triggers, stored procedures and functions using complex SQL Queries
• Developed several customized reports to analyze the emergency and frequency of calls received
• Prepared user and technical documentation on the applications developed
• Involved in testing and implementation of the application
• Involved in the creation of schema objects like indexes, views, stored procedures and synonyms.
• Involved in the analysis of how the purchase order process was organized. Created SQL tables with referential integrity and developed queries using Pl/SQL Developer.
• Involved in writing Triggers which internally called procedures and functions.
• Involved in testing the database for queries that were generated and handled the performance issues effectively.
• Involved in testing and documenting the entire technical process.
• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Consulted with Subject Matter Experts and core team on new data definitions and other extensions to the existing strategies.
• Generated reports using Crystal Reports.
• Derived the relationships among the tables by analyzing the stored procedures

Environment: - Confidential, Visio, MS-SQL 2000, VB, ASP