Business Analyst Lead Resume Profile
NJ
PROFESSIONAL SUMMARY
- Certified Business Analyst Professional CBAP with 7 years of experience in Business Analysis, design, testing, gathering and eliciting requirements based on functionality, workflow and business rules and maintenance of business applications in Finance and banking domain
- Working as Business Analyst Lead at Citibank and certified in Introduction to Finance from Stanford University.
- Extensive experience with product and pricing reference data application and platforms
- Well versed with Agile methodology using Scrum, iterative and incremental software development lifecycle using Rational Unified process RUP . Hand on experience on Agile tools like Rally for sprint planning, Blueprint Requirements Management Centre to write user stories.
- Conversant with UML and designing of logical and conceptual database schema.
- Highest GPA 3.95 in MS-Management Information systems, University at Buffalo
- Proficient in writing complex SQL queries, stored procedures database administration using Oracle SQL developer
- Great analytical skills and Excellent Oral and Written communication skills
Confidential
- Proficient in establishing Business Cases, gathering requirements, creating BRDs and FRDs
- Experience working with end users to understand and create business requirements, Dataflow analysis using use cases, dataflow diagrams, and business process diagrams
- Extensive experience with C, C programming and .Net platform
- Extensive experience in test planning and test case designing
- Experience in designing and development of testing scripts in Automated regression testing tool QTP
- Comfortable working individually as well as in a team environment
- Team player and have Project Management experience
EXPERIENCE
Confidential
Business Analyst Lead
- Monitor Securities and pricing reference data platforms to identify data exceptions containing inaccurate data and to engineer processes to ensure data quality.
- Modify existing datasets in the database using SQL and other database management tools.
- Remediate exceptions by modifying datasets in the database via SQL or other tools
- Engineer advanced operational and financial processes to maintain data quality, and perform further analysis to compare datasets from Strategic and Legacy securities and pricing platforms requiring enhancement.
- Lead- Vendor Management Process: Manage communication with external/ internal vendors e.g. Bloomberg to onboard pricing feeds, to improve price quality and liaison with technology teams to setup procedures for the same
- Create and monitor business-as-usual BAU processes to satisfy data requirements and perform test script execution for new financial systems implementation and present testing results to management.
- Work on the legacy integration and decommissioning projects as a lead for Pricing applications and coordinate with global clients to gather requirements, translate them to the tech team and deliver the products back to the clients.
- Train and manage team of 3 business analysts working on the strategic Pricing data platform of Citibank
- Independently query data from multiple relational databases for analysis
- Work with Citi Security Coding and leverage external vendors and standards organizations
- First point of contact for existing clients as a SME subject matter expert to address concerns and to investigate scenarios that require remediation and data quality improvements at systemic level
- First point of contact for New clients as a SME subject matter expert to onboard them on to the application
- Providing domain and technology training to new resources in the Price Master Central team
- Conformed with issue tracking JIRA and escalation process
- Familiar with Corporate actions and have thorough knowledge about financial products
Confidential
- Interview third party Content management and BI tool providers to help LR dept. to purchase the best suited tool to support their business
- Designed the logical hierarchy of categories, after studying Disney LOB thoroughly, and categorized thousands of LR data files into a searchable containerized content on SharePoint 2007
- Designing and developed the LR module of Disney website using proprietary tool-GoPublish
Confidential
Architecture Graduate Assistant
- Gathered and reviewed business requirements from Dean, SA P, CFO-UB and administrative staff to develop use cases for the accounting system of SA P
- Designed the conceptual and ER model of the database for accounting system supporting financial data of 4 verticals of SA P
- Accounting system development: MS Access front end with the centralized Oracle SERVER to implement a multi user DISTRIBUTED system.
Confidential
Business Analyst
- Gathered requirements from business users in OH, Colorado and UK and translated them to the technical team using UML diagrams and Functional design documents
- Created and delivered full sign-off project documentation starting from Development and ending at post-Production deliverables by working with Key Stakeholders to elicit information and gain agreement
- Managed and mentored a team of 8 quality assurance associates to deliver 24/7 support to 21 run and change applications supporting 70 of the vertical clusters of Bank of America
- Accurately estimated the efforts required for incoming work-orders and scoped projects to bill client
Confidential
Sr. Software Engineer
- Helped Infosys to reduce testing efforts by 85 and resources by 66 by designing an automation tool, using Shell script, for automating a batch processes supporting a legal advisory app
- Influenced client and brought business to the company by proactively designing and presenting a proof of concept prototype to simulate the functionality of a standalone Java app. using QTP and VB scripting
- Anchored 3 cross functional geographically separated teams to successfully deliver a data migration project resulting from BoFA acquisition
Confidential
Software Engineer
- Top scorer in a two month training program on core technologies at Infosys including .Net technologies C , SQL server, ADO.Net and test automation
- Identified and replicated intricate and inconsistent issues, analyzed them, prepared root cause analysis RCA reports, found the root cause and fixed them after proposing the solution to client
- Developed a fully functional travel portal, using .Net, as part of the training plan
TECHNICAL SKILLS
| Languages | Proficient in C, C , SQL, UML, Quick Test Professional VB Scripting , UML, MS Project Familiar with Shell script UNIX , C , 4T Test language Silk Test , ASP.Net |
| Database | MS Access, MS SQL server, Oracle 8i, Oracle 11g, Relational database concepts |
| Operating Systems | Windows 98/NT/ 2000/ 2003/ XP/Vista, MS-DOS, Linux, Unix. |
| Tools | Proficient in Quick Test professional, MS Visio, MS Excel Familiar with Visual Studio 2005/8, Silk Test, SAS e-minor, MS SharePoint 2007, Cygwin |
