Kirthi Teja Bobba Email & Phone Number

Austin, Texas Metropolitan Area

Austin, Texas, United States

Austin, Texas

Saint Louis

Technical Scope: SSIS, T-SQL, SSRS, OBIEE and UNICA. Provide exceptional support to Business Intelligence team on critical projects concerned with international customer data mapping, anti-money laundering efforts, security encryption, marketing campaigns and SQL and SSIS package upgrades. Well experienced in creating stored procedures, views and SQL agent jobs. Improve query performance by evaluating query execution plan, usage of user-defined functions(UDFs), common table expression (CTE), creating partitioned tables, clustered and non-clustered indexes, column store index, etc.. Effectively develop and maintain SSIS package configurations and variables to ensure reliable server connection and boost export capabilities; upgrade SSIS packages to SQL server 2014. Build SSRS reports in SQL Server Versions 2008, implement dacpac file usage within multiple teams, and develop and maintain OBIEE reports and dashboards. Implement projects utilizing Agile methodologies SCRUM and KANBAN, and maintain vital data definition documents. Identify and resolve crucial problems for users at various locations; travel to end-user locations as necessary. Mentor new hires to improve team communication and overall cohesion. Key Achievements: Spearhead the merging of international client data in Enterprise Data via the gathering of needed requirements, the creation of new SSIS packages and updating of existing packages to map with existing fields. Serve as a key member of the Anti-Money Laundering project by setting triggers for high-risk customers, enacting new metrics to evaluate the customer profiles, and developing trading surveillance reports in OBIEE and SSRS. Identify critical security fields, encrypt vulnerable fields, and decrypt fields as necessary in collaboration with DBA team. Conducted workshops to educate new users on the correct use of OBIEE and SSRS reports.

Saint Louis

Managed the decommissioning of SSRS 2000 reports via the effective upgrade to newer versions. Develop, maintain and implement vital SSIS packages and OBIEE reports.Key Achievements: Spearhead the merging of international client data in Enterprise Data via the gathering of needed requirements, the creation of new SSIS packages and updating of existing packages to map with existing fields. Identified target customer bases through the effective application of key metrics and promoted information transparency within the marketing team by providing exceptional data availability.

Greater St. Louis Area

Technical Scope: SISS, T-SQL, SSRS, SSAS and MDX. Provided exceptional client support through the resolution of data issues, explanations of results and requirements, and the provision of regular status updates. Analyzed system requirements, planned and implemented Data Warehouse program, and synthesized data from various sources. Effectively developed and maintained SSRS reports, including parameterized reports, linked reports, snapshot reports, drilldown reports, drillthrough reports and sub-reports. Generated reports, scheduled database backups, managed business intelligence life cycles for multiple clients, and increased performance via the upgrading of existing scripts. Updated dimensions and fact definitions, created job scripts per client parameters, and maintained all project documentation.Key Achievements: Championed the development of several SSIS packages to support tasks including: slowly changing dimensions, aggregate, derived columns, conditional split, look up, multicast, data conversion, data profiling and more. Created T-SQL Queries, MDX queries, stored procedures, views, clustered, and non-clustered indexes and fined tuned for optimal performance. Provided extensive troubleshooting of job failures, query issues, source files, domain tables, SSAS cubes, and SSRS database reports to ensure the timely resolution for critical issues.

Rolla, Missouri

Working as a student assistant at Office of Undergraduate studies at Missouri University of Science and Technology. Job includes developing and maintaining of department’s web pages. Experience in J2EE, HTML and SQL. Extensive use and familiarity of Microsoft Excel.

Master Of Science (Ms), Computer Science

Bachelor Of Technology (Btech), Computer Science