Ganesh P

Software Engineer - 6 Years of Experience - Near 40009


Business Analyst

Education Level:


Will Relocate:



Professional summary * Having 8 years of Professional experience in IT industry, Out of 7 years 3 months Involved in MSBI projects with extensive usage of ETL & Reporting tools like SQL Server Integration Services (SSIS) and SQL Server Reporting Service (SSRS), Crystal Report 11.0 and also One Key MIS Reporting Tool (Third Party). Also having beginning level of knowledge in SAP BO Web Intelligence. * Expert level skills on T-SQL and query optimization, developing ETL strategies using SSIS, Database designing using SQL Server 2005, 2008, 2008R2, 2012. * Excellent knowledge of Business Intelligence and Data Warehousing with good fundamentals in Databases and Programming. * Expertise in writing and debugging Stored Procedures, Functions, Triggers and Views. * Strong experience in Extraction, Transformation and Loading (ETL) in SQL Server database. * Having Domain Knowledge in Financial Field, like Share Market. * Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled SSIS Packages. * Maintenance and Monitoring of Database like log shrinking, Database Backup, Scripts Backup. * Trace the SQL Queries on Servers using SQL Server Profiler. * Experience in creating Linked Servers, Users, and giving Table level authentication like DML Statement authentication. * Supported team in resolving ETL as well as SSIS related issues. * Familiar with Complex Reporting Requirements - Develop different types of Reports using 1 Key MIS Reporting Tool, like Data Grid, Cube, Charts Reports. * Experience in how to tackle with User level queries. Understands their requirements and queries and gives sufficient solutions to them. * Good Knowledge and understanding of database design, relational integrity constraints, OLAP, OLTP and normalizations. * Sufficient communication skills bridging Client Interaction and Team Player. * Strong analytical, problem troubleshooting/solving skills and self-starter.





CollapseJob Skills