SUMMARY:

• Confidential 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.
• Confidential 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.

CAREER HISTORY

Confidential, Washington, D.C

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, Chattanooga, TN

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

Confidential (Contractor), Charlotte, NC

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

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