Devi G N Email & Phone Number

Waukee, Ia, Us

West Des Moines, Ia, Us

Des Moines, Iowa, Us

Worked closely with the database team to make the necessary model changes as pert the requirement. Used JIRA to request the changes to the team.Development of informatica jobs to perform the daily extraction, transformation and loading of data into the data warehouse.Creation and maintenance of Test Data Document for the purpose of integration and unit testing.Creating parameter file for the jobs using unix.Reviewed the ETL code, design documents and all other deliverables created by ETL team.Created and executed test cases, supported all testing activities and generated test reports based on test results.Scheduling of informatica jobs using Tivoli scheduler. Created Sisense cubes and Sisense reports.Deployment of developed code into test and production environment and providing support for few days to make sure the deployed codes are executing as expected.

Bolingbrook, Il, Us

Data analysis from all the source system to identify the attributes on which the Informatica data quality should be implemented.Modeling of Informatica MDM tables based on the data processing method.Identifying the merge and trust rule to be implemented to attain the Best version of truth.Development of Informatica MDM mapping for implementing the requirement.Performing unit testing to make sure the data are being processed as per the required rule and the correct data are being loaded in the Base objects.To provide support for the integration and QA testing to fix the issues identified during the testing phase.

Bangalore, Karnataka, In

Brentwood, Tn, Us

Worked closely with Database administrator to create the database tables, views, functions, stored procedures and packages and implemented sql scripts in Oracle 10g.Lead and guided the ETL development team and provided ongoing support during design, development and testing phases.Developed Talend jobs for loading data into Datawarehouse and Datamart and to load data from the XML files in to SAP system.Have written complex SQL queries as part of development integration testing before releasing the code for QA testing.Reviewed the ETL code, design documents and all other deliverables created by ETL team.Created and executed test cases, supported all testing activities and generated test reports based on test results.Created change request in service now during deployment phase which included deliverables such as implementation plan, rollback plan, post validation plan, support knowledge transfer documents etc.Provided production support and maintenance for each new subject area for a certain period before releasing to Prod Support team

Dallas, Tx, Us

Designed data model from to aid team in data collection to be used for Tableau visualsDeveloped Tableau reports to give visualization based on various industry-specific KPIs.Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculationHave used advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.Created weekly, monthly reports using Tableau.Developed Heat maps using MapInfo.Created various dashboards in Tableau server using various data sourceInstall upgrade Tableau server and server performance tuning for optimization.Involved in Administrator user, user groups, and scheduled instances for reports in Tableau.Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.Created best practices for Tableau report development to be followed in future for the project.Aided the development team to develop Dashboard and preparing ad-Hoc Reporting.Developed Dashboards based on the requirement with drill down, drill up and various filter to enable the dashboard based on the user login credentials.Used dynamic filters for prominent search.Developed dashboard which have the capability to report based on the selected entity.Technology: Oracle, Flat files, Tableau 9.x

London, Gb

Ensuring a quality system design which provides good system performance, an effective human-machine interface, optimal operational cost, and flexibility for future change Designed and Developed Mappings, sessions and workflows in Informatica for data migration from SAP and JDE source systems to an enterprise oracle 10g data warehouse.Provided support for the implemented code for defects and enhancements.Worked closely with users during the User Acceptance Testing phase and fixed bugs that were reported in Mercury Quality center.Created Reusable Transformations and Mapplets and used them in various Mappings to reduce the redundant work.Created complex mappings using Normalizer, Unconnected Lookup, Sorter, Aggregator, dynamic Lookup and Router transformations for populating target table in efficient manner.Performed data validation, reconciliation and error handling in the load process.Involved in the exception design and reprocessing the rejected rows to the target tables.Developed Star Schema Models, Snow-Flake Models, FACT and Dimensions Tables, Physical and Logical Data models that capture current state/future state data elements and data flow using Erwin.Created Low-level design document that includes the detailed design of each components and data flow diagrams.Worked with Data / Data Warehouse Architect on logical and physical model designs.Involved in Exception handling and reprocessing in Informatica.Customized the stored procedures and database triggers in PL/SQL.Implemented and tuned the indexes.Involved in analyzing user requirements, coding, preparing testing specs, database designing and user acceptance training.Used entity relationship and normalization techniques.Technology: Informatica 9.6.1, MS SQL Server, Oracle, Unix shell scripting

Boston, Ma, Us

Provided hands-on leadership in requirements, design, development and implementation of the Enterprise Data Warehouse (EDW).Provided project estimates based on complexity of ETL process and reports.Created data warehouse architecture diagram, ETL design documents and technical specifications for mappings. Worked directly with Business to gather and understand the requirements.Created traceability matrix and documented source to target mappings.Developed logical and physical data models that capture current state and future state data elements and data flows in staging area.Implemented parameter file concept (in Informatica) using csv files and PL/SQL procedures.Developed and Deployed UNIX script for automation as per business requirements.Tuned ETL procedures and STAR schemas to optimize data load and query performance.Performed code reviews, unit testing and integration testing extensively during development.Created test cases and test plans, coordinated system testing with quality assurance team and providing test support. Managed the release and deployment of all data, mappings, cubes and reports into the production environment.Provided support for new and evolving sources of data being brought into the data warehouse.Provided knowledge transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mapping.Technology: Informatica 9.1, MySQL, Access, Windows IBM DB2, CA for Scheduling, IBM rational clear case

Teaneck, New Jersey, Us

As a developer was responsible for the preparation of detail design documents, coding using informatica tool, testing and deployment. Reporting on the data warehousing was done using Business Objects and Microstrategy.Lead and mentored a team with estimation preparation, providing technical and domain trainings, reviewing the codes.As Analyst Coordinator had done the Functional design specification document, High level design documents. Had worked on the feasible solutions by working close with the end users.

Bangalore, Karnataka, In

Stamford, Ct, Us

Worked as a developer / Lead developer to perform detailed analysis analysis, detailed design, development, testing and release management documentation.Performed Extraction, Transformation and Loading using Informatica 7.x/8.xReports were created using Cognos.

Bachelor'S In Electronics And Instrumentation

Master Of Business Administration - Mba