SUMMARY:

• 5+ years of IT Experience in Web Applications, Database Design, Development and business intelligence of Microsoft SQL Server 2008(R 2)/2012/2014/2016 in Development, Test and Production Environments with Healthcare business domain.
• Experience in migrating DTS (SSIS) packages and reports projects from SQL server 2008 to SQL server 2012.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance. That increases my ability in Performance Tuning, Query Optimization.
• Experience working on Data Warehousing (DW), Business Intelligence (BI), data migration and/or data conversion projects.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using SQL.
• Knowledge of TSQL and OLTP topics such as Normalization, data types, query tuning, indexing, constraints, and query plan.
• Advanced knowledge of Excel: pivot tables, macros, database connections.
• Familiar with HIPAA Security and Privacy.
• Experience with Excel with VBA.
• Advanced knowledge of Microsoft Excel including the use of Pivot Tables, Lookups, and VBA Macro Functions.
• Understanding of OLAP and Data Warehousing.
• Working knowledge of SSAS.
• Knowledge and skills to create cross tabs, graphics, charts and manipulate result sets and variables to meet business needs.
• Experience with RDBMS.
• Experience with Power Pivot and Power View tools.
• Experience performing data analysis.
• Advanced knowledge of Excel.
• Basic understanding of databases, data mapping, data modeling and strong excel.
• Experience on Tableau & SSRS development, Document analysis, design, test cases, perform unit testing.
• Knowledge on Hadoop and automation tools like AWS.
• Experience with Microsoft Report Builder.
• Experience in creating technical documentation such as system architecture, functional and design documents. Worked in Agile, Scrum environments.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. Experience with Business Objects and Informatica .

TECHNICAL SKILLS:

Web Technologies: HTML5, CSS

JavaScript, Java, PHP, MySQL, T: SQL, C, C++, C#.NET, ASP.NET

IDE s/Tools: Eclipse, NetBeans, Sublime Text, Microsoft Visual Studio latest versions, Microsoft Office Suite, Microsoft Excel, Microsoft Access

Databases: MSSQL, Microsoft SQL Server 2008/2008 (R 2)/2012/2014/2016 , Tableau Reporting, Power BI, Crystal Reports, Report Builder, Trizetto, Facets

Version Control: GitHub, TFS, SVN, Visual Source Safe

Waterfall, Agile: SCRUM

Theoretical Knowledge: Big Data, Hadoop, Hive, MS SharePoint, NHibernate,AWS

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, Arizona

SQL/Tableau Developer

Responsibilities:

• Working for GSGT(Global Servicing Group Technology) Team.
• Working for Big data validation(BDV) project, Involved in Rally and JIRA.
• Validating data in Teradata and Hive.
• Responsible for weekly status reports, updated showing the progress of Manual Testing effort and open issues to be resolved.
• Using automated scripts, validating data between two environments and sharing results with team.
• Gathered Business Requirements, Interacted with Strategic Development Team, Business analyst to analyze business needs and developed technical specifications.
• Evaluated data models to design Tableau solutions by created different KPI using calculated key figures and parameters.
• Created side by side bars, Scatter Plots, Stacked Bars, Radial Charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server.
• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Validating data on table level.
• Interacting with the team and resolving the issues.
• Complete and submit weekly status report to the Project Manager.

Environment: SQL Server 2008/2008(R 2)/2010/2, Hive,Teradata, Rally, JIRA.

Confidential, Phoenix, Arizona

SQL and Tableau Developer

Responsibilities:

• Working for ISRM(Information Security and Risk Management) and CRM(Cloud Risk Management) Team.
• Experience in Tableau Report and Dashboard development, Involved in Agile Methodology.
• Experience in end - to-end Tableau based implementing dashboards & creating reports using various charts.
• Good Knowledge on data base concepts. Hands on Experience on Tableau Architecture and Tableau BI application creation,Data modeling and advanced Reporting experience.
• Experience in Tableau server installation, configuration and administration.
• Created and developed reports & dashboards using Tableau Desktop 10.3 and 10.5.
• Involved in creating data visualizations like Bar charts, cross tab, Tree Maps, Line charts, Scatter plot, Mapping Visualization etc with Tableau desktop 10.3
• Worked on Data Blending and admin activities like creating users and groups, publishing workbooks to server and end users, assigning permissions, subscriptions etc.
• Prepared Unit Test Cases and Test Plans for the Reports Developed.
• Interacted with the users extensively and gathered the business requirements, and analyzed the needs of the end users
• Designed Technical dashboard document using tableau desktop based on the business requirements.
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Published Workbooks by creating user filters so that only appropriate teams can view it.

  Generated tableau dashboards with combination worksheets for clear understanding

• Performance tuning of DB and Tableau Server, data sources, workbooks and extracts.
• Involved in creating and visualizing dashboards using Tableau Desktop.
• Developed interactive dashboards using multiple charts and used actions, parameters, filters.
• Improved Reports performance in tableau by creating extract, empty extract and filters.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Created worksheets and dashboards by using custom queries and multiple tables.
• Created various interactive customized dashboards and stories.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Creating New Schedule's and checking the task's daily on the server.
• Involved in gathering the requirements and analyzing the requirements and interact with the customer to find the proper information.
• Validate the data for each report and review the reports.

Environment: SQL Server 2008/2008(R 2)/2010/2, Tableau Desktop 10.3/10.5, Tableau Server, SharePoint, JIRA.

Confidential, Nashville, TN

SQL and Tableau Developer

Responsibilities:

• Created and managed schema objects such as Tables, Views, Indexes and Referential Integrity depending on user requirements.
• Performed backup/restore of database objects such as Tables, Procedures, Triggers, Constraints, Indexes, user defined functions and views.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Worked on CMSDE Audit project. Experienced in Visual source safe latest version.
• Worked on performance tuning of SSIS packages using error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Monitoring SSIS packages of SQL Agent Jobs success / failure history.
• Transform the data using different components of SQL Server Integration Services.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.
• Created queries for generating drill down reports in SSRS /20122014.
• Responsible for writing technical documentation.
• Accurately provided quality assurance of reporting environments.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Defined best practices for Tableau report development.
• Created users, groups, security roles and SSL authentications.
• Having good ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and parameterized using Tableau.
• Deployed code on to TFS.

Environment: SQL Server 2008/2008(R 2)/2010/2012/2014 , C#, NET, T-SQL, SQL Server Integration Services 2008/2010/2012 , SQL Server Reporting Services 2008/2010/2012 .

Confidential, Norfolk, VA

SQL and BI (ETL) Developer

Responsibilities:

• Removed HTML codes in procedures to SSIS package Script task .
• Created success and failure mail notifications in TIDAL and SSIS packages .
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets to SQL Server using Business Intelligence Development Studio.
• Configured jobs schedule in tidal as per SSIS jobs.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table.
• Upgraded SSIS packages for an entire Application from using Project wizard and successfully deployed packages.
• Experienced in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Experience working with Business Analysts to develop business and technical requirements .
• Used SVN Subversion for source and version control .
• Generated SSRS reports which included various reporting features such as groups, sub-groups, adjacent-groups, group by total, group by sub-totals, grand-totals, drilldowns, drill through, sub-reports, navigation reports .
• Created sub reports, bar chart, matrix reports, Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports for newly created Markets .
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.

Environment: SQL Server 2008/2008(R2)/2010/2012, .NET, C#, T-SQL, SQL Server Integration Services 2010/2012, SQL Server Reporting Services 2010/2012.

Confidential -Kingsville, TX

SQL Developer

Responsibilities:

• Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server 2012 and 2014, and MS Access databases .
• Performance tuning to optimize SQL queries using SQL Profiler and query analyzer .
• Rebuilt Indexes and Tables as part of performance tuning exercise.
• Extract the data from various sources like SQL Server, Text files, and access into Data Warehouse.
• Wrote and maintained stored procedures and functions using T-SQL and SSMS.
• Created SSIS packages to populate data from various data sources.
• Developed various charts and graphs like bar chart side by side, stacked, line graphs, pie -charts etc. by using chart expert of Crystal Reports .
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS .
• Collaborated with fellow team members through Team Foundation Server (TFS) for effective project management, which includes work issues and track on the update of versions.
• Developed user test cases and validated test results during user acceptance testing.

Environment: Microsoft Power BI Power, Crystal Reports, MS SQL Server 2008/2008(R2)/2012, SSIS/SSRS, T-SQL, SharePoint server, DTS Designer, MS Office 2013, TFS.

Confidential

Testing Engineer

Responsibilities:

• SQL strong - write complex queries and test databases.
• ETL - Tool experience on understanding the data flow.
• Write and implement test plans including creating test cases .
• Automate test cases to ensure product functionality, increase efficiency and support white box testing .
• Track, document and verify resolution of defects .
• Assisted in test planning and execution. Created test plan for User Acceptance Testing .
• Involved in Unit testing and involvement in integration, user and performance testing.
• Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a variety of failures.

Environment: SQL Server 2008/2008(R2)/2012,Windows Server 2008.