About Me
Senior Consultant with more than 12 years of experience in IT Industries, and extensive “hands-on” experience with windows & web-based technologies, ETL, Microsoft Azure, SQL Server and other databases. Specifically, my experience has been wit...
Key Technical Skills: Microsoft Business Intelligence(SSIS, SSAS with MDX/DMX & SSRS), ADFv2, Power BI, SentryOne, Visual Studio (2010,2012,2015) VB.Net & C#, Oracle SQL, MVC, Entity Framework, Java scripts, Data Warehousing, ETL, SQL Server 2008 R2 (including PL-SQL and performance tuning), SQL Server 2014, DTSX Jobs, Windows and Web Services
Show MoreSkills
Data & Analytics
Software Engineering
Database
Programming Language
Web Development
Operating System
Others
Positions
Portfolio Projects
Company
IBM
Description
Being part of Kemet’s BI team, worked on Data Stage Jobs Migration to SSIS which loads data between Oracle sources, few of the jobs are Part Plant Report, EBARS, Unreleased MES to ASCP, KMS Part Plant Usage, Cognos Pegging & Rollout Reports. Data the stage jobs which were running through Orsyp scheduler changed to SQL Server Agent jobs. Supporting existing Oracle Datawarehouse, which runs Nightly jobs that loads data from sources like ETBF and Oracle systems. Fixing reports issues which is connected through Vertica DB, parallelly working on other enhancements like OCI migration testing.
Technologies:
Show More Show LessCompany
TCS
Description
Worked on Support & Development Projects like Markets Data Warehouse (MDW), BAU MI Reporting, which includes LBG’s Data Staging, Data Warehouse with Cubes & Dynamic reports used by various teams.
MDW is data warehouse which provides management information to the business instantly and in a self-service manner. It is also to be the authority and central source of MI reporting.
Reconciliations of expected transactions will be performed after each successful MDW ETL against source systems and include reports to identify any missing records in the MDW data store, the results are used to instigate further investigation with the respective Group IT System Support teams and Markets Operations Processing teams.
BAU MI Reporting is a collection of SSIS packages and tables that contains details of LBG warehousing and reporting data. The contents are updated daily Monday-Friday from the Group Data Warehouse. Other data is extracted from CrisP(Oracle db) and MDW(Deals)
Show More Show LessSkills
C Sharp Microsoft SQL SSAS SQL Server Reporting Services - (SSRS) SQL SQL Server Integration Services (SSIS)Tools
Microsoft Visual StudioCompany
Kemet Corporation BI
Role
Software Architect
Description
Being part of Kemet’s BI team, worked on Data Stage Jobs Migration to SSIS which loads data between Oracle sources, few of the jobs are Part Plant Report, EBARS, Unreleased MES to ASCP, KMS Part Plant Usage, Cognos Pegging & Rollout Reports. Data the stage jobs which were running through Orsyp scheduler changed to SQL Server Agent jobs. Supporting existing Oracle Datawarehouse, which runs Nightly jobs that loads data from sources like ETBF and Oracle systems. Fixing reports issues which is connected through Vertica DB, parallelly working on other enhancements like OCI migration testing.
Show More Show Less
Tools
SSIS MS SQL Server PLSQL DeveloperCompany
Telstra
Role
Full-Stack Developer
Description
It’s an Australian Telecom based Business Intelligence & Finance department, I had worked for transition project from internal resource to vendors along with support and maintenance of demand breakthrough server which contains ETL jobs, Tabular Cubes & SharePoint sites
Show More Show Less