| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Highland Park, IL Street Address PHONE NUMBER AVAILABLE EMAIL AVAILABLESenior Programmer AnalystDriving projects forward from design inception through successful completionSystem Improvement Focused Strategic Problem SolverStrong Analytical SkillsExpert in all facets of software development life cycle (SDLC), from analysis and design through development, implementation, documentation, and user training. Software developer with extensive experience in Information Technology. Expertise in IT processes and procedures in security, financial and sales industries. Provide high-level development, testing, deploying, and maintenance for custom software solutions. Perform well in a project team and independently. Quick learner and self-starter with excellent communication skills, ensuring meticulous attention to details. Naturally inquisitive troubleshooter and detail-oriented team member. Adapt easily to changes in priorities, seamlessly manage multiple assignments simultaneously. Excellent follow-through skills.Summary of QualificationsProgramming and Scripting Languages: C#, Delphi, Visual Basic, C, HTML, VBA, VB Script, PL/SQLDatabases: MS SQL Server, Oracle, Transact-SQL, Sybase, MS AccessOperating systems: Windows NT - 10, DOS, UNIXTools: SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), Crystal Reports, SAP Business Objects, Service Now, Microsoft Office Suite (Word, Excel, Outlook, Access), MS TeamsProfessional ExperienceUSA CLINICS GROUP, Northbrook, IL February 2022 October 2023Programmer AnalystCreated, maintained, enhanced, and optimized stored procedures, functions, cursors, and joins, created database objects like tables, views, triggers, indexes necessary to support SSRS reports. Designed and developed new reports from scratch, maintained and modified existing different types of SSRS reports to meet business needs. Provided ongoing design, development, and implementation of SSRS reports. Interacted with internal users and the third-party Services to determine which datasets should/should not be integrated over. Supported general business reports and benefit plan administration processes. Worked closely with various departments and supported their analysis and data needs. Optimized SQL Stored Procedures.Developed complex Stored Procedures to generate various Drill-down reports, Parameterized reports, Tabular reports, and Matrix reports using SSRS.Created interactive parameter driven SSRS reports providing clients the ability to review and analyze their claims.Owned the design of advanced analytics dashboard and KPI reports starting from requirements gathering from billing, call center, and senior leadership teams to the delivery of a final, polished reports to production.Created numerous customized reports and ad-hoc reports based on end-user requests, analyzing effectiveness of business.Candidate's Name EMAIL AVAILABLE Page TwoUSA CLINICS GROUP (Continued)Developed different type of reports including Billing Reports, Scheduling Reports, Accounting Statement Reports, Inventory Report, Auditors Reports, UFE QOL Study Report and Insurance/Payroll/Expected Payments reports using SSRS and SSMS.Optimized database by creating various clustered and non-clustered indexes. Managed index statistics, tables, cursors, and optimized queries by using execution plan for tuning the database.Extensively used joints and sub-queries for complex queries involving multiple tables from different databases. Analyzed data and re-mapped fields based on business requirements.SECURITAS SECURITY SERVICES USA, Rosemont, IL June 1999 October 2021Senior Programmer AnalystDesigned, developed, and implemented frontend and backend models for various applications. Stored, retrieved, and manipulated data for analysis of system capabilities and requirements. Performed automated/manual data clean ups/updates on bad or corrupted records. Provided ongoing design, development, and implementation of Crystal reports for business needs. Monitored system operation to detect potential problems. Coached users on issue-prevention techniques. Documented system design specifications and other system-related information. Performed data conversion from Sybase to MS SQL Server.Designed, developed, and implemented frontend and backend Administrative, Billing, Accounts Payable, Scheduling systems designed to handle massive data traffic, using C#, Delphi, and Microsoft SQL Server, providing ongoing support of the implemented systems.Created numerous customized reports based on end-user requests, analyzing effectiveness of business.Wrote complex SQL scripts and queries, created Stored Procedures utilizing Dynamic SQL.Worked on enhancements and optimizations, addressing design gaps and ongoing evolving requirements requested by business.Developed billing portion of Billable Non-Worked process intended to flag Time Off (PTO) as billable and automatically create corresponding Supplemental Charge to easily tracking PTO through the scheduling system, reducing work required by the field, increasing accuracy of all changes, affecting client billing and employee payroll, and eliminating 100% data input manually.Successfully designed and developed Holiday Update application requested by business to automize annual process ran for U.S. and Canada systems, reducing processing time from 8 hours to 1 hour.Successfully designed and deployed Patrol and Alarm system used for scheduling and billing processes of mobile security services provided by the company, reducing input data time processing by 70% and increasing efficiency of provided mobile services by 50%.Collaborated with a team, creating, and maintaining payroll system.Communicated with testing leads for robust testing of requirements and solutions, ensuring compatibility, lower regression occurrences, and maintain code integration.Communicated with training leads, providing clear documentation of billing and payroll processes solution and scheduling system.Provided production level support for detailed and complex issues, requiring intense data review, script development and execution, and coordination with end-users.Successfully implemented migration of non-relational database-based application to a fully relational Sybase-based utility.Candidate's Name EMAIL AVAILABLE Page ThreeSECURITAS SECURITY SERVICES USA (Continued)Developed tools to perform data-transformation service for uploading and downloading unsynchronized data from company centralized mainframe-based system to local offices.Modified the existing software, resolving issues to improve performance.Created interfaces, communicating with field data collecting devices, such as magnetic card readers, and chip-readers.Analyzed assigned Help Desk tickets from the end-users, developing solutions to resolve the issues.Provided technical support to end-users, leveraging broad-based expertise to handle problem identification, diagnosis, resolution, and escalation via helpdesk system, telephone, and remote support tools. Performed security administration functions for user, data, and remote access.Additional Relevant ExperienceVOLKSWAGEN CREDIT INC., Deerfield, IL, Programmer AnalystEducation and TrainingBachelor of Science (BS), Mechanical Engineering,Tashkent State Transport University (TSTU), Tashkent, UzbekistanMS Visual Basic, MS Access, Project methodology,Advanced Windows Development Program for Professionals, Lincolnwood, ILSAP Business Objects for design and reports, Rosemont, ILWebucator, Technical & Business Training, Rosemont, IL |
