SUMMARY

• Over 6+ years of IT experience in Analysis, Design, Development, Testing and Administering database applications using SQL Server BI suite, Tableau Desktop,Tableau ServerandTableau Reader
• Strong Experience in SQL, Oracle, Sybase and MySQL
• Strong experience in SQL Development, Administration, ETL development using Microsoft SSIS, Reporting solutions using SSRS, Performance tuning, Designing logical/physical databases and Troubleshooting
• Experience in creating and developing Power BI Dashboards in to rich look. Expert T - SQL development skills in Objects creation such as Tables, Views, Normalization, User Defined functions, Indexes, Stored Procedures, Correlated sub queries, Cursors and Triggers using SQL Server 2008R2/2012/2014 and Oracle
• Knowledge of Agile Software Development Process, good understanding of Database Concepts, Design Principles, Database Standards, and Test-driven Development

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, C#, Shell Scripting

Database Environments: SQL Server, Oracle, MySQL, Sybase

Tools: SSMS,SQLServer Profiler, Tuning Advisor, Business Intelligence Development Studio (BIDS), Visual Studio, Tableau Server 6 Toad, Embarcadero Rapid SQL, SQL Developer, Power BI, MS Office, Microsoft Visio, Tortoise SVN, Team Foundation Server, MS Access

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

BI Developer

Responsibilities:

• Working on applications using SQL, SSRS, SSIS in an agile environment. Closely worked with business users and business analyst to gather user requirements and generate high level BRD’s and Report Mockups for the Report Development
• Create reports on Sales, Accounting, Customer and Fair data and modify existing reports using SQL, SSRS
• Created and maintaining drill down, matrix, parameterized Reports along with their respective subscriptions using SSRS and Report manager, ad hoc reports using Report builder
• Used various sources to pull data intoPower BI such as Sql Server
• Scheduled Automatic refresh and scheduling refresh in power bi service
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily
• Performance tuning of slow running queries in SQL database using SSMS, SQL profiler and tuning advisor
• Worked on all types of transformations that are available in Power bi query editor
• Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications
• Created ETL processes to load data from Core database to team specific databases using SQL, SSIS for reporting purposes using advance transformations (i.e. Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate)
• Rewrite database processes to meet new coding standards and improve run times

Environment: Visual studio 2015, SQL Server 2014/2012, SQL Server Management Studio, Power BI, SQL Prompt, SSIS, SSRS, Workfront, Agile Methodology

Confidential, Salt Lake City, UT

SQL BI Developer

Responsibilities:

• Worked on database applications using SQL, Oracle 11g, Sybase, SSRS, SSIS
• Actively participated in design, development discussions with DBA, team lead and project manager and performed impact analysis, interact with user groups and BAs to gather requirements
• Created Reports in SSRS with different type of properties like Chart controls, Interactive sorting, SQL
• Parameters on claims data such as Medicaid, Medicare, APCD and also created ad hoc reports using Report builder for business analysts
• Created report subscriptions such as email and file drops for report management and monitoring using SSRS and Report manager
• Created Dynamic SSIS packages using complex expressions, variables and control flow components such as For Each Loop, For Loop to loop over a Directory to load inbound Medicare Managed Care System Data
• Created and maintaining SSIS packages to load application specific data from Facets to SQL and Oracle Databases using advance transformations and created jobs to schedule them using SQL server agent
• Created application specific claims databases in Oracle, SQL and batch jobs using SQL stored procedures
• Deployed Database changes, Packages, Reports from development to QA, UAT and PROD environments
• Conducted Peer review sessions to identify and minimize issues in testing phase. Provided QA and UAT Support by actively fixing issues which are reported in HP Quality Center

Environment: Microsoft Visual studio, SQL Server 2012/2008, Oracle 11g, SSIS, SSRS, Windows 2012 Server/2008 R2 server, MS Visio, Control-M, Toad, SQL Developer, Rapid SQL, HP Quality center, VersionOne, Agile Methodology

Confidential

SQL Developer

Responsibilities:

• Worked on database applications using SQL, PL/SQL, SSIS, SSRS and Oracle in an Agile Environment
• Worked on US to Guntur, an e-commerce application using SQL, SSRS and SSIS
• Involved in Logistics and Healthcare applications developed using SQL, Oracle, SSIS, SSRS and .Net
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports according to business requirements
• Created rules, defaults, tables, views, clustered & non-clustered indexes, user defined data types, user defined functions, stored procedures and database normalization
• Created ETL processes to load pricing and product details into SQL Server and to archive data using SSIS, created jobs to schedule them using SQL server agent
• Actively participated in design, development discussions with DBA, team lead and project manager and performed impact analysis, interact with user groups and BAs to gather requirements
• Created and Maintained Packages to load payment, logistics, healthcare data into application specific databases using SSIS
• Involved in performance tuning of T-SQL Queries and Stored Procedures
• Deployed Database changes, Packages, Reports from development to QA, UAT and PROD environments
• Involved in migration from SQL server

Environment: MS SQL Server 2008/2012, T-SQL, SQL Developer, Tortoise SVN, PL/SQL, Business Intelligence Development Studio