Amulya Pulipati
TX
Summary
- 8 years of experience in Microsoft Database Technologies as a SQL Server Developer and BI Developer (SSIS/SSRS /SSAS/Power BI). Worked in various business domains like Retail, Banking, and Professional Services.
- Experience in Analysis, Design, Development, Testing and Implementation of data, reporting and analytic solutions in OLTP/OLAP/BI environment.
- Experience in Microsoft TSQL statements (DDL and DML) including features like Temporary tables, Ranking functions, Joins, Pivot For XML path, CTE.
- Expert in calculating measures and dimensions using Multi-dimensional expression (MDX), mathematical formulas and user-defined functions.
- Created hierarchies in Power BI reports using Data visualizations like Bar Chart, Line Chart, Pie Charts, and Forecast Charts.
- Experienced in creating DAX expressions, Date to year columns and implement partitions in Tabular models for Power BI.
- Expertise in Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
- Experience in generating Drill through and Drill down reports with Drop down menu option and sorting the data in Power BI.
- Experienced in Microsoft Business Intelligence Suite (Power Pivot, Power View, Power Query, Power Maps, Power BI Service, Desktop and Mobile Apps).
- Experience in creating Tabular reports, Matrix reports, Parameterized reports, Sub reports and Global map reports in Power BI desktop and cloud services.
- Robust MS Access and Excel skills with Power Pivot, PivotTable, PivotChart, Power View, and VLOOKUP.
- Excellent TSQL scripting skills in development of efficient stored procedures, and functions.
- Used tools like MS SQL Profiler, Index Tuning Wizard and Windows performance for monitoring and tuning SQL Server Performance.
- Designed, scheduled and maintained ETL framework for enterprise processes.
- Data Mapping skills, Data Migration Methods and Validations from Legacy systems.
- Proficient in working with RDBMS including Normalization, Constraints, Joins, Keys and Data Import/Export.
- Worked in both SSAS Tabular and SSAS Multidimensional Cubes
- Developed OLAP cubes using SSAS to calculate the metrics proposed in functional analysis.
- Experience in developing Power BI Reports and Dashboards from multiple data sources using Data Blending and managed Database Views available to all BI and DW applications.
- Designed and developed SSIS packages using OLE DB connection from different sources by using SSIS transformations
- Experience in SDLC like Agile (Scrum), Waterfall and V-model.
- Effective communication with all levels of business partners to ensure the requirements are analyzed with analysts and technical owners to minimize risks.
- Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
- Strong Data Modeling experience using ER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling using tools like Erwin.
- Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
Overview
9
9
years of professional experience
Work History
Data Analyst | BI Developer
ADP
04.2023 - Current
- Developed SSIS templates which can be used to develop SSIS packages to dynamically deploy into Dev, Test and Production environments.
- Worked on performance tuning using indexing (Cluster Index, Non Cluster Index) tables.
- Designed various cube objects like KPIs, drill through actions, aggregations, and translations.
- Implemented key performance indicators, actions, hierarchies, and attribute relationships.
- Generated MDX scripts for KPIs and calculated members based on business requirements in SSAS.
- Migrated and recreated existing Dimensions and Cubes using Star schema to achieve the efficiency of SQL Server Analysis (SSAS).
- Implemented DAX (Data Analysis Expressions) functions for SSAS tabular models and Excel pivot tables.
- Understand business needs to translate to Data Models using Erwin.
- Expertise in configuring and managing data sources, views, cubes, dimensions, mining structures, roles and hierarchies using SSAS.
- Responsible to create calculated columns and measures in Power BI using DAX queries.
- Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
- Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, and Sub Reports using Sql Server Reporting Services (SSRS).
Data Analyst | BI Developer
Mindlance Inc.
03.2022 - 01.2023
- Developed complex programs in TSQL, Stored Procedures, Triggers and Queries with best execution plan.
- Interact with stakeholders to gather business requirements to analyze, design and develop the data feed and reporting systems.
- Extensively worked on Views, cursors, CTE, with client/server database design.
- Defined unique/check constraints, rules and defaults along with exception handling with try/catch.
- Created views to restrict access to data in a table for Security.
- Performed data extraction using SSIS from OLTP to OLAP and bulk data migration using DTS and SSIS from flat files.
- Designed and deployed reports with Drill Down, Drill Through and drop down menu options with parameterized and Linked reports.
- Developed and deployed reports using Power BI to generate daily, weekly, monthly and quarterly reports.
- Used multiple transformations provided by SSIS such as Data Conversion, Derived Column, Lookup, Conditional Split, Bulk Insert, Merge and union all, etc.
- Performed error handling in SSIS using Event Handling and logging.
- Developed calculated columns and measures using DAX in Power BI.
- Improved the performance of SSIS packages by using fast load options, converting the data type at source if applicable, parallel processing, using non-blocking, semi blocking components over blocking components, dropping and rebuilding the indexes during the SSIS package run.
- Used T-SQL queries to insert the complete file information and layout to MDF tables.
- Experience in writing T-SQL for developing complex Stored Procedures, Triggers, Index, Views, User Functions, SQL joins for Data Integrity and normalization.
- Customized columns and tables utilizing Named calculations and Named queries in SSAS.
SQL Server BI Developer
ACS Solutions
01.2020 - 02.2022
- Created SSIS package to load data from Flat Files and SQL Server 2008R2 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
- Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
- Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MSOLAP/Analysis Server (SSAS).
- Worked on performance tuning using normalization, indexing and transaction isolation levels, monitoring logs.
- Designed, Developed MDX qureries to retrive data from cubes using SSIS.
- Responsible for Monitoring and Tuning Report performance.
- Resolved issues with reports/stored procedures like slow response time, inconsistent results, poor format of the actual report.
- Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in memory in both tableau and excel.
- Involved in creating views, stored procedures and custom SQL queries to import data from SQL server to Tableau.
- Analyzing Business Intelligence Reporting requirements and translating them into data sourcing and modeling requirements including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas, Snowflake Schemas, Operational Data Stores, etc.
- Involved creation of extended dimension modeling tables like snowflake for OBIEE.
- Designed and implemented stored procedures and Triggers for automating tasks.
Data Analyst | BI Developer
Xenon Infotech
01.2018 - 12.2019
- Worked on data retrieval programs to import, extract, transfer, and load (ETL) data from heterogeneous data sources throughout the organization to support ad hoc reporting.
- Designed, developed and supported self-service reporting options like building tabular data models in Power BI.
- Developed SSIS Packages for integrating data using OLE DB connection from heterogeneous sources.
- Created and managed complex workflow rules, data validation, and triggers and automated workflows.
- Designed and implemented SSAS Tabular Cube as the analytic layer.
- Used DAX scripting to access data from Tabular Model.
- Worked on SSRS to develop dashboards and reports.
- Worked on SSIS to automate report generation.
- Used multiple transformations provided by SSIS such as Data Conversion, Derived Column, Lookup, Conditional Split, Bulk Insert, Merge and union all, etc.
- Used T-SQL queries to insert the complete file information and layout to MDF tables.
- Experience in writing T-SQL for developing complex Stored Procedures, Triggers, Index, Views, User Functions, SQL joins for Data Integrity and normalization.
- Derived measures and dimensions using Multi-dimensional expression (MDX), mathematical formula and user-defined functions.
Data Analyst | BI Developer
Wipro Technologies
02.2015 - 01.2018
- Created database objects like tables, user defined functions and cursors using DDL, DML statements.
- Designed and implemented stored procedures and Triggers for automating tasks.
- Developed stored procedures and view for managing efficient data retrieval.
- Created and implemented triggers in TSQL to facilitate consistent data entry into the database.
- Actively involved in normalization and de-normalization of database.
- Generated different types of Tabular reports, Matrix reports, Chart and Graph reports, Ad-Hoc reports using MS SQL Reporting Services (SSRS).
- Designed and created MDX queries to retrieve data from cubes using SSIS.
- Automated SSRS reports using parameterization in SSRS.
- Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS SQL Analysis Server (SSAS).
- Created DAX expressions for date to year columns and implement paritions in Tabular models for Power BI.
Education
Master of Science - Nanotechnology
Acharya Nagarjuna University
IndiaSkills
- Databases: SQL Server, Oracle 11g, Azure DW, Azure Analysis Services
- Database Tools: SQL Server Management Studio , SQL Server Data Tools, Enterprise Manager, Business Intelligence Development Studio
- Development Skills: T-SQL, PL/SQL, SSIS/SSRS, SQL PLUS, Power BI, Alteryx, Tableau, Microsoft Azure
- Languages: VBnet, C#, SQL, PL/SQL, HTML
- ETL Tools: SSIS (SQL Server Integration Services), Informatica, SnapLogic
- BI Packages: SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services), Power BI, Tableau, MS Excel
- Tools/Methodologies: MS Project, SQL Profiler, Toad, Alation, Agile, Jira, Waterfall, VBnet, Logging, SQL PLUS, Microsoft SQL Server
Timeline
Data Analyst | BI Developer
ADP
04.2023 - Current
Data Analyst | BI Developer
Mindlance Inc.
03.2022 - 01.2023
SQL Server BI Developer
ACS Solutions
01.2020 - 02.2022
Data Analyst | BI Developer
Xenon Infotech
01.2018 - 12.2019
Data Analyst | BI Developer
Wipro Technologies
02.2015 - 01.2018
Master of Science - Nanotechnology
Acharya Nagarjuna University