Data Sql Server
Resume:
Sudhakar Ande
*************@*****.***
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