SUMMARY

• He is a dynamic Technology professional with more than 7 years of IT experience. His extensive technical background includes performing and maintaining DB applications, Data Analysis, ETL Development, Data modeling and data warehousing. He is a keen researcher with robust resolution pedigree. Confidential . Confidential has expertise in utilizing knowledge of relational database and Business Intelligence models to improve on efficiency and effectiveness of organization’s IT functions.

TECHNICAL SKILLS

Operating Systems: Oracle Linux, Windows Server 2k8 and Server 2k12

Databases: MS SQL Server 2005/2008/2012 , MySQL 5.2, 5.7, Oracle 9i, 10g, 11g, DB2, MS Access.

ETL/Other Tools: SAS Base 9.x, SAS Enterprise Guide, SSIS (Visual Studio), Informatica, Erwin Data Modeler, ER Assistant

Querying Tools: SQL Management Studio 2008/2012, Teradata SQL Assistant, SQL Plus, SQL Developer, Teradata - BTEQ, PL/SQL

Querying language/Programming skills: SQL, PL/SQL, TSQL, Base SAS

Business Intelligence Tools: Tableau 9.1, 9.2, 9.3, 10.1, 10.2, 10.3, Cognos, Excel and PowerPivot, Microsoft Power BI, MicroStrategy Desktop, SSRS

PROFESSIONAL EXPERIENCE

Confidential

Analytics Developer

Responsibilities:

• Worked with our government clients to develop, deploy and maintain analytical and reporting software solutions for inter - agency budget reporting
• Developed specific reports, database objects, ETL scripts, and other analytical tools and supported the migration of data
• Wrote complex queries for report creation that is used as a resource for the Presidential Budget.
• Developed, enhanced, and supported complex SQL queries, and translated end-user requests into technical specifications
• Explained intricate technical processes in non-technical terms, and modernized, maintained, and streamlined reports
• Work with relational databases (MySQL, MS SQL Server, DB2, Oracle); SQL optimization using indexes and query optimization
• Utilize report writing software or Business Intelligence (BI) tools such as Tableau, Pentaho, SAS and Power BI
• Use Microsoft Excel and pivot tables
• Worked with Agency data to create algorithms for generation of Budget Reports per Agency.
• Worked extensively with OMB MAX.GOV site for inter-agency reporting by employing SQL and other analytical tools

Confidential

Data Analyst/ Tableau Developer

Responsibilities:

• Pulled data from Facets and Nasco claims systems to create operational reports for applications
• Curated ad hoc queries, stored procedures, and programming scripts with SQL
• Used SISS for ETL data modeling, data migration, integration, and analysis
• Prepared high level analysis reports with SSRS, Cognos and Excel
• Supported data profiling activities
• Created database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently
• Created action filters, parameters and calculate sets for preparing dashboards and worksheets in Tableau.
• Created Tableau reports and visualizations for monthly inventory analysis
• Supported logical data designs/models by reviewing with Business stewards
• Worked with member eligibility data, demographic data, claims (Medical, Dental, Pharmacy) data, premiums
• Pulled from data warehouse and generating day-to-day reports in support of the Actuarial Finance department for pricing, catastrophic actuarial analysis and other purposes
• Created source to target mapping at the element level including specifications for data integrity, referential integrity in support of the Actuarial Finance Systems

Confidential, Knoxville, TN

Data Analyst

Responsibilities:

• Wrote complex SQL queries using advanced SQL concepts like Aggregate functions
• Performed ad-hoc reporting analysis as well as manipulate complex data on MS SQL server
• Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and also used concepts like Explain, Stats, Cast and volatile tables on SQL server
• Analyzed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports
• Developed several operational reports using SSRS
• Used SQL and PROC SQL (SAS) for ad-hoc report programming and creation of the ad-hoc reports for marketing research data
• Utilized IMPORT and EXPORT features in MS SQL to load data onto the data warehouse
• Created numerous Permanent tables, Volatile tables and Global Temporary tables
• Wrote standard SQL Queries to perform data validation and created excel summary reports (Pivot tables and Charts)
• Ensured that data warehousing design was scalable and maintainable
• Used tableau for visual analytics and dashboard developments

Confidential

Tableau Developer

Responsibilities:

• Used Tableau server as a front-end BI tool and MS SQL Server 2012 as a back end database to design and develop workbooks, dashboards, global filter page, and complex parameters based calculations
• Worked with team of developers, designed, developed and implemented a BI solution for Sales, Product and Customer KPIs
• Created compelling dashboards using tableau dashboard and prepare user stories to deliver actionable insights
• Connected Tableau server to publish dashboard to a central location for portal integration
• Implemented Tableau mobile Dashboard via Tableau mobile application
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T- SQL to provide definition, structure and to maintain data efficiently
• Created action filters, parameters and calculate sets for preparing dashboards and worksheets in Tableau
• Developed Tableau workbooks from numerous data sources using Data Blending
• Developed Tableau visualizations and dashboards using Tableau Desktop