DEVENDHAR YEDUGANI

Email: ac2d72@r.postjobfree.com

Ph.: 215-***-****

Summary

About 7 years of total experience in Information Technology Industry with expertise in Designing and Developing of SSRS, Business Objects, Crystal Reports, Tableau and Data Warehouse applications.

2+ years of HIPAA & corporate compliant Healthcare experience, with knowledge in various business areas of health care including but not limited to Authorizations, Claims, customer service, Ambulatory, ER, Provider services, Accounting, Clinical and Finance, Case Management.

Extensive experience Designing and Developing Reports using SSRS 2008 R2/ 2012 and Crystal Reports 8.5/11.5/2013.

Extensive Experience in Business Objects 4.0/XI R3/R2/6.X/5.X (Designer, CMC, Web Intelligence, Desktop Intelligence, Scheduler, Import wizard).

Experience in SQL Stored Procedures, Triggers, Indexes, Views, Data Transformation Services and Reporting services.

Coding of Database objects like Triggers, Procedures, Functions and Views

Experience in migrating from SQL Server 2005 to SQL Server 2008

3+ Years of experience working on Tableau 7.x/8.2 (Desktop, Server, Reader), creating various Reports and Dashboards using different functionalities.

Experience in all the Latest BI Tools Tableau, MicroStrategy and JasperSoft.

Good Knowledge of Data warehouses and Business Data marts with Star Schemas and Snowflake Schemas.

Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Working experience in Relational Database Management systems (RDBMS), Star Schema and Multidimensional Data Modeling.

Transform data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).

Utilized Integration Services (SSIS) to produce a Data Mapping and Data Mart for reporting.

Strong experience in single and multi-dimensional data warehousing applications using Business Objects Enterprise and Business Intelligence Products.

Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL).

Worked on canned reports and Complex Ad-hoc reporting tools.

Good communication skills and has ability to implement projects with demanding objective.

TECHNICAL SKILLS

Languages:

SQL, PL/SQL, C, C++, HTML, JAVA,J2EE,.NET

Database:

Oracle 8i/9i/10g/11g/12c, SQL Server 2000/05/08, 08 R2, 12, Sybase, DB2, MS Access.

Tools:

Crystal Reports2008/XI/10/9, SSRS 2005/08 R2/2012, Business Objects 4.0/XI R3/R2/6.X/5.X, QaaWS, CMC, Designer, Business View Manager, Info View, Web Intelligence, XCelsius, Microstrategy 9.1/10, Tableau 8.2.

DW Methodologies:

Data Warehousing Design, Data Modeling, Logical and Physical Design.

Others:

ERWIN 4.1.2/4.x/3.x, Visio, Excel, version control, SQL Navigator, SQL Developer, TOAD, MS Access.

Degree: Masters Degree(Lawrence Tech University)

Professional Work Experience

Softrek corporation, Buffalo, NY

Role: Software Engineer

FEB-2017 – Present

Responsibilities:

•Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

•Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

•Administered user, user groups, and scheduled instances for reports in Tableau 8.1.

•Executed and tested required queries and reports before publishing.

•Mastered the ability to design and deploy rich Graphic visualizations with Drill Down, Drill up, Drop through menu option and Parameterized using Tableau.

•Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau .

•Experience on writing PL/SQL Queries, Packages, Store Procedures, Functions.

•Developed stored procedures and triggers to facilitate consistent data entry into the database. Written Stored Procedures using PL/SQL and functions and procedure for common utilities.

•Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.

•Created programming code using advanced concepts of Records, Collections and Dynamic SQL.

Environment: JIRA Tickets, Tableau 8.2, Oracle 11g, JasperStudio 6.3, Clearview.

State of Texas Austin, TX

Role: Sr. BI / MicroStrategy Developer

JAN-2016 – FEB-2017

Responsibilities:

Created new and modified SUMR (Summer), FALL, Mid Year reports in Crystal Reports Enterprise.

Involved in SCRUM with team and Project Managers for PEIMS and ECDS.

Developed user requested reports using Business Objects and Excel, CSV.

Created reports for Austin Code, Austin Police, Austin Water and Transpotation reports in Crystal Reports Enterprise and MicroStrategy.

Created complex webi reports with multiple queries, custom SQL, using complex functions, merging dimensions at report level, drill down, drill up, drill across, complex filters etc. Created Custom functions, formulae, cross tabs, graphs and charts.

Created Attributes, Metrics, security filters and other report objects, drilling, defined hierarchies using MicroStrategy Desktop.

Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS). Created drill down and drill through reports using SSRS.

Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).

Design and Development of Business Analysis Interactive Dashboards & Scorecards organizations HR's goals & KPI in Microstrategy Desktop and web.

Once ETL is done and data gets loaded to Data warehouse, Defined and created MicroStrategy objects including Attributes, Filters, Cubes, Nested Filters, Hierarchies, Templates, Prompts & Nested Prompts.

Extract Transform Load(ETL) development Using SQL server 2012, SQL 2012 Integration Services(SSIS)

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SSIS.

Performed data analysis and data profiling using SQL on various sources systems including SQL Server 2012.

Environment: Oracle 11g, SQL Server 2012, SSIS, SSRS, Web Intelligence, MicroStrategy 10, Crystal Reports 2013, BOXI and Teamforge ticketing system.

Fidelis Care, Buffalo, NY

Role: SQL Server/ Report Developer (SSRS, Crystal)

DEC-2013 – DEC-2015

Responsibilities:

Involved in project planning, gathering requirements from the users, creating spec and layout of the report.

Expert in generating 3-D charts, Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports 2013.

Extensively shared and global variables across business objects/crystal reports, store procedures and views.

Making changes to existing reports and new reports from FACETS ICD 9 to ICD 10 codes.

Used Footprints tickets for version control of the reports to know the status of the report.

Enhance/modify existing reports by creating new Parameters, Formulas etc,

Schedule the reports using Info View to run at specific times in a day/week as desired by the Business Users.

Worked on FACETS modules such as Membership, Benefits and Plan.

Worked on reports in HBX, Claims, Members, Providers, Medical Plan reports.

Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report. Extensively used Calculations, Variables, User Objects in the creation of reports.

Development WEBI BOBJ 4.0 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions.

Worked on complex reports on HIPAA, Billing cycle and subscribers.

Involved in configuring of FACETS Subscriber/Member application.

Optimize various SQL queries to make the reports run faster.

Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.

Used various ETL tools like DataStage, SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.

Converted Data Transformation Services (DTS) application to SQL Server Integrated Services(SSIS) as assigned.

Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).

Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.

Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)

Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.

Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.

Environment: SSRS 2008 R2/SSIS /SSAS, Sybase, Crystal Reports XI R2, Info View XI R2, T-SQL, DataStage, Win SQL, UNIX, Windows XP.

PIMA COUNTY, TUCSON, AZ

Role: SQL SERVER Developer / SSRS-SSIS Developer/ Crystal Reports

OCT-2010 – DEC-2013

Responsibilities:

Involved in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Involved in Daily Stand-Up meetings with Project manager and development team on reports and their road blocks.

Extensively involved in using Formula fields, parameter Fields, Group Selection and Record Selection in Crystal Reports.

Developed Tabular, Drill Down, Parameterized and sub-reports using SSRS.

Exported Crystal reports into various Formats like PDF, Excel and Word for the Users.

Performed analysis and collection of claims data involved in scheduling the daily, weekly, monthly Crystal reports Using MS Access.

Extensively developed user interfaces and tools using MS Access.

Created various SQL scripts for verification of the required functionality.

Developed SQL scripting for regular maintenance and production support to load the data in regular intervals.

Developing complex SQL queries, Stored Procedures and packages using T-SQL.

Creating database objects like Tables, Indexes, Stored Procedures, and Views.

Created various Low, medium and complex reports using drill down on various levels, grouping, filters, parameters and sorts.

Configured SSIS packages using Package configurations wizard to allow package run on different environments.

Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS 2008 and SSIS in Business Intelligence Development Studio (BIDS).

Experience in PROD issues, creating tickets in footprints, tracking the tickets, viewing, Updating and making them resolved.

Used BIDS to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.

Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.

Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server.

3 Executive Dashboards depicting Sales and Inventory data were created during the stint. Dealt with a data volumes ranging from 10 to 20 million records.

Worked on Qlikview Server and Publisher, to manage user access, schedule refreshing of documents, mount completed applications.

Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.

Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters.

Created Standard Reports, Cross-tab Reports, Sub Reports and Drilldown Reports using Crystal Reports 11.5.

Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.

Extensively involved in using Formula fields, parameter Fields, Group Selection and Record Selection in Crystal Reports.

Developed the reports as well as got them done by team on time for the releases.

Environment: AMS Advantage, Crystal Reports 11.5, QlickView, MS Access, Business objects XI r2, Web Intelligence, T-SQL, SQL Server 2008 R2/SSIS/SSRS, Footprints, AMS info advantage.

Contact this candidate