SUMMARY

• Lead various new reporting system/BI project
• Managed various complex project
• Working on Advisory search engine project
• Lead various data migration, report migration, system migration project
• Financial, Banking, Wealth Management, clearing, trade position, risk report and application
• Ability to efficiently manage the processes of requirement gathering, analysis, use cases, data diagram, process flow diagram, testing, training and quality assessment, UAT, production support - day, nights, week ends
• Strong understanding of data warehousing concepts, ETL, OLTP, OLAP, Normalization, Star and Snow Flake data models
• New systems analysis, requirement gathering, gap analysis, design and develop project management
• Data Migration, Data Mapping, Data Modeling, RDMS, Data warehousing, Data Analysis, Data Visualization
• Business Objects/Crystal Report/Oracle Report/QlikView/Tableau/Spotfire/Cognos
• Microsoft Office - Excel(VLOOKUP,PIVOT), Visio, Power Point, SharePoint, TFS
• Proficient in full life cycle design and development of Business Objects reporting Applications
• Experience in training users - how to use enterprise application, reporting system and test and validate them in UAT, support
• Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team
• User manual creation, new system requirement creation, operation risk analysis
• Worked wif different areas of IT groups(domestic and global team) - application developer, system engineers, Change Management, Operations, QA, Change Control Group, data center and others
• Assisted own team as well as other team when ever needed - pick hours and off pick hours
• Database experience in Oracle 7 to 11G (RAC), DB2, SQL Server

TECHNICAL SKILLS

• ORACLE 10g 11g
• TOAD
• DB2
• AQT
• SQL
• PL/SQL
• Crystal Report 10.5 XI 2008
• Crystal Enterprise 10.5
• SAP Business Object XI(Crystal XI) 2.X 3.X(service pack 6.0) 4.x
• Microsoft Office
• Excel
• Star Team
• Footprints
• HP Quality Center
• JIRA
• GIT
• Mercurial
• Suportsuite and VMWARE
• HTML
• JSP
• CSS
• JAVA SDK
• Windows
• AIX
• Sun Solaris

PROFESSIONAL EXPERIENCE

Confidential, NY

Business Analyst

Environment: Microsoft Office, Share point, Quality Center, Solr, DB2, Hadoop, JASON, Visio, Various ticketing systems

Responsibilities:

• Worked wif product owners to understand different advisory systems
• Gatheird requirement for various data entities(Investments, Accounts, Portfolio, FAs, Clients, Plan, Portfolio, Fees, KYC, Variance etc)for Platform design and development
• Created Use cases for various entities for Solr based search engine
• Created and maintaining attribute list
• Created data requirement for new project
• Worked wif UX design team, created screen for GUI
• Worked on managed account (UMA,SMA)
• Involved in platform Hackathon design, development and UAT session of Advisory Search engine
• Run scrum call, documenting open issues, checking status of various development issue
• Worked wif database developer, backend developer, front end developer, Solr Architect, developer
• Analyzed/Compared legacy system vs new system
• Analyzed BRD and created SRS, technical specification
• Worked wif BRD authors and documented any open issues
• Designed process flow diagram, Use Case diagram using Visio
• Worked wif tech managers, business and explained them requirement impact on existing system
• Scheduled meeting, interviewed users, checked status of various project
• Worked wif Portfolio construction tools, Billing, Fees, trading tools
• Documented and published meeting notes
• Worked wif app developer, Database team, Big data developers, QA, UAT,business users
• Analyzed multiple environments and preparing data mapping documents for new projects/systems
• Worked on GAP analysis of multiple system
• Analyzed various data elements for multiple systems(equities, mutual funds, ETF, fixed income data)
• Worked wif Excel for data analysis, comparing data, finding duplicate data, missing data, data elements
• Maintained SharePoint portal and documents
• Worked on HP Quality center, enter and track issues

Confidential, NJ

IT Business Analyst/Data Analyst

Environment: JIRA, ORACLE11g, TOAD, SQL, PL/SQL, SQL Server 2008 & 2012,SSIS,Excel, Microsoft Office, Share point, JAVA, TibcoSpotfire, RSA Archer, Actimize, Cognos, Quality Center, various Ticketing System

Responsibilities:

• Worked wif technical users to understand different compliance monitoring and risk systems
• Worked wif user to understand user requirement
• Worked on reference data (LRR, ERH, Legal Entity, Vendor, Risk Hierarchy, Geography)
• Worked wif RSA Archer report for various compliance Risk data analysis, reference data analysis
• Worked on Compliance Monitoring search application
• Analyzed SSIS package and worked on ETL data mapping, Field Mapping
• Worked on Data profiling, data validation, data cleaning
• Scheduled meeting, interviewed users, checked status of various project
• Created JIRA stories for data modeler, developer, user
• Worked on BRD, LLD
• Worked wif app developer, data modeler, QA, Users
• Wrote Change control form for QA and Production deployment
• Worked wif release manager, operation
• Analyzed multiple environments, source and preparing data mapping documents for new projects/systems
• Managed different data project - data migration, inventory build, data cleaning, data validation project
• Worked and managing GAP analysis of multiple system
• Worked wif different LOB, application
• Analyzed various data elements for multiple systems
• Wrote database views for different applications
• Created various compliance, regulatory report using raw SQL
• Compared and validating data for multiple systems, writing SQL to for data cleaning effort
• Analyzed various existing system and tried to find data link wif new system or target(e,g, FIX, EQ data) - Trade Surveillance, Compliance data(monitoring/testing)
• Assisted/lead UAT
• Wrote SQL for day to day data analysis using toad and SQL Server Management studio and exporting dat for various format for data analysis, uploading share point
• Worked wif Excel for data analysis, comparing data

Confidential, Pennington, NJ

Business System Analyst/Application Developer

Environment: ORACLE 10g, 11g, TOAD, SQL, PL/SQL, Crystal Report 10.5, XI, 2008, Crystal 11, SAP Business Object XI(Crystal XI) 3.X(service pack 6.0), .Net, Visio, Microsoft Office, Visual Studio, Excel, HP Quality Center, Share point, TFS, Tableau

Responsibilities:

• Worked wif technical user to analyze existing SAP Business Objects reporting systems
• Managed various project
• Worked wif offshore and onshore team, assigned job to them and checked status day to day basis
• Designed various data, system architectural/process flow diagram using Visio, power point
• Analyzed different web based reporting system to improvise the existing system
• Prepared various documentation regarding reporting system, deployment, tester guide
• Worked wif end users to identify user requirements
• Worked on Retirement product (401K), Executive Stock Options
• Created various QC for users, developers
• Designed and developed simple to complex SQL queries for day to day data analysis
• Worked on data validation for XLS to XLSX migration project, new report, production support related issue
• Compare data using SQL queries, report and Excel depending on situation
• Designed report mockup/layouts
• Worked wif the Business Users to identify user requirements,
• Worked on BRD, LLD & HD and analyzed the reporting systems to identify improvements including UI system analysis and creating various diagrams
• Analyzed different reporting system to improvise the existing system
• Prepared various documentation regarding reporting system, deployment, tester guide, and user guide
• Designed Crystal Report and Web me report
• Worked on Excel version of report - day to day analysis/support/troubleshoot
• Lead XLS to XLSX conversion project
• Designed different type of reports including Conditional, Drill-down, Summary, Subtotals, running totals, formulas, conditional groups, chart, cross tab, mock cross tab using SQL queries
• Analyzed risk for any code/report update and impact of the changes
• Assisted system integration test
• Assisted/Lead UAT
• Supported release and post release issues
• Supported production support issues

Confidential

Senior BI Analyst/Software Engineer

Environment: ORACLE 10g,11g, TOAD, DB2, AQT, SQL, PL/SQL, Crystal Report 10.5, XI, 2008,Crystal Enterprise 10.5, SAP Business Object XI(Crystal XI) 2.X,3.X(service pack 6.0), 4.x, Microsoft Office, Excel, Star Team, Footprints, HP Quality Center,JIRA,GIT, Mercurial, Suportsuite and VMWARE,HTML,JSP,CSS,JAVA SDK, Windows, AIX, Sun Solaris

Responsibilities:

• Managed and owned multiple clearing products
• Worked wif domestic and global Business Users and senior management to identify user requirements, set up requirement sessions wif Business users, wrote functional specifications, perform Business Process Modeling using Visio
• Identify, research, investigate, analyze, define and document business processes
• Conduct workflow, process diagram and gap analyses to derive requirements for existing systems enhancements
• Converted user requirements to report requirements, created detail report specification and report templates
• Successfully managed multiple complex project - new system, migration, company merger
• Worked on various risk reports which cover risk analysis for derivatives like future, option, fixed income etc
• Analyzed risk for any code/report update which used for multiple report or application or user
• Designed Report Layout
• Developed Database views/ SQL queries for the reports using Oracle 10,11, DB2 8.1
• Worked wif PL/SQL(FIXML) Trade Matching/ settlement
• Worked on Capital Market data analysis(Future, Options, Fixed Income, Cash, Currencies etc)
• Worked on Data profiling, data validation, data cleaning
• Worked on reference data (settlement information, such as identifier, issuer name, exchange, ticker, currency, payment frequency, coupon rate, maturity date, dated date, settlement date, first payment, put, call, settle price)
• Designed and developed Crystal Report, webi report, Universe, Business Views
• Worked Excel version of report - day to day analysis/support
• Created Oracle Table, View, Package, Stored Procedure & maintain & update existing oracle application - for trade capture application
• Worked on UNIX
• Performed gap analysis for data migration from DB2 to Oracle, report server migration Crystal 10.5 to XI R2 and XI R2 to R3
• Worked on data quality and data validation using SQL queries, report and Excel data for various new project and migration project
• Wrote documentation for users on how to select necessary parameters and date frames for different selections
• Created run book as project manager
• Created user manual
• Worked wif QA - helped them to write test case, perform the test, integration test
• Worked wif performance test team to test performance of new system and constantly check status
• Worked wif operation(both US and EU) - production deploy and prod support, DR test
• Worked wif system engineers, information security - building new environment, get access to new environment for myself and users
• Wrote Change control form for QA and Production deployment
• Worked wif Change Control manager
• Worked on Run Book/deployment guide
• Worked wif release manager, operation
• Created user manual/guide for multiple project
• Created technical e learning document for various project
• Worked wif users – requirement gathering, UAT, training etc

Confidential, NYC,NY

BA/Report Analyst

Environment: ORACLE 9i, TOAD, DB2, SQL, PL/SQL, Crystal Report 10.5, Microsoft Office, UNIX

Responsibilities:

• Worked wif end users to identify user requirements for Report design and development
• Wrote functional specification for the reports
• Arranged user session
• Wrote detail design document
• Analyzed mainframe report
• Created questionnaire to gather requirement and question answer session
• Created data mapping document
• Created report templates for new report
• Wrote Database views/query (Command) for the reports using Oracle 9i Integrating Crystal Reports10.5 wif database application
• Created various financial reports for internal users, Commerce, DOE, Treasury
• Created parameterized reports, sub-reports both on demand and inline
• Created and designing different type of reports including Conditional, Drill-down, Summary Subtotals, running totals, formulas, conditional groups using CR 10.5
• Wrote test cases, test script for QA

Confidential

Report Analyst

Environment: ORACLE 9i, TOAD, DB2, AQT, SQL, PL/SQL, Crystal Report 10.5, Crystal Enterprise 10.5, Microsoft Office

Responsibilities:

• Worked wif Business Users to identify user requirements for report design and development
• Created report templates for the new reports
• Wrote Database views/query for the reports using Oracle 9i, DB2 8.1 and created Business Views for Reports using Oracle VIEW, DB2 Query
• Implemented row level security using Business View Manager, setting rights for the users
• Integrated Crystal Reports10.5 wif Business View
• Created various financial reports for Servicing, mainly clearing members and inside staffs, various reports for dealers, warehouse, and internal use. Reports are mainly trade/position related, buy/sells, trade register

Confidential, NYC,NY

BA/Report Analyst

Environment: SQL Server2000, T-SQL, SSRS, Crystal Report 10, MS Access, ERWIN, Visio, MS-Office, MS Project, Win 2000,Visual Studio. Net, ASP, Crystal XI

Responsibilities:

• Worked wif Business Users to identify user requirements and performed customer data analysis, identify, research, investigate, analyze, define and document business processes
• Assisted in efforts for continuous improvement in performance and functionality
• Created report templates, wrote stored procedure using T- SQL