We provide IT Staff Augmentation Services!

Analytics Developer Resume

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

Hire Now