Sudhakar Ande

ac5t9o@r.postjobfree.com

862-***-****

SQL Developer/ BI Consultant

PROFESSIONAL EXPERIENCE

Currently working as BI Developer/SQL Developer in Fusion Global Solutions, Dallas TX USA from Feb 2015 to Till Date.

Worked as a MSBI consultant in Genisys information System (India) Private limited, Bangalore from Jan 2014 to Jan 2015.

Worked as a Technology specialist in Wells Fargo India solutions Private Limited, Bangalore from June 2013 to Dec 2013.

Worked as a Programmer Analysts in Cognizant Technology Solutions, Bangalore from Nov 2008 to May 2013.

Worked as a Project Trainee in First Indian Corporation Private Limited, Bangalore from May 2008 to Oct 2008.

PROFESSIONAL SUMMARY

10+ Year of experience on MSBI, Power BI, MS SQL Server, Tableau, Big Data and Jasper Reports, Oracle 11g .

Having good experience in BI suite - using integration services (SSIS) for ETL (Extraction, Transformation and Loading), reporting services (SSRS) for creating different types of reports using SQL query’s and analysis services (SSAS) for design and developing complex cubes and MDX query’s.

Expert in writing T-SQL, data migration for DTS 2000 (Data transformation services) packages to SQL Server 2005/2008 using ActiveX script task to support business logic in packages, data cleansing, data scrubbing.

Expert in understanding and querying complex Oracle databases (10g/11g) as well as an ability to understand the business rules that apply to the data.

Experienced in team mentoring, task planning and estimation, status tracking, Goal Setting and feedback discussion, trainings and recruiting technical resources etc.

Experience in providing SSRS server level, item level security & accessibility to various reports in multi-user environment.

Extensive hands on experience on SQL Server 2005/08/R2/2012/2014 and IReports 5.6

Good understanding of RDBMS concepts and experience in writing joins, sub queries indexes, views, store procedures and function using SQL Server

Exposure to all phases of software development life cycle (SDLC) with in-depth knowledge of agile methodology, enterprise reporting life cycle, SQL server migrations, change control rules, problem solving skills and escalation procedures.

Skilled in developing Jasper Soft I reports, supporting and maintaining Jasper Report Server.

Strong report layout and presentation skills. Demonstrated skill in designing and developing complex reports

Solid understanding of T/SQL and ability to write scripts to automate and manage data, performance tuning, SQL Query optimization and Drive to automate process and procedures which are manual.

Ability to develop in fast moving, agile product development methodology. Strong data analytical skills for report validation and testing

Have extensive experience in configuring SSRS\I Report, Report Manager and Drill down report, Sub reports, creating subscription and scheduling reports.

Experience with open source Java technologies and APIs including Groovy.

Team player with good interpersonal skills and the ability to work in team.

TECHNICAL& DOMAIN EXPERTISE

Reporting Tools: SSRS, Tableau, SSAS, OBIEE 10g, I Reports 5.6 (Jasper Reports), Power BI.

ETL Tools: SSIS, Informatica

ETL Testing Tools: Informatica Data Validation

RDBMS/DBMS: MS SQL Server 2008/R2/2012/2014/2016, Oracle 10g/11g

BIG DATA: HADOOP (SPARK.), Azure

Data Model Tools: ERWIN

Job Schedule Tools: SQL Agent, CRON Jobs

NoSQL DB: Mongo DB

Languages: C#. Net and ASP.NET 2005/08, Java, J2EE

Database Connectivity: ADO.NET, OLEDB, and ODBC

Scripting/Markup: HTML, Java Scrip, JSON, XML

Operating Systems: Windows 10/8/7/XP/2000/2003/08, UNIX, LINUX

Domain: Logistic/Supply Chain, Retail, HealthCare, ERP, Banking, Mortgage, Media, IM (Infrastructure Management).

PROFESSIONAL EXPERIENCE

Client: CIT GROUP, Livingston NJ Oct’17 to May’18

MSBI Developer/SQL Developer

Leasehub is the hub for all CIT Lease information related to Equipment Finance, Vendor Finance and Transportation Finance. Objective of Leasehub is to provide one source of truth related to all CIT leasing information. Hub data is used for all federal reports like Liquidity 2052, QRM and Y9C reports.

Data Management Services project involved loading UDB databases for all geographies USA, EUR, CAN and ASIA from Infolease files to carry out financial transactions and generate reports for business needs. Infolease is the upstream systems via which the information is fed into bank's systems.

Responsible for the architecture, design, and implementation of data warehouse solutions for the enterprise.

Developed reconciliation tool to reconcile Lease source data to all downstream applications there by enforcing quality in deliverables.

Successfully provided lease data to all federal reporting layers ensuring all end users easy reporting data requirements were available on time.

Established ETL framework and created packages using SSIS for data extraction where coordinated offshore/onshore teams and implemented agile project management practices.

Created guidelines for developers regarding SSIS, SSRS SSAS and DB development.

Designed an ETL framework to manage error-handling and conduct health checks on SQL Server. Designed and developed an auditing database that acted as a central location for custom log files, package configurations, error messages and run outputs

Designed and implemented complex ETL transformations by developing, scheduling and deploying complex packages using SQL Server Data Tools 2013 (SSIS).

Created out architectural design and developing Databases, Tables, Views, Stored Procedures, Functions, Indexes and Triggers.

Implemented migration of SQL server databases/ SSIS packages from 2005 to 2012 version and also data center migrations.

Hands on experience on power query.

Interacted with business users and help them with any SQL Scripting & query processing.

Developed Adhoc -Query Requests based on the requirement using Joins, Sub Queries

Managed Logins and Users like adding logins, roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures.

Performed troubleshooting SQL issues, Database design and Database modelling

Resolved technical issues and provided guidance when and where required.

Coordinated with various downstream teams to perform various tasks like interface testing and working on UAT and PROD deliverables etc.

Providing immediate solution for critical production issues and analysis on the user queries

Hands on experience in Data Modeling, familiar with snowflake schema, star-schema, Multi-dimensional model and tabular model.

Create Power BI Dashboard reports and SSRS report type Parameterized reports, Linked reports,Snapshot reports,Cached reports,Ad hoc reports, Click through reports, Drill through reports, Sub reports.

Environment: MS SQL Server 2012/14, Oracle 11g, PL/SQL, T-SQL, SSIS, C#.Net, InRule, SSRS, Power BI, SSAS, Dimensional Model, Tabular Model.

ASSA ABLOY Logistics Solutions, Dallas Feb’15 to Sep’17

SQL Developer & BI Consultant

Description:

ASSA ABLOY is an advanced logistics software solution that solves challenges all the way from the guard gate to the loading dock. ASSA ABLOY can also provide critical warehouse logistics management for the doors and assets inside your warehouse. ASSA ABLOY is unlike any product available on the market today – it combines the loading dock, the yard and the warehouse into one comprehensive unit, providing managers with the visibility, reporting metrics and productivity tools they need to increase efficiency and profitability. However, our module-based system makes it easy for you to choose just the logistics solutions you need to solve your operation’s particular challenges, and our modules are designed to easily integrate with your existing business systems and processes. ASSA ABLOY ensures you have the data and tools to make the most of your operation. ASSA ABLOY provides real-time visibility into your operations.

Responsibilities:

Create ETL SSIS packages and Invoke InRule (business rule management tool) through SSIS ETL package to evaluate data for cleansing.

Design the Physical and Business Model Diagram mapping and joins with Facts and Dimensions based on the Star and Snow Flake Schemas as per best practices in SSAS.

Designed multiple KPI and partitioning of cube based on requirement using SSAS.

Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.

Responsible for defect resolution and prioritize the local requirements from business.

Responsible for technical root cause analysis, providing solutions and work around.

Provide support during deployment of delivered requirements.

Create SSIS profiling package for data analysis and data profiling.

Create physical / logical data model design for Logistic Data warehouse project.

Create ETL Mapping document and Technical specification document for mapping data elements, data flow.

Create ETL for extracting data from source system to staging repository for business analysis and data cleansing work.

Translate data rules to complex SQL and PL/SQL queries for data validation and cleaning.

Define Business Rules using InRule Engine.

Created and maintained proof of concepts for all the SSIS ETL packages.

Involve in OLTP and OLAP data modelling techniques and a demonstrated ability to interpret Entity Relationship Diagrams.

Create Power BI Dashboard reports and SSRS report type Parameterized reports, Linked reports,Snapshot reports,Cached reports,Ad hoc reports, Click through reports, Drill through reports, Sub reports.

Use Master Data Services for data steward review and decision.

Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Responsible for managing all the production deliverables (deployment document, Work Order, Change Order).

Maintain the best practices and RDMS best concept for writing the SQL queries and maintain the ETL tools.

Created C# .net tool for invoking InRule entities in SSIS component and pass the rules through inRule engine.

Create test Cases for business scenarios for validation and testing.

MS-SQL DBA experience with Migration & Up gradation.

Define and maintains database objects.

Hands on experience in Data Modeling, familiar with snowflake schema, star-schema, Multi-dimensional model and tabular model.

Designed Dimensional Modeling using SSAS cubes for End-User. Created Hierarchies, Aggregations, partitions, calculated members and KPIs in Dimensional Modeling.

Involved in creating deployment document, Work Order, Change Order for production with DBA team.

Resolve the QA/Production Issues.

Interact with Onshore & off shore team on daily basis

Environment: MS SQL Server 2012/14, Oracle 11g, PL/SQL, T-SQL, SSIS, C#.Net, .Net, InRule, SSRS, Power BI, SSAS, Dimensional and Tabular Model, Tableau, Groovy/Grails, JQuery

Electric Full Scope, UK (Bangalore) Jan’14 to Jan’15

Consultant/Team Lead

Description:

The OOH industry in the UK has started using a tool called ‘Postar’ with the aim to use the data to plan & trade campaigns by the audience delivery. Postar is an industry wide audience measurement tools that Postar scope and their competitors in the UK have equal access to. In Postar there is the concept of the ‘ frame ID ‘, a unique identifier for each site, providing lots of information useful for planning campaigns.

The key objective of this application is:

To deliver an end to end OOH system for Posterscope with Planning, Optimisation, Project Management, Reporting and ECOS portal functions with each forming an individual work stream within Project Electric.

Responsibilities:

Interact with Onshore & off shore team on daily basis

Analyze source data and create SSIS packages based on USE cases

Discuss with BA & Team on gaps on the Data flow

Create SP & work closely with Database Architect

SSIS packages with Microsoft standers like dynamic package configuration and error log etc.

Maintaining the Log and Audit information in the SQL tab Experience in providing Logging,

Error handling by using Event Handler for SSIS Packages.

Administrate SSRS reports, SSIS packages and agent jobs.

Conduct KT session for new joiners in team

Deploy package from Development TFS to UAT on each sprint

Environment: ETL –SSIS, MS SQL Server 2012, SSRS

Wells Fargo – IM Data Integration and Reporting (Bangalore) Jun’13 to Dec’13

Senior Developer

Description:

This project is part of Infrastructure management domain. The project is to import data from different sources/systems (like factory app, Remedy, HPSA, etc.), integrate the data in reporting database and provide measurable, actionable, consistent metrics in an automated manner for different LOB heads/management within Wells Fargo organization. We use SSIS for data ETL, integrate data using database programming and design/develop metrics/reports/dashboards using reporting services.

Responsibilities:

Interacting with Client and Users and gathering the requirement based on their business prospective.

Implemented the Caching for speeding up the reports and to improve the performance wise.

Interact with business unit/US counterpart to consolidate requirements.

Analyze the requirement and distribute work among the team.

Design & Develop complex SSRS reports

Create SSIS packages to data import and export

Create database objects – tables, stored procedures, functions, views

Deploy SSRS, SSIS objects into UAT/Production environments

Administrate SSRS reports, SSIS packages and agent jobs.

Experience in Dimensional Data Modeling Star and Snow Flake Schemas

Conduct healthy weekly team meetings and technical sessions

Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS).

Co-ordinating with on-site team.

Environment: ETL –SSIS, MS SQL Server 2008, SSAS, SSRS

Core Logic Sales and Marketing (Bangalore) Nov’08 to May’13

BI Analyst

Responsibilities:

Interacting with Client and Users and gathering the requirement based on their business prospective.

Daily Attending the Status meeting with Clients and Coordinating the On-Site Team to walk them to move further.

Preparing the Documents and Naming Specifications as per SQL Server Standards based on MSBI Best Practices.

Design the POC RPD for the future requirement purpose with Generic Standards.

Design the Physical and Business Model Diagram mapping and joins with Facts and Dimensions based on the Star and Snow Flake Schemas as per best practices.

Implemented the Caching for speeding up the reports and to improve the performance wise.

Created the reports and Store procedure as per the requirement.

We created the global Filters and Time Dimension prompts for all the Reports.

In Reports we have created the charts, tables, Pivot tables, Drill Down and Drill through and etc.

Worked Data load SSIS Packages to pull data from Source to staging table.

Configured Subscription and Scheduler for delivery options of a report and also scheduled FTP delivery options for a report.

Developed many T-SQL procedure & functions and used the same in mappings, pre and post sessions.

Performed Unit and Integration testing to validate report and mapping functionality.

Co-ordinating with on-site team

Environment: SQL Server 2008, SSRS, SSIS and SSAS

EDUCATIONAL DETAILS

B.Tech (CSE), from Jawaharlal Nehru Technological University (JNTU), India - 2006.

Contact this candidate