Ankur Setia

Bank of America uses various tools and to manage issues related to issues it use BMC Remedy tool to keep track of Incident, Change, Problem and Service Request tickets
Microstrategy development team works on Microstrategy BI tool to provide Microstrategy reports, dashboards and documents to the users and leaders within the Bank for analyzing and prompt decision making

Roles & Responsibilities:

• As Microstrategy Developer work on new requirements provided by various users within Bank
• Writing scripts for creation of new views and synonyms
• Designing of new report
• Build, modify Microstrategy Dashboards and Documents
• Creating various Microstrategy objects ( Attributes Metrics, Filters and Prompts)
• Analyze and resolve issues for availability of reports
• Lead Bi-Weekly releases end to end

Bank of America uses various tools and to manage issues related to issues it use BMC Remedy tool to keep track of Incident, Change, Problem and Service Request tickets
Microstrategy support team works on Microstrategy BI tool to provide smooth working of various Microstrategy reports, dashboards and documents and Microstrategy BI tool to the users and leaders within the Bank for analyzing and prompt decision making

Roles & Responsibilities:

• Manage Microstrategy support team from India
• Work and analyze various support related issues to provide solution to users within Bank
• Creation of Reports, Dashboards and Documents for internal leadership team
• Subscription of Microstrategy reports
• Work in coordination to Microstrategy engineering and admin team for smooth working of Microstrategy Project
• Manage the subscriptions of all the reports dashboards and documents for hassle free delivery of Microstrategy reports.

Bank of America uses various monitoring tools and for leadership team to analyze the kind of work these tools are handling Monitoring reporting team came into picture

Roles & Responsibilities:

• Write SQL queries in MS-SQL tool , analyze data and provide to monitoring leadership team as per requirement
• Analyze the requirement and fetch data from 5 different schemas for leadership team
• Create Monthly health checkup report, analyze and discuss with Monitoring Leadership team for future decision making

After working for around a year on project, came up with an idea to automat project and design dynamic reports using MSBI-SSRS tool

After working for around a year on project, came up with an idea to automat project and design dynamic reports using MSBI-SSRS toole

Roles and Responsibilities :

• This was a cost saving project for Bank
• Roles and Responsibilities:
• Analyze the kind of requirements user raise each month and designed dynamic SSRS reports for the same
• Created a repository and placed all monitoring related reports at one location
• Leading the team globally designed and provided support for all monitoring reports.

Bank uses various patching tools to send various upgrades to servers, desktops and laptops

Roles and Responsibilities :

• For leadership team to monitor and analyze patching reporting team use to provide information
• Roles & Responsibilities:
• Write queries to fetch patching reports at different time interval
• Design reports for leadership team to analyze team’s performance
• Design leadership reports and dashboards

Airtel is divided into various zones, circles and sub-circles where in data for all the vendors is managed by IBM and is integrated to TIVOLI Identity and Access Manager .From IBM India worked on Bharti Airtel project

Roles & Responsibilities:

• Importing data gathered from different circles
• Fetch reports and provide same to various Airtel leaders on demand
• Manage data integration between Oracle DB and Tivoli LDAP

Fleet Management system has various garages where in beside internal vehicles it provides services to locals
To manage BT-Fleet management software was designed in Oracle 9i, D2K .
Roles and Responsibilites :

• I was working on the development of various modules
• Roles & Responsibilities:
• Development of various modules on D2k,Oracle 9i
• Writing Stored procedures
• Creating new tables views
• Writing test cases