SUMMARY:

• 8 years of Professional experience as Data Analyst including in analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehousing/ Data mart design.
• Working knowledge of Dimensional Data Modeling, Star Join Schema/ Snowflake Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling using ERWIN and MS Visio.
• Highly experienced in data mart life cycle development and ETL procedure to load data from various sources into data marts and data warehouse using PowerCenter Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor. Extensively worked with Informatic mappings, sessions and workflows.
• Designing, Installing & Configuring core Informatica MDM Hub components, Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD & Data Modeling.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring.
• Experience in Real Time Data integration using Informatica Power Exchange Change Data Capture (CDC) technique.
• Worked on DataStage tools like DataStage Designer, DataStage Director and DataStage Administrator.
• Proficiency in leading ETL & DI projects involving ETL tools, including INFORMATICA PowerCenter primary databases as Teradata, SQL Server, Oracle & DB2.
• Extensive experience in conducting Market research, Feasibility studies, Data Analysis, Data mapping, Data warehouse, Business Intelligence, Data Warehousing and Business Architecture, Master Data Management, Reference Data Analysis, System Analysis, Gap Analysis, and Risks Analysis, Supply Chain Management.
• Expertise in Data management, Data Quality / Audit - Balancing / RI frameworks, Purge strategies, Volumetric and Capacity planning.
• Experience working Business Process Analysis, Business system Management and Requirements, D ata Extraction, Data Cleansing, Data Profiling, Data Consolidation, and Data Quality for various business data feeds.
• Well versed with several types Software Development methodologies- Water fall, Agile, RUP, Iterative and extreme Programming.
• Experience in Software QA and Testing Methodologies, verification and validations in all phases of the SDLC.
• In depth, technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
• Written XSLT scripts for various XML needs and used XPath, XQuery for data retrieval from XML documents.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Designed Source to Target Mapping documents with the business rule transformations to load the data into Date Warehouse from multiple source systems.
• Understanding of the ETL concepts especially various components of Informatica Powercenter i.e. Mappings, sessions, workflows.

TECHNICAL SKILLS:

DBMS Programming Languages: PL/SQL (Oracle), T-SQL (SQL Server)

SQL Interpreters: Toad, SQL Developer, SQL Plus, SQL Loader

Scripting Languages: MS-DOS, Bash, Korn

Operating Systems: Windows, Unix

ETL tools: Informatica Powercenter, SSIS, AB Initio

Data modeling: Sybase PowerDesigner / IBM Data Architect

BI & Reporting tools: Business Objects, Cognos, SSRS, Crystal Reports

MSOffice Package: Microsoft Office (Windows, Word, Excel, Power Point, Visio, Project).

PROFESSIONAL EXPERIENCE:

Confidential, Las Vegas, NV

Sr. Data Analyst

Responsibilities:

• Used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Worked in Informatica version-based environment and used deployment groups to migrate the objects.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplets Designer and Mapping Designer.
• Developed the mappings using needed Transformations in Informatica tool according to technical specifications.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Validated data using Informatica Data Explorer (IDE) & performed Proof of Concept for Informatica Design Quality (IDQ).
• Analyzed existing database schemas and designing star schema models to support the users reporting needs and requirements to develop Data Mart from Oracle tables.
• Developed initial & incremental data Conversations, validations and loading in Informatica using Update strategy transformation to load data into Oracle databases.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Developed High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models.
• Helped with data modeling and defining the conceptual and logical model of the data warehouse.
• Led the team in coding, testing, performance tuning in developing Informatica mappings and workflows.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Designed and developed, Use Cases, Activity Diagrams, Sequence Diagrams, Visio and Business Process Modeling.
• Evaluates data mining request requirements and help develop the queries for the requests.
• Participated in sessions with management, SME, vendors, users and other stakeholders for open and pending issues Involved in reviewing/ analysing Business Requirement Documents/Functional specifications/use cases.
• Worked with Business Analysts, developers while reviewing the Business Requirement Documents and when there are enhancements in the applications.

Confidential, St. Louis, MO

Sr. Data Analyst

Responsibilities:

• Used Informatica Powercenter for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Involved in ETL design, development and maintenance using oracle SQL, PL/ SQL, SQL Loader, Informatica Powercenter 9.x.
• Created mappings using Designer and extracted data from various sources, transformed data per the requirement.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a Star Schema.
• Used Informatica PowerCenter 9.1 for extraction, loading and transformation (ETL) of data into the target systems.
• Led and mentored the efforts of data quality completeness initiative for Informatica based ETL architecture.
• Developed Informatica Mappings using Aggregator, SQL Overrides in Lookups, source filer usage in source qualifiers, and data flow management into multiple target using Router.
• Processed prime Members centric claims using Master Data Management initiatives using Informatica Master data management and data quality product.
• Created sessions and extracted data from Various Sources, transformed data per the requirement and loading into data warehouse.
• Fixed the issues while getting the data loaded in stage and base tables and worked with Informatica Support.
• Developed Unix shell scripting, Pl/SQL processes (Triggers, functions, procedures, packages), AB Initio ETL jobs, Business Objects reports and universes.
• Generated Data profile reports using Data explore in Informatica to understand source and target data which is processed thru ETL processes.
• 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 analyse and document business data requirements.
• Performed tuning heavy queries and optimizing Informatica PowerCenter workflows and Stored procedures.
• Documented and evaluated test cases/test results/feasibility study of various ETL tools like DataStage/ Informatica.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Gathered detailed business and technical requirements and participate in the definitions of business rules and data standards.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Conducted user interviews, gathered requirements, analysed the requirements by using Rational Rose, Visio and Requisite pro - RUP.
• Prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Created Informatica jobs, sessions, workflows to load organization related fact and dimension tables.
• Utilized Informatica IDQ to complete initial data profiling and matching/ removing duplicate data .

Confidential, Plano, TX

Data Analyst

Responsibilities:

• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Designed and developed complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications.
• Tested and Validated the Informatica mappings against the pre-defined ETL design standards.
• Generated weekly and monthly report Status for the number of incidents handled by the support team.
• Verified the data quality or data validation through Informatica data validation option tool (DVO) and Data Quality (IDQ).
• Designed, developed and improved complex ETL structures using Informatica to extract data from Oracle, Sybase and transform and load data into Oracle data warehouse, and flat files based on business requirements.
• Created of Sessions and executing them to load the data from the source system using Informatica Workflow Manager.
• Analyzed raw data, drawing conclusions & developing recommendations. Writing SQL scripts to manipulate data for data loads and extracts.
• Performed daily system checks. Data entry, data auditing, created data reports & monitored all data for accuracy.
• Used Informatica PowerCenter workflow manager to create sessions, workflows and worklets to run with the logic embedded in the mappings.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Used Informatica PowerCenter Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Coordinated with QA team and the Informatica development groups to support end-to-end testing in term of new release code from development to production.
• Interacted with business users effectively to understand precise and accurate requirements.
• Provided clarifications to offshore team about technical specification documents including data transformation and business rules.
• Worked with IT and project team to develop release schedules that's consistent with production runs.
• Manipulated data for analysis using SQL in Oracle database; join multiple tables and group data .
• Wrote SQL queries using joins and aggregate functions from scratch to validate ETL data transformations from source to target for data warehouse testing. Provide status during stand-up or scrum meetings and host triage call meetings.
• Participated in the planning and execution of the UAT efforts. Provide guidance in writing test cases, developing test scenarios and test data .
• Performed database validation, data analysis and prepare test data or test data conditioning for all test.
• Devised and implemented a Business Intelligence technology roadmap for a global organization, set-up BI environment utilizing Oracle OBIEE BI tool on the front-end and Oracle 11g, and Informatica ETL tool on the back-end.
• Facilitated JAD sessions and provided data architecture and project design reviews and technical direction for Analytical reporting, KPI, dashboards, scorecard metrics, and ad hocs needs.
• Performed Business Data Analysis in an evolving data environment. Extracted and analysed data, patterns & related trends with the subsequent ability to synthesize data into information consumable to senior business decision-makers.
• Developed PL/SQL Stored Procedures, Functions, Triggers, Packages, Constraints, Views and Fine-tuning them.
• Used SQL to test various reports and ETL load jobs in development, QA and production.

Confidential, Los Angeles, CA

Data Analyst

Responsibilities:

• Provided Data modeling, Database Architecture and designed the Database using ERD and Database using Erwin.
• Scheduled and run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Involved in requirement gathering, data analysis, design, development, testing and systems implementation.
• Independently worked closely with data modellers and data analysts doing design work to hand off data requirements and facilitate the transition from requirements to design including capturing of data consumption requirements and managing traceability.
• Analyzed source and profile data related to business requirements and match up to business names and definitions and work with business and technical metadata.
• Designed reports in Access, Excel using advanced functions not limited to Vlookups, pivot tables, formulas
• Involved in migrating Informatica ETL application and Database objects through various environments such as Development, Testing, UAT and Production environments.
• Identified the stake holders, priorities the task items which could be delivered in the next cycle as per part of engagement.
• Identified ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design.
• Used Informatica client tools to extract data from different sources like flat files and oracle.
• Created Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Defined Mapping parameters and variables and Session parameters per the requirements and performance related issues.
• Involved in error checking and testing of the ETL procedures and programs using Informatica session log.
• Developed and maintained Informatica workflows, Oracle PL/SQL, and Linux shell scripts.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Developed UNIX Shell scripts to extract and convert data from different sources into the databases.
• Performed tuning in Informatica PowerCenter at the Target Level, Source level, Mapping Level, Session Level, and System Level.
• Wrote UNIX Shell Scripts for Informatica Pre-Session, Post-Session and Autosys scripts for scheduling the jobs (work flows)
• Designed and Implemented the Data Mart for complex reports and queries using SQL Reporting Services and Analysis Services. Use modern ETL techniques and Erwin to integrate data from disparate systems maintain complex data integration systems using SQL Server Integration Services.
• Developed Extraction, Transformation and Loading (ETL) processes to acquire & load data from internal and external sources.
• Provided analysis of data sources to establish information relationships and to develop integration solutions for the data warehouse.
• Created ETL workflows and mappings to provide data migration and integration from production (Oracle) database into warehouse DB (Teradata) using Informatica Powercenter tool.
• Developed new models in the data warehouse as per any new downstream requirements.
• Involved in extensive data analysis and data profiling of various source system and accessing the impact on the existing data warehouse and designing solution for incremental extraction of data on daily basis.
• Developed conceptual data model in data warehouse for specific treasury business needs.
• Worked with Informatica mappings, workflows and sessions for the data warehouse which includes building logic for a normalized database, de normalized enterprise data warehouse and building logic for staging databases.
• Played a critical role in requirement analysis, data modeling and implementation of the whole outbound interface of the data warehouse solution that required seamless communication between divergent teams.
• Tested, modified, debugged, documented and implemented of Informatica mappings.