Pratik L Kudva M

313-***-**** Email: adjzzx@r.postjobfree.com Louisville, KY LinkedIn

PROFESSIONAL SUMMARY

• A Business Intelligence (BI) SQL Developer/Lead with over 7+ years of comprehensive experience in all phases of Software Development Life cycle (SDLC) from requirement gathering, development, testing and support. Well versed in concepts of data warehousing, developing and maintaining ETL packages (SSIS) integrating a wide range of data sources, SSAS cubes (Multidimensional & Tabular) and creating reports in SSRS and Power BI.

• Strong understanding of data warehouse and ETL concepts and best practices such as Kimball Methodology, Dimensional Model, Star Schema and Snowflake Schema etc.

• Able to take directions and complete tasks on-time with minimal supervision. Currently leading a team of 8 developers across multiple geographies (India & Mexico).

• Strong communication, analytical, documentation, and problem-solving skills. Highly self-motivated and able to adapt and learn new technologies quickly. Results-driven with ability to take initiatives and meet deadlines in a fast-paced changing environment.

WORK EXPERIENCE

IT Analyst - Tata Consultancy Services Ltd

Over the last couple of years, worked on Multiple Large-scale BI Reporting Applications for a major logistics client primarily used for close to real time reporting built by integrating data using SSIS from wide range of data sources finally stored into a SQL database with an additional analytical layer (SSAS Cubes) with data refreshing within few minutes providing close to real time reporting via SSRS, Power BI and Excel reports which are primarily used by CxO level users. Application providing data to downstream systems in various formats like SSAS Cubes, Flat files, Dump to external DB etc. enabling self-service BI for users. TECHNOLOGIES USED

● Agile and Waterfall methodology.

● Microsoft SharePoint, Microsoft Team Foundation Server (TFS)

● T-SQL, SQL Server Integration Service (SSIS), SQL Server Analysis Service (SSAS – Multidimensional

& Tabular), SQL Server Reporting Services, Power BI

● C#

MSBI-SQL Lead

Location: Louisville, Kentucky May 2018 – Current

RESPONSIBILITIES

● Design, develop and deliver / implement data solutions including architecture design, prototyping of concepts to proof of concept, development of standards, design and development of test plans, code and module design.

● Partner directly with end users to create and execute implementation plans that are on time and within budget, resulting in the highest degree of customer satisfaction

● Facilitate and design technical solutions for existing applications and processes.

● Involved in creation/ review of Technical requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.

● Collaborate with developers, system analysts, business users, and project managers working across multiple geographies to resolve issues for the system.

● Make prompt, technically sound decisions and recommendations that add value to business priorities and needs.

● Create SSIS Packages for integrating data from heterogeneous sources (Excel, CSV, Oracle/SQL, XML, flat file, web services, SharePoint Lists) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge Join and Lookup etc.

● Follow Standard practices while developing SSIS packages. Creating Parameterized projects, Parent Child packages to avoid replication of code and ease maintenance of code.

● Troubleshooting issues and performing root cause analysis and documenting everything for future reference. Also enhancing the logic to prevent reoccurrence of the same issue again.

● Create database objects - table, view, indexes, trigger, complex stored procedures, indexing, table partitioning, triggers, CTE, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.

● Design balanced databases which perform efficiently while the same database objects are being used in the ETL and reporting in Parallel.

● SQL query performance tuning for complex queries, procedures by analyzing execution plan, table statistics, SQL hint, table partitioning and indexing using SQL Server Profiler etc.

● Develop SSAS Cubes (Multi-Dimensional & Tabular). Creating Measures, Dimensions, hierarchies and implementing role and row level security. Use of DAX functions on Tabular model and Power BI reports to generate required KPIs for reporting.

● Develop and maintain SSIS packages for dynamic partition maintenance and processing of SSAS Cubes which ran on a daily/weekly schedule.

● Design, manage and publish various reports utilizing SQL Server Reporting Services (SSRS) and published on Microsoft Office SharePoint Server (MOSS) featuring Complex drill down & drill through functionality, parameterized reports etc.

● Received ‘Beyond Excellence Award’ for going over and above his normal job responsibilities to create a visible difference in the outcome of a project or an assignment, multiple ‘On the Spot Award’ and ‘Service & Commitment Award’.

MSBI Developer

Location: Pune, India Dec 2013 – April 2018

RESPONSIBILITIES

● Responsible for System Integration, Performance and End to End testing of the ETL and SSAS Cubes including creation and maintenance of all relevant documents.

● Develop and Deploy SSIS Packages Design complex ETL using loop containers and data transformation etc.

● Write complex T-SQL queries and able to do data cleansing writing the same.

● Perform data validation, error checking, troubleshooting, and keeping schema/data in existing application database environments in sync.

● Worked as coordinator between onsite team and offshore team.

● Manage data management procedures, compliance, and auditing.

● Provide on-call support on rotating basis for Production report related issues

● Helped Streamline monitoring process by creating an SSIS package for monitoring the system which would send out an automated email or text directly to the team based on the criticality of the failure. This saved the team a couple of hours of time every day from constant monitoring of the application.

● Managing security and Maintenance of SSAS Multidimensional cubes which are refreshed continuously 24*7 through automated SSIS jobs.

● Developed parameterized SSRS reports and created subscriptions which would execute the reports at a scheduled time and email the results to respective users in Excel, PDF & mhtml format.

● Implemented Live Power BI Dashboard which shows health of the application in a single window Consisting of Status of currently running jobs, failures in past 24 hours, pending file and record count, ETL Processing rate, times when each of the SSAS cubes were last refreshed.

● Received ‘Best Team Award’ and multiple ‘On the Spot Awards’

Contact this candidate