Sagar Nayak
Senior Business Intelligence Analyst at AppDynamics- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Querying Microsoft SQL Server 2012/2014
Microsoft -
Administering Microsoft SQL Server 2012/2014 Databases
Microsoft -
Microsoft certified solution associate
Microsoft -
SAS Certified Base Programmer
SAS
Experience
-
AppDynamics
-
United States
-
Software Development
-
700 & Above Employee
-
Senior Business Intelligence Analyst
-
Feb 2018 - Present
Involved in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping. Wrote SQL queries (aggregates, conditional statements, sub queries) and analyze large data sets resulting in problem resolutions and improvement recommendations. Capable of performing data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata Developed normalized Logical and Physical database models to design OLTP system Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r9 Developing SQL database and BI solutions using T-SQL, SSIS, SSRS, SSAS, MDX, query performance tunings, database development, implementation, support of data, and underlying data models. Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server. Environment: MS SQL Server 2014/2012/2008, Visual Studio 2010/2012, Erwin r9, MS Excel, MS Visio, Rational Rose 7, Tableau, Reporting Services (SSRS), Power BI, Integration Services (SSIS), Python/SAS, Analysis Services (SSAS), T-SQL, Microsoft Azure, Excel, Agile Methodology. Show less
-
-
-
Optum
-
United States
-
Hospitals and Health Care
-
700 & Above Employee
-
Data Modeler/Analyst
-
Apr 2016 - Jan 2018
Worked with Business Analysts team in requirements gathering and in preparing functional specifications and translating them to technical specifications Worked with Business users during requirements gathering and prepared Conceptual, Logical and Physical Data Models. Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies. Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development. Wrote complex Queries, Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL. Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS. Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server. Created SSIS packages to Export data from text files/CSV files to Teradata SQL Assistant Database. Used various SSIS tasks such as Conditional Split, Derived Column, Lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse. Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes using dimensional modeling standards in SQL server. Developed Power Pivot Reports in Excel 2013 by publishing them to SharePoint 2013 for providing ad-hoc reports according to client need. Implemented SSAS Cubes, Facts and Dimension tables to perform analysis services. Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS. Environment: SQL Server 2008R2/2012, SSIS, SSRS, SSAS, T-SQL, MS Office (Word, Power point, Excel), ETL, Microsoft Visual Studio, Tableau, TFS, ERWIN, SharePoint, Agile Methodology. Show less
-
-
-
Liberty Mutual Insurance
-
United States
-
Insurance
-
700 & Above Employee
-
Data Analyst
-
Sep 2015 - Mar 2016
Responsibilities: Developed and managed Stored Procedures, Triggers, Functions, Indexes, Views, and Joins using SQL for tuning the customer transaction data. Created a highly complex multifunctional application using MS Access to support a team of people. Profound knowledge of MS Access programming with VBA. Worked with business users, programmers, testing staff, and database administrators to develop database requirements, test plans and database schemas to transition MS Access database to SQL Server. Migration on Access tables to SQL Server using SQL Server Migration Assistant (SSMA). Created packages using SSIS (SQL Server Integration Services) to perform ETL (extract, transform, and load) operations by importing and exporting data, cleaning data, adding new variables and deploying it in form of SSRS reports. Use advanced Excel functions, power and regular pivot tables, pivot charts, and other functions to conduct data extraction and analysis to make data-driven decision. Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Desktop Resolved various performance issues and analyzed the best process distribution for different projects. Environment: T-SQL, SQL Server 2008/2012/2014, MS Access 2010/2013, VBA, SQL Server Management Studio (SSMS), SSIS, SSRS, ETL, Data Mining, MS Excel, SQL Server Migration Assistant (SSMA), Tableau Show less
-
-
-
ADP
-
United States
-
Human Resources Services
-
700 & Above Employee
-
Technical Analyst
-
Jan 2013 - Nov 2014
Responsibilities: Upgraded to latest version from SQL Server 2000 to 2005 Wrote various Stored Procedures for the purpose of application development Tuned SQL statements (e.g.: using Indexes) and Stored Procedures Maintained disaster recovery and database maintenance plan Worked on replication of data (Transactional method used) Designed and implemented data access stored procedures and triggers for automating tasks. Performed job scheduling and alerts Created database objects for improving the performance Fine-tuned Procedures, Functions and Triggers for optimum performance Involved in creating SQL reports Involved in the SQL Query Performance Tuning Designed and implemented user log in and security Resolved any deadlocks issues with the databases/servers on a real-time basis. In-Depth working knowledge of ODBC. Created many complex Stored Procedures and user defined functions. Environment: MS SQL Server 2008/2012, T-SQL and Windows XP Show less
-
-
-
QSG Technologies Pvt Ltd
-
India
-
Information Technology & Services
-
1 - 100 Employee
-
Software Developer
-
Mar 2011 - Jan 2013
-Gathering and analyzing the end user requirements -Design of user interface screens according to the low level design documents -Coding in VB6.0, unit testing, integration testing -Writing SQLs to use in application development -Writing database stored procedures and triggers to as specified in low level design -Reporting to project manager -Gathering and analyzing the end user requirements -Design of user interface screens according to the low level design documents -Coding in VB6.0, unit testing, integration testing -Writing SQLs to use in application development -Writing database stored procedures and triggers to as specified in low level design -Reporting to project manager
-
-
Education
-
Illinois Institute of Technology
Masters, Management Information Systems, General -
Visvesvaraya Technological University
Bachelor's degree, Computer Science
Community
