Bachelor of Science (BS), Information Systems @
The University of Texas at Arlington
I am a Business Intelligence (BI) Developer with seven years of experience in Data Warehouse, Business Intelligence, Data Integration, Business Analytic, and Data Visualization. I have worked on integrated team of business analyst, software developers and functional business manager in order to design and to implement BI projects. I have been appreciated with several endorsements from my
I am a Business Intelligence (BI) Developer with seven years of experience in Data Warehouse, Business Intelligence, Data Integration, Business Analytic, and Data Visualization. I have worked on integrated team of business analyst, software developers and functional business manager in order to design and to implement BI projects. I have been appreciated with several endorsements from my co-workers during my career.
Currently, I am working as a senior BI developer for a Health Care Marketing business. In this role I have focused on consolidating data from transaction databases into a data warehouse and provide analytical reports to the business. My Successes includes creating Enterprise Data Warehouse (EDW) using SQL Server Analysis Services (SSAS), Build ETL frameworks and Packaged to load data into EDW using SQL Server Integration Services (SSIS), and create analytical reports using SQL Server Reporting Services (SSRS) and Tableau.
Colleagues know me as a creative, reliable, dependable, quick learner, and result oriented person who can always be trusted to come up with a solution. But I know that the client’s business comes first, and I never try to impose my ideas on others. Instead, I spend a lot of time on understanding the business requirement and the audience, analyze data before suggesting ideas. I have introverted personalities and I often do work well alone, but I’m at my best collaborating with others in the team.
Sr. Business Intelligence Developer @ • Design, develop, modify and support ETL packages for Data Warehouse data load process using SQL Server Integration Services and Informatica Cloud
• Create views, stored Procedure to extract the data for reporting
• Create reports and interactive Dashboards using SSRS 2012 and Tableau 7.0
• Participate in all Business Intelligence activities including requirement gathering, Functional and Technical Design, Dimensional Modeling, ETL Design and Implementation for reporting database.
• Mentor junior team members, train end users, conduct cross training and knowledge transfer among team members in the team From August 2013 to Present (2 years 5 months) Business Intelligence ETL Engineer @ Imported and Exported data acrross business units using SSIS and Informatica Cloud
Design, implement , and maintain ETL framework
Automateed and Monitored ETL jobs
Supported and Maintained existing reporting infrastructures ( SSRS, Tableau, and Microsoft Access). From August 2012 to August 2013 (1 year 1 month) Dallas/Fort Worth AreaBusiness Intelligence Developer @ Conducted requirements gathering sessions with business users, and developed technical requirements, and test plans
Created data models to show key components of source systems and performed profiling of source data
Developed ETL packages using SSIS and SQL
Designed and loaded star schema reporting tables
Created and supported reports using SSAS, SSRS
Created SQL Server Agent jobs for process automation
Functioned as part of On-Call team to monitor data load process.
Communicated technical solutions to non-technical end-users.
Developed documentation of Business Intelligence systems, policies and procedures From May 2012 to August 2012 (4 months) ETL Developer/SSRS Report Developer @ Created and automated SSIS packages to load data from FTP site into the Enterprise Data Warehouse (EDW)
Developed, maintained and standardized reports through the use of SQL scripts, stored and automated reports using SQL Server Reporting Services (SSRS)
Worked with business users to help them frame their business requirements
Used systems and templates to document technical specs detailing the methodology, procedures, outcomes, and observations as part of the data processing and analytical steps in the BI projects
Performed the appropriate data analysis to validate the technical requirements
Planed and implemented user acceptance testing (UAT) From September 2011 to May 2012 (9 months) SQL Database Developer/Report Developer @ Created and modified database objects: Table, Stored Procedure, View, Function
Created new reports, and modified existing reports using SQL Server reporting Services (SSRS) environment. From January 2009 to September 2011 (2 years 9 months)
Master of Science (MS), Information Sytems @ The University of Texas at Arlington From 2015 to 2017 Bachelor of Science (BS), Information Systems @ The University of Texas at Arlington From 2013 to 2015 Ganesh Lohani is skilled in: SSIS, SSRS, ETL, Business Intelligence, Microsoft SQL Server, SQL, Visio, Analysis Services, Databases, SSRS 2005/2008/2008R2, Crystal Reports 8.0/10, Relational Databases, Data Warehousing, Data Modeling, Informatica, T-SQL, MDX, Performance Tuning, Dimensional Modeling
Looking for a different
Get an email address for anyone on LinkedIn with the ContactOut Chrome extension