Database Quality Analyst Lead Resume
Germantown, MD
PROFESSIONAL SUMMARY:
- Over 28 years of IT experience as a Systems Engineer, Software/Database developer/designer/Manager, Data Warehousing, Database Architect (Relational Database developer/designer), Team Lead and Business Systems Requirements Analyst using Oracle, Informix, Sybase, DB2 and SQL server
- Extensive experience in creating Business Requirements (BRD), Functional Requirements (FRD), documents and sequence diagrams using IBM Rational Rose tools RequisitePro and Rhapsody.
- Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server, XML and Flat files.
- Excellent experience in data modeling using Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
- Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
- Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
- Well versed in developing the SQL queries, unions and multiple table joins and experience with Views.
- Experience in database programming in PL/SQL (Stored Procedures, Triggers and Packages and functions).
- Outstanding experience developing ad - hoc reports on various data source (ASCII, CSV, XML, Excel, Dbase, Oracle, MS SQL Server) using report developing tools i.e. Business object’s Crystal Reports, SQR
- Very well experience working with Waterfall and Agile development technology.
- Excellent Data warehouse/ETL experience using Scripts/Procedures (SQL*Loader, Bulk Collection) to load data from various sources and various data types (CSV, text, dbase, MS access, XML) into Oracle tables.
- Participate in Design, develop and maintain ETL system for CDRH at FDA using Pentaho Data Warehouse tool
- Excellent communication, documentation and presentation skills.
- Experience working with FAA (over 20 years) for installation of Automated Surface Observing Systems (ASOS) on all major airports in United States and exchanging Meta data with FAA
- Outstanding customer relationship by respecting customer needs and providing value added outputs (Supported National Weather Service’s Confidential (121 Weather Forecasting Offices and 6 Regional offices) - Confidential for over 20 years at Silver Spring, MD).
TECHNICAL SKILLS:
Databases: Oracle 11g, SQL Server 2014, MS Access, MySQL, Sybase, Informix, DB2, Postgres
Programming: SQL, PL/SQL, T-SQL, COBOL, Visual Basic, VB Script, Dbase, FoxBASE/FoxPro, HTML, XML, JSON, Python, PostreSQL
Requirement Tools: Rational RequisitePro
Data Modeling Tools: ERWIN, ER Studio, Oracle Data Modeler, Toad Data Modeler, SAP Power Designer, IBM Rhapsody
ETL Tools: Informatica, Pentaho (PDI), Talend
BI Tools: SAP Crystal Reports 10/11 & Business Objects, Oracle Reports, Pentaho BI (Business Analytics, Dashboard Designer, Report Designer)
Columnar Databases: HP Vertica, Amazon AWS/Redshift
Other Tools: Toad, SQL Developer, VISIO, QTP, MS Office, AGILE JIRA
Operating Systems: Windows, UNIX, Linux, MVS (IBM 4341/9000), BTOS (Burroughs), Primos (Prime 550), PDP-1170
PROFESSIONAL EXPERIENCE:
Confidential, Germantown, MD
Database Quality Analyst Lead
Responsibilities:
- Systems engineering and requirements gathering and working on BRD, FRD and sequence diagrams using IBM RequisitePro and Rhapsody
- Coordinate with ETL developers and ensure testing of functionality
- Develop/modify SQL and PL/SQL queries/procedures for ETL/data validation & migration (used up to 22 complex joins in one single procedure)
- Create, execute, monitor, and update database scripts and reports to help verify ETL operations
- Perform root cause analysis of data issues and classify them as source system, ETL bugs, etc.
- Notify data owners of source system issues they can correct, track issues to completion, and verify resolutions
- Help ETL developers correct bugs, track issues to completion, and verify resolutions
- Report the status of CARS data quality tasks and outstanding data issues on a weekly basis
- Help define, calculate, and report data quality measurements
- Lead discussions about data quality issues, measurements, and resolution/prevention strategies
- Identify, evaluate, and implement data quality tools
- Collect and manage user stories/acceptance criteria/requirements for new features and change requests
- Conduct reviews of user stories/acceptance criteria/requirements with stakeholders and design/development team
- Meet with stakeholders to discuss and prioritize system change requests
- Write, revise, and get approval of stories/acceptance criteria/requirements
- Work with end-user support staff to confirm, analyze, and resolve user issues
- Work with testing lead to perform sprint, system, and post-deployment testing
- Work on Triage responsibilities i.e. creating JIRA tickets, initial triage, secondary triage and follow up the whole process.
- Participate in AGILE meetings including user acceptance (UAG) meetings.
- Work on data warehouse and ETL issues, relating data elements to business functions, and data migration (e.g., validation and clean-up)
- Develop reports using Crystal Reports and Business Objects
Environment: Oracle 11g, SQL Developer, TOAD, SQL, PL/SQL, Microsoft Office (Excel, Word, PowerPoint) and Crystal Reports XI and Business Objects, Pentaho, RequisitePro, Rhapsody, AGILE
Data Migration manager (Requirements/Systems Analyst)
Confidential
Responsibilities:
- User meetings, collecting requirements and develop a requirements documents and logical data model and Physical data models.
- Developed two Data Migration Requirements Document for two sub systems i.e. Vendor migration and bills migration.
- Developed source to target data mapping, table relationships (1 to many, 1 to 1, many to many).
- Developed ER and dimensional modeling.
- Analyzing the source data to provide users with various reports for decision making on selection of source data.
- Developed data cleaning SQL, PL/SQL procedures for data cleaning and selection.
- Providing selected data to user group in easy/clean excel formats for making necessary corrections/addition to the data.
- Developed Ad-Hoc reports for users using multiples tables with complex joins (Left Outer, Right Outer, Equal joins) and complex conditions using Crystal Reports XI.
- Developed staging table structures for data migration.
- Importing data from excel tables to Oracle staging tables to be used as source for migration.
- Developed data migrations SQL, PL/SQL scripts for populating the data to target tables.
- Developed verification scripts to verify the accurate 100% results.
- Managing and guiding junior developers.
- Participating in user meeting, testing meeting and co-ordination with developments group.
- Giving presentations to senior management on progress/functionality of the system related to data management issues.
- Training users to understand the whole systems start using/working on the new modules.
Environment: Oracle 9i, 11g, SQL Developer, TOAD, SQL, PL/SQL, Microsoft Office (Excel, Word and PowerPoint) and Crystal Reports XI, Java, AGILE, RequisitePro and Rhapsody
Confidential, Germantown, MD
Sub-Task Manager/ Sr. Systems Engineer
Responsibilities:
- Created and updated Business Requirement documents and Functional Requirement documents.
- Created all SDLC diagrams and requirements documents using RequisitePro and Rhapsody
- Managed Project Milestones through the entirety of the SDLC process.
- Assisted the Project Manager and QA Team, coordinating between team members according to the business requirements.
- Involved in project planning and coordination.
- Responsible for submitting Status Reports to management summarizing completed Milestones and Tasks.
- Develop requirements document to enhance the Data warehouse module to the existing Financial Assessment system (FASS-PH system)
- Develop System flow charts and co-ordinate between users and developers
- Develop ad-hoc reports to analyze the data and additional user requirements using SQL and BI tools
- Define processes and tools best suited to each project. Moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures
- Co-ordinate between users and developers to make sure the development is as per requirements using requirements traceability matrix
- Develop addendums for the changes/additions in the requirements document in AGILE environment
- Analyze/Modify various existing sub routines to in corporate changed business requirements (given by end user)
- Write Test plan and create data to Implement new functional requirements by creating DML SQL and scripts and finally deploy them in production after successful output
- Develop PL/SQL scripts for mapping, transformation and loading data to Oracle tables
- Data loading of various file types including ASCII, XML
- Prioritize development and enhancement requests
- Co-ordinate unit testing, system testing and assist UAT
- Troubleshooting database problems
- Design and develop various Quality check scripts to find and correct data discrepancies
Environment: Oracle 9i, 11g, SQL Developer, TOAD, SQL, PL/SQL, Microsoft Office (Excel, Word, PowerPoint) and Crystal Reports X/XI, INFORMATICA, AGILE, RquisitePro and Rhapsody
Confidential, Germantown, MD
Sr. Systems Analyst/Sub Task Manager (Systems Engineer IV/ Metadata manager)
Responsibilities:
- ER data modeling STAR and SNOWFLAKE schema design, transforming logical data models (LDM) to physical data models (PDM).
- Analyzed the business requirements and functional specifications.
- Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to bulk load them in the central oracle database.
- Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
- Developed complex mappings to load the data from various sources.
- Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
- Parameterized the mappings and increased the re-usability.
- Created procedures to truncate data in the target before the session run.
- Extensively used Toad utility for executing SQL scripts and worked for enhancing the performance of the conversion mapping.
- Used the PL/SQL procedures for mappings for truncating the data in target tables at run time.
- Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
- Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
- Developed over 200 ad hoc reports using Crystal Reports 9/10, Oracle discoverer and SQR
- Provided technical support to the Observing Systems Division of the Office of Climate, Water and Weather Services (OCWWS) for Confidential and Mesonet database management, Crystal Reports development, data export, data transform and data load functions (ETL). Provided subject matter expertise related to Cooperative Station Service Accountability system (CSSA).
- In addition, provided support to the Regional Confidential program managers to monitor and ensure field operation on Confidential networks by providing them business intelligence reporting solutions.
- Supported the activities in ASOS (F&P) and Confidential modernization efforts. I provided various reports and statistics at the regional and program office level.
- Liaised with other Confidential line office, the USDA, the Western Governors Association staff, USGS, COE, Federal Aviation Administration, State universities, State Mesonet agencies, DOD, and other Confidential contractors such as Raytheon, TDS and SMI Corporation on meteorological observational networks.
- Provided formal and informal training to internal staff and regional Confidential program managers on CSSA and ASOS systems.
- Following are the main systems worked on.
- Provide support on Confidential program data sets including:
- Confidential station equipment information
- Confidential station weather elements Observations details
- Confidential station’s observer details
- Confidential station master data information
- Confidential station inspection information
- Confidential station ad-hoc reporting system
- Integrate Crystal Reports with Oracle Server to generate effective reports for the Confidential program on a routine
- And ad hoc basis.
- Automate existing manual processes in the division and facilitate Confidential program manager and analysts.
- Support regional Confidential managers, providing them ad-reports and any other information by retrieving reports from Oracle databases
- Develop SQL, T-SQL, PL/SQL scripts to data export, data transform and data load functions.
- Develop SQL, T-SQL, PL/SQL scripts to locate erroneous data entries in the CSSA database tables
- Develop database tables and export data for main system to provide support to Confidential program managers.
- Support the GIS-based Weather Observing network location/density system on the Internet. Provide database tables to GIS developers for them to keep up to data maps and website.
- Automate and maintain the Confidential Program Funds reimbursable system. Coordinate with USCOE and
- Agencies to receive reimbursable funds Memorandum of Agreements for the Confidential program.
- Coordinate with budget, finance and regional offices to provide them the consolidated spread sheets and allocate funding. Keep track of fund usage.
- Support OCWWS to automate and maintain Length of Service (LOS) Awards system. Provide timely ad-hoc reports and data to regional program managers to avoid delays in distribution of awards. Verify data sets for erroneous entries. Provide data to CPM for estimations.
- Automate and maintain the Holm and Jefferson Award nominee database for each year and provide
- Rankings, winners and other reports to the selection committee.
- Provide ad-hoc reports on ASOS systems using ASOS metadata and ASOS configuration databases.
- Develop and integrate Mesonet data sets including:
- Mesonet Sensor configuration data
- Mesonet implementation schedule data
- Database ad-hoc report development
- Develop various reports for the communications office to support the office director for
- Congressional briefing. Provide databases for GIS group to develop maps for the briefings.
Confidential, Greenbelt, MD
Sr. Systems Analyst (Systems Engineer II/Database Manager)
Responsibilities:
- Cooperative Station Reports (B-44) for total forms processed vs. error free reports
- Cooperative Station Visitations - cumulative percentage of annual requirements vs. actual site visits
- Monthly Climate Data (B-91) forms mailed to NCDC vs. goal of 95%.
- Developed graphs and statistical reports project for Confidential director.