Kranthi

Company Overview:

Altice USA commonly known as Altice, is an American Cable provider with headquarters in New York City. It delivers pay television, Internet and phone services, and original television content to approximately 4.9 million residential and business customers in 21 states

Responsibilities:

• Work on Full life cycle development (SDLC) involving in all stages of development
• Design and develop Alteryx workflow, self-service application for business users to extend insights for multiple what-if scenario analysis(Build once and use many)
• Worked and enhanced Different Key reports like Key Metrics Now and CTIO Dashboards which are distributed daily to CEO and CTIO of Altice.
• Developed shell scripts for data aggregation in Amazon Redshift Data Warehousing Environment from business runes for Audience measurement group
• Developed Power Bi reports and dashboards using Company’s standard defined visuals using toolkit
• Develop complex Alteryx analytic Jobs to provide extracts to be used by Reporting for support to business functions
• Responsible for creating, supporting and maintenance of BigQuery SQL code as well as improving performance
• Created and architected Complex Stored Procedures, Views and functions and other statements for various Applications, maintained referential integrity and implemented complex business logic
• Design and develop BI reports in Tableau using advanced functions like LOD, Parameters, Sets, Groups, and Quick table calculations
• Used DAX function to compute calculated columns and measures
• Provide feedback to management concerning possible problems or areas of improvement and Make recommendations to implement improved processes
• Altice USA commonly known as Altice, is an American Cable provider with headquarters in New York City
• It delivers pay television, Internet and phone services, and original television content to approximately 4.9 million residential and business customers in 21 states
• Environment: Netezza, Python, HTML, CSS, Google BigQuery, Redshift, Windows Sever 2012/2016, SQL Server Management Studio, Alteryx 11.3, Tableau Desktop 10.5, Azure DW, Power BI

• Company Overview: Cablevision system corporation was an American cable television company with systems serving in New York and surrounding cities
• It is the fifth largest cable provider
• Design and develop interfaces to visually surface key statistical outcomes and experimentation results which determines the subsequent development and experimentation choices
• E.g
• Use training data from Azure and choose data model parameters and run the model with test data to derive expected outcomes
• Design and develop high-impact data visualization applications (using HTML5, AngularJS, CSS3, D3.js, Java and Redshift) to derive actionable insights for business users
• E.g
• High-risk customer profiling, financial analysis, customer breakdown by market segment
• Converted Complex business logic into SQL Stored procedures and User-defined functions to achieve functionality required by the UI team
• Created and generated reports to display data
• Developed complex T-SQL code for the application conversions
• Provide data required for sophisticated analytics requested by external as well as internal clients
• Create ETL between different data warehouses and data preparations for Visualization in Power BI
• Created SSIS packages for transferring data from various data sources like SAP R3 system, Oracle, MS Access, Excel
• .Txt file
• .CSV files
• Involved in security and user role assignment to different reports
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load
• Cablevision system corporation was an American cable television company with systems serving in New York and surrounding cities
• It is the fifth largest cable provider
• Environment: Netezza, T-SQL, Python, Netezza, Redshift, Windows Sever 2012/2016, SQL Server Management Studio, Snowflake, Alteryx 11.3, Azure, Power-BI Desktop, Tableau Desktop 10.5

• Company Overview: Comcast is a U.S based international mass media company and is the largest broadcasting mass media company and Cable Company in the world by revenue
• It is the largest cable company and home internet service provider in the United States, and the nation’s third largest home telephone service provider
• Comcast services U.S residential and commercial customers in 40 states and the District of Columbia
• Worked on Full life cycle development (SDLC) involving in all stages of development
• Designed the process for Payments, Content Providers and Accrual for Comcast finance team
• Created SSIS Packages and Reports for Comcast Accrual and Payment process
• Worked and lead the offshore team in all phases of the project development
• Created Database Objects Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc
• In Power BI
• Developed complex Stored Procedures using SQL, Dynamic SQL queries having good performance
• Extensively used Joins, CTEs, Table Variables, Global and Local Temp Tables
• Developed complex SSIS packages to load the data from SQL Server, Oracle databases
• Used various transforms in SSIS to load data from flat files and FTP to the SQL databases
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI
• Designed, tested (unit testing and integration testing) and implemented stored procedures and triggers for data processing of huge volumes of data
• Comcast is a U.S based international mass media company and is the largest broadcasting mass media company and Cable Company in the world by revenue
• It is the largest cable company and home internet service provider in the United States, and the nation’s third largest home telephone service provider
• Comcast services U.S residential and commercial customers in 40 states and the District of Columbia
• Environment: MS SQL Server 2008/2008R2/2012 on windows 2007/2012 server, IIS, Visual studio, SSIS, Power BI, Framework Manager, BIDS, SQL Server Data Tools, SSMS, Azure

• Company Overview: ISIGMA delivers powerful, fully integrated web-based Customer Information (CIS) and Billing Solution for regulated and deregulated energy markets such as Retail Electric Providers, TDSPs, energy Aggregators, Co-ops, and Municipals
• The functionality includes Enrollment of the Customer based on Post or Pre-Pay Product and generates the Electricity bill
• Worked on conversion projects that include data extraction and transfer services
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data in Database Tables
• Created packages for transferring data from various data sources like SQL Server, SAP R3 system, Oracle, MS Access, Excel
• .Txt file
• .CSV files
• Performed troubleshooting of issues related to sigma CC&B application
• Implemented Framework based on (MVC) Model View Controller paradigm in WSAD
• Involved in Java code which generated XML document, which in turn used XSLT to translate the content into HTML to present to GUI
• Worked on migration of dts and SSIS packages in 2005/2008 to 2012
• Involved in day-to-day maintenance of database Objects, SSIS packages and SSRS Reports
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases and data mart databases
• Regular responsibilities for updating, staging and dimensional databases using ETL as well as rebuild the Dimensions and Cubes in SSAS
• Provided Index tuning as required for performance improvement of the applications (SQL tuning)
• ISIGMA delivers powerful, fully integrated web-based Customer Information (CIS) and Billing Solution for regulated and deregulated energy markets such as Retail Electric Providers, TDSPs, energy Aggregators, Co-ops, and Municipals
• The functionality includes Enrollment of the Customer based on Post or Pre-Pay Product and generates the Electricity bill
• Environment: MS SQL Server 2008/2008R2/2012 on windows 2003/2007 server, IIS, Visual studio, SSIS, SSAS, SSRS, Database Mirroring, Replication, log shipping, Cognos Report Studio, Framework Manager, BIDS, SQL Server Data Tools, SSMS

• Company Overview: Applied Materials is a global leader in supplying manufacturing equipment, services, and automation
• Software to enable the manufacture of advanced semiconductors, flat panel display and solar photovoltaic products
• It helped in the innovations like Smartphone’s, flat screen TVs and solar panels more affordable and accessible to consumers and business around the world
• Worked on Full life cycle development (SDLC) involving in all stages of development
• Created and maintained Databases for development, testing and production environments
• Managed project versions and source code changes by check in and checkout using source control tools like TFS, Visual source safe and clear case
• Created Database Objects – Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles
• Developed complex SSIS packages to load the data from SQL Server, Oracle, DB2 and Hyperion databases
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent
• Created and maintained logins, roles and permissions on the SQL instances and databases and provided required privileges according to the user’s requirements
• Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Constraints
• Involved in building business objects and data accessing from SQL databases using ADO.NET
• Wrote T-SQL code for creating cursors and handling the data validations
• Created Linked Servers for building Distributed queries using OLE DB data sources
• Provided index tuning as required for performance improvement of the applications (SQL tuning)
• Created parameterized, drill down, drill through and aggregation type of reports in SSRS
• Applied Security to Web Server and Database Server that affects SSRS Report server installation and managed role-based security to reports and reporting resources
• Applied Materials is a global leader in supplying manufacturing equipment, services, and automation
• Software to enable the manufacture of advanced semiconductors, flat panel display and solar photovoltaic products
• It helped in the innovations like Smartphone’s, flat screen TVs and solar panels more affordable and accessible to consumers and business around the world
• Environment: MS SQL Server 2012, Amazon AWS, SSIS, Tableau, Framework Manager, BIDS, SQL Server Data Tools, SSMS

• Company Overview: Ventyx, an ABB company, is a leading business solutions provider offering software, data and advisory services
• Ventyx offerings comprise a broad range of solutions to address the most critical needs of utility, power, and communications companies, including asset management, customer care, energy analytics, energy operations, energy trading and risk management, equipment reliability, mobile workforce management, network management and operational decision-making
• Created SSIS packages for transferring data from various data sources like SAP R3 system, Oracle, MS Access, Excel
• .Txt file
• .CSV files
• Involved in security and user role assignment to different reports
• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Excel and Flat Files
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data in Database Tables
• Responsible for creating batch files and scheduling the jobs
• Experienced in analyzing the Dashboards, including Action Items, KPI’s
• Involved in analyzing Custom Reports and Ad-hoc Reports by using SQL Server Reporting Services (SSRS)
• Involved in preparing detailed technical documents
• Ventyx, an ABB company, is a leading business solutions provider offering software, data and advisory services
• Ventyx offerings comprise a broad range of solutions to address the most critical needs of utility, power, and communications companies, including asset management, customer care, energy analytics, energy operations, energy trading and risk management, equipment reliability, mobile workforce management, network management and operational decision-making
• Environment: MS SQL Server 2008, SAP ECC, SSIS 2008, SSRS 2008, SSAS 2008, DTS, T-SQL, OLAP Service, Visual Studio 2005, ASP.NET, SQL Server Profiler, Erwin Data Modeler 7.2, Windows Sever 2000/2003/2008R2, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS)

• Company Overview: Indiana University Health is Indiana’s most comprehensive healthcare system
• A unique partnership with Indiana University School of Medicine, one of the nation’s leading medical schools, gives patients access to innovative treatments and therapies
• IU Health is comprised of hospitals, physicians and allied services dedicated to providing preeminent care throughout Indiana and beyond
• Extensively used T-SQL in constructing user functions, views, indexes
• The Tasks involved writing lot of T-SQL code, including use of complicated joins and cursor loops
• Created Complex Stored Procedures, Views and functions and other statements for various Applications, maintained referential integrity and implemented complex business logic
• Involved in translating business requirements into technical design specifications
• Converted Complex business logic into SQL Stored procedures and User-defined functions to achieve functionality required by the UI team
• Created and generated reports to display data
• Developed complex T-SQL code for the application conversions
• Developed XML file Parsing in SSIS
• Involved in mock testing and Unit testing in SSIS
• Created Automated Stored procedure for day end operation using SQL Server agent
• Collected business requirements from users and translated them as technical specs and design docs for development
• Handling the change requests and estimating the work efforts
• Indiana University Health is Indiana’s most comprehensive healthcare system
• A unique partnership with Indiana University School of Medicine, one of the nation’s leading medical schools, gives patients access to innovative treatments and therapies
• IU Health is comprised of hospitals, physicians and allied services dedicated to providing preeminent care throughout Indiana and beyond
• Environment: SQL Server 2008 R2, SQL Server 2008, Windows 2003/2000, VBScript, VB.Net, ASP.Net, HTML, SSIS, SSRS, XML