ATHIRA VIJAYA GOPAL

SR. BUSINESS INTELLIGENCE DEVELOPER

CONTACT

Phone: 714-***-****

Email: adcjlx@r.postjobfree.com

Current Location: Herndon VA 20171

Visa: H1B (Green card I-140 Approved)

KEY SKILLS

Database: MS SQL, Oracle, DB2

Data warehouse: Snowflake, Redshift

ETL: SSIS, Informatica

Reporting: Tableau, Cognos

Storage: Amazon S3

Scripting: Python, PL/SQL

Environment: Amazon EC2, Windows

CERTIFICATION

AWS Certified Cloud Practitioner

Google Analytics Individual Qualification

IBM Certified Designer – COGNOS 10 BI

IBM Certified DB2 professional

EDUCATION

Bachelor of Engineering (Computer

Science) – Jul 2002 to May 2006

Government College of Engineering,

Tirunelveli (Anna University), India

PROFILE

Senior BI developer with 14 + years of experience in data modeling, architecture, optimization and complex querying for driving business intelligence solutions.

EXPERIENCE

Tegna Inc, Mclean VA Feb 2016 – Current

Designed, developed and deployed inhouse pricing data warehouse for Tegna Sales using SSIS, Redshift and MS SQL.

Built advanced pricing platform for all stations to perform future quarter planning and developed high complex analytical reports using historical and forecasted data for sales teams using Tableau.

Developed complex SQL scripts to generate on-demand reports for higher management.

Built data cleansing and matching process using Python and SQL. Worked on loading and retrieval of high-volume data from Amazon S3. Cognizant Technology Solutions (USA and India) Jul 2006 – Feb 2016 Client: Freddie Mac, Mclean VA (Mar 2014 – Feb 2016) Designed and built data mart for Asset classification using SSIS, Informatica, Oracle and PL/SQL

Developed Python scripts for financial data analysis and validation Built analytical dashboards using Cognos BI 10

Client: Discover Financial Services, Fairport NY (Sep 2012 – Mar 2014) Developed a data model for student loans using Informatica and DB2. Migrated all reports from Citi bank to Discover Financial Services Built new analytical reports for student loan processing using Cognos report suite.

Client: Unified Grocers, Los Angeles CA (Mar 2011 – Sept 2012) Designed and built data mart for sales team using SSIS and MS SQL Created complex reports using SSRS for analytical purposes Client: The Northern Trust, Chicago IL (Aug 2007- Mar 2011) Built data workflow and data model for Trade Capture applications Created analytical reports using Crystal reports

Developed complex SQL scripts using DB2 for all user requirements on data analysis.

Client: Healthnet, Chennai India (Jul 2006- Aug 2007) Enhanced the existing data warehouse to include Facts and dimensions for the Medicaid process

Built SQL queries for data analysis and adhoc reporting.

Contact this candidate