BHARATHI KAILASH

ad2d4s@r.postjobfree.com

913-***-****

CAREER

SUMMARY: Information Systems Professional with over 24 years of industry experience. During this period, I have designed and developed several reports from ground up by consolidating data from multiple sources to support various customer needs. Reports requirements, look and feel were always driven by business and finance management.

EDUCATION: Associate of Science in Computer Programming, 1999 Honors Graduate.

Santa Fe Community College, Gainesville, FL.

Bachelor of Science, Maris Stella College, India, First Class.

Alteryx Micro Certified

Alteryx Core Certified

PowerBI Proficient

Microsoft Certificate in Word Proficient

Microsoft Certificate in Excel Proficient

Member of High Honors at SFCC

Member of Dean’s List three times at SFCC

SOFTWARE/

HARDWARE: Power BI, Alteryx, Microsoft Azure, Sales Force, ETL, JIRA, Microsoft Access, Crystal Report, Microsoft Word, Excel, Power Point, Front Page, Oracle, Toad, SQL Server 2000, Python, Business Objects, Micro Strategy 7, Visual Basic, Java, JavaScript, Unix, HTML, JDBC, and ODBC, Windows NT, Windows 95/98, Windows 3.1, and MS DOS, OOP

RESPONSIBILITIES:

My position demands strong understanding of business, accounting, and finance groups requirements to design, develop, and deliver consolidated reports on a consistent basis in an automated fashion without any human intervention.

When new projects are assigned, I meet various customers, gather their requirements, project deadlines. Even though I am working on various high-profile projects, I work very hard and delivery the projects well ahead of time and keep all my customers very happy.

I am very efficient in troubleshooting the data for any inaccuracies, identify root causes and take appropriate actions to fix the problem before the data is presented to my customers.

Before creating the reports, I arrange meetings with customers and understanded their requirements. After implementation of the reports, I ask them to test/validate the reports to satisfy their need. Once I got the approvals from the customers then I automate reports and schedule them to run on daily/weekly based on their requirements.

After database implementation, I check/test implemented tables for data validity, data integrity, data accuracy (row counts, dollar amount, certain changed fields and make sure that the data is populated accurately), run complex SQL queries to thoroughly test its capabilities and responsiveness.

PROFESSIONAL

EXPERIENCE:

T-Mobile – Business Intelligence 2020 – Current

Excellent knowledge of TEOCO (BTP) database, Salesforce, Sittera, ATOMS, TCM, CITS, CASS

Based on my strong skills of SQL and Data Visualization/ Analytics, I have designed and developed automated reports to various customers using Alteryx and Power BI

Projects currently working - Decom contract deselect Reports, Power & Energy Reports

Data for these reports are pulled from multiple data sources (Azure Legacy T-Mobile and Legacy Sprint) and the data is normalized.

Join multiple tables and simplify the process by using append queries, update queries, applying filters, and writing formulas.

Create Power Bi Reports

Publish dashboards.

Schedule jobs to run automatically.

Reports are consumed by data analysts and managers from various groups (Accounting, Finance and Business).

Sprint/Nextel 2005 – 2020

AV built a new Platform called Bill Track Pro (BTP). This Platform has Wire Line IXC, CDMA, IDEN, and ADMIN data. Before BTP conversion, Wire Line IXC data was in CBS system, CDMA data was in COA system, IDEN and ADMIN data was used and maintained by Nextel group on their won systems.

Once Bill Track Pro Platform was Built, I developed the reports and Applications needed for Management of AV Department Operations & Non-AV groups. These Applications were originally created in various platforms like Oracle, Crystal, DB2, COBOL, and Excel Modules. I had to understand the code from various platforms with no guidance and develop these applications in Access Database and Business Unit for Automation process. This was a very challenging project for me since I had to understand the old CBS, COA, and NEXTEL data and also understand the BTP platform for creating similar reports. After conversion I tested all these reports in BTP and matched the results against the old data and they were accurate. All these reports are run on a monthly basis. I maintain these reports and modify the code based on management requests.

Sprint PCS Sep.2002 - 2004

Worked with RODEO Conversion Operations and Error Management group. Developed several Applications to support the Conversion process. *Developed an automation reporting application to produce actionable reports for use by Business Units for measuring the Post Conversion P2K Activity.

*Also developed an application to monitor and report on the Converted Account API Activity to report errors and processing times outside established SLA’s and build email/paging notification functionality. *Identified and streamed the eligible pool of accounts into Production/Development through Scheduler/Exception process; created screen shots and network audit reports to validate conversion.

*Developed Rz Canned Reports and Certified reports from a data level. Created queries to produce the results meeting the report requirements and ran the queries to evaluate the results. Research discrepancies.

The analyses are done using SqlPlus, SQL Server 2000 and Access Database, Toad, Crystal Report, Visual Basic, and SSH secure shell. The results are presented using Automation process of Excel files, emails, and pagers.

Sprint LTD Apr. 2001 – Sep.2002

Worked with Mkis database to create Ad Hoc and Monthly Recurring Reports. This database contains customer and revenue information from LTD and Long Distance. The database contains revenue generated by providing different services such as PBX lines, DSL, Key Trunk lines, B1 lines, Centrex lines, ISDN, T1 lines and Frame Relay lines, etc. From this information I analyze the data to obtain how many customers are disconnected, how many customers are new and how many are existing from month to month. I also analyze how much revenue is generated from each customer based on different active lines. The MKIS database is developed in ORACLE. The analysis is done using SqlPlus and Access Database, Toad, Crystal Report and MicroStrategy. The results are presented using PowerPoint and Excel.

Sprint PCS (Kelly Services) -Contract Feb. 2001 – Apr. 2001

Worked with Market Business Spectrum software and Access Database. The Spectrum software is used to find the general information about a company. The information includes the company’s location, total number of employees, company’s Head Quarters and its parent company’s name. This information is checked against the information stored in Access Database. If any information stored in the database is mismatched, the new information is overwritten into the Access Database. SQL queries and reports are created to find out specific details about any company in the database. The information includes if more than one company has the same ultimate duns number, or if the company is merged with another company, or if a company no longer exists, etc.

Universal Underwriters Group - Contract Aug. 1999 – Dec. 2000

Worked on Rating Database. Rating Database stores information about insurance provided to car dealers, automobile parts, etc. For this database, I am involved in creating queries, reports, and data entry for the various states. The queries and reports are done using SQL statements.

University of Florida - Contract Jan 1994 – Aug. 1999

As a database developer, implemented a relational database UFDATABASE using Access97. The database is used to store large amounts of data obtained from various field tests. The tests were conducted on bridges from all over the country. The data is entered through Forms. The data is converted into ASCII text file. Several finite element programs use this data to find the ultimate capacity of Piles, Shafts, and Drilled Shafts.

Contact this candidate