Professional Summary
Jessica Claire Astute Technical Data Architect/Analyst with data-driven and technology-focused approach, specializing in healthcare domain. Expert Sql programmer with end-to-end knowledge about all facets of data architecture. Extensively develop Hive Sql logic to transform data for projects, write shell scripts to automate and schedule Sql batches, load data into Hive warehouse. Extensively code Sqoop scripts for data transfer across Hadoop and all other relational databases. SAS programming, SAS Data integration, SAS data formats, storing and managing data in SAS. Excellent at Excel reports using external data sources, extensively use formulas, Pivot Tables and data slicers. Develop and publish Tableau/QlikView reports, access administration. Expert in complex relational database design, combining data from different sources, querying and working with large tables. Analyze and design new Database objects such as tables, indexes, triggers etc. Coordinate Database development on designing data architecture, create Logical and Physical Data Models using PowerDesigner. ETL Datawarehouse development using tools such as Datastage, Informatica, SSIS & Talend Data studio, model Datawarehouses around schemas such as Star, Snowflake. Executed projects involving Database migration from DB2 to Netezza, large scale data migration projects for SAS based analytics platforms, Datastage version upgrade. Lead big offshore team (around 15 resources) for numerous projects and kept track of performance of every associate. Excellent understanding of data management principles such as joining, aggregation of data, concatenating, sorting/merging. Critical thinking, Multitasking abilities, Analytical skills, Planning and Coordination, Excellent Written Communication skills SKILLS O Data Analysis using data cleansing tools, create data pivots, run Sqls using database clients such as Toad for Oracle/DB2, Dbeaver (Hive), Netezza, Teradata studio. Data Mapping for ETL development and data migration projects. SAS programming, Analytics and Enterprise Guide with experience in Base SAS, Macros, Loading data from external files like CSV, Hadoop (Hive), Oracle, Sql server into SAS metadata environment. Automate SAS projects using SAS data studio. BigData/Hadoop, Extensively use Hadoop utilities Hive, Sqoop, Spark ETL/Data Warehousing, ETL development using tools such as DataStage Designer, Informatica, Talend Data studio. Sql development, Sql scripting, automating long running Hive/Oracle Sqls. WORK HISTORY O TECHNICAL DATA ANALYST/ARCHITECTURAL ENGINEER Deposco | Alpharetta, GA Client: United Healthcare (Minnetonka, MN), Data Architecture design using SAP PowerDesigner. Databases Netezza, DB2, Oracle, Teradata, MS SqlServer. Programming Language, Unix shell & Python scripting, use it extensively for automation. BI & Reporting: Tableau/Business Intelligence program developer. Excellent MS Excel report developer using data slicers & complex formulas. 01/2019 to CURRENT SAS programming, SAS Data integration, SAS data formats, storing and managing data in SAS. Develop Hive Sql logic, write Sqoop scripts for data transfer across Hadoop and all other relational databases. Create and publish Tableau/QlikView reports, administer user level access. Develop complex MS Excel reports using external data sources, extensively use formulas, Pivot Tables and data slicers. Create, document, validate, process, and maintain programs and macros that generate analysis, datasets and tables and graphics for reusability. Improvised data and reports availability across team by automating weekly/monthly SAS projects, resulting in 24/7 execution without manual intervention. Established and head Data operations team to maintain database and file system health check, perform data cleanup. Revised, modularized and updated old code bases to modern development standards, reducing operating costs and improving functionality. - Monitor batch runs followed by QA and communicate to team upon data availability. LEOD ETL DEVELOPER/DATA WAREHOUSE ARCHITECT 06/2016 to 12/2018 Avispa | Denver, CO Client: US Bank Corp (Richfield, MN), Datawarehouse development, Data migration, database migration, BI & reporting platform development. Executed projects involving Database migration from DB2 to Netezza, large scale data migration projects for SAS based analytics platforms, Datastage version upgrade. Extensively used Datastage Designer to develop ETL jobs for extracting, transforming, integrating and loading data from various sources into Data Warehouse, automate jobs using tools such as ControlM, Autosys. Executed other project responsibilities such as QA of developed ETL projects, coordinate with business on UAT, project deployment into production environment. - Lead big offshore team (around 15 resources) for numerous projects and kept track of performance of every associate. Collaborated on all stages of systems development lifecycle from requirement gathering to production releases. PROJECT LEAD Syntel Inc | City, STATE Client: American Express, Phoenix (AZ) 10/2010 to 05/2016 - Developed and established high level data flow diagram, data standards and naming conventions and evaluated consistency and integrity of model and repository. Analyze and design new Database objects such as tables, indexes, triggers etc. Worked with Database administrator on designing data architecture, create Logical and Physical Data Models using PowerDesigner. Trained and Mentored team of developers and discussed issues in order to provide resolution and apply best practices Collaborated on all stages of systems development lifecycle from requirement gathering to production releases. SCOTWARE ENGINEER Capgemini | City, STATE 10/2007 to 10/2010 Consulted for US Insurance firm, Analyze different components of Policy management system and document it. Writing low level design specifications followed by Design/develop transformed modules from MVS to VSE, followed by unit testing and SIT.