Data Analysis

Sarika Srivastava

**** ***** **. *********@*****.***

Woodbridge, NJ 07095 Mobile: 551-***-****

Experience Summary

5+ years of extensive experience in data analysis, reporting and IT project management. Experience in

full lifecycle of application project development including business analysis, design/architecture &

implementation. Broad domain experience including Retail banking, Mortgage, Core Banking

Solutions (CBS), Retail Banking Automation

Dedicated and hardworking professional with strong analytical, technical and managerial skills.

PROFESSIONAL SUMMARY:

• 5+ years of extensive experience in Data Analysis, Business Intelligence, Implementing and

Managing IT development projects including Client-Server and Web based applications.

• Strong Database and Data querying skills using SQL/Pl-SQL.

• Extensive experience in data analysis and reconciliation using MS-Excel, MS-Access, Oracle.

• Proficient in working with various RDMS like FoxPro, Oracle 9i/10g/11g.

• Extensive experience in Retail banking, Mortgage, Core Banking Solutions (CBS), Retail Banking

Automation.

• Hands on experience with various flavors of Unix.

• Experience in data validation and extracting data in UNIX environment using various UNIX

commands and editors.

• Knowledge of Data warehousing concepts.

• Experience in implementing Core Banking Solution – CBS for retail banking.

• Excellent knowledge of defect management and tracking.

• Self-conscientious starter, strong team skills and ability to lead a team toward achieving

organizational objectives.

• Experience in installing and maintaining computer hardware, software and networks in banks.

TECHNICAL EXPERTISE:

Operating Systems : UNIX, Linux and Windows

Languages : SQL,PL/SQL, XML,VBA, C, C++,HTML,CSS

RDBMS : Oracle 10g/11g, SQL Server 2005 /2008,Foxpro-2.6

Testing Tools : ALM, HP Quality Center 9/10

Tools : Toad, Sql Developer

Other tools : MS Office 2007, 2010,Visio 2007

KNOWLEDGE, SKILLS AND ABILITIES

• Good knowledge Data Warehousing concepts.

• Good knowledge of ETL process and tool e.g. Informatica 9.1.

• Good knowledge of VBA and MS Excel 2010.

• Analytical and problem solving skills.

• Effective verbal, presentation and listening communications skills,

• Effective written communications skills.

• Extensive experience in working with Spreadsheet, Word-processing, graphics.

• Management and supervisory skills.

• Ability to install and administer computer hardware, software and networks.

• Decision making skills and team building skills.

PROFESSIONAL EXPERIENCE:

Allahabad Bank, Pune,India Sep-2004 - Apr 2010

Allahabad Bank is one of the largest and one of the fastest growing retail banks in India . Allahabad Bank

provides wide range of services which includes Cash management, Depository Services, Real time gross

settlement, Nationalized electronic fund transfer, Credit Card services etc. Allahabad Bank is also a

leader in Home, Business and Education loans.

Project 1- CBS – Implementation of Core Banking Solution

Project was to consolidate various client-server based systems into one centralized firm wide retail

banking solution.CBS was a web based platform to provide all retail banking features under one

centralized system.

This system also automated various End-of-day, quarter and yearly reporting. CBS was also compliant

with regulatory banking mandates and was able to provide all the required reporting for the same.

Role and Responsibilities: IT-Officer - Business/Data Analyst

Data extracting, conversion, sanitization and data migration from legacy system to new

system.

Reconciliation of data between legacy and new system

Conduct QA and defect identification, tracking and reporting

Conduct UAT

Conduct Deep-dive sessions and User Training

Responsible for L3 support.

Technology and Tools Used:

Database: Oracle 10g

Tools: Toad

MS Office (Excel, Word, Power Point)

OS – Unix, Windows XP

Sarika Srivastava

1410 Plaza Dr. *********@*****.***

Woodbridge, NJ 07095 Mobile: 551-***-****

Project -2 Maintenance and Enhancement of the Legacy system

Support FoxPro based Legacy system along with various excel and access based tools written to

automate the day to day tasks.

Role and Responsibilities: Officer –IT

Responsible for all M&E activities for legacy system.

Troubleshooting day to day data and technical issues faces by business users.

Reporting – Excel and Access based report generation of weekly monthly, quarterly and

yearly reporting.

Excel based data reconciliation for quarterly and yearly ending.

Requirement gathering and prioritization of the enhancement raised by business users.

Estimation, planning, implementation, testing and rollout of enhancements

Regular server patches and other system maintenance.

Efforts and Financial estimates for M& E and infrastructure projects.

Manage team of consultants – work allocation and review.

Technology and Tools Used:

Database: MS-Access, Oracle 10g, FoxPro

Tools: Toad

MS Office (Excel, Word, Power Point)

OS – Unix, Windows XP

Other Projects/Achievements

Managed and lead task force to setup Core Banking infrastructure including Servers and Network

Setup in all 42 regional branches.

Responsible for automated data migration from verities of data formats to unified data format for

CBS migration.

Conducted and faced various internal and external EDP audits.

Conduct training (online/classroom) for CBS System for all 42 branches.

Hands on working of day-to-day functions e.g. Retail Banking and Loan Processing,Managing net

banking issues.

Quarterly report generation for upper management.

EDUCATION:

• Masters in Computer Application (MCA)

• Bachelors Of Science (Mathematics, Computer Science), University Of Lucknow.

Contact this candidate