Jegades Kumar Achappan
*** **** **** ******, **********, CT 06604
********@*****.***
Skills Summary
More than 5 years of experience in systems and business analysis for
largest regional banking in New England. Analyze data and channel it
via reports to increase branches productivity. Solid knowledge in
relational database and denormalized databases, data warehouse
concepts, web based programming languages, operating hardware and
software systems. Proficient with Business Objects XI and SQL.
Experience
Peoples United Bank, Bridgeport, CT March 2005 -
Present
Business Analyst
. As a Business Analyst I involved in various business operations and
helped the organization to achieve cost-effective production with
increased quality, efficiency and satisfied customer service.
. Involved in documenting the business process by identifying the
requirements and also involved in finding the system requirements.
. Provide technical support in designing and building business intelligence
universe and Datawarehouse solution via Business Object Universe
designer.
. Perform in-depth analysis of branch productivity and profitability to
identify opportunities to maximize the value of the branch network.
. Prepare and analyze productivity and profitability reports for branches
and senior management presentations. Highlights key findings and makes
recommendations to improve productivity.
. Develop detailed reports for branch networks in evaluating sales, net
sales lift, net margin impact in order to determine sales program
effectiveness. Analyses were performed by utilizing SQL, Excel and
Business Objects.
. Crafted and automated more than 100 reports on Infoview XI, a web-based
reporting tool used for tracking sales results, profitability, deposits
and special promotions. Support network of branch management, senior
management and other areas of the bank.
. Serve as liaison with IT and product areas on all sales reporting issues,
including resolution of data discrepancies, Infoview reporting and ad-hoc
requests.
. Serve as knowledgebase for specific inquiries, questions and concerns
regarding a wide range of divisional data.
. Train branch employees on utilizing available reports to enable them to
accurately track their sales results and incentive plan projections.
. Executing system test and validating the applications against defined
requirements according to the documented scripts and success criteria.
. Oversee data mapping, testing and conversion of Data Warehouse redesign
in conjunction with core banking system replacement GFS (Unisys-
Mainframe) to a new FIS Core banking system.
. Analyzed and validated data conversion, new table creation for banking
core system replacement to be pared with the bank's business need.
. Developing final test reports. Coordinating and supporting user
acceptance testing.
. Utilized FIS(Metavante) Business Intelligence Center in designing new
reports via Business Objects
. Develop, support and maintain the division intranet application.
. Managed across multi-functional meetings by utilizing MS Project to track
the project and to deliver progress reviews and reports; also utilized
SharePoint as reporting tool in project reporting.
. Gathered employee competency data using Excel as a data collection tool,
compiled the results which is being used by Senior Management, in
staffing the appropriate employees at branches
OLM LLC, Trumbull, CT October 2004 - March
2005
Technical Support Analyst
. Provide technical support to customer over the phone and by e-mail,
regarding domain registration, domain renewals, domain transfers, web
hosting (Unix, Windows), e-mail setup (Outlook, Outlook Express, Eudora,
Netscape), Primary and Secondary DNS services, domain forwarding, email
forwarding and other related duties.
. Troubleshoot streaming video issues (Real media, MPEG, Windows Media
Player)
. Troubleshoot to assist clients with technical issue on web hosting.
. Regularly document support-related material as required -Escalate support-
related issues to Team Leader and Customer Support Manager as
appropriate.
. Experienced in installing & troubleshooting Web hosting and various
applications on Windows & UNIX platforms.
. Participating in a 24X7 on-call rotation, monitoring and working on
network and server issues until they are resolved
Quinnipiac University, Hamden, CT October 2004 - March 2005
Lab Administrator
. Configure/Maintain/Troubleshoot/Update Windows Server 2003, MS Exchange
2003, IIS servers and Linux Servers.
. Configure/Maintain/Troubleshoot/Upgrade hardware/software of Servers,
Switches and Workstations.
. Successfully migrated Windows 2000 systems to Windows XP SP2
. Windows domain administration, Active Directory, file/mail/print servers,
and DHCP.
. Manage virus protection of servers and workstations using Symantec
Antivirus Corporate Edition.
. Regularly perform hardware and software maintenance.
. Install and replace hardware, when needed.
. Administer SQL Server, Install, and Identify server needs and perform
daily maintenance.
. Document Network Configuration, responsible for patch management.
. Monitored Firewall systems for the network & network performance
. Participate in special computer lab projects when applicable.
. Manage virus protection of servers and workstations using Symantec
Antivirus Corporate Edition.
. Assist students with PC and desktop application issues.
Systems Proficiency
Operating System
UNIX, Linux Red Hat7.3 & 9.0, Windows Vista, 2003, XP, 2000, and NT
Programming Languages
COBOL, C, C++, Visual Basic 6.0, .NET, HTML, XML, ASP, SQL Server 2000 and
PL/SQL
Applications
Minitab, SAS, MS Office, MSSQL, Veritas Backup, Linux Red Hat, LAN setup,
Adobe, Windows 2003, XP, 2000, NT, MS FrontPage, Macromedia Dream weaver,
Cognos Impromptu, Business Objects XI /5.1 Infoview XI, Business Object
Designer, Business Objects Data Integrator, AQT, MS Project Management
Education
Masters of Science in Computer Information System
May 2004
Quinnipiac University, Hamden Connecticut.
GPA of 3.75 on a 4.0 scale.
Bachelors of Science in Business Computer Information System
December 2001
St Cloud State University, St Cloud, Minnesota.
Graduated Suma Cum Laude with a GPA of 3.33 on a 4.0 scale