SUMMARY:

• I have experience working in a fast paced, detail oriented environment while developing quality control measures that immediately improved integrity and consistency of data. I am a skilled problem solver who works well individually or as a member of a team. I also bring customer service experience in resolving data related issues to the program. I am a lifetime learner committed to making an immediate contribution to your company.

PROFESSIONAL EXPERIENCE:

Confidential, Silver Spring MD

Informatica ETL Developer/Analyst

Responsibilities:

• Data profiling and generation of scorecards for Critical Data Elements (CDEs)
• Data warehouse Remediation and Data Migration
• Champion data quality improvements and consistency across technology source systems
• Development and support of Data Quality rules
• Data Testing and Gap Analysis
• Developed Data matching and standardization mapping
• Establish standard metrics and quality expectations for data elements that support critical business processes across - functional teams.
• Converted PL/SQL Stored Procedures logic into Informatica mappings
• Implemented Informatica loading techniques like Incremental loading
• (Change Data capture) and slowly Changing Dimensions SCD TYPE II and I.
• Created the Source and Target Definitions using Informatica PowerCenter
• Designer.
• Prepared Technical specification documents for Informatica.
• Involved in Performance Tuning of Informatica mapping and queries
• Developed schedules to automate the update process and Informatica
• Batches/Sessions.
• Performed incremental loads and automated them using Informatica scheduler.
• Designed and developed database objects such as packages, procedures, functions, views, materialized views, indexes and cursors.
• Conducted Business process analysis, task/workflow analysis.
• Translated the business process codes into Informatica mappings for building the data mart.
• Extracted data from variety of sources like flat files, relational databases and loaded to the data warehouse.
• Worked closely with Business Analysts to Design & Develop SQL Statements,

Confidential, Fairfax, VA

Informatica ETL Developer/Analyst

Responsibilities:

• Created quality rules, development and implementation patterns with cleanse, parse, standardization, validation, scorecard transformations. Created Informatica mappings using transformations Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, Lookup and Router transformations to extract, transform and loaded data mart area.
• Created re - usable transformations/mapplets and used across various mappings
• Used SQL/PLSQL scripts /functions/procedures/packages.
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager
• Created DAC jobs to schedule and monitor Informatica Workflows and other
• OBIA
• Worked on performance tuning tasks using standard informatica and database tuning steps.

Confidential, Arlington, VA

Informatica ETL Developer/Analyst

Responsibilities:

• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle, Web XML, SQL
• Server and Delimited Flat files.
• Development of ETL using Informatica Power center 9.5 and 9.6. transformations.
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.
• Prepared various mappings to load the data into different Staging and Target tables.
• Used various transformations like Source Qualifier, Expression, AggregatorJoiner, Filter, Lookup, Update Strategy Designing and optimizing the
• Mapping.
• Developed Workflows using task developer and workflow designer in
• Workflow manager and monitored the results using workflow monitor.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Worked extensively on SQL as part of the process to develop several scripts to handle different scenarios.
• Prepared the error handling document to maintain the error handling process.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Create databases and configured them to meet developers and user requirements

Confidential, Rockville, MD

Informatica ETL Developer

Responsibilities:

• Involved in Performance tuning for sources, targets, mappings and SQL queries in the transformations to increase the performance.
• Extracted data from variety of sources like mainframe tables, flat files, SQL Server and loaded to the data warehouse.
• Performed tuning of SQL queries for speedy extraction of data and troubleshoot long running Sessions and fixed the issues.
• Worked with a team in the integration of various data sources definitions like SQL Server, Oracle, Flat Files.
• Worked on SQL Server 2012 and took the advantage of column stored indexes to improve the performance of the databases.
• Identified and troubleshoot bottlenecks at various levels like SQL logic, Mappings, and Sessions to enhance the performance.
• Extracted data from various sources like MS SQL Server and relational databases (Oracle) and supported in Production.
• Worked closely with Business Analysts to Design & Develop SQL Statements, Data Conversions, and Data Cleansing.
• Extracted sources from flat - files, Oracle, SQL Server and load them into Oracle using Oracle Warehouse Builder.
• Used SQL tools like Query Analyzer and DB Visualizer to run SQL queries and validate the data.
• Designed various Mappings for extracting data from various sources involving Flat files, Oracle and SQL Server.
• Extracted the source definitions from various relation sources like Oracle, SQL server and from flat files.
• Experience with SQL plus as an interface to databases, to analyze, view and alter data.
• Used SQL-Loader to load data from flat file to Oracle tables, to improve the performance.
• Worked with database connections, SQL joins, Union, aliases, views, aggregate conditions.
• Improved performance of long running batch processes by implementing new mappings and modified existing SQL queries.

Database Administrator

Confidential, Washington, DC

Responsibilities:

• Installed Configured, and Administered SQL Server 2008 and 2012 in development, test, and production environment.
• Installed configured and managed Database Mirroring, Replication and Log Shipping.
• Use optimization tools such as SQL Profiler, Dynamic Management Views (DMVs) and windows Performance Monitor for monitoring and tuning MSSQL Server performance Monitoring SQL server performance using profiler to find performance.
• Backing up, restoring the database manually and scheduling jobs and Maintenance Plans.

Confidential, Mclean, VA

Database administrator

Responsibilities:

• Support the development and analysis of measurable components of data collection activities, apply techniques to data management, quality assurance, and explore best approaches to data analysis and reporting.
• Installed and Configure SQL Server 2008, and 2012 in test and production environment.
• Create Backup jobs for different types of backup like full, Bucklock, and Simple Differential and Transaction Log.
• Migrated databases from SQL Server in test and production environment.

Confidential, Washington, DC

Database Administrator

Responsibilities:

• Provide primary support for the SQL Server, MYSQL environments and support Oracle environment.
• Responsible for managing and supporting all Production, Development and Staging instances of Oracle Version 10g and 11g.
• Maintaining data integrity and tune database for optimum performance and availability.
• Provide technical support and assistance to all database end-users.
• Upgrading of Database from lower version to higher version.
• Installation of Patch.