SUMMARY

• Around 7 years of extensive IT experience understanding and participate in phases of Software development life cycle: system, database, design,functional, business and data analysis using Access, Oracle 11g/10g/9i, SQL, SQL*Plus, TOAD, SQL Navigator and SQL on Windows platforms.
• Good Knowledge in Data modeling, Data warehouse Design, Development and Testing using ETL for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP).
• Knowledge in ER Modeling, Dimensional Modeling (Star Schema) and Data Warehousing
• Experience in Data Cleansing, Data Conversion, data validation and System Testing
• Proficient in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
• Data Acquisition strategies to extract data from different source systems, created data mappings using different transformations and executed workflows for data loads to target systems.
• Experience in SQL and Good Knowledge in PLSQL programming. Extensively used Quest tools like TOAD.
• Experience Creating Data Reports and Graphical Reports using Excel (Pivot Tables, Look - Up tables Functions, Formulas), MS Access
• Good communication and presentation skills. Experienced in working with business users as well as senior management.
• Excellent analytical, communication skills with clear understanding of business process flow, SDLC life cycle. Quick starter with ability to master and apply new concepts. Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.

TECHNICAL SKILLS

Programming Languages: SQL, PL\SQL

DBMS: Oracle 9i/10g/11g, DB2, Netezza, MS Access

Analysis/ Modeling Tools: Erwin, MS Visio

Utilities: SQL*Plus

Operating System: Mainframes, Windows Vista, UNIX, Sun Solaris, AIX

Tools: TOAD, MS Office Tools.

ETL Tools: Data stage 8.1

PROFESSIONAL EXPERIENCE

Confidential, IL

Data Analyst

Responsibilities:

• Interacted with End user community to understand the business requirements and in identifying data sources.
• Closely worked with Business Users and acted as the source for IT with the complete business knowledge of the Projects.
• Conducted several UAT sessions with Business people.
• Understood the Business requirement documents and involved in the development of Logical data model from the business requirement
• Involved in gathering functional requirements interacting with Business Analyst.
• Also acted as the Business Analyst of the team creating the mock-up’s based on the business requirements for different projects.
• Provided analysis documents for initial programs to migrate data sources from Flat files and source databases to Oracle system.
• Prepared documentation for all the analysis done and extensively used MS Office to prepare presentations.
• Performed data mapping document from source to target and data loading
• Performed extensive Data Analysis and Data Validation by writing SQL scripts
• Worked closely with offshore team to help them understand the system to analyze the data as part of my role.
• Developed ad hoc queries to generate reports and involved in unit testing of ad-hoc reports
• Efficient in all the faces of the SDLC, coherent with data cleansing, data conversion, data profiling.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms and documented the Purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.

Environment: Oracle 11g /10g,SQL, TOAD, MS Access, Data stage 8.1, Aginity Netezza MS OFFICE, DB2.

Confidential, PA

Business Data Analyst

Responsibilities:

• Gathered business requirements through interviews, surveys and observing from account managers and UI (User Interface) of the existing system.
• Prepared High Level Logical Data Models and BRDs (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.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards. Conducted Design discussions to come out with the appropriate Data Mart.
• Designed different type of STAR schemas like detailed data marts and Plan data marts, Monthly Summary data marts using Erwin with various Dimensions Like Time, Services, Customers and various FACT Tables.
• Involved in the integration of data coming from different sources.
• Provided architecture/development for initial load programs to migrate production databases from Oracle data marts toTeradatadata warehouse.
• Mapped the data between Source and Targets.
• Created data model for the star schema using Erwin, created DDL scripts for static dimensions.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Designed and Developed Oracle database Tables, Views, Indexes with proper privileges and Maintained and updated the database by deleting and removing old data
• Imported millions of records from .CSV files .TXT files using SQL * LOADER and Test Importer.

Environment: Oracle 9i/10g, SQL, ERWIN, Teradata, HTML, TOAD, SQL * LOADER, MS OFFICE.

Confidential, Chicago, IL

Data Analyst

Responsibilities:

• Performed analysis, review, and estimation of client requests; prepared and reviewed system requirements and documentation
• Produced functional specifications and led weekly meetings with developers and business units to discuss outstanding technical issues
• Wrote Functional requirements for designing data marts that were used as the source for the various reporting systems in the company.
• Used Informatics to develop ETL to extract from external data source (Oracle, Excel file)
• Conducted JAD Sessions with the subject matter experts, stakeholders and other management teams in the finalization of the User Requirement Documentation.
• Performed Data Modeling using Erwin by creating logical models of the database system.
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.
• Worked with the DBA and developers to identify bottleneck and performance issues of the ODS population.
• Created Data Flow Diagrams and Process flow diagrams for various load components like FTP Load
• Used MS Visio to represent system under development in a graphical form by defining use case diagrams, activity diagrams and workflow diagrams.
• Conducted review meetings with development, QA and data management team to communicate business requirements.
• Code review for Data Extraction, Data Mapping and Data Conversion for various application and processes.
• Worked closely with quality assurance and development teams to clarify and understand the functionality to resolve issues and provide feedback in terms of the test matrices and to nail down the bugs.
• Engaged with onsite/off site team model to fulfill the business needs.

Environment: MS-Office, MS-Visio, Informatics, Oracle 9i/10g, Teradata, TOAD, Erwin, MS Access, MS-SQL, SQL, PL/SQL, UNIX.

Confidential

Data Analyst/Developer

Responsibilities:

• Confidential is software consulting firm, that supports its client’s system development, extension, customization and
• Maintenance Needs. The requirements are handled through a variety of software business applications, databases and scripting methods. As Oracle Developer involved in developing Oracle reports, PL/SQL reports, SQL
• Analyzed the business requirements of the project by studying the Business Requirement Specification
• Maintained security and data integrity of the database
• Creation of database objects like tables, views
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user
• Manuals for the new programs.

Environment: Oracle 8i, SQL, PL/SQL, TOAD.