SUMMARY:

• Around 8 years of IT Experience as a Data Analyst, Business Analyst, and Data Modeler especially in Data Warehousing and Business Intelligence applications.
• Strong skills in using ETL, Data stage tools like Informatica Source Analyzer, Data Warehousing Designer.
• Worked in Agile Environment as an Oracle Developer.
• Strong knowledge in Oracle Cursor Management, Exceptional Handling, REF - Cursor.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
• Good Data Warehousing concepts including Meta data and Data Marts tuning and query optimization using various types of hints, partitioning, bulking techniques and indexes.
• Proficient in Data modeling using Erwin and logical and physical database designs.
• Good knowledge in data flow diagrams, data dictionary techniques, Entity Relation modeling, database normalization.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance.
• Comfortable working with unit testing, debugging and deployment of applications. Implemented and supported test and production environment.
• Experience in Analysis of ETL Applications using Teradata technologies.
• Extensive experience with object oriented analysis and design and developing use-case models.
• Ability to meet deadlines and handle pressure coordinating multiple tasks.
• Used Informatica mappings for truncating the data in target tables at run time.
• Experience of working on development focused projects with an understanding of the software development life cycle and in an Agile/Scrum environment.
• Worked with risk management team to ensure complete, timely and accurate pricing for existing and new securities.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience in writing Technical design documents and developing unit test documents.
• Supported integration and end user testing with efficient defect management process.
• Experienced in Unit testing and Integration Testing with excellent debugging skills.
• Strong Knowledge on oracle architecture and database design.
• Excellent conceptual knowledge of Oracle 9i/10g.
• Worked on production support, troubleshooting the application and involved in bug fixes.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, T SQL, XML, HTML

Operating Systems: Windows (NT/XP/95/98/2000), UNIX, Mac OS.

Databases: Oracle 10g/9i/8i, SQL Server 2000/2005/2008, PL/SQL, SQL*Plus, SQL*Loader, IBM DB2, MS SQL Server 2000/7.0/6.5, MS Access 2000.

Data Modeling Tools: Erwin,Rational Rose, MS Visio, ER Studio

Reporting Tools: Business Objects 5.x / 6.5, Microstrategry, Crystal (6, 8, and 11), OBIEE Business, Intelligence Enterprise edition 10.3.4.1

Web Development Tools: Flash 5.0, Adobe Photoshop

ETL Tools: Informatica Power Center 8.6/7.1/6.2

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

Sr. Data Analyst

Responsibilities:

• Gathered the requirements document and analyzed the process.
• Performed weekly oracle database migrations from development databases to staging database
• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems.
• Gathering development requirement from client's functional team and from functional design specification documents.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop mappings in the Informatica Designer.
• Used Crystal Reports to track logins, mouse overs, click-through, session durations with SQL database of customer information.
• Worked with internal architects in the development of current and target state data architectures
• Involved in defining the source to target data mappings, business rules and data definitions.
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Created staging and Dimensional data models in Erwin based on the requirements and adhere to enterprise data warehouse standards.
• Analyzed the reporting requirements from the business users and convert them into technical specifications.
• Worked as a part of the technical team in understanding the business requirements and translating them to technical documents.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Analyzed the existing structures, ETL, database objects, Server infrastructure for the EDW and Data mart and then created system stabilization tasks to improve the data quality, avoid ETL failures and improve performance.
• Worked with the business analysts and analyzed various sources for requirements gathering, business analysis, testing, metrics and project coordination.
• Extensively used error and exception handling techniques.
• Used different transformations such as Merge, Join, Filter, Lookup, and Aggregator using Informatica in ETL to transform the data.
• Created Indexes on Tables to improve the performance by eliminating the full table scans and views for hiding the actual tables to eliminate the complexity of the large queries
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Prepared and distributed Escalation Report and Daily Metrics through SAP (Business Object Web Intelligence) for the manager for Business improvement purpose.
• Worked to ensure high levels of data consistency between systems.
• Worked with the global technical data community and assist with implementing the global data management strategy.
• Involved in developing many Dash Boards for home, rental and auto insurance.
• Worked with Oracle SQL Developer to develop the SQL scripts.
• Developed PL/SQL programming that included writing Views, Stored Procedures, Packages, Functions and Database Triggers.
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Created action plans to track identified open issues and action items related to the project.
• Prepared analytical and status reports and updated the project plan as required.

Environment: Oracle SQL Developer, MS Access, TOAD, Teradata, Informatica Power Center 4.7, ER/Studio Windows XP, AML, Excel, Business Objects

Sr.Data Analyst

Responsibilities:

• Gathered requirements, analyzed and wrote the design documents.
• Used principles of Normalization to improve the performance.
• Providing End-user Training and documentation for customer reporting services.
• Attended JAD sessions and created reports for Budgeting, Finance and Project Management departments of Pima County.
• Participated in the Analysis, Design and Development Phases of report development, performance tuning and production rollout for every report of Information Technology Department.
• Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables.
• Expertise in SQL and strong knowledge on Oracle architecture and database design.
• Analyzed the present data warehouse logical model and developed strategies for Extraction, Transformation and Loading (ETL) the data into the data warehouse.
• Defined and processed the facts and dimensions.
• Created DDL scripts for static dimensions and ETL mappings using Informatica.
• Experience in Data Transformation and data cleansing.
• Utilized Erwin for reverse engineering the database from DDL scripts.
• Assisted the Data Acquisition Architect to ensure the Data Architecture is applied properly
• Store procedures, User defined functions, Views for complex business logic.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages.
• Assured and checked the quality and the integrity of the data received from the store collectors.
• Worked with Technical and reporting team to develop ETL jobs as per the technical specification documents.
• Wrote conversion scripts using SQL, Stored Procedures, Functions and Packages to migrate the data from the SQL server database to Oracle database.
• Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Involved in resolving the data type inconsistencies between the source systems and the target system using the Mapping Documents.
• Identified the objects and relationships between the objects to develop a logical model in Erwin tool.
• Translated the logical model into physical model using Forward Engineering technique in Erwin tool for both OLAP and OLTP systems.
• Created Data Definitions and help maintain Metadata repository.
• Involved in the Analysis, Design, Coding and Testing of the application.
• Involved in developing packages for implementing business logic through procedures and functions.
• Strong working experience in use of SDLC methodologies, standards and Gathering the Requirements, Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading.

Environment: PL/SQL, SQL Server 2008,Oracle 10g,TOAD,Crystal Reports, MS SQL, Teradata, Informatica Power center, Erwin r7.3, Windows XP, Excel.

Data Analyst/Developer

Responsibilities:

• Knowledge of Normalization, and data transfer, documentation, preventive maintenance, codereview, automation, store procedures and triggers etc.
• Created database objects like tables, views, procedures, packages using Oracle tools likeSQL* Plus.
• Applying constraints and writing triggers to apply the business rules. Involved in handling errorand transaction processing in the procedures.
• Facilitated transition of logical data models into the physical database design for data marts and recommended technical approaches for good data management practices.
• Performed the activities necessary to support the standardization of facts and dimensions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large numberf tables.
• Extracted data from Flat files and transformed it in accordance with the Business logic mentionedby the client.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Involved in developing packages for implementing business logic through procedures and functions.
• Documented data content, data relationships and structure, and processes the data using InformaticaPower Center Metadata Exchange.
• Turned SQL queries to make use of data base indexes, and analyzed the data base objects.
• Developed data mapping documents between Legacy, Production, and User Interface Systems
• Used Materialized views in order to improve the performance.
• Designed and built an integration solution that merged Oracle tables from two separate Oracle databases using PL/SQL.
• Worked on Performance tuning and monitoring of database.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Conducted logical data analysis and data modeling JAD sessions, documented data-related standards.
• Assisted the DBA in converting the logical models to physical.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using OracleHints, for Rule based optimization.
• Created entity relationship diagrams, functional and data flow diagrams. Developed the data mart for the proposed project.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.

Environment: Oracle 9i, SQL, PLSQL, SQL*Loader, Informatica, PL/SQL, MS SQL,TOAD, SQL Server 2008,Ms Visio, Business Objects, Windows NT, Linux,UNIX

Data Analyst

Responsibilities:

• Analyzed requirements, designed, developed, deployed and documented software components.
• Designed ER diagram using Erwin, to set the logical and physical relationships of database.
• Created database Triggers for the security purposes.
• Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Creation of database objects like tables, views, Indexes on tables, synonyms, materialized views, stored procedures, packages using oracle tools.
• Designed and developed Oracle SQL scripts for data import/export.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Used Erwin for developing data model and forward engineer the data model.
• Reverse engineer the data base in to physical data model by using Erwin.
• Developed entities and relationships using Sybase Power Designer.
• Wrote the test cases and technical requirements and got them electronically signed off.
• Created new reports based on requirements.
• Developed Data Migration and cleansing rules for the integration architecture.
• Developed data mapping documents between legacy, production and user interface systems.
• Designed different type of STAR schemas like detailed data marts, Plan data marts,
• Used Erwin for monthly summary data marts and inventory data marts.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.

Environment: Oracle database 9i, Forms 6i, Erwin, Windows NT, ER-Win 4.0, Teradata, UNIX, SQL Loader, Rational Rose 2000, Jasper.