SUMMARY OF QUALIFICATIONS:

• Disciplined Analyst possessing over 13 years of experience creating & managing databases used to identify trends, existing problems and potential problems, with 7 years of that experience directly supporting Citizenship and Immigration Services.
• Conducting organizational studies and evaluations, report findings of collected data as well as provide expert analyses in short periods of time from computer generated and regional input materials. Perform time - based analysis and adjustments of data.
• Throughout my 10 plus year career, I have used Microsoft Office, Excel, Access, Oracle and SQL in extensive ways.

COMPUTER EXPERIENCE:

HARDWARE: IBM-Compatibles, Routers, Hubs, Intel Switches 416T

SOFTWARE: SQL Server, ERWin, Visio, MS Access 97/2K/ 2003/2007/2010 , MSOffice 97/2K/ 2003/2007/2010 , C++, Visual Basic, Remedy, MS Excel 97/2K/ 2003/2007/2010 , TCP/IP, TOAD, SQL, MS Powerpoint

OPERATING SYSTEMS: Windows XP/95/98/NT/2K, UNIX

WORK EXPERIENCE:

Confidential

ETL Developer(SSIS)/Reports Developer (SSRS)

Responsibilities:

• Created reports using Microsoft SQL Server reporting services (SSRS) using data sources from different Line Of Business within Confidential
• Met with business analyst and client to gather business requirements to ensure accurate and comprehensive understanding of data and reporting requirements
• Created, delivered and maintained of new and existing reports for several LOB's utilizing Oracle and SQL Server as the data sources.
• Planned, developed, implemented, maintained and administered SQL Server SSIS packages to support database applications, feeds, and extracts from the several LOBS within Confidential .
• Extracted data from different flat files, Oracle, and SQL Server and transformed the data based on user requirement using SSIS and loaded data into target, by scheduling the sessions.
• Created SSIS Packages to extract data from Flat Files, Oracle, and SQL Server files using, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse
• Wrote SQL queries using SQL Developer and provided data pulls for client.
• Wrote SQL queries and provided data views for client.
• Wrote T-SQL queries, sub-queries and complex joins to generate complex stored procedures.
• Created ETL packages using Oracle as the source and SQL Server as target.

Applications Used: SQL Server 2008R2/2012/2016, BIDS 2K8, Microsoft Excel, Visual Studio 2K8, SQL Server Management Studio 2017, SQL Server Data Tools 2012/2015, SQL Developer 11g/12c

Confidential

ETL Developer(SSIS)/Reports Developer (SSRS)

Responsibilities:

• Created reports using Microsoft SQL Server reporting services (SSRS) for HR reports, damage inventory assessments reports and accounting reports.
• Analyzed, developed, and implemented database designs, data models, and logical data specifications.
• Met with client to gather business requirements to ensure accurate and comprehensive understanding of data and reporting requirements
• Business Process Review - Participated in the evaluation, design, development, testing, and implementation of technology solutions to support improvements in business processes
• Planned, developed, implemented, maintained and administered SQL Server SSIS packages to support database applications, feeds, and extracts from the 8 offices nationwide.
• Extracted data from different flat files, MS Excel, MS Access and transformed the data based on user requirement using SSIS and loaded data into target, by scheduling the sessions.
• Created SSIS Packages to extract data from Flat Files, Excel Files, MS Access files using, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse

Applications Used: SQL Server 2008R2, SQL Server Reporting Services 2K8, Microsoft Excel, Visual Studio 2K8, ERWin, Visio

Confidential

ETL Developer(SSIS)/Reports Developer (SSRS)

Responsibilities:

• Administered and developed applications utilizing Microsoft Access front-end connecting to SQL Server backend.
• Designed/Maintained/Supported MS Access application with customizations coded in VBA.
• Designed/Maintained reports utilizing MS Access and migrating to SQL Server Reporting Services (SSRS)
• Planned, developed, implemented, maintained and administered SQL Server SSIS packages to support database applications, feeds, and extracts.
• Analyzed source system of record to identify and document data quality issues
• Developed, maintenance, and operation of applications supporting the business processes using Microsoft SQL Server integration services (SSIS)
• Reporting - Modification of existing reports and development of new reports using Microsoft SQL Server reporting services (SSRS) and Microsoft Access 2016
• Business Process Review - Participation in the evaluation, design, development, testing, and implementation of technology solutions to support improvements in business processes

Applications Used: SQL Server, SQL Server Reporting Services 2K8, Microsoft Access, Microsoft Excel, Visual Studio 2K8, ERWin, Visio

Confidential

Data Analyst

Responsibilities:

• Planned, developed, implemented, maintaining and administering Access database used to compile and analyze Citizenship and Immigration data that consists of millions of records annually.
• Created SSIS Packages to import text delimited/Excel files containing Fee Waiver data from the 100+ Field Offices on a monthly basis.
• Created SSIS Packages to extract data from Flat Files, Excel Files, MS Access files using, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task and others to generate data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Development of an ETL infrastructure, including the use of metadata, staging, and load/reload procedures utilizing SQL Server Integration Studio (SSIS)
• Produced technical requirements and design documentation for ETL processes
• Analyzed source system to identify and document data quality issues
• Designed/Maintained data warehouse to support reporting
• Designed/Maintained reports utilizing MS Access and migrating to SQL Server Reporting Services (SSRS)
• Created and maintained a Data Warehouse with fact tables, and dimensions using SQL Server Analysis Services.
• Prepare and disseminate weekly, monthly, quarterly, yearly, and as-needed production reports and analysis, and other performance management reports for distribution to management and specified stakeholders.
• Work with management to analyze specific business problems and provide direct assistance in visualizing data and data patterns
• Manage the development/design of financial, production, and quality reporting projects for use in client deliverables, sourced across multiple lines of businesses employing key performance indicators (KPI) and an analytical scorecard approach
• Responsible for creatively developing projections based on multiple sources of data, macroeconomic data/trends, and business needs. Projections are used in defining the agency’s operating budget (currently $2.1 billion) and in determining the annual production and staffing allocation requirements
• Coordinate with Field Offices, Service Centers and the National Benefits Center the reconciliation of all identified anomalies in production data reporting and implement all necessary corrections to agreed-upon errors in Performance Analysis System (PAS).
• Performs quantitative and qualitative analysis on productivity for each of the 19 Regional offices with a focus on allocation of current staff, possible discontinuities in the staffing / workload and proposed reallocations.
• Identify and report to Confidential management all relevant production trends and developments, operational and performance issues, and areas of concern, improvement and weaknesses.
• Interface with Finance, Budget, Domestic Operations, Service Center Operations, International Affairs and other Confidential divisions on an as-needed basis to fulfill all requirements in data gathering, reporting, analysis and verification.
• Researches and interprets immigration laws, identified in the 8 Code of Federal Regulation (CFR).
• Presented evidence for comparative measures for Senate Appropriations Committee to support adjudication office needs for staffing to eliminate INS backlogs.
• Conduct studies of adjudication policies, processes and practices.
• Responded verbally and/or with statistical analysis to inquiries from representatives of Congress, Department of Justice, OMB, Media and CIS other government agencies, and congressional staff concerning a variety of internal and external matters affecting a district or office activity accurately and timely in line with Citizenship and Immigration Services.
• Overseen critical team efforts to ensure accurate reporting of CIS data its naturalization and adjustment of status backlog reduction goals while maintaining quality and integrity in our process
• Responsible for the staffing analysis and standardized reporting on the agency’s 10,000+ employees (cost, capacity analysis, and utilization rates).

Applications Used: SQL Server 2008R2, SQL Server Reporting Services 2K8, Microsoft Excel, Microsoft Access, Visual Studio 2K8, ERWin, Visio

Confidential

Data Analyst

Responsibilities:

• Planned, developed, implemented, maintaining and administering Access database used to compile and analyze Citizenship and Immigration fee waiver data that consists of millions of records annually.
• Created ETL processes to import Fee Waiver data from the Field Offices
• Development of an ETL infrastructure, including the use of metadata, staging, and load/reload procedures.
• Producing technical requirements and design documentation for ETL processes
• Designed tables, queries, forms, and reports.
• Writing and tuning complex SQL queries
• Analyzing source system to identify and document data quality issues
• Maintained database dictionaries, work on complex projects, ensure database performance and resolve problems, analyze and project long-range space requirements, and perform Life Cycle Support for the databases.
• Developed MS Access applications based on functional requirements received from clients
• Performed SQL queries to retrieve pivotal information to provide to other Government agencies, Congressional staff, and news reporter regarding the numbers of Fee waivers that were received, approved, or denied.
• Provided experienced technical consulting in the definition, design, and creation of a database environment
• Advised applications development staff and users on data-based solutions to business problems, data architectures, database management system facilities and capabilities, and the operation and tuning of databases.
• Participated in user acceptance testing to identify the problems and needs of the new Confidential data collection system, ePAS (Enterprise Performance Analysis System) and SMART system.
• Worked with a team to create static reports and gather requirements for the SMART system.
• Prepared and disseminate weekly, monthly, quarterly, yearly, and as-needed production reports and analysis, and other performance management reports for distribution to management and specified stakeholders.
• Developed flow diagrams that detailed the work process.
• Created pivot tables, graphs and statistical charts to display the movement of data as well as represent the performance of Field Offices’ production and workload using MS Excel.
• Performed, integrity and quality of the databases, control system capacity for existing requirements and plan for future needs.
• Trained end users on how to use software applications.

Applications Used: SQL Server 2008R2, SQL Server Reporting Services 2K8, Microsoft Access, Microsoft Excel, Visual Studio 2K8, ERWin, Visio

Confidential

Business Analyst

Responsibilities:

• Monitor 20 web servers daily to make sure that they are accessible by the public and internal users.
• Performed Quality Control checks of documents for the WEB CRD and IARD environments.
• Created and maintained an Access database that tracks each trouble ticket that was opened for the Production Support department.
• Research and analyze business-related issues.
• Created and maintained an Access database that tracks each trouble ticket that was opened for the Production Support department.
• Review and document business activity, systems, products, and processes
• Recommended innovative ways to increase the processes of the data and submit schedule change request for possible changes to implement in the each software release.
• Attended meeting with the Data team to discuss changes that were proposed. Prepared business rules for the system.
• Perform Quality Control testing to ensure the validity of the data in the database after an upgraded software release.
• Provided advanced-level technical and business support to system, product, and process users on a daily basis.
• Developed training, documents, and materials.
• Performed SQL queries in an Oracle database to analyze data.
• Identified technologies that improve program and system quality, economy, and efficiencies
• Performed acceptance testing on servers to be used in production environment.
• Prepared a weekly Outage Report in Excel 2000 that documents the web server outage times, dates, problem, and ticket number that was pened for the case.

Applications Used: Toad, Microsoft Access, Microsoft Excel, Remedy

Confidential

Installation Coordinator

Responsibilities:

• Provided assistance defining, documenting, & maintaining technology service standards & policies related to hardware, software operational procedures.
• Served as primary technical implementation and deployment contact for domestic and international customers.
• Communicated with the customer, domestic and internationally, regarding service problems or to clarify any product issues.
• Inputted customer data, opened trouble tickets, updated customer information, and tracked customer problems using the Remedy Action Request system.
• Created configuration files, using the Unix (FreeBSD 4.0, 3.2/Sun Solaris), for specific customers to run the software.
• Supported installation for 10 customers simultaneously
• Worked w/ customers on a daily basis to get equipment to them and walking them through each step to make them Operational.
• Accustomed to working in a fast-paced environment and juggling multiple assignments while producing accurate work.
• Guided customers in implementing the most efficient network topology for a given LAN/WAN.
• Worked with contractors scheduling site survey and install dates to have equipment installed on site.
• Assisted customers in meeting Kerberos security specifications through proper DNS resolution.
• Troubleshoot issues dealing with TCP/IP on the customer's network. (Denmark. Europe. Asia) via telephone.
• Analyzed and solved customer connectivity issues using ping and other ICMP-based messaging, traceroute, nslookup, telnet.
• Configured, tested and maintained in-house Service Adapters prior to their deployment to customer destinations.
• Configured and shipped customer equipment computer hard drives, service adapter by Confidential, Intel Switches 416T, Remote Power Units, and Broad Logic and Viacast receivers using Unix on a SPARC station.

Applications Used: Remedy, Microsoft Access, Microsoft Excel, UNIX