SUMMARY

• 8+ years of IT experience with expertise in Data Analysis/Data warehousing/Data Modeling.
• In - depth domain knowledge of Telecom and Networking Industry.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML).
• Strong business analysis skills and an understanding of the software development life cycle (SDLC) utilizing Rational Unified Process (RUP).
• Experience designing and developing SQL statements and queries for Oracle Sybase and SQL Server 2000 database.
• Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server 2000.
• Involved in installation and configuration of DAC, Informatica and OBIEE.
• Extensive experience in Sybase Database Servers, developing and maintaining automated software used to monitor the database
• Experienced in conducting requirement analysis, use case design, designing test plans and developed database schemas based on the logical models.
• Extensive experience in configuring data mapping between different Databases.
• Ability to gather business and technical requirements from both formal and informal sessions utilizing a variety of software tools including, Use Cases and the Rational Unified Process.
• Extensive experience in conducting Joint Application Development (JAD) sessions.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Excellent experience onTeradataSQL queries,TeradataIndexes, Utilities such as Mload, Tpump, Fast load and FastExport.
• Experience in working with OBI administration tool developing metadata repository and strong experience in working as OBIEE BA analyst.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (Sequence diagrams, Collaboration diagrams, State chart diagrams, Activity diagrams), Class Diagrams based on UML using Rational Rose
• Worked extensively on user requirements gathering, gap analysis, and development of functional speculations for critical mission accomplishing projects.
• Proficient in Functionality Testing, Black Box Testing, System Testing, Integration Testing, and Regression Testing.
• Proficient in Unit Test Plans (UTP), Integrated Test Plans (ITP) Extensive experience in User Acceptance Testing (UAT).
• Expertise in Logical Modeling, Physical Modeling, Dimensional Modeling, Star and Snow-Flake schema
• Extensive knowledge of IBM and Tandem Mainframe, AS400, and ASP/Client Server
• Designed changes for Mainframe Systems and Web Based System.
• Proficient in programming languages like C, C++, Java and .NET TECHNOLOGIES
• Provided technical and functional consulting to corporate and divisional users for Cognos.
• Strong experience in Client interaction and understanding business applications, business data flow and data relations for them.
• Efficient in converting the systems database from Sybase to oracle & vice versa.
• Highly motivated, result oriented professional with a short learning curve and strong communication skills.

TECHNICAL SKILLS

Software/Hardware: ERWIN, ETL: Ascential DataStage (7.x, 6.x, 5.x), Star-Schema Modeling, Snowflake Modeling, FACT and dimension tables, Erwin 4.0, Business Objects, Erwin 4.x, C/C++, Java SE 1.4, TURBO PASCAL 7.0, VB.Net, HTML, COBOL, SQL Server, MySQL, Oracle 8i, Sybase PowerDesigner (v4 - 11), Sybase System 10, Sybase ASE (11 - 12) and Sybase ASA (6 - 9).ASP/ASP.net, PHP, Microprocessors 8085 & 8086, Unix, MVS, MS Windows/95/98/NT/2000/XP, MS DOS, MS Office 2000

PROFESSIONAL EXPERIENCE

Confidential, Columbus OH

Sr. Data Analyst

Responsibilities:

• Analyzed the existing claims process and specific business rule logic will be applied in the ACP model.
• Prepared questionnaire based on the System Analysis Performed for all entities.
• Wrote TPT scripts to load/ unload data to/fromTeradatathat includes writing a generic script as well.
• Data loading toTeradatatables using Fast load and Multi load scripts.
• Did error handling and performance tuning inTeradataqueries and utilities.
• Designed and Administered Teradata Scripts, Tables, Indices and Database Objects.
• Performed Data Warehouse Assessments using Informatica,Teradata and Data Guard
• Considered Unified Dimensional Model (UDM) using views, and Unified Modeling Language (UML) and object-oriented design.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Developed Reports & Dashboards in OBIEE Answers using different analytics views like pivot table, charts, column selector, view selector & narrative view, etc.
• Worked in mainframe environment and used SQL to query various reporting databases.
• Conducted user interviews, gathered requirements, analysed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Helped with data modeling and defining the conceptual and logical model of the data warehouse.
• Conducted extensive Joint Application Development (JAD) sessions for all business related issues.
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers.
• Prepared High Level Logical Data Models and BRD’s (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Identify customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
• Configured the Data mapping between Oracle and SQL Server 2005.
• Prepared Logical Data Models using ERWIN that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata.
• Provided data modeling support for numerous strategic application development projects.
• Documented the meeting minutes with issues of about discussed and solutions resolved.
• Gathered information and documented on Conceptual design and Technical design for phase III systems.
• Used MS Visio to create Flow diagrams and Use Case Diagrams.
• Prepared Use cases and activity diagrams for a source system using Enterprise Architecture (EA) tool.
• Created the test cases for all the Use Cases using EA tool.
• Created test scripts for all the test cases in PL/SQL.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.

Environment: Ascential DataStage 7.5, (Designer, Director, Manager, Parallel Extender) Debugger, Autosys 4.1, WinCVS 1.3, Enterprise Architect 4.5, Sybase, Toad 8.0, Erwin, TeraData, Business Objects, Windows NT 4.0,UNIX, Oracle 8i, PL/SQL, OBIEE, DOS and UNIX Sequential Files, MS Visio, MS Excel, MS Access, CSV Files, XML File

Confidential, Richardson, TX

Sr. Data Analyst

Responsibilities:

• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database.
• Initiated and led project towards automated system of intranet based ordering of marketing supplies.
• Continually improved operations by conceptualizing and implementing tools, using technology, towards efficiency and increasing productivity. E.g.: Pivot tables for expense reports, automated toolkits, scripts for batch processes, identifying and terminating redundancies in daily functions, develop centralized database for client service contracts.
• Client/Vendor interaction: Evaluated lease contracts, performed negotiations and oversaw support operations for external offices;
• Collected requirements from cross functional business community
• Studied and assessed the clients systems and business processes
• Worked on transformation logic usingTeradataqueries.
• Involved inTeradataSQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved on the basis of using defect reports.
• Conducted individual and group (JAD) sessions with business stakeholders and technical units
• Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business requirement Document
• Developed project delivery schedule, managed projects and identified resources to successful completion
• Configured pre-built reports in OBIEE Answers & created new Reports which were not provided with the OTB.
• Configured OBIEE both in Windows and UNIX environment.
• Analyzed all aspects of the order processing lifecycle, starting from initial order entry and welcome call to the first billing and designed the system in such a way that the complex orders could be easily identified and monitored
• Implemented and oversaw the ongoing execution of the ITIL/ COBIT best practice frameworks.
• Played a key role in the planning, testing, and implementing system enhancements and conversions
• Assisted Test Lead, Testers understanding business process and helped them for successful completion of Unit Testing, Integration Testing and Requirements Testing
• Played a major role in developing the Design Documents for the Developers.
• Communicated with upper management to help define requirements, designs, and develop prototypes
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams
• Streamlined clerical work processes and mapped to the automated system
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.

Environment: Ascential DataStage 6.0(Manager, Director), Business Objects, IBM DB2/UDB Universal Database Oracle 8/9i, MS SQL Server 7.0, OBIEE, Teradata, MS Visio, HTML, XML, UNIX, Windows NT, Sybase, MS Visio, MS Excel, MS Access.

Confidential, Dallas, TX

Data Analyst

Responsibilities:

• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
• Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Expanded model of multidimensional data mart practiced UDM Universal Data Models generic data models.
• Generated Surrogate ID’s for the dimensions in the fact table for indexed and faster access of data.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle andTeradata.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Used OBIEE Administration Tool for creating physical, business and presentation layers of repository.
• Drew Business Process Flow diagrams by extensively using MS Visio.
• Created RUP activity diagrams and sequence diagrams to analyse the requirements and recommend solutions.
• Created hash tables used for referential integrity and/or otherwise while transforming the data representing valid information.
• Served as a resource for analytical services utilizing SQL Server, and TOAD/Oracle.
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Enabled Proper selection of the hash table design parameters for faster table look-up.
• Created re-usable components using shared containers for local use or shared use.
• Imported and exported repositories across projects.
• Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Generated XML documents using the XML Output Stage.
• Troubleshot the designed jobs using the DataStage Debugger.
• Tuned DataStage transformations and jobs to enhance their performance.
• Assist other project teams with data analysis, data mining and data profiling as needed.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Created job schedules to automate the ETL process.
• Enhanced the job properties for performance tuning.

Environment: Ascential DataStage 7.5, (Designer, Director, Manager, Parallel Extender) Debugger, DataStage BASIC language Expressions, SQL Server, TeraData, Business Objects,Windows NT 4.0, Sybase, UNIX, Oracle 8i, PL/SQL, IBM DB2, Dbase3, Erwin, MS Visio, MS Excel, MS Access, OBIEE, XML Files, MVS, IMS.

Confidential, Warrenton, VA

Data Analyst

Responsibilities:

• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Reverse Engineered the existing ODS in to Erwin.
• Conducted meetings for the Data Modeling and Analysis.
• Enforced naming standards.
• Created the logical models and generated the physical models in the databases using Erwin.
• Involved in jobs and analyzing scope of application, defining relationship within & between groups of data, Star Schema etc
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
• Tuned the batch programs and online transactions to alleviate performance problems.
• Worked on exporting data using Teradata.
• Responsible for different Data mapping activities from Source systems toTeradata
• Developed & executed several Optimized queries in SQL on this data.
• Tested Performance & Accuracy related queries under SQL Server.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Analyzed the given source Dimensions and target Fact table structures to develop Surrogate Key tables referencing required dimensions.
• Created Hash tables referencing the Surrogate Key tables for quicker and more efficient lookup to Dimensions.
• Maintained on-going technical assistance and provided help desk support to customer’s mainframe systems software that included problem determination and resolution.
• Developed various jobs using ODBC, Hashed file, Aggregator, Sequential file, Transformer stages.
• Create prototype SQL Server 2005 Analysis Services (SSAS) cubes using the Unified Dimensional Model (UDM).
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Imported and exported Repositories across DataStage projects.
• Analyzed data with discrepancies through Error files and Log files further data processing and cleansing.
• Trouble-shooted jobs using DataStage Debugger.
• Worked on performance tuning and enhancement of DataStage job transformations.
• Summed key performance indicators using Aggregator stages as an aid to Decision Support Systems.
• Used DataStage Director run time engine to schedule and execute developed jobs and job sequences, and use Log events to monitor job progress and performance.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings.

Environment: Ascential DataStage 6.0(Manager, Director), Business Objects, IBM DB2/UDB Universal Database Oracle 8/9i, MS SQL Server 7.0, MS Visio, MS Excel, MS Access, TeraData, HTML, XML, UNIX, Windows NT, Sybase.

Confidential, Chicago, IL

Data Analyst

Responsibilities:

• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Created source table definitions in the DataStage Repository by studying the data sources.
• Generated Surrogate ID’s for the dimensions in the fact table for indexed and faster access of data.
• Created surrogate key tables to map the required dimensions.
• Created hash tables used for referential integrity and/or otherwise while transforming the data representing valid information.
• Enabled Proper selection of the hash table design parameters for faster table look-up.
• Created re-usable components using shared containers for local use or shared use.
• Imported and exported repositories across projects.
• Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
• Conducted user interviews, gathered requirements, analysed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Worked in importing and cleansing of data from various sources likeTeradata, Oracle, flat files, SQL Server 2005 with high volume data
• Troubleshot the designed jobs using the DataStage Debugger.
• Tuned DataStage transformations and jobs to enhance their performance.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Created jobs sequences.
• Created job schedules to automate the ETL process.
• Enhanced the job properties for performance tuning.
• Prepared the documentation of Data Acquisition and Interface System Design.

Environment: Ascential DataStage 6.1/5.1,Metastage (Enterprise Metadata directory), (Designer, Director, Manager, Parallel Extender) Debugger, TeraData, DataStage BASIC language Expressions, Windows NT 4.0,UNIX, Oracle 8i, PL/SQL, IBM DB2, Dbase3, DOS and UNIX Sequential Files, MS Visio, MS Access, .csv Files, XML Files, Sybase.