| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address Luke hill roadBethany CT Street Address
Cell: PHONE NUMBER AVAILABLEHome :( PHONE NUMBER AVAILABLEEMAIL AVAILABLETECHNICAL SKILLSPL/SQLETLSQL ServerODBCDTSStored ProcedureOracleCrystal ReportOLAPSQRMicrosoft VisioToadMicrosoft PowerPointMicrosoft AccessVBAVBScriptSQLTCP/IPPeopleSoftVisual BasicMS .NetActiveX Data Objects (ADO)Remote Data Objects (RDO)Data Access Objects (DAO)Web Client TechnologiesVNC (Virtual Network Computing)Visual SourceSafeEXPERIENCEFiserv IncConsultant Sept 2017- Aug 2023Develop and standardize several financial, ad-hoc reports pulling large volume of data from data warehouse,MS Access database, SQL Server database.Performed data analysis; data mapping and extraction from data files coming from several banks dailyWork on windows upgrade 2008 to 2012 and migrate all the applications residing on the server and resolve all the issues.Generate various senior management reports summering the extracted information on weekly, monthly, quarterly and yearly basis.Migrated all the MS access 2010 applications to SQL Server and other platform that includes writing stored procedures and create Crystal Reports.Resolve complex production issues from legacy applications.Robert Half Management Resources HSB Insurance Company (Munich Re)Financial Reporting Analyst 2016(June)-July (2017)Automated several monthly and yearly processes using advanced excel functions, VBA programming forForecasting budget and actual budget calculations utilizing advanced techniquesPerform various day to day functions of accounting & financial department like extracting information from various settlement systems and generate forecasting and actual budget summary reports.Converted old excel complex files with macro and links to databases into new excel versions file with integrity of the dataPerform data analysis using Excel macros, pivot tables, VLOOKUP tables, advance excel functions.Royal Bank of Scotland, Stamford, CTRisk Analyst/Consultant 2011 (Feb) 2016 (May)Reconcile various feeds from RBS settlement system like Loan IQ, FX and make sure data is reported accurately to IRS.Worked on several RBS internal projects using relational databases, SQL Server enterprise manager, data mapping to import export data by developing custom queries, stored procedures, T-SQL and DTS (data transformation services).Generate various Tax reports summarizing the total for all the 1099 filing and 1042-S filings for 2010, 20011and 2012.Document all the technical and business requirements changes to the existing systems and future enhancements to existing RBS internal systems.Automated several small applications using VB and VBA script for account remediation of various TAX forms.UAT testing of new tax application both front end and back end. Created SQL server database to store historical information for last 3 years of all the RBS filing of 1099 (Various forms 1099-int, 1099 Misc., 1099-Div, 1099-B, 1099-C and 1042-S)Electronic filing of 1099 and 1042-S data to IRS using 1099-Pro and 1042-S pro software for 2009, 2010, 2011and 2012.Design and Developed complex MS Access application and link to SQL Server databaseComp Intelligence, Oxford, CTConsultant 2010 (Jul) 2010 (Dec)Develop and maintain SQL scripts and procedures (Microsoft SQL Server, Oracle, and Microsoft Access)Design & developed Oracle Tables, views, stored procedures, functions for a major project.Manage data conversion projects with frequent client contact, conduct post-conversionData reconciliations between source and destination platforms.Perform data analysis using Excel macros, pivot tables, lookup tables, advance excel functions.GDF SUEZ North America / FirstLight Power/Select Energy, Hartford, CTRisk Analyst 2006 (Mar) 2010 (May)Performed data analysis; data mapping and extraction; data cleansing, data mining, data warehousing and relational database management.Perform historical energy price analysis; compare forward prices from several brokers and performed statistical analysis using Excel functions and SQL Server functions.Performed requested technical enhancements and modifications to existing data collection processs Queries, Stored Procedure,Automate various analytics reports including custom financial reporting using SQL Server Stored Procedure, VBA, MS Access, Excel Macro'sPerform VaR (Value at Risk) scenario analysis and track volumetric risk using ZAINET analytics softwareDeveloped complex Visio flowcharts, Excel graphs, histograms and documented existing daily procedures and processes.Create technical ad-hoc queries for senior manager, business users, and validate risk management calculationsPerformed statistical analysis using Excel functions and SQL Server functions.Ensure compliance to risk management policies and procedures on a daily basis and to investigate and report instances of noncompliance on a timely basis.Compiled and update forward commodities prices from several brokers into Oracle database.Check the accuracy of all energy risk model's inputs like volatility curves, forward prices,And ensure that no major discrepancy in data.Citizens Bank, Lincoln, RIRisk Analyst/Consultant Credit MIS Development 2004(June) 2006 (Jan)Provided support to internal and external auditors as they validate risk management information for monthly, quarterly and yearly transactionsDesigned, coded and implemented ETL (extract, transform & load) for the Citizens Bank risk management projects including extracting information from various source systems such as commercial loans, leasing, asset based lending, bonds, customer derivatives, treasury, and bank trade/Letter of credit.Performed detailed project management functions, prepared test cases, detailed test plans, document user acceptance testing (UAT), ad-hoc queries for business users, and validate risk management calculations.Prepared detailed technical specifications for data and systems integration from mergers and acquisitions. Provide management with updates regarding status of all projects. Worked with other IT functional areas, various business units, and the data management team to ensure accurate design of data extraction from legacy systems.Designed and developed several projects using relational databases, SQL Server enterprise manager, query analyzer, stored procedures, T-SQL and DTS (data transformation services).Published monthly and daily risk management information including internal and external risk rating for Citizens Bank customers.Compiled draft executive summary indicating key legacy system totals and noting any irregularities.Generated and documented new processes, developed complex flowcharts using Visio and power point.Relational database management, performed data analysis; data cleansing, data mapping and extraction; provided development support for existing systems; created batch jobs; systems documentation.Energy East Corp, Hartford, CTLead Analyst, IT Shared Services 1999 (July) 2004 (June)Provided support for accounts payable, purchasing, general ledger, fixed assets, and inventory production modules of the PeopleSoft financial system.Worked on related customization projects and create technical specifications based on requirements, coded in People code, SQR, HTML, PL-SQL, MS DTS, OLAP, SQR, stored procedures.Write technical specification, software development; develop test plan, configuration, and life cycle support.Migrated financial system patches, including upgrades, installation and configuration product updates.Coordinated electronic file management processes such as positive pay files to bank, 1099 IRS file, 1099 vendor, purchasing card transactions, and refund checks.Developed SQL Server Stored Procedures, data warehouse PL/SQL scripting, ETL.Performed requested technical enhancements and modifications to financial system functionality and processes.Developed complex financial reports: positive pay, budget forecasting, accounts payables, and general ledger.PRT Group Inc., Windsor, CTConsultant, IT 1998 (Aug) 1999 (June)Developed software from application design through implementation using Visual Basic, VBA, HTML, and VB script MS Access, Java script and ASP.Designed, developed and documented software in a client-consultant environment.Gather requirements from business users at all levels, analyzed needs, develop alternatives, and perform systems analysis tasks including process flows.Developed systems design and functional specifications; created test cases, verify test results.Implemented Internet based Loss Prevention System for Ames Corporation.Applied following tools in Software development: Oracle, MS-SQL Server, web design, data modeling (database design), reporting tools, proto-typing, testing tools (test director), ETL tools, XML.Assisted the senior managers in developing reports, presentations, and data analysis for upper management.Aetna Inc., Middletown, CTSenior Systems Analyst, Health Care Information Services 1990(Jan) 1998 (Aug)Developed several client/server applications including analysis, design, coding, testing, and implementationAnalyzing large healthcare datasets and perform quantitative and qualitative analysis.Automated/improved several existing manual tasks by eliminating redundant processes.Extract data from relational Oracle databases & SQL Server database for reporting and software development.Integrated third-party add-on tools to existing systems e.g. reporting tools to generate reports.Provided life-cycle support including upgrades to healthcare and financial systems.Assisted with complex application installation and configuration in Aetna regional field marketing offices following procedures and policies with in the IT infrastructure group.EDUCATIONMBA Management Information Systems University of New Haven, CTGraduate level engineering courses Worcester Polytechnic Institute, Worcester, MABS Engineering Osmania University Engineering College, Hyderabad, IndiaTRAININGVisual Basic application developmentPeopleSoft programming (People Tools, PeopleCode, SQR)SQL Server senior data transformation services: Hand on trainingWorking knowledge of the following technologies; web development, ASP, XML, VBScriptSKILL:Advanced knowledge Microsoft Excel and building integrated Excel VBA applicationsAdvanced knowledge in statistics and related softwareExperienced in relational database such as Oracle, SQL Server, Data warehouse and AccessExperience with PeopleSoft ERP systems.STATUS: US Citizen |
