SUMMARY

• To maximize my contributions in areas of software engineering, database, testing, data analysis or related information technology disciplines for the benefit of the organization and clients.

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• Responsible for collecting requirements and creating implementation plans for several Federal government agencies ServiceNow projects.•
• Provided database assistance and problem support to application developers, business analysts and business users• Identified and resolved data quality issues with Data Profiler.• Created SSIS Packages to Extract
• Transform and Load (ETL) the data into Reporting tool to generate reportseasily and quickly• Completed ServiceNow CSA training and exam for ServiceNow System Administrator• Conducted practical training in full
• ServiceNow test environments running scenarios for Incident, Change, troubleshooting, CMS, Facilities, Knowledge, CMDB and reports/metrics, and ran associated Performance Analytics

Confidential

System Engineer

Responsibilities:

• Responsible for designing, implementing, and managing analytical database environment using SQL Server reporting for Department of Veterans Affairs project on• Designed, implemented, and supported Frontend version control on
• TFS.• Served as SME in support of structuring and managing data transformation and integration functions.• Improved data integration preformation and helped improved the environment stability and efficient usage.• Implemented sound software quality assurance processes for accurate and precise project data sets and reports.• Verified accuracy deployment into production environment by using Version Control,
• SharePoint, SQL Server, SSIS and ETL.• Designed and developed Microsoft Flow automation tasks to audit internal documents in SharePoint folders.

Confidential

SQL Data Analyst

Responsibilities:

• Responsible for building and maintaining SQL Server Database, ensuring system data integration, automating numerous functions, and troubleshooting issues as they occurred in support of DHS TSA
• Impact project.• Fine - tuned database objects and server to ensure efficient data retrieval.• Monitored and optimized system performance using SQL Profiler and Database Engine Tuning Advisor.•
• Designed and implemented incremental and full back-up policies and procedures.• Created and implemented database design solutions in collaboration with programming team.• Developed user-defined functions and triggers to implement the business requirements.•
• Performed database logical and physical design, maintained tuning, archiving, backups, replication, recovery, software upgrades, capacity planning and optimization for SQL Server database.

Confidential

System Data Analyst/ Data Modeler

Responsibilities:

• Responsible for Data Modeling, System/Data Analysis, Design and Development in ER studio and SQL server Database for Department of
• Treasury MHAC (Make Home Affordable Compliance) project.• Analyzed business production source data and used ER Studio to create relational database model.• Leveraged comprehensive knowledge and experience of process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation to deliver on project requirements.• Created, documented, and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions and repository for enterprise data stores.•
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.•
• Developed, mapped spreadsheets for (ETL) team with source to target data mapping, physical naming standards, datatypes, volumetric, domain definitions, and corporate meta-data definitions.

Confidential

System Data Analyst

Responsibilities:

• Responsible for analyzing and comparing raw data artifacts received from DHS CBP with CBP internal database and identifying preparing monthly discrepancies reports for
• DHS CBP project• Implemented complex big-data projects with a focus on collecting, parsing, managing, analyzing, visualizing gathering and processing raw data. Conducted data cleansing/normalization for DHS DF datasets.•
• Designed, tested, and implemented data translation configuration files (maps) for DHS DF using AWS, SharePoint, MS Access and Excel.• Created and tested Jobs, SQL Mail Agent, Alerts and Schedule SSIS
• DTS Packages.• Developed data translation objects and data processing flow using Pentaho and Sqoop ETL transport technologies for DHS DF.

Confidential

Data Analyst

Responsibilities:

• Responsible for generating monthly MMDM (Monthly Medical Database Management) reports for 18 clients (HealthCare Providers, Insurance Co) based on tailored business rules of healthcare production and customer's requirements.• Analyzed, extracted and manipulated healthcare data from SQL server database base on client business needs.•
• Designed and Built Extract Transform Load procedures in SQL Server Integration Services for Data Conversion• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.

Confidential

Database Analyst

Responsibilities:

• Responsible for tracking and maintaining wireless data performance tool on-site and backend for wireless data provider clients (AT&T, T-Mobile, Verizon, etc).• Analyzed, extracted, and manipulated wireless data from SQL server
• MS Access database base on GWS business needs• Designed, developed, tested, documented, and implemented technical applications and application enhancements to GWS internal systems.• Enhanced, maintained and troubleshot
• GWS network performance website for more TEMPthan ten clients.• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.• Implemented Event Handlers and Error Handling in SSIS packages.•
• Designed, developed and tested applications using Visual Basic, SQL Server, MS Access

Confidential

Programmer/Analyst

Responsibilities:

• Responsible for Design, development and maintenance of Confidential internal database analysis including comparing MBS-NUC data with Confidential Central Database using Microsoft Access 2003, VBA.• Collected user requirements, designed user-friendly graphical interface, programmed built-in function to support and maintain MBS office
• Quality Assurance process.• Major features of the database included calculating and comparing Loan information between the entered data and source RDW data from
• Generating reports (Top ten error rate, Top ten seller with error and user productivity report) based on comparison result.• Managed user security levels and access privileges based on their group.

Confidential

Data Analyst

Responsibilities:

• Responsible for Confidential Express 24x7 legacy dispatcher delivery system maintenance, enhancements, improvements, and troubleshooting to support Confidential Express business and customers.•
• As a TEMPprincipal engineer, maintained and developed new features for Automated Dispatch System in Visual Basic, C and AS400.
• The system has over 20,000 lines of legacy code and is the only dispatch system used by Confidential Same Day division, which dispatches thousands delivery jobs daily.

Confidential

Programmer/Analyst

Responsibilities:

• Responsible for DHS accounting department project CRIS (Credit Report Information System) in the designing, development, testing and implementation on a debt management action to assist federal agencies in reporting consumer and commercial debts.• Built CRIS in ASP, HTML, XML, JavaScript and Microsoft SQL server.
• Designed and developed the navigation, user, and system administration modules of the system, among others. Maintained key and professional relationships with client personnel.• Designed and developed for U.S. Equal Employment Opportunity Commission a warehouse and inventory database system using Microsoft Access.
• dis included creating tables, queries, forms, and reports. Created user security levels to ensure the system's integrity and restrict a user's set of responsibilities.• Designed and lectured a four-week
• MS Access training session for over 30 junior programmers in the company. Training contents include building database, generating forms and reports, importing, and exporting data between
• Excel spreadsheet and Access, creating advanced SQL query, and using VBA to create built-in functions to improve efficiency.• Designed and implemented the company partner web site using PHP/MySQL on a Linux platform.
• Designed web graphical advertisement layouts using an html template.