Business Analyst Resume Profile
CT
Professional Summary
A highly efficient and motivated IT Developer Engineer with over 15years experience in systems design and development, data analysis and integration, administration, technical support and project management. Effective in ensuring high standards of design and support excellence, confidently interacts with all levels of management and aptly skilled in the execution of proposed projects.
Key Skills, Areas of Expertise Competencies
- 7yrs in ASP.NET, VB.NET, C , VB, C , Java, SQL, Web Services and Crystal Reports, JSON, JQuery, SSIS and SSRS
- Comprehensive understanding of design pattern Singleton, Prototype, Abstract Factory method and Builder
- Expertise and extensive knowledge of varied software, database and programming applications
- Interchangeability in operating in both Windows and Linux/Unix Environments
- User acceptance testing and adherence to project guidelines and business standards
- Detailed data reporting and code analytics
- Procedural systems analysis and troubleshooting
- Results oriented team player with strong multi-tasking abilities and focus on Quality Assurance
- Open-minded and willingness to learn and teach
- Ability to cultivate key interpersonal relationships with clients in building technical specifications from project requirements
- Self-motivated, able to work without supervision, and adaptable to change
- Out-of-the-box thinker who enjoys finding innovative and creative solutions to complex issues
- 5 yrs. of Electronic Data Interchange experience working with data packets over distributed networks and serialization
Work Experience
Confidential
IT Product Manager
- Worked with the JIRA Ticketing system and organized daily SCRUM meetings in conjunction with QA Manager to guide the development team to concise and clear objectives towards key implementation goals.
- Coded in SSRS to create a reporting engine for the CRM release Escoware front end system to show conflicting data for cleanup and investigation to client utilities companies that conducted their billing through our interface.
- Coded in C for version control self-updating of the web application as well as bug fixes with the CRM front end interface for scheduled deployment.
- Worked with stored procedures to troubleshoot scheduled jobs for the nightly update process feeding in data from client utilities to be processed through our internal systems for their customer base for their review and examination.
Confidential
Senior Software Developer contractor
- Worked with C in combination with, JavaScript and Infragistics Controls to enhance and build out the Advix web application for Advanced Behavioral Health Care.
- Provided analysis for assessment of database connectivity failure for the client as well as ran reports off of Oracle database on request along with driving web application enhancement and providing code debugging and hotfixes.
- Implemented and designed SQL procedures through the existent WPL layer within the C code for the Advix application new release
Confidential
Senior Software Developer
- Worked with ADAPT proprietary systems in conjunction with Pervasive SQL to create scheduled jobs for data files containing fund services information.
- Committed work effort to troubleshooting analysis of SSRS services towards various reports that were not generating the correct data or in some cases no data requiring in depth analysis and coding of the existing C application and driving that process to completion.
- Created table structure, imported data within SSIS and created ad hoc stored procedures on client requests. Implemented a new internal job scheduled application aggregating data for Fund services and correlating to brokers data within the various brokerages that the company worked with over time.
- Responsible for the parallel migration of existent jobs running through ADAPT that connected and ran successfully generating the correct test data on the new designated server assigned within a same day turnaround timeline.
- Worked with Pervasive SQL to implement data mapping of the existent file gathering process and SQL Server Management Studio to troubleshoot stored procedures and analysis of reporting services that had errors to be fixed on the database layer.
Confidential
Production Support Analyst Consultant
- Dedicated coding skills to a complete rewrite and build in VB.Net of the Advance Amisys Session Launcher a transitional application originally coded in VB6 that launched browser sessions in multiple user environments configured within the XML portion of the code.
- Created and improvised stored procedure and instituted a substantial ADO code fix enhancement that resolved the issue of an inadequate table structure that had no relational keys to specific data thus saving the end users hours of manual work to achieve the same results.
- Created a C number generator web application on demand building the sequence from a text file and from there inserting the random numbers as the new primary key for Oracle table for provider and member affiliation data that due to a flaw in the design the system would have run out of that key sequence integral to data correlation and running effective reports.
- Implemented SQL scripts to allow employees and consultants permissions to Surround and Fast Processor Applications.
- Developed a comprehensive Oracle SQL queries to generate active data for the Provider Affiliation application loading quantified table and query data from Access to be processed through my redesigned query that had to incorporate a change in the parameters to factor in a range between the effective date and future end date within the membership cycle.
Confidential
Senior Software Developer
- Conducted Windows Communication Foundation coding with TCP binding enabling client banking software to connect to windows Services remotely on the existing HP Thin Client CAT systems.
- Provided client support and code fixes for legacy VB6 code for the existing version of Cash Ware program providing tellers and banking personnel with records and measuring controls User Acceptance Testing in accordance with project guidelines and business standards.
- Participated in WebEx online customer support sessions troubleshooting issues with Cash Ware coding bugs as well as connectivity to the API regulating the cash dispensers and recycler machines.
Confidential
Senior Software Engineer
- Conducted detailed coding modifications and logging capability to existing Payment Delivery File Application that FTP and sent confirmation emails with attachments to clients concerning their billings.
- Documented changes to existing EA legacy application for individual clients by generating the proper SQL scripts and revising the document attachments required to be added.
- Monitored ITP and client related jobs in SQL for deadlock in their processing and reran them when necessary according to management decision.
- Was responsible for complete unit testing and documentation of all projects before submittal to QA and timeline for production release of deliverables.
Confidential
Senior Information Analyst
- Performed coding analysis of .NET applications ASP.NET and VB.NET enhancing existing functionality based on the new business requirements.
- Developed test cases and worked on metrics and testing requirements for revised applications.
- Conducted code changes to existing applications written in ASP, .NET and SQL achieving management expectations.
- Routinely write tickets in HP Service Manager ticketing system to schedule code into development and production server environments for successful deployments.
- Collaborated with business clients and offshore personnel to build business requirements successfully maintained timeline for key deliverables.
Confidential
Web Developer
- Developed and documented internal web applications using ASP.NET, VB.NET, C , Java script, XML, and Business Objects Crystal reports.
- Provided regular data analysis. Created SQL stored procedures using ADO.NET to extract/store data and access member information.
- Routinely provided troubleshooting support on data and development issues.
- Provided a key contact for internal clients in developing business requirements and set timetables for testing and implementation of projects.
Confidential
Systems Integration Analyst
- Wrote SQL stored procedures to check developer code and ran migration scripts against client environments. Performed Sybase to SQL server database migrations.
- Wrote project specifications defining client needs and provided analysis in the processing, transfer and integration of sensitive client data among Dealogic products for major accounts such as Oppenheimer and Deutsche Bank.
- Acquired procedural knowledge of finance, securities and trade operations, SOX compliance.
Confidential
Developer
- Co-authored the E-TRAC application for the museum to upload personnel information for pre-tax and post-tax deductions for their Transit-Check system.
- Developed the Travel Desk Application which keeps track of all business expenses and locations of personnel for all business related trips.
- Implemented maintenance on existing Museum applications in production by creating new Crystal Reports and SQL queries behind them to extract data for generating the proper insurance certificates for the catalogued artwork in the Registrar's Office.
- Directed upgrade of the OLAS systems between the client and third party vendor Salmon LLC and distributed the SQL scripts and Java servlets in the proper directory folders within the application server.
- Assisted the web staff in modifying/updating existing pages and images on the Museum website.
- Set up key application versioning meetings and demonstrations of in house built applications coded to client specifications.
Confidential
Software Engineering Consultant
- Constructed educational software packages and data base applications for corporate clientele and healthcare providers.
- Assisted clientele with deployment of services from inception through completion, via both on-site and web meetings.
- Provided web site design assistance for Andersen Consulting and conducted beta testing for completion of applications.
- Acquired managerial experience in full life cycle project design implementation.
- Provided expansive, second level, high profile support in cases of elevated need.
- Interfaced with clientele and displayed strong troubleshooting attributes as deemed necessary.
- Tested and certified software applications SRD for business users.
- Conceived methods and procedures for overall desktop deployment including site survey and discovery, software application and testing, PC staging, inventory tracking and disposal of damaged equipment.
- Implemented standards applications on various operating systems.
- Ensured all work was performed on a timely basis while adhering to quality assurance guidelines and procedures.
Confidential
Business Analyst
- Provided administrative and technical support for Department of Transportation and Department of Motor Vehicles staff members as well as State and City law enforcement officials
- Created and modified computer databases utilizing MS Access to archive new and existing data
- Compiled statistical data on NYC traffic patterns to support the Red Light Camera Project
- Worked directly with network administrator to ensure server maintenance and upkeep
- Liaison with vendor maintenance staff and client in terms maintaining reliability of hardware and service contracts
Confidential
Technical Support Specialist
- Performed hardware/software upgrades on over 50 computers within the NYC Transit Authority.
- Provided technical and software support to end-users.
- Worked with system administrators to define network parameters and maintain system integrity.
