We provide IT Staff Augmentation Services!

Etl Developer/solution Consultant Resume

Hyattsville, MD

SUMMARY

  • 12+ years of experience in database development, design, application development, implementation and production support activities in a Client/Server environment with a core competency in Oracle 11g/10g/9i, Forms, Reports, ETL, SQL Server and support experience in UNIX and Windows.
  • Expert in the development of PL/SQL Procedures, Functions, Triggers and Packages in PL/SQL to implement business logic.
  • Data Analysis provide insights and provide necessary recommendations.
  • Received appreciation and recognition from all previous employers.
  • Proficiency in data warehousing techniques for Data Profiling, Change Data Capture, Data Cleansing, Dimension phenomenon, surrogate key assignment.
  • Proficient in Data analysis, Data modeling, Database design, Data migration, and Business intelligence solutions.
  • Expert knowledge in dimensional modeling, Star Schema modeling, Snowflake modeling, fact and dimension table design, physical and logical Data modeling using Erwin 3.5, Toad Data Modeler.
  • Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques, and Indexes
  • Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings
  • Expertise in working with Oracle 11g/10g/9i, TOAD, SQL Navigator, SQL * Loader, Forms 10g/9i/6i and Reports 10g/9i/6i/ for both development and customizations as per client specifications.
  • Knowledge in Tableau Desktop 8.3
  • Knowledge in schema structure design and involved in estimation and optimization of data storage Experience in utilizing Oracle tools and methods like the use of External Tables, Pipelined functions.
  • Experience in migration and conversion from Flat Files/MS Access/SQL - Server to Oracle using Oracle SQL* Loader
  • Experience in Tuning SQL statements using EXPLAIN PLAN and TKPROF to optimize the performance of the batch processes.
  • Experience in Re-Organization of database using export/import and Data Pump.
  • Experience in implementing and using Oracle Streams for Replication.
  • Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
  • Enforcing Database security by creating and assigning Roles, Profiles and Privileges to various Users (Schemas) on different Objects.
  • Well versed in OLTP Data Modeling, Data warehousing concepts.
  • Well-versed in using tools like SQL*Plus, SQL Developer and TOAD.
  • Good experience on Analytical functions like COVAR POP,CORR, COVAR SAMP,CUME DIST, DENSE RANK,RANK,ROW NUMBER etc..
  • Expertise in using JIRA, SMS, TCMSfor project tracking, teams planning and also reviewing and commenting the code base.
  • Involved in review and gap analysis of Functional Requirement documents. Creation of Technical Documents and related Test Case Document.
  • Expertise in fixing software bugs and problems quickly and effectively.
  • Refine conceptual systems design requirements into the technical design Involved in review and Gap Analysis of Functional Requirement documents. Creation of Technical Documents and related Test Case Document.
  • Great learning skills to adapt the rapid changing technologies and implementing the same at work. Strong Analytical, Inter-personnel, Problem-solving and Proven ability to work under pressure.
  • Knowledge on Informatica 8.6, BI Publisher, DAC, OLAP. OLTP, XML, Oracle Argus, SSRS and OBIEE.
  • Experience with ETL involving large amount of data, in particular XML parsing and loading into Oracle, Oracle XML Packages.

PROFESSIONAL EXPERIENCE

Confidential, Hyattsville, MD

ETL Developer/Solution Consultant

Responsibilities:

  • Build Technical specification document with various sources involved and the transformational logic to meet the user requirements.
  • Provide ETL solution design and source to target data mapping specifications
  • Work closely with the development team to identify/propose any changes to the physical design and work with the testing team to help define test strategy and scenarios
  • Developed mappings to load into staging tables and then to Dimensions and Facts.
  • Used existing ETL standards to develop these mappings.

Environment: Oracle 12c, Shell script, SQL Developer, Informatica Power Center, ServiceNow

Confidential

Technical Lead / ETL Developer/DB Developer

Responsibilities:

  • Perform production system support for multiple Sales Operations Management related systems (IDR, EDW, Endeca, OBIEE, Apex) as given: Incident Resolution Service, Service Request Support Service (Standard & Adhoc), System Change Management Support Service as per ITIL process, Planned Outage / maintenance Support, Root cause analysis of critical incidents, Communication / coordination with other support groups for issue resolution, in case of any dependency.
  • Enhancement, break fixes, unit testing/ UAT testing for CRs (Eg: Metadata changes in Database Oracle, SQL, PL/SQL and DW etc) ¢ Work on Change requests of Data Analytics based functionalities using technologies e.g. Informatica, Tableau, OBIEE, ODI/APEX.
  • Work will be based on Service Level Agreements (SLAs) like supporting, enhancement and production implementation. To resolve business impacting issues in collaboration with other application teams, infrastructure.
  • Provide periodic status reports on performance. As required, contribute and participate in knowledge sharing sessions with multiple other application support or development teams under my direct supervision.
  • Writing PL/SQL Scripts (Stored Procedures and Functions) for fetching multiple records based on business logic.
  • Tuning SQL statements using EXPLAIN PLAN and TKPROF to optimize the performance of the batch processes.
  • Consults with customers and IT managers to develop, define, and prioritize work assignments and work delivery. Demonstrate excellent customer focus
  • Resolve user requests in a timely manner. Work on development for small requests, code and design reviews
  • Document and create the knowledge repository which will help in providing quick resolution of tickets
  • Assist in acquiring and developing talent
  • Executes ITSM processes (Change, request, incident, problem management) on technical IT systems at the Project level.

Environment: Oracle 11g, SQL Developer, Servicenow, OBIEE, Endeca, Apex, Informatica, ODI, Tableau

Confidential, Clarksville, TN

DB Developer/Analyst

Responsibilities:

  • Involved in Data Modeling.
  • Created Oracle Stored Procedures to parse XML files to Oracle Tables.
  • Tuning SQL statements using EXPLAIN PLAN and TKPROF to optimize the performance of the batch processes.
  • Writing PL/SQL Scripts (Stored Procedures and Functions) for fetching multiple records based on business logic.
  • Gathering functional requirements for GPDW applications and preparing Technical design documents.
  • Day to day interaction will take place with customers, Service Management and Release Management, IT colleagues
  • Identify potential process improvement areas and suggest options and recommend approaches
  • Continuous Improvement

Environment: Oracle 11g, SQL Developer, JIRA

Confidential

Project Lead/Data Analyst

Responsibilities:

  • Involving in Team management activities.
  • Development of new feed configuration using Scheduler, cron expression.
  • End to end flow development from upstream till downstream of global stock data’s
  • Excel sheet reporting using APACHE POI
  • Software application delivery
  • Application maintenance and Enhancement
  • Tuning SQL statements using EXPLAIN PLAN and TKPROF to optimize the performance of the batch processes.
  • Writing PL/SQL Scripts (Stored Procedures and Functions) for fetching multiple records based on business logic.
  • Gathering functional requirements for GPDW applications and preparing Technical design documents, PMR documents.
  • Providing data processing related resolution information to operations
  • Provide expert knowledge of data normalization processes to team members
  • Utilize Microsoft Project and Microsoft Sharepoint for documenting all outcomes, for reporting progress to management, and for collaborating with team members
  • Create and maintain configuration notes for the testing environments
  • Lead data mapping efforts between project and other existing data sources

Environment: Oracle 10g/11g, JAVA, Spring, Autosys, Shell script, SQL Developer, GITHUB, JIRA

Confidential

Sr. DB Analyst

Responsibilities:

  • Gathering data for Sales Tracking and Revenue Management.
  • Data cleansing by extracting relevant files from the sources.
  • Feature engineering using Factor Analysis and Domain expertise.
  • Built a model using Machine Learning algorithms to predict the vehicle breakdown.
  • Working on NIS, EzTrack applications.
  • Involving in data modeling using ERWIN.
  • Involving in DB design for NIS tables.
  • Tuning queries for NIS and PONIS and PNAR databases.
  • Created scripts to load data from SAP HR to Oracle tables.
  • Downloaded data from FTP site, integrate data to a database and extract data for analysis.
  • Established departmental procedures, metrics and work flow where none previously existed.
  • Assisted managers and business analysts in developing reports, presentations, and analysis for upper management.

Environment: Oracle 10g/11g, Embarcadero Rapid SQL 7.6.3, SQL Developer, SVN, Erwin, Sybase, DB2 Teradata, Autosys, Informatica,HP GSM, Data Mining (SVM, NN), Forecasting (ES, ARIMA) & Regression Techniques (Logistic)

Hire Now