Extensively involved in almost all the phases of Project Life Cycle (SDLC) right fromRequirements Gathering to Testing and Implementation, Reporting etc.● Learned the company’s EDW architecture which consists of sources, middleware, staging area,data warehouse, and reporting tools.● Worked on data profiling & various data quality rules development using Informatica DataQuality.● Strong experience in Data Analysis, Data Modelling, Data Mapping, Data Profiling… Show more Extensively involved in almost all the phases of Project Life Cycle (SDLC) right fromRequirements Gathering to Testing and Implementation, Reporting etc.● Learned the company’s EDW architecture which consists of sources, middleware, staging area,data warehouse, and reporting tools.● Worked on data profiling & various data quality rules development using Informatica DataQuality.● Strong experience in Data Analysis, Data Modelling, Data Mapping, Data Profiling, DataMigration, Data Conversion, Data Quality, Data Governance, Data Integration and MetadataManagement Services and Configuration Management.● Implemented Exception Handling Mappings by using Data Quality, Data validation● Build and developed reports based on the user stories given by the product manager andproduct owner.● Held responsibility for integration points and the order in which these must be executed.● Built compelling, interactive dashboards in Tableau that answer key business questions● Created extracts from the data source and refresh extracts on the monthly data.● Created test cases and completed unit, integration, and system tests for Data warehouse.● Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.● Involved in Performance tuning for sources, targets, mappings, sessions, and server.● Used Alteryx to speed the processes of cleansing, joining, and shaping data● Automates the process of updating when the dataset changes● I connected both relational, no relational as well text files.I used for geo spatial as well predictiveanalysis Show less

Worked with Business analysts for requirement gathering, business analysis, and testing andproject coordination.● Analyzed source data and gathered requirements from the business users.● Worked on understanding and creating ETL Design documents and specifications.● Prepared technical specifications to develop ETL mappings to load data into various tablesconfirming to the business rules.● Experience in creating Data Governance Policies, Business Glossary, Data… Show more Worked with Business analysts for requirement gathering, business analysis, and testing andproject coordination.● Analyzed source data and gathered requirements from the business users.● Worked on understanding and creating ETL Design documents and specifications.● Prepared technical specifications to develop ETL mappings to load data into various tablesconfirming to the business rules.● Experience in creating Data Governance Policies, Business Glossary, Data Dictionary,Reference Data, Metadata, Data Lineage and Data Quality Rules● Used SFDC Datal Model regularly for data analytics and to ensure proper analytics process● Used MySQL to extract external data and transfer into SFDC platform● Used Tableau for data visuals (graphs, charts, etc.)● Linked data lineage to data quality and business glossary work within the overall datagovernance program.● Performed an end-to-end Data Lineage assessment and documentation.● Gathered requirements by working with the business users on Business Glossary, DataDictionary, Reference data, and Policy Management.● Responsible for extracting, transforming, and loading (ETL) data from spreadsheets, databasetables, and other sources using Alteryx, Microsoft SSIS, and Informatica● Developed ETL solutions for data warehousing using SQL Server Integration Services● Traced and catalogue data processes, transformation logic and manual adjustments to identifydata governance issues● Exposure to implementation and operations of data governance, data strategy, datamanagement and solutions Show less

Gathered requirements, analyzed, and wrote the design documents.● Providing End-user Training and documentation for customer reporting services.● Attended JAD sessions and created reports for Budgeting, Finance and Project Managementdepartments of Pima County.● Participated in the Analysis, Design and Development Phases of report development,performance tuning and production rollout for every report of Information TechnologyDepartment.● Queried the databases, wrote… Show more Gathered requirements, analyzed, and wrote the design documents.● Providing End-user Training and documentation for customer reporting services.● Attended JAD sessions and created reports for Budgeting, Finance and Project Managementdepartments of Pima County.● Participated in the Analysis, Design and Development Phases of report development,performance tuning and production rollout for every report of Information TechnologyDepartment.● Queried the databases, wrote test validation scripts and performed the System testing.● Worked with the developers during coding and while doing the remediation of the software.● Worked with the users to do the User Acceptance Testing (UAT).● Document all data mapping and transformation processes in the Functional Design documentsbased on the business requirements● Created Technical specifications documents based on the functional design document for theETL coding to build the data mart.● Created data trace map and data quality mapping documents.● Performed Data Profiling and Data Quality.● Used ERwin for data modeling.● Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Sourceto target systems using Informatica Power Center 7.1● Designed and implemented report layouts according to reporting standards of the department.● Owned the assigned reports, worked on them and updated the Report Development Schedulerfor status on each report.● Worked on daily basis with lead Data Warehouse developers to evaluate impact on currentimplementation, redesign of all ETL logic.● Adhered to the reporting standards laid down by Pima County ITD. Show less