Ashish Singh

  • 991, Jal Vayu Towers, NGEF Layout ,Bangalore-560038,INDIA
  • +91 9663822282
Ashish Singh

Lead Business Analyst at YAHOO!


B.Tech. (IT) with 11 years of fruitful experience in Business Analysis,Business Intelligence, Data warehousing, Analytics, System design and development. Seeking senior level assignments in Business Intelligence. Currently on Notice Period.

  • Gathering requirement, deploying suitable business research tools to gauge business model, market trends & competitor activities, etc., to gain the competitive edge
  • Ensuring timely completion and delivery of project to the client, managing the implementation phase by formulating project plans, planning resources and resolving issues arising due to scope creep or other technical / personnel matters
  • Interacting with clients for requirement gathering, tracking, and communicating bugs, enhancements, analysis of unresolved problems
  • Managing the complete end-to-end process for user acceptance testing phases of the project and executing testing within deadlines

Work History

Work History
May 2012 - May 2016

Lead Business Analyst

  • Working as Lead Business Analyst I Designing, Implementing and manage multiple Business Intelligence and Analytics Projects from scratch in SQL Server server, MSBI, Microstrategy and other tools to ensure they function normally.

  • I look after MicroStrategy as Architect. Creating Intelligence Cubes, Report, Dashboard, Attributes, Facts, Matrix and Importing Tables from database, managing Subscriptions, Schedules, Users,Users Group and Security filters.Taking daily Metadata and statistics backup and ensure it functions properly. Have good knowledge of Microstrategy Command Manager and Object Manager.

  • proactively manage daily Jobs and ensure data quality. Creating SSIS ETL Packages and scheduling them.I take Database backup, Installation and restoring occasionally.
Jul 2009 - May 2012


  • Developing sales credit revenue analysis and reporting for country COO management using SQL, VBA, Office tools.
  • Act as a IT specialist offering guidance to users on backend and Front end of reporting database.
  • Producing weekly flash and monthly revenue packs and supporting the interactive features within the packs that allowed the user to analyze the features of the data.
  • Liaise with stakeholders for Gap analysis, process mapping, writing system specification and future development opportunities for reporting and analysis,
  • Implementing SQL, VBA (Access and Excel) tools Reporting to support the ‘Key Account Management’ program.
  • Country analysis tools identifying client revenue concentrations, product reliance and profile change.
  • Preparing processes and documentation for off shoring. Stakeholder management involving Business and IT.
  • Implementing Advance Microsoft Access & Excel, Access/Excel VBA, Business Objects, Hyperion, SQL and other tools to report customer revenue performance on a country level basis for all products and trading/Sales desks.
Feb 2009 - Jul 2009

Sr. Associate-Market Data

  • I involved in knowledge transfer/migration of support job from on shore third party to India, Traveled to New York for Knowledge transfer, Gap analysis, process mapping, writing system specification.
  • As a Sr. Associate I involved in IT support of business operations and helped the organization to achieve cost-effective production with increased quality, efficiency and satisfied customer service.
  • Involved and responsible for accurate and complete load/Normalization of data received from different vendors (Reuters, Bloomberg, Iress etc)
  • Used Microsoft Access & Excel Query, Access/Excel/Outlook VBA, ActiveX and ODBC direct connections, Sybase ASE, SQL and other tools to accomplish the automation.
  • Used DTS and Data Type conversion from SQL/Oracle/Sybase Servers via ODBC & Direct connections.
Mar 2007 - Feb 2009

Business Analyst

Bank of New York Mellon
  • As a Business Analyst I Took part in the preparation of Project plan, user acceptance testing. I also took part in the meetings with Sr. Business Analyst and managers and understood various process plans, business process, and functionality in detail. This helped me to prepare Integration Test Plan which was used by functional team as well as development team for doing a detailed testing on the business application.
  • Interaction with Portfolio Managers/Traders for requirement gathering, analyzing the information gathered finalization of technical specifications and discussions for effort / time estimation and client co-ordination and reporting. I wrote test planes and test cases of the business process or application.
  • I also have wide knowledge and experience in re-engineering concepts which I use to re-engineer the process and improve it to make the business effective and efficient by using Microsoft Access & Excel Query, Access/Excel/Outlook VBA, ActiveX and ODBC direct connections, Sybase ASE, SQL, BO and other tools to accomplish the automation.
Oct 2006 - Mar 2007


  • Analyzing and Automating the Business Process Projects in Excel/Access with macros/VBA.
  • Overseeing database management functions and writing programs in Oracle, PL/SQL. Running daily, weekly and monthly batches and debugging any issue. Reconciling generated batches.
  • Responsible for developing advance PL/SQL procedures, packages, Triggers, other required objects in Oracle.
  • Generated PL/SQL Procedure in oracle9i used to calculate Charged-off, Delinquent EMI, Amounts etc. of clients and automated many other Business process. Automated Data Conversion from Oracle to Sybase System. Coded PL/SQL Procedure to send automated mails with Attached data file. Created Job Scheduler to run package on working days only, Directories.
Jul 2005 - Jul 2006

Senior Software Engineer

Limtex Infotech
  • Client interaction for requirement gathering, risk assessment, finalization of technical specifications and discussions for effort/ cost/ time estimation and client co-ordination and reporting.
  • Plan how the programs will fit together and write programs. Ensure smooth functioning of the program in sync with the computer through implementation of tests.
  • Identify faults in programs, prepare reports on the uses and maintain, upgrade programs by modifying appropriate Java, JSP, JS, and pages to fulfill client’s requirements.
  • Test, system integration, debugging and troubleshooting of the application.
  • Generate complex PL/SQL Report and write procedures for data loading from existing system (Cobol, dBase) to another system (Oracle 9i),with PL/SQL coding and SQL Loader.


Jul 2001 - Jun 2005

B.Tech. (Information Technology)


I have completed my Bachelor of technology major in Information Technology with 80% in 2005



Database Development, Maintenance and Tunning.

Have managed very Large Databases in Orcale, Sql Server. Have worked with sensitive Financial data of Big Investment Banks like UBS, Credit Suisse, BNY Mellon.

Business Analyst

I have Experience of 8+ years as Business Analyst with Investment Banks and Software company.

Business Analytics

Comfortable with Business Analytic tools like Microstrategy, MSBI. Have created IC, Reports, Dashboards, Attributes, Facts. knowledge of Business Objects, Tableau ,R and Hive.

Database Modelling

Knowledge about designing both logical and physical implementation of complex abstract systems as well as the process of denormalization used in BI environment.

MS Excel, MS Access, VBA

I have Excellent experience in developing tools in MS Access, Excel with VBA/Macro coding. I have Re-engineered many slow tools to Extremely fast and more reliable Tools. I have developed VBA tools to Extract Bloomberg Historical data in Access.


Apr 2016 - Present

Introduction to R