Engineer Sql Server

SUMMARY

Over * years of experience encompassing financial analysis, reporting, business analysis, system analysis, and data analysis in financial services and IT industry. Other experience includes engineering in manufacturing industry. Forte includes business process re-engineering, turning back-of-the-envelope ideas into results as well as leading the implementation of management strategies. Summarized analytical skills are as follows:

Financial Modeling and Quantitative Analysis:

• Designed and developed dynamic corporate finance and investment models in Excel using VBA

• Developed ytd, yearly and monthly reporting including forecasting, planning, rate, volume variances and trends for financials

• Knowledge of capital markets, descriptive and inferential statistics, Probability distributions, correlation and regression, sampling and estimation, financial statement analysis, preparing for CFA

Data Analysis:

• Hands on experience in analyzing, extracting, manipulating, mapping, maintaining and migrating large sets of data from Essbase, Excel, Oracle, Access and SQL Server

• Expert in Excel (simple and complex data analysis - VBA, Add-ins, functions). Understanding of Relational databases , SQL

Business and System Analysis:

• Facilitated between stakeholders and IT team to collect functional and non-functional requirements

• Experience in business modeling and system modeling to develop financial models, CRM apps like Customer Support, Inventory management Systems and call center applications. Certified CRM Consultant

• Gathered, documented and diagrammed object oriented requirements for business use cases and system use cases in BRD, using UML – Use Case, Activity and Sequential diagrams

• Prepared technical specifications for FSD. Experience. White box testing, Systems testing (Performance, Stress, Volume, Usability). Followed RAD and RUP approaches in SDLC cycle. Drafted user manual and conducted training. Experience in wealth management and pre-IPO application

• Experience in application development using Visual Basic, Access using OOP - object oriented programming

Technical Skills:

• Financial Analysis: Essbase, Excel Macros (VBA), Pivot tables, functions, Reconciliations, Variance Analysis

• Business Analysis: MS Visio, MS Project, MS Office, Crystal reports

• Statistical Analysis: SPSS

• Databases: Oracle, MS Access, SQL Server

• Languages: SQL (DML,DDL,DCL), UML, Visual basic

• OS: Windows, UNIX

• CRM: Clarify (Certified), Pivotal

PROFESSIONAL EXPERIENCE

04/2010 – 08/2010 Wells Fargo, San Francisco, CA Sr. Financial System Analyst

• Working in Global wealth Mgmt as a consultant for KForce.. Responsibilities involve budgeting, forecasting, and heavy financial modeling, Automation using VBA macros, co-ordination with off-site teams.

07/2006 – 05/09 Citigroup, New York AVP/ Financial Business System Analyst

• Hired full time after contracting for one year through CCR inc. Worked in financial reporting in Citigroup Technology Infrastructure group where technology expenses were tracked for all Citigroup businesses across 6 regions

• Financial Analysis included monthly and quarterly reporting, picked trends, technology chargeback forecasting, investigating and reporting budget over-runs that impact business-critical operations, variance analysis. Conveyed businesses the cost of resources in the terms of headcount (FTE costs), Data Center (hardware, software, support costs), Network, Voice and Conferencing and desktop incurred costs

• Business Analysis included requirement gathering for reporting and making data, user interface, business logic decisions

• System analysis included re-engineering whole business process, removing data inconsistencies and automation of financial models in excel using VBA macros and advanced functions (text, numeric, date, lookup) spitting charges and volumes of technology spend

• Data Analysis included analyzing very large datasets using MS Excel and MS Access, using pivot tables, array formulas, data extraction from essbase, data migration and advanced data manipulation. Managed tasks, subtasks, phases for reporting

09/2005 – 05/06 IMF Professional Consulting, New York Financial Business Analyst

• Unpaid practical training in which web enabled “New IPO Issues System” was being developed. Existing customers were allowed to participate in new equity offerings via traditional auction and Dutch auction system

• Reviewed existing BRD and project plan. Gathered and documented additional requirements for extended business use cases, Interpreted requirements using UML methodology from textual Use Cases into Activity diagrams, Involved in interviewing, presentations, preparing questionnaires, Providing inputs in JAD sessions involving issues relating to database design, front end interface, data analysis, data extraction and non-functional requirements

05/2001 – 08/05 Wayne State University, Michigan Graduate Student Research Assistant (Part-Time)

• Self study in the initial period till Sep 2002

• Pursued full time Post Bachelors in Business Administration (GPA 3.6/4.0)

• MBA majoring in Finance and Info. Sys (GPA – 3.7/4.0)

• Aided students preparing financial models in Excel. Instructed quantitative and statistical analysis at including descriptive and inferential statistics, data analysis using MS Excel, VBA Programming. Mentored students on SPSS Statistical Tool

01/2001 – 04/01 Infogain, California Software Engineer/Jr. Business Analyst

• Involved in integrating CRM functionality in an Asset Allocation application. Participated in gap analysis between old legacy excel model and new portfolio system , Wrote technical specifications to migrate CRM data and analyzed data / workflows

• Participated in reviewing requirements of two front end screens – Client & Asset Mix. This included dynamic functionality of efficient frontier with asset allocation pie charts, Dealt with investor issues like risk aversion, future financial goals

12/1999 – 12/00 ICSG Group, California Software Consultant

• Client: 3Com, CA, 01/00 – 04/00

o Developed Interface between legacy LPA Vision system and Logistics system in Clarify. Involved in data migration, data mapping, customization of Clarify CRM system, SQL queries, gaps between legacy system and the Clarify, testing

o Aligned business processes, documented business rules, screens, functional and non-functional requirements

• Client: Sendmail, CA, 04/00 – 08/00

o Synchronized Clarify Oracle database and Pivotal SQL Server database, front end screens, data migration issues, data mapping, SQL queries in Clarify Oracle database and MS Query in SQL Server, use case’s and documenting screen customizations in Clarify and Pivotal applications for sales process

• Client: Epylon, CA, 08/00- 12/00

o Involved in implementing Pivotal CRM. Prototyping, SDLC methodology, front end, user manual , user requirements and database design, workflow diagrams for sales business process

11/1997 – 10/99 Asset International, India Programmer / Analyst

Customized call center customer support applications, Database design , Requirements, Identified business rules, Testing, Reported and analyzed market research data for the clients.

10/1994 – 08/96 TRW Steering and Suspensions,, Sydney Engineer

Programmed computer numerical control machining centers in production environment and managed inventory

09/1992 – 09/94 Meters and Instruments Pvt Ltd, India Design Engineer

Collected and documented engineering design requirements, Co-coordinated with draftsperson to incorporate the requirements in the software, Worked closely in development, testing and production phases, Worked in testing and quality control phases

EDUCATION:

• 06/09 – 03/09 – CFA preparation and business analyst training from Hudson consulting.

• MBA, Wayne State University, Detroit, Michigan, GPA – 3.7/4.0, Sep 2005

Majors: Finance, Information Systems, Awarded “Professional Development Division Scholarship”

• Post bachelors in Business Admin., Wayne State University, Detroit, Michigan, GPA – 3.6/4.0, Sep 2003

• Graduate Certificate in Business Administration, University Of Technology, Sydney, NSW, Nov 1997

• Bachelor in Arts, Panjab University, India, Sep 1993

• Engineering, ISTC Chandigarh, India, Sep 1992. Awarded “Indo Swiss Alumni Scholarship” for leadership & academics

CERTIFICATIONS: Clarify Certified CRM consultant

ACHIEVEMENTS: Awarded scholarships based on excellent merit and scholastic achievements during MBA & Engineering. In

Deans List during MBA.

Contact this candidate