Sql Server Supply Chain
Resume:
Hitesh Sudan
Business Intelligence Developer
**********@*****.***
Professional Summary:
Over 8 years of rich IT industry experience in development and maintenance of business intelligence, data warehousing and client server applications.
Extensive experience with all the phases of SDLC life cycle - requirement gathering, estimation, analysis, design, development, implementation, Quality Assurance and operation of software applications especially for Data warehousing applications
Proficient in analyzing and translating business requirements to technical requirements and architecture.
Created ETL/SSIS packages to extract data from various sources like SAP, Excel, Flat files to SQL Server systems using different SSIS components and used dynamic configuration files and variables for production deployment.
Strong database skills, object oriented programming (C#) and development knowledge.
Worked on multiple projects using Agile Methodology.
Experience in leading and managing teams. Handled multiple roles - Team Lead, Developer, Tester, support and maintenance.
Executed software projects for various Business domains (Manufacturing, Sales, Supply Chain, Purchasing and Finance).
Good and effective communication skills, interpersonal skills, self-motivated, quick learner, team player.
Strong experience in Extraction, Transformation and Loading (ETL) using SSIS on SQL Server, File System, Oracle Databases and SAP HANA.
Sound Experience and understanding of SSAS, OLAP cube and Architecture.
Involved in designing multidimensional OLAP cubes in SSAS from the existing data warehouse for various Sales, Purchasing, Supply chain and Finance divisions.
Expert level skills on T-SQL and query optimization which were taking longer time in SQL server 2008/2012.
Experience in creating jobs, alerts and scheduling SSIS packages using Active Batch and CPS Scheduling tool.
Experience and understanding of SSAS cubes (OLAP databases) storage, partitions aggregations, calculations.
Working knowledge of querying OLAP databases (SSAS cubes) using MDX query.
Proficient in writing stored procedures, functions and indexes, optimize the complex stored procedures and queries.
Proficient in creating dimensions, partitions, actions, roles, basic calculations and multidimensional cubes in SSAS using snow flake and star schema.
Good knowledge in developing and designing reports through SSRS using Report Builder.
Developed various operational Drill-through and Drill-down reports using SSRS. Have created different kinds of Sub Reports, Charts, Matrix reports, Linked reports.
Have experience in preparing SSRS reports with Cascading parameters. Also, performance tuned many complex reports in SSRS.
Responsible for designing and implementing interactive Visualizations, Dashboards and Reports in Power BI.
Created data model pulling data from various sources like SQL Server database, Oracle, Excel, Analysis services and SharePoint and using it created reports and dashboards in Power BI.
Created various calculated columns and Measures in DAX (Data Analysis Expressions) used in Power BI Reports and dashboards.
Technical Skills:
Databases
SQL Server 2008 R2/2012, Oracle 9i, 11g, SAP HANA
ETL Tool
SQL Server Integrations Services (SSIS) 2008/2012(SSDT) and Oracle Warehouse Builder (OWB)
Reporting Tool
SQL Server Reporting Services (SSRS) 2012, SQL Server analytical Services (SSAS) 2012, Power BI
Additional Tool
Active Batch scheduling tool V5/8/10, SAP CPS Scheduling tool,
BMC Remedy, Rational Clear Quest
Languages
C# scripting, UNIX Shell scripting, T-SQL, PL/SQL, PERL
Operating Systems
Windows Server 2012, Windows 7, Unix
Education:
Master of Computer Applications (MCA) – Jamia Millia Islamia, New Delhi, India –2009
Certification:
Oracle certified Associate (OCA)
Professional Experience:
Project 1:
Client: Micron Technology Inc, Boise, Idaho Jan 2016 – Present
Role: Sr. BI Developer
Business Solution Delivery (BSD)
Business Solution Delivery project is to analyze, design, develop more robust solutions to enhance client’s data warehouse applications developed using Microsoft business intelligence platform. Primary objective is to incorporate new business requirements with faster turnaround time to generate effective Data Warehouse solutions for business users to help them in decision making, forecasting and analyzing.
Responsibilities:
Used scrum(Agile) process for software development with 3-week long sprint.
Involved in gathering, analysing, documenting business and functional requirements by interacting with business users from various domains like Supply Chain, Sales, Finance and Purchasing.
Develop complex SSIS ETL’s solutions with various sources like SAP BW on SQL Server and HANA, XML files, Flat files to load data into Oracle and SQL Server.
Worked on change requests to enhance performance of existing SSIS ETL packages and rewriting poorly executing SQLs.
Fix defects in existing SSIS and SSAS solution and enhance the same to meet client requirements.
Co-ordinate and collaborate with DBA team, operations team and production deployment teams to ensure successful code release.
Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables
Responsible for providing support and bug fixes after production releases for the warranty period.
Ensuring smooth transition to operations team for the new products developed.
Responsible for sync up between offshore and onshore teams. Used to organize sync up calls.
Provide training/Knowledge transfer sessions to new entrants on critical applications and tools.
Created tables, Stored Procedures, Triggers, User-Defined Functions, Views, Indexes, User Profiles using T-SQL.
Worked on creating OLAP SSAS cube using specified functional and technical requirements. Created Named Calculations, working with cube partitions and MDX.
Completed migration of legacy OLTP system (written in T-SQL, procedures and functions) to very performant SSIS ETL packages.
Created SSIS packages with C# scripting to process and sync SSAS/OLAP cubes programmatically.
Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
Create parameterized Reports in SSRS using Charts, Cross-Tab and Sub-report types.
Created several reports using SSRS like parameterized report, drill through reports, linked and sub reports.
Developed Scorecards/Reports for the system using SSRS, Power BI.
Designed and developed various reports and dashboards in Power BI pulling data from data model from many data sources.
Explore data in a Variety of ways and across multiple visualizations using Power BI Desktop.
Created various calculated columns and Measures in DAX (Data Analysis Expressions) used in Power BI Reports and dashboards
Environment: MSBI (SSIS, SSRS, SSAS), SQL Server, Power BI, SAP HANA, Oracle.
Project 2:
Client: Micron Technology Inc, Boise, Idaho July 2015 – Dec’ 2015
Role: Team Lead
Lfoundry Isolation
The objective of this project was to isolate an existing Micron manufacturing site data warehouse systems and re-structure it to full standalone production capacity to be handled by the local Facility support teams, removing all dependencies from between the 2 companies.
Responsibilities:
Lead technical owner in driving the project work to its completion.
Interacted with Lfoundry business owners and teams to define the project expectations, deliverables and timelines.
Worked in setting up the new ETL server host, in co-ordination with the system admin team to have the server readiness for enabling the data warehouse.
Worked in migrating the SSIS 2008/ 2012 packages over to the new ETL Server and ensuring successful runs.
Worked with DBA’s in getting all the Oracle DB objects moved and updated. Also, worked to tune various poor performing SQL and fixed them to create various normal and function based indexes.
Performing regressive impact analysis on both the application ends to avoid the breakage in production after the network/Firewall cut off.
Involved in re-factoring efforts that simplify code migration and to improve performance.
Responsible for investigating the issues, defects, system outages, determining problem root cause, formulating corrective action recommendations & implementing them on the new ETL host.
Actively involved in support for production issues, System, Integration & dev issues.
Environment: SSIS, SQL Server, Oracle, PERL, UNIX, T-SQL
Project 3:
Client: Micron Technology Inc, Boise, Idaho Mar’ 13 – June 15
Role: BI Developer (Tech Lead)
Business change Management (BCM)
BCM is a process for business to authorize requests for a change (less than 250 hours’ enhancements and defects).
Responsibilities:
Gathered all business requirements from various Business Users (Sales, Supply Chain, Finance, Purchasing) and converted them to technical requirements for design implementation.
Involved in the architecture team for design and implementation of system
Responsible for ensuring team is delivering the monthly committed cases on time.
Assign and coordinating tasks to team members (onshore/ offshore), proving guidance and mentoring them in faster resolution of issues and deliverables.
Actively involved in support for production issues, System, Integration & dev issues after production deployments.
Preparing monthly metrics/ reports on overall BCM work and presenting to the client.
Managing team dynamics of resourcing, training and grooming.
Optimized existing store procedures for efficient data storage and retrieval using T-SQL.
Effectively participated in weekly client communications with Business Analysts.
Designed and implemented Data Marts, Facts, Dimensions and SSAS OLAP cubes having Star/ Snowflake schemas using Dimensional Data Modeling principles in SSAS
Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints using T-SQL in SSMS 2008/2012.
Worked on performance tuning of poorly executing SSIS packages, ETL’s, T-SQL and other programmable database objects.
Successfully involved in migration of legacy Perl code to SSIS ETL packages.
Completed migration of legacy OLTP system written in ASP.Net and C# to SSIS ETL packages.
Generated SSRS reports and dashboards from relational databases and OLAP cubes.
Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
Design daily/weekly/monthly SSRS reports utilizing multiple types of reports including sub reports, Drill Through/Drill Down, and Cascading Parameterized Reports
Environment: MSBI (SSIS, SSRS, SSAS), SQL Server, Oracle, SAP HANA, T-SQL
Project 4:
Client: Micron Technology Inc, Boise, Idaho April 12 – April 13
Role: BI Developer
SSIS Migration 2012
Objective of this project was to encompass clients (Micron Technology) vision to migrate their IT infrastructure ETL’s in Datastage to complete Microsoft platform (SSIS 2012). It was complete rewrite and replication of code logic since no utility was present to convert the Datastage ETL to SSIS packages.
Responsibilities:
Understand the existing ETL code in Data stage and convert them to SSIS 2008/2012.
Fixing the defects and issues occurred during the deployments to ensure successful code run.
Involved in end to end validations and testing of the complex ETL’s to meet all the business test criteria’s.
Effectively participated in weekly client communications with Business Analysts.
Worked as a developer in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL codes and SQL joins for applications.
Divided many highly complex data stage ETL’s into various medium to small complexity SSIS packages to help performance tune the ETL and timely delivery of data for reporting to Business Users.
Also, involved in migration of SSIS 2008 packages to SSIS 2012 packages and completing the project with in the specified deadline.
Environment: SSIS, SQL Server, Oracle, Data Stage, T-SQL
Project 5:
Client: Numonyx, Noida India Jan 09 – Mar 12
Role: BI Developer
Numonyx BI Support
Business intelligence support and maintenance project for Critical BI Applications.
Responsibilities:
Monitored Production Plans and resolved incidents created by the job failures and ensuring timely data delivery for reporting.
Analyzed and resolved incidents created by Business Users related to data issues.
Performance tuned poorly running ETL jobs and SQLs.
Worked for recovery of missing data caused due to the failure of the ETL jobs and ensured the minimal impact on reporting.
Contributed to the knowledge repository of the project with relevant documents and presentations and received appreciation for the same.
Environment: PL/SQL, Oracle Warehouse Builder, Oracle, Shell Scripting.
Achievements:
Received star of the month award from higher management.
Client appreciation received on multiple occasions.
Contact this candidate