| Experience | Confidential System Administrator - Extensive use of the following were necessary for the successful preparation, development, updating and enhancement of these complex reports
- Extensive use of the following programming languages SQL, TSQL, HTML, XHTML SAS, VB, VBA, XML, JavaScript, VBScript, VB.Net, ASP.Net was used in the preparation, distribution and enhancement of the reports.
- Reporting was off of a NetSuite ecommerce platform and MySQL Data Warehouse. Responsible for the development of a tool in Visual Studio 2010 to streamline the reporting process
- Provided design, implementation and maintenance for custom reports.
- Participated in a number of cross-functional teams.
- Adhered to best practices in terms of coding standards.
- Mapped data between Crystal Reports, Data Marts and the Enterprise Data Warehouse.
- Translated end user reporting requirements into technical design documents.
- Developed complex, production-level reports.
- Responded expediently for requests to create, modify and fix reports.
- Prepared time estimates for all Crystal reports developed.
- Created mock-up reports for review.
- Gathered reporting requirements from the requestor and shared report options with the requestor.
- Solely responsible for the development of processes, interfaces and Crystal Reports XI reports Also responsible for the daily, weekly and ad hoc generation and distribution of the report data. Daily, I was responsible for the processing of over 10,000,000 records in the development of the financial and productivity reports. I was also responsible for the support, modification and maintenance of the approximately 40 Crystal reports that are currently in production.
- generating Sub Reports, Cross Tab Reports and Graph Reports by using Chart expert
- shared and global variables
- functions like WhilePrintingRecords, WhileReadingRecords etc.
- pre defined functions like string, date, numeric, conversion and null functions of Crystal like isnull, inrepeatedgroupheader, monthtodate, lastfullmonth, lastfullweek etc.
- writing complex formula at the summary level and group level to implement the business logic
- developed sophisticated Excel 2010 VBA for display of summary total
Confidential IT Consultant - Provided 3rd level technical support for a national medical services operation on a wide range of issues such as application installations, pc and laptop initial setup, imaging, MS Office and Windows upgrades as well as issue resolution. Responsible for the complete resolution of issue and performing the necessary research and tasks to accomplish this.
Confidential MS Access Developer/Data Analyst - Solely responsible for the analysis of the SQL and VBA code of an existing MS Access based application to determine the resolution of issues experienced due to inaccurate output data being produced by the app. Determined the reasons for the discrepancy and developed and implemented the solution that fully resolved the issue.
Confidential Informatics Support Services Technician/Data Analyst - Providing 1st level support on all Windows XP 7 operating system issues Examples of the support provided includes the following,
- Development of forms, interfaces and processes by the use of Access, VBA, SQL and other techniques to more efficiently deliver the daily, weekly and monthly reporting on call volume, resolution rate, outstanding issues, training activities, AEDW and Application User access lists quarterly for audit purposes etc. for all Informatics areas and the development and enhancement of the actual reports. Also was responsible for the distribution of these reports and processing the information updates as a result of them.
- PC Performance issues by the use of disk defragmentation
- Windows Firewall Settings
- Internet Connection Settings
- Registry Issues by use of the Registry Editor
- Application install, uninstall reinstall
- System Restore Process
- Providing 1st level support on all LAN. AEDW, Teradata, Blue Info Explorer, Active Directory, SAS, SQL Server 2008, Teradata Active Enterprise Data Warehouse AEDW , Teradata SQL Assistant 12.0. Advanced Query Tool AQT , PCAnywhere Citrix Remote Access over 500 other web based and mainframe applications. The support involved attempting to ascertain the issue resolution and if necessary determining the appropriate referral area on issues requiring escalation. The tracking of issues was done with the use of HP Service Manager.
- Development of training material used to cross train Customer Support Center technicians on the support of Informatics issues. Responsible for the training of these associates on the support of Informatics issues.
- Weekly update, compression back-up of the MS Access based Issue tracking system application database residing on a network server that was being used on a wide area network to track reported issues.
- Processing of all AEDW, Teradata access requests from start to finish which included determining and obtaining all of the required approvals and following the request through to a successful completion.
- Administration and technical support of the. Informatics Information Delivery System IIDS web based reporting system. This system consisted of an internal version for IBC associates: BlueInfo Explorer BIE an external version for IBC customers: Informatics Express. The reports were developed in the SQL Server 2008 SSRS environment.
- Logging tracking all of the various issues related to AEDW, Teradata, Blue Info Explorer, Informatics Xpress and Cognos. For 2009, 1,794 Issue tickets were processed by with resolution of 89 of them being successfully determined by me and the ticket closed.
- Proper Network Access Request NAR preparation, submission processing for issues such as application installation, ODBC driver installation, LDAP account setup etc. Also was responsible for follow-up and follow through to completion of all Network Access Request NAR forms submitted as well as the final testing to confirm the successful application and ODBC install, LDAP account setup etc.
Confidential System Administrator - Responsible for the coordination of a nationwide project installing kiosk workstations in over 300 sales offices. Responsible fro the acquisition and installation of the necessary equipment at each office. Also responsible for making the arrangements to have the electricians, etc determine and address the specific infrastructure needs of each office
- Responsible for coordinating and managing the configuration, installation and initialization of the Pivotal 5.1 CRM system web based front end on over 500 computers located in Sales offices throughout the country through the use of Symantec PCAnywhere remote access software,
- Responsible for providing 2nd level telephone technical software support to staff located throughout the United States on application questions in the Pivotal 5.1 CRM system web based front end with a SQL Server 2000 relational database backend.
- Responsible for the setup and management of user accounts and troubleshooting user access issues
- Responsible for providing 2nd level telephone technical software support to staff located throughout the United States on application questions in Microsoft Excel, Word, Access, PowerPoint, Novell GroupWise, Internet Explorer and many others.
|
Privacy Policy
