| Summary of Qualifications Fourteen years, of extensive experience in project, staff, operations, and process management. Managed the software development life cycle which includes planning and finances, program and project management, software development, package implementation, infrastructure and operations, configuration management, networking and data telecommunications, and implement procedures for the continuing growth and reliability of the company 's network and data center. Development of procedures to allow for utilization of GREEN practices to assure environmental and cost saving strategies and in bridging the communication gaps between IT and management. Experience Confidential Consultant of Information Technology - Analyzed and effectively report on project metrics which explained hours burned vs. hours estimated, profitability, project progress, risk and issues
- Created and delivered presentations on project goals and plans, including progress reports for management
- Developed and managed complex project plans and budgets, working with team members to understand problems, focus on bringing issues to resolution, and escalate as necessary to meet timelines
- Worked with other department managers to identify, articulate, and manage project risks and issues
- Facilitate team and staff meetings effectively and enforcing departmental changes and procedures
- Third party billing to healthcare programs medicare, medicaid HP and state APS contractor using EDI interface solutions and enhancements
- Create medical billing procedures and HCFA-1500 forms for Medicaid and State payers APS
- Analyzed data from various SQL databases and debug reporting issues
- Ensured that training and user documentation are available for staff
- Handle confidential and sensitive information with discretion
- Assisted in troubleshooting user problems relating to Operating System issues Windows XP/7, Vista, and SBS 2008 , network connectivity, TCP/IP configuration, upgrades, MS Office products and internet connectivity
- Manage user rights and permission, disabling and enabling accounts, file and folder permissions and configuring security templates as per need.
- Assisted on on-site visits hardware troubleshooting, local system upgrades deployed updates, service packs and hot fixes using Windows Update, Automatic Updates, and Group Policies
Confidential Crystal Report Developer - Creating and troubleshooting SQL views, stored procedures, and functions at basic levels
- Audit existing applications for inefficient code and fix / trouble shoot or offer alternatives as needed
- DML Data Manipulation Language statements i.e. Inner Join, Outer Join, Cross Joins, Self Joins, aggregate functions, etc.
- Ability to extract and analyze data from the data warehouse using Crystal Reports
- SQL server database or T-SQL scripting hands on experience developing, implementing and establishing support policies and procedures
- Managing and supporting any problems, categorization break/fix vs. enhancement , root cause analysis, creating a knowledge base library
- Responsible for corrective action as warranted, of day-to-day production support/maintenance, application availability, and reliability
- Designing, developing and maintaining Crystal Reports based on the standards and guidelines provided in large enterprise based environment
- Knowledge of application development and web reports using Crystal Report XIR2
- Created complex store procedure in Microsoft SQL server and Oracle
- Installed and configured XIR2 Enterprise
- Migrated BO/Crystal reports X to BO XIR2
- Gather resources to perform assigned task for projects to be implemented into the environment
- Responsible for ETL technical design, development, implementation and support for a Data Store project
- Design and implement a database cluster which meets data availability, recovery, security and auditing requirements including failover procedure testing
- Tuned SQL statement by create views to minimize response time
- Setup universes in business objects web intelligence XI/R2 environment
- Scheduled meeting with end user to collect data and specs
- Coordinated and scheduled weekly SFTP files with other State Departments
- Develop ETL jobs to extract data from various source systems
- Assisting with mapping requirements, developing estimates, developing data warehouses, developing OLAP databases, writing reports, performing some DBA tasks, code and data testing
- Worked closely with business analysts, DBA, and project manager to plan, design, develop, implement, and enhance applications, scripts, procedures, and metadata for relational databases
- Provide input to training and/or documentation materials regarding latest technical and functional design changes
- Recommend, created and adhered to policies and standards regarding the use of data and databases
- Develop and deploy SQL scripts, stored procedures, functions in support of application database needs
- Translate business requirements into an effective and efficient data model/architecture
- Perform database development activities such as coding stored procedures, triggers, and operating system scripts
- Perform troubleshooting multiple data extraction, transform, and load processes
- Designed and implement web pages using Crystal Report Enterprise
Confidential Report Developer - Worked with developers in resolving issues relating to views and application performance
- Verify that design meets quality standards and functional/technical requirements
- Provide basic WebFOCUS support and provide accurate and complete answers to detailed product questions in a timely manner
- Provide accurate level of efforts for design and programming efforts for system changes and enhancements
- Solid understanding of queries, database objects, design and architecture
- Provided input to training and/or documentation materials regarding latest technical and functional design changes
- Document all work for future reference
- Developed and modified complex parameterized WebFOCUS reports
- Supported enhancements of the intranet-based investment reporting application
- Performed impact analyses on production fixes and enhancements to establish priorities
- Monitored and maintain WebFocus components, including ReportCaster Reporting Server, master files, and other similar reporting objects
- Create timely solutions based on customer requirements regarding business rule changes and database changes to support better reporting
- Collaborated with the rest of the report and development team to come up with a realistic and sound solution for a given business problem
Confidential M.I.S. Programmer - Design, develop, test, and support SQL stored procedures, functions, triggers and other database objects to solve complex business problems
- Improve performance on the database
- Ability to think, work and contribute beyond defined responsibilities
- Performed system design, architecture, and implementation
- Responsible for scripting, design/analysis, installation, monitoring, maintaining, troubleshooting, and tuning databases used by all departments
- Designed, developed, tested, and documented workflows based on the business process requirements
- Provides crystal report training to peers, supervisors, and managers
- Designed, developed, tested, and documented templates and forms
- Developed new and custom components as well as applications that integrate with the current web applications
- Migrated BO/Crystal reports 7 to BO XI
- Resolved issues / requests as well as escalate issues if required
- Ability to work under pressure as while as multitask projects daily
- Custom print screens
- Participated in the development of internal standards and best practices for ETL and database design
- Worked closely with managers to understand, document and design and code OLAP and reporting needs
- Designed, developed, tested, optimized and deployed packages and stored procedures to perform all ETL related functions
- Tracking changes to Dataflex code and databases
- Created project progress chart based on the project schedule
- Monitored and created new webpage's to KEH website
- Modified and maintained website databases
- Created security for credit card information on KEH website
- Experience with the development and support of web enabled database applications using ASP, ColdFusion and IIS 6.0
- Experience working with XML, CSS and JavaScript
- Assist in the modification of Coldfusion, and MySQL on the web servers
- Developed, tested, deployed and supported tools as specified by web development management
- Tested all projects before implementing them into production
- Assisted with planned and unplanned downtime, including notification of customers
- Assist in the analysis of changes to hardware, network, database objects, patches and applications
- Research new technologies and offer suggestions for latest upgrades
- Participated in engineering brainstorming sessions
- Engineer reports using Coldfusion on the website and Crystal Report in-house as specified by management
- Trained end users to operate new or modified Dataflex programs
- Analyzed and assessed existing business systems and procedures
- Generated statistics and write reports for management and/or departmental reports on the status of the programming process
- Administer critical analysis of test results and deliver solutions to problem areas
- Install software products for end users as required
- Created SQL Server stored procedures and triggers
- Assist in developing database security, control procedures, testing, conversion, implementation and documentation
- Assist in the preparation, creation and review of test plans and data
- Perform pro-active database performance monitoring and tuning
- Developed windows and web based GUI's, build modular middleware layers plus developed database schema and stored procedures
- Inculcate good software design methodologies and patterns into the system
Confidential Visual Basic Developer - Developed skills in SQL created stored procedures triggers and designed complex tables
- Designed and documented the sales department databases
- Updated existing applications based on feedback and recommendations
- Document software changes according to our documentation procedures
- Accepted responsibility for agreed upon schedules being met
- Maintain the code library in a central location
- Work with end users to ensure the highest quality of applications from analysis and design through the final testing phases and application deployment
- Assist in developing database security, control procedures, testing, conversion, implementation and documentation
- Communicated schedules and plans to mangers and end users
- Followed standard policies and procedures defined by the IT manager
- Continually dove high utilization and effectiveness on projects
- Provided leadership and mentoring to the IT team and end users
- Created universe classes, subclasses, objects, conditions, joins and prompts
- Determined the effectiveness and efficiency of existing reports
- Performed unit testing of new and modified reports
- Analyze customer database and reporting needs and requirements, implement recommended solutions
Confidential Visual Basic Developer - Designed and developed an intranet applications using various client-side and server-side web technologies
- Designed, developed and tested the presentation's run-time platform
- Migrated Visual Basic 3.0 code to Visual Basic 6.0
- Closely monitored fully rendered assets for quality and file size to ensure that they were compatible with the run-time platform and the target distribution
- Migrated access database into SQL Sever
- Supported existing business object solutions as needed
- Shared technical knowledge with team members
- Researched and evaluated alternative solutions and recommends the most efficient and cost effective solution for the design
- Managed, tracked and resolved support requests from end users related to various crystal reports
Confidential Production Representative - Analyzed various payroll and time and labor audit queries for different payroll cycles to ensure smooth process before confirming the payroll
- Managed the e-fax and payroll e-mail boxes
- Developed processes to improve workflow, reporting and efficient processes
- Ensured pay adjustments were handled correctly to minimize impact on the W2 Wage and Tax Summary Statement and/or 1099-R tax form
- Closely monitored fully rendered assets for quality and file size to ensure that they were compatible with the run-time platform and the target distribution
|
Privacy Policy
