Objective

To explore opportunities with new challenges where I can use my experience and skills set to help a prospective employer achieve its goals and become a valuable asset to the company.

Experience

Database Application Developer

• Built custom applications utilizing Microsoft Access and Web forms as the frontend and SQL Server as the backend data and processing environment.
• Created technical documentation as part of the development process
• Produced various reports and reporting tools for internal client use
• Performed data analysis and presented results as pivot tables, charts, and summaries that were effective in conveying what the data represented from a business perspective

Confidential

Database Specialist

• Built SSIS packages as ETL processes that imported data from various data sources into SQL Server and Access.
• Web application development using ASP.Net
• Database development for new applications, reporting, and analysis
• Converted MS Access databases to Web Application with SQL Server 2008 R2 backend.
• Performed analysis and profiling of company data and presented to stakeholders through reports, charts, and diagrams. This job function was critical to our business because it showed where we were doing well and where opportunities may exist for improvement.
• Involved in report and application development from requirements gathering and coding to testing, deployment and documentation
• Use case testing for applications and reports
• End user training and on-going support
• Created technical documentation of all applications and reports I built or had involvement in.

Confidential

• Project technical lead for analysis and reporting
• Specialized in data integrity analysis and data profiling for trend reporting
• Create automation queries and SSIS packages for data imports and validation.
• Issue resolution including root cause analysis, business impact, and resolution
• Engage external vendors to resolve data issues, including file format, data integrity, and delivery
• Liaison between business and IT in order to complete project tasks such as connectivity, security and compliance
• Ability to prioritize and work on concurrent tasks in a fast-paced, time-sensitive environment
• and migrations to new data platform
• Perform User Acceptance Testing on new data implementations
• Create mapping documentation identifying data attributes relationship between source and destination systems
• Develop, document, and maintain business processes that enhance support and monitoring capabilities

Confidential

• Data analysis, querying, and reporting using data warehouse and other relational environments.
• Interrogate data and data sources for validation, anomalies, consistency, and reporting purposes.
• Analyze and evaluate present or proposed business procedures to define efficient methodology .
• Create Ad-Hoc reports using SQL, Cognos, and other reporting applications. This often entails building databases and programs when required to meet reporting needs. Also automated Ad-Hoc reports that one required on an ongoing basis freeing up valuable resource time .
• Interact extensively with external and internal clients. Specifically, work with Business Analysts, IT resources, business stakeholders, and clients in order to ensure the appropriate technologies and resources are used to efficiently complete projects.
• Create data maps based on analysis of data source and destination target environment. This entailed validating data format, content, and purpose met business and technical expectations.
• Translate requirements of the client into highly technical specifications in brief.
• Coordinate and link the computer systems in the organization to increase compatibility and so information can be shared.

Confidential

System Administrator PMO Coordinator

• Develop and maintain installation and configuration procedures.
• Contribute to and maintain system standards.
• Produce detailed, technical documentation including flows and diagrams outlining systems requirements and interface definitions.
• Implemented Time Management module into our HP PPM system. Including test case creation, user acceptance testing, project management and end user training.
• Manage the HP PPM time submission and approval process. Tasks include compliance reporting and follow up, notifications and enforcement.
• Manage the system upgrade process entailing software implementation, configuration and contingency roll back plans.
• Troubleshoot and resolve hardware, software, and connectivity problems, including user access and component configuration.
• Maintain operational, configuration, or other procedures.
• Provide Tier III/other support per request from various constituencies. Investigate and troubleshoot issues.
• Interpret and/or discuss information with others, which involves terminology or concepts not familiar to many people regularly provide advice and recommend actions involving rather complex issues. May resolve problems within established practices.
• Provides occasional guidance, some of which is technical.

Confidential

Technical Analyst

• Experienced in managing, implementing, and supporting applications, interfaces, databases and IT related projects
• Developed data standards to support reporting and analysis
• Extensive, detailed analysis skills in a technical environment
• Work with ETL team in interpreting data mapping documentation and testing
• Create Ad-Hoc reports using PL/SQL, T-SQL, and Oracle
• Developed training program for end user community included in the program was the training of over 300 users.

Confidential

Production Programmer

• Primary responsibilities entail data manipulation within a TSO MVS mainframe environment. Work closely with customer service representatives and other staff to ensure client requirements are met in an accurate and timely fashion.
• Create AD-Hoc reports using Oracle Report builder program utilizing my extensive experience in SQL to effectively create and provide reporting solutions to management.

New process development and documentation.

Confidential

Direct Mail Programmer

• Performed data hygiene on customer data using Mail Manager 2010 and First Logic. Processing included: CASS certification, NCOA, Merge Purge, Postal Presort.

• Prepared final data files for Scitex inkjet and IGEN variable printing
• Communicated with inkjet, digital printing, and prepress in order to properly configure data files for production.
• Worked closely with postal officials to ensure we were up to date on latest postal developments that would impact the mailability of our products. Also, set up permits
• Implemented new processes that improved efficiency of data file processing. i.e. templates, requirements for processing forms

Confidential

Programmer

• Created DTS packages to handle database uploads and updates
• Maintained data integrity of a complex and highly clustered SQL Server environment.
• Analyze data and create Ad-Hoc reports for client and management.
• Communicate data analysis results both verbally and written to appropriate parties. i.e. client, other departments, management
• Processed customer data using First Logic Software. Processing included: CASS certification, NCOA, Merge Purge, Postal Presort.
• Prepared final data files for Scitex inkjet equipment printing
• Communicated with inkjet and prepress in order to properly configure data files for production.
• Worked closely with postal officials to ensure we were up to date on latest postal developments that would impact the mailability of our products. Also, maintained permits