ANANDA KOSARAJU

HOUSTON, TX 713-***-****

adc7ox@r.postjobfree.com https://www.linkedin.com/in/ananda-kosaraju-07508a15

SENIOR IT DEVELOPER BI / DATA ANALYTICS

Data Engineering Business Intelligence Optimizing Solutions Exceptional User Experience

Certifications

Microsoft Certified Azure Data Engineer

Microsoft Certified Azure Fundamentals

Certified Oracle Business Intelligence Enterprise Edition (OBIEE)

CRM Product Configurator

Data Analytics, Business Intelligence and Customer Relationship Management (CRM) expert for successful, full life cycle implementations of IT systems across Energy, Communications, and entertainment industries.

Over 13 years of Strong development Experience in design, implementation, application

integration, and operational support expertise in utilizing Microsoft Azure, Power BI, SSIS, SSRS, Oracle OBIEE, Actuate and Siebel CRM products.

Expert in delivering data acquisition, Conversion, digital transformation, and migration projects.

Proactively engaged with business stake holders, PMO and delivered automated solutions.

Excellent communication, interpersonal skills, and ability to interact with product owners, technical teams, and end users.

Technical Profile

Cloud technologies

Microsoft Azure (Certified)

BI and Analytics

Azure Databricks, Power BI 2.7, MS SSRS 2016, 2014, Oracle OBIEE 11.1, Actuate Workbench 6.0, Crystal Reports 8.0

ETL Tools

Azure Data Factory, SSIS, Informatica

CRM

Siebel 8.1, 7.5.2

Database

Oracle 11 g, 9i and 8.0.5, SQL Server 2019, 2016, 2014, 2012,

MS-Access

Languages

Python, Scala, PL/SQL, T-SQL, DAX, Siebel VB, Siebel eScript, Visual Basic.Net, VB Script, Java script, XML and HTML

Notebooks

Jupyter

Tools and Utilities

Visual Studio 2019, vs code, Toad 9.6 for Oracle, SQL developer 4.0, Visio 2016,

Version Control

Azure GIT, GitHub V 2.1, TFS 2013, 2015, 2017, Concurrent version System (CVS), Visual Source Safe 6.0,

Cloud technologies

Microsoft Azure

Agile planning tools

Azure Boards, Version1

PROFESSIONAL EXPERIENCE

Data Engineering Pilot - Microsoft Azure 2020

Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like SQL server, Blob storage and publicly available datasets.

Configured AZcopy and storage explorer tools, moving the data between storage accounts.

Performed data migrations and data synchronization between on premise SQL database and Azure databases leveraging data migration assistant and SQL Data sync.

Configured Polybase in azure Synapse analytics, reading the data directly from external data sources.

Configured HDInsight cluster and Storage Account, leveraging Python to import and transform datasets.

Configured Data bricks environment to ingest and analyze Social media data using Spark SQL queries, Data frames, transformations, and read/write operations.

Created Azure Event hubs and Stream analytics jobs, capturing stream data and reference data

(Log data) from Storage accounts.

Leveraged power BI dash boards to surface and visualize the live stream data from Stream analytics.

Configured Cosmos DB with Table and SQL API to load the data from on premise database and enabled multi region writes.

Created and configured security through Managed identity, Access control lists and SAS policies.

Constellation Energy / Exelon, Houston, TX

Senior Analyst, BI / Datawarehouse developer 2014 – 2020

Subsidiary of Exelon, a fortune 100 energy company which owns 6 utilities and delivers electricity and natural gas for 10M customers.

Served as an expert developer for various projects such as Acquisitions, New market entries, Digital transformation, and operational support.

PROJECT: C&I digital transformation - Microsoft Power BI:

Collaborated as BI solutions lead in designing and building the reports for the C&I digital team.

Developed and streamlined complex Stored procedures to extract the data for C&I Power and Gas customers to support multiple Power BI reports and dashboards.

Created complex calculated measures using DAX queries and leveraged hierarchical filters and slicers in Power BI.

Designed dashboards for customers to access Monthly and historical billing and usage information.

Designed dashboards with geographic pointers, Map visuals, quick insights and Ask a question for business development managers to perform utility specific interactive analysis.

Created invoices and Payments Roll up reports at commodity, Utility and Parent billing account levels for large C&I customers which significantly improved end user experience.

Embedded the power BI reports in Energy manager web sites and set up security through Microsoft Azure.

Thrive in a team environment and actively engaged with multiple project teams in a fast-paced work environment.

PROJECT: AGERA Energy Acquisition - SSIS 2015:

Constellation Energy acquired retail providers to expand market cap and strengthen position as largest competitive energy supplier.

Involved in AGERA Energy data conversion project as IT lead and successfully converted Over 10,000 large commercial customers across 50 different utilities.

Created multiple SSIS packages for ETL, loading external files from AGERA Energy to Constellation retail systems.

Developed SSIS packages to map and transform different entities to Target CRM and billing systems resulting the smooth transition of data conversion process.

Created reusable dynamic transformations leveraging table driven business logic, eliminating hard coded utility specific rules.

Excelled at rapid data acquisition requirements and completing life cycle of data conversion process.

Effectively engaged with business stake holders, PMO and business analysts for data gathering, mapping and best practices.

Provided technical leadership in developing data migration strategies for conversion of customer and usage data from Source to target systems.

Created and monitored the Active batch scheduling jobs, automating the end to end data conversion process.

PROJECT: Retail BI and Data Analytics Support- Microsoft SSRS / SSIS / SQL server 2015:

Strong knowledge and experience in OLAP data warehouse, model, design, and implementation of best practices.

Developed Multiple SSIS Packages, loading data from OLTP to ODS and to data warehouse.

Designed SSIS packages with various transformation such as derived column, Conditional split, lookup, and aggregations in the process of configuring multiple destinations.

Implemented slowly changing dimensions and enabled historical data maintenance in data warehouse using ETL process.

Supported dimensions and cubes with Star schema using SQL server analysis services SSAS.

Design and developed stored procedures, queries, and views in MS SQL server, supporting SSRS reports.

Designed, deployed, and maintained about 1000 SSRS reports and dash boards across multiple business entities.

Scheduled and managed daily/ weekly /monthly operational reports for better visibility, delivering through Emails and File shares.

Developed stored procedures to generate various Drill-through reports, parameterized reports, tabular and matrix reports.

Designed various reports including: Customer enrollment counts, utility enrollment rejections, Customer status mismatches, monthly usages, late invoices, overdue payments, Audit reports by using SSRS.

Collaborated with the management to plan BI strategies, created BI road map, and helped in budget plans, delivering organizational needs.

PROJECT: MX Energy Retail BI and Data Analytics Support-Oracle 11g Data warehouse / OBIEE reports:

Maintained and supported entire retail data warehouse using Oracle 11g, Delivering key business insights through reporting and ad hoc requests.

Maintained Oracle data warehouse for residential and small commercial customers with over 1 TB of data, serving many Business needs and insights to further business improvements.

Designed and implemented Stored procedures, functions and ETL scripts to enable the processing of large data sets from CRM and billing systems and energy forecasting process.

Partner with business owners in requirement gathering, maintaining data quality and execution of the user and department specific report requirements.

Created control files, using SQL loader for bulk data uploads.

Designed and implemented appropriate ETL mappings extracting and transforming customer enrollments, usage, Invoice, and payments data for various Constellation supported markets.

Automated the process to utilize customer usage information to risk system, improving forecasting purposes.

Developed daily, weekly, and monthly dashboards to multiple business owners including Customer operations, accounting, FP&A, Risk, sales, fulfillment, and call center teams.

Created/modified Metadata repository using the OBIEE 10g's Physical, Business Model, Mapping and Presentation Layers.

Mx Energy / Constellation Energy / Houston, TX 2007 - 2013

Senior CRM Analyst

Subsidiary of Exelon delivers natural gas and electricity to residential and commercial customers in deregulated energy markets and serves million customers in 52 utility territories throughout US and Canada.

Performed operational support of CRM application, maintenance, and integration to billing, Forecast, middleware and BI systems.

Designed, developed, supported, and Administered the complete life cycle of CRM application.

Delivered continuous improvement of CRM system and Oracle RDBMS environment to ensure the highest availability to the end users.

Implemented Siebel best practices and developing appropriate solutions.

Developed the complex workflows for batch enrolling the customers from marketing campaigns and web enrollments.

Consolidated multiple legacy CRM systems into one CRM extracting and formatting of legacy data using PLSQL and Siebel EIM.

lead the team for the new market entry challenges, Government aggregations programs, implemented process in adding 400K customers into CRM system.

Performed various Siebel administration tasks, including building migration scripts, Monitor and configure Siebel components, repository migrations, set up access controls and procedures.

Mentored junior developers, resolved recurring performance issues within the application.

Served as a primary system support individual to multiple business teams, product owners, providing automated solutions to manual processes.

Developed a user-friendly interface in Visual Studio.net to interact with CRM, uploading New customer enrollments, Contacts, Addresses, Re enrollments, and Contracts.

ADDITIONAL RELEVANT EXPERIENCE

Siebel CRM Integration Consultant: Feb 07 – Sep 07

Client: 20th Century FOX, Los Angeles, CA.

Project: Home Entertainment International Sales/Financial Planning & Forecasting

Siebel CRM Consultant Nov 06 – Jan 07

Client: Chase Com LP, Houston, TX.

Project: Account Management

Education

Bachelor of Technology in Electrical Engineering, Nagarjuna University, India

Contact this candidate