TECHNICAL SKILLS

• AS
• GretlInformatica Power Center 9.x NoSQL Databases
• MongoDB SQL
• TSQL
• SPARQL PL/SQL
• Python Agile
• Waterfall and RAD LINUX
• HP UNIX and Windows

PROFESSIONAL EXPERIENCE

Confidential

Data Science/Analytics

Responsibilities:

• Pulled data from different sources and prepared it for analysis - addressing data integration issues
• Performed statistical analysis of data to tackle abstract business problems with well-backed solutions
• Translated business objectives into actionable items for analysis and communicated findings clearly to both technical and non-technical audiences
• Researched and performed data experimentation to interpret, analyze results using statistical techniques and generated reports for delivery provide ongoing reports
• Develop and automate BI dashboards and reports using Tableau software and on occasion excel
• Perform analysis of data using Gretl to determine statistical significance of findings
• Identified variables analytics, and interpreted trends or patterns in complex data for forecasting models
• Build and prototype dashboards to provide insights into the operations of a business function.
• Performed ETL development using Confidential - involving data extraction from different sources, cleaning data and addressing data quality issues and loading the data
• Performed data modeling using Erwin for OLTP/OLAP systems - created and maintained star/snowflake schemas.

Confidential, San Diego, CA

Snr. Software Engineer

Responsibilities:

• Developed Oracle SQL scripts and PLSQL functions, procedures and packages
• Performed unit testing / tuning of code / support for QA team testers.
• Address data quality issues and reviewing code - Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into staging area and address data quality issues.
• Implement strategies to improve performance - data partitioning, materialized views, indexing strategies, use explain plan and hints

Confidential

Data Analyst

Responsibilities:

• Performed OLTP data modeling, Dynamic SQL, Records and PL/SQL Tables.
• Created Shell Scripts for invoking SQL scripts and scheduled jobs on Linux Server
• Performed ETL work using home-grown applications
• Created and maintained a star topology DW - also created and supported a materialized views environment

Confidential, Burlington, MA

Data Analyst

• Installed and configured Oracle database on Unix platform - 10g/11g/12c
• Performed ETL development using home grown APPs and data migrations
• Participated in periodic compliance training required by Healthcare / banking industry information handling
• Worked with FDA and private sector drug studies
• Supported SAAS environment for Confidential
• Worked on Confidential projects - supporting data migration efforts/ ETL/ Database Development/Modeling
• ETL tools used - Confidential and SQL Server Integration Services (SSIS)
• Used ERWIN for data modeling of OLTP/OLAP
• Performed data migration across environment and also was a liaison for data exchange

Confidential, McLean, VA

Snr. Data Analyst

Responsibilities:

• Defined corporate standards for data architecture, maintenance and security.
• Worked on SQL / NoSQL DBs, Big Data solutions for streaming structured and unstructured Data.
• Utilized metadata management tools to perform ETL tasks - Confidential
• Analyzed data-related and system integration opportunities to improve the system recommendations
• Worked on data quality / security and compliance issues.
• Held meetings with application stake holders to identify areas of concern - derive a plan and implement steps to address issues
• Used Erwin to design and support OLTP / DW environments
• Participate in review of models / code and participated in deployment efforts

Confidential, Fairfax, VA

GBS IAS - Snr Applications Architect/Modeler

Responsibilities:

• Perform source data profiling to ensure data quality
• Worked on data quality / security and compliance issues.
• Held meetings with application stake holders to identify areas of concern - derive a plan and implement steps to address issues
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Experience with Oracle Supplied Packages
• Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Business Objects.
• Worked with stake holders to define and establish data quality rules and definitions consistent with organizations strategies.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Confidential, Oakton, VA

Lead Oracle Database Admin

Responsibilities:

• Design, develop, install and administer Oracle databases 10g Identified source systems, their connectivity, related tables and fields and ensure data suitability for mapping
• Worked on data quality / security and compliance issues.
• Held meetings with application stake holders to identify areas of concern - derive a plan and implement steps to address issues

Confidential

Information Technology -Data Warehousing Engineer

Responsibilities:

• Installed and configured Oracle / MySQL / MS SQL Server 2000
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application.
• Analyze business/functional requirements to derive logical models
• Analyze data-related and system integration opportunities and challenges and make recommendations
• Building complex entity relationship models - synchronizing models and generating complex SQL/DDL
• Perform data analysis and mapping of source/target databases