Project Sql Server
Resume:
N R Praneeth Goparaju
****************@*******.***
OBJECTIVE
Would like to work on technologies which challenge me and my experience and grow professionally by achieving the challenges and help the organization to grow.
COMPUTER SKILLS
BI Tools
MicroStrategy 8.x
MicroStrategy 9.x
SQL Server Integration Services (SSIS)
Languages
Fair enough with: C, Microsoft Visual Basic, Java
Software
Database: Microsoft SQL Server and IBM DB2
Platforms: Microsoft Windows 2000, Microsoft Windows XP
EXPERIENCE
Senior Software Engineer April 2010 - Present
Bank of America
Primary responsibilities include interacting with the clients; finalizing requirements, designing, developing and testing reports, creation of dashboards in Flash and AJAX mode for internal financial reporting.
Senior Systems Engineer July 2007-April 2010
Infosys Technologies Ltd.
Primary responsibilities include development and testing.
PROJECTS
Project Name CRA Monitoring and Reporting (Generation I and II)
Client Bank of America, USA
Duration April 2010 – Till date (Project spanned over multiple generations)
Role Architect, Developer
Tools/Technologies MicroStrategy 9.0.2, Oracle
Description
Community Reinvestment Act (CRA) Monitoring and Reporting is one of the key projects at Bank of America, as the reports developed in this project have to be submitted to the Government of USA by the Bank of America. The reports generated from this project help the USA government to monitor the loans issued by the Bank of America for Community Development. Created dashboards using Flash, for internal and external audit purposes.
Project Name TCPS AML Reporting Project
Client American Express (AMEX), USA
Duration April 2009 – Till date
Role Architect, Developer
Tools/Technologies MicroStrategy 8.1.2, IBM DB2, Visual Source Safe
Description
TCPS AML Reporting Project involved the development of AML reports which were created to track suspicious money laundering activities. This project implemented reports in MicroStrategy that will help monitor the suspicious activities related to the products & services offered by the Travelers Cheque & Prepaid Services (TCPS) business units.
This project helped us to get a better exposure of the Business Processes, thereby helping me understand more about banking domain. This project involved extensive work on Dashboard reports, parameter passing in documents, Conditional Formatting, VLDB Settings to tweak the report queries thereby improving the performance of the reports.
Project Name Data Management & Reporting – Tuscany Reporting (Launch 1 and Launch 2)
Client American Express (AMEX), USA
Duration October 2007 – April 2009 (Project spread across various phases)
Role Developer
Tools/Technologies MicroStrategy 8.0.2, IBM DB2, Visual Source Safe
Description
The Data Management & Reporting (DM&R) project is a strategic business initiative for the American Express Travelers Cheques & Prepaid Services (TCPS) business unit. The Tuscany Summary Reporting project involved the transition of the prepaid business processes from the in-house infrastructure supported by Travelers Checks and Prepaid Services to FIS (third party vendor dealing with Prepaid Cards) prepaid platform. The reports will be used by the users of Travelers Cheque & Prepaid Services (TCPS) business unit for various business analysis based on the information available in the reports.
This project aided exploring the advanced features of MicroStrategy including Drill Maps, Hierarchies, Table/Column Aliasing, Custom Groups and Consolidations.
Project Name Metrics Dashboard (Phase 1 and 2)
Client American Express (AMEX), USA
Duration December 2007 – February 2008(Phase 1)
August 2008 – September 2008(Phase 2)
Role Developer
Tools/Technologies Microsoft SQL Server Integration Services, SQL Server 2005, Tortoise SVN, MicroStrategy 8.0.2
Description
This project involved development of Metrics Reporting Tool to the client which would help to provide meaningful and timely management information to drive improvements in the Solution Delivery Lifecycle Process (SDLC). It is a web-based reporting tool developed on Microsoft Business Intelligence platform, which is the POA metrics tool for the client. The metrics reports helps the client to better understand, track, control, and predict projects, processes and products.
ACCOMPLISHMENTS
• Got an award, in the field of Innovation, for creating a tool to automate the process of generating Microstrategy Report Layouts. This tool is developed in Microsoft Visual Studio .NET and its saves a lot of time wasted in manual work.
• Submitted Books of Knowledge on MicroStrategy, Microsoft SQL Server Integration Services (SSIS) and Visual Basic .NET.
• Received appreciation mails from managers and clients at Bank of America, for the excellent work done in CRAMR project.
• Developed internal Dashboards for Infosys Technologies Ltd, to track trainings and certifications done by the employees.
EDUCATIONAL QUALIFICATION
Sl. No. Exam. Passed Year of Passing Institution / University Percentage
1. B.Tech, Computer Science April 2007 M.V.G.R College of Engineering, Vijayanagaram. 68.33%
2. Intermediate Public Exam March 2003 Vidhyardhi Junior College, Visakhapatnam. 87.7%
3. S.S.C Mar 2001 M.P.L High School, Rajahmundry. 84.33%
PERSONAL DETAILS
Full Name N R Praneeth Goparaju
Date of Birth January 9th, 1987
Address 13-9-197, Sri Kalanilayam,Panduranga Nagar, Moti Nagar, Hyderabad, AP, India 500018
Marital Status Married
Nationality Indian
Passport Number G2297545 (Valid until: 09 May 2017)
PAN Number ALZPG9664J
Valid Visas USA B1 Visa
Mobile +918*********
Email Id ****************@*******.***
Work Experience 4 Years 2 Month
Experience in Microstrategy 3 Years 11 Months
Current Company Bank of America
[N R Praneeth Goparaju]
Contact this candidate