Jayesh Ojha Email & Phone Number

Mumbai About The company: Deutsche Bank is a leading global investment bank with a strong and profitable private client's franchise. Its businesses are mutually reinforcing. PROJECTS: DbMI (Database Management Information; This application displays various reports. Management Reports like Consolidated, P&L, Businesses, MTM (Mark To market), RTB (Risk To Bank), and Per Unit etc. Income Variance Reports like P&L IVA Comparison vs. Prior Quarter, Prior Month, and Prior year. Critical business data Trade Volume, Repo Revenue, and etc. all the data is compared with actual and planned with prior Quarter, Month etc. assisting to forecast and analyze future operations.Designation: Sr. Process Executive.Role: As a Sr. SQL Developer and providing Business Intelligence I was responsible for the following:Designed and developed databases for financial applications using SQL Server 2000/2005Involved in performance tuning, query optimization, applications testing, processes enhancement, and documentation.Working with MS SQL Server(2005/2000) and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity Responsible for providing analytical solution by creating Reports using MS SQL SERVER BUSINEES INTELLIGENCE STUDIO (SSRS). Developed Financial Reporting, Interactive Reporting and ad-hoc reports for the analysts.Working and setting up SSRS(SQL Server Reporting Service) & SSIS (SQL Server Integration Services)Providing consultation on SQL Server to our development teams.As a DATA ANALYST & SQL ANALYST responsible for gathering, modeling, and transforming data with the goal of highlighting useful information, suggesting conclusions, and supporting decision making.PROJECTS: DARE (Data Analysis and Risk Environment

Key Responsibilities:- Create and execute SQL query scripts on database having 170 million household and 274 million Individuals. Train/Guide new comers and programmers working under team.Generate SQL Statements based on the requirements sent in by the clients based in the US. Extensive use of BCP/Bulk insert command to load raw data from text, dat, xls format into table. Create stored procedures for day-to-day requirement based on client's queries/doubts/requests. Handle any kind of client's queries/doubts/requests in the form of job instructions, create SQL scripts execute on Ms-SQL server, use all types of joins, sub-queries in select statement and provide desire counts without any duplication. Check SQL scripts coded by juniors; troubleshoot; do performance tuning on the same and then execute on the production server. Based on these counts, final counts are generated on the Nth ratio. Thus, final order report is generated and a confirmation mail is sent. Environment: MS-SQL Server 2000, DTS MS-SQL Utility, MS-Office. Gronet Marketing Private Limited - Mumbai (Bandra

Key Responsibilities:- Developed website to make it easy to access large numbers of promoter from anywhere. Created HTML/DHTML and some ASP pages using JavaScript.Assured ability to populate database with new entries, and operational search engine through each users (promoter) retrieve information about chain of people under him. Environment: HTML, ASP, VbScript, JavaScript, SQL Server, Adobe PhotoShop, and Macromedia Flash. Rishabh Kreation, Mumbai (Jogeshwari

Bcom, Accountting

Out Bachelor Of Commerce (B.Com); Of Science, Arts And Commerce

Education record

Education record