jessica claire resumesampleexamplecom 555 4321000 100 montgomery st 10th floor professional summary 8 years experience data warehousing business intelligence emphasis project planning management business requirements analysis application design development testing implementation maintenance clientserver data warehouse seeking challenging career data warehousing business intelligence growth potential technical well functional domains work critical timebound projects apply technological skills knowledge best possible way skills cloud technologies snowflake aws programming languages pl sql python pandas snowsql dashboard elastic search kibana datawarehousing snowflake teradata dbms oracle sql server mysql db2 operating system windows linux os x ides eclipse netbeans servers apache tomcat data integration tool nifi ssis education san francisco bay university fremont ca 122015 master science computer science work history verizon data engineer birmingham al 012022 current expertise developing internal external stages aws s3 well import export capabilities bulk loading external aws s3 internal stage snowflake cloud using copy command used copy list put get commands validating internal stage files writing complex snowsql scripts snowflake cloud data warehouse business analysis reporting used flatten table function produce lateral view variant object array column developed snowflake procedures executing branching looping experience using snowflake clone time travel used snow pipe continuous data ingestion s3 bucket data validations done information schema performed data quality issue analysis using snow sql building analytical warehouses snowflake cloned production data code modifications testing perform troubleshooting analysis resolution critical issues experience aws cloud services ec2 s3 emr rds athena glue abt associates etl developer alexandria va 042018 112019 expertise identifying analyzing business need endusers building project plan translate functional requirements technical task guide execution project served liaison thirdparty vendors business owners technical team proven ability communicating highly technical content nontechnical people prepared etl standards naming conventions wrote etl flow documentation stage ods mart involved design analysis implementation testing support etl processes stage ods mart designed developed informaticas mappings sessions based business user requirements business rules load data diverse sources source flat files oracle tables target tables worked various kinds transformations like expression aggregator stored procedure java lookup filter joiner rank router update strategy developed reusable mapplets transformations used debugger debug mappings gain troubleshooting information data error conditions involved monitoring workflows optimizing load times used change data capture cdc simplify etl data warehouse applications involved writing procedures functions plsql bankers healthcare group sql developer richmond va 012016 032018 participated client business need discussions translating needs technical executions data standpoint translated business requirements bl application designs solutions assisted definition database requirements analyzed existing models reports looking opportunities improve efficiency troubleshoot various performance issues developed highly optimized stored procedures functions database views implement business logic also created clustered nonclustered indexes involved performance monitoring tuning capacity planning tuned slow performance queries looking execution plan used various ssis tasks conditional split multicast fuzzy lookup slowly changing dimension etc data scrubbing including data validation checks staging loading data data warehouse flat files excel xml files responsible implementation data viewers logging error configurations error handling packages involved complete life cycle creating ssis packages building deploying executing packages environments development production designed deployed maintained complex canned reports using sql server 2008 reporting services ssrs created reports retrieve data using stored procedures accept parameters customized reports adding filters calculations prompts summaries functions created parameterized queries generated tabular reports subreports cross tabs drill reports using expressions functions charts maps sorting data defining data sources subtotals reports cognizant technology solutions etl tester new city ny 102010082014 worked team 14 system tested dmcs 2 application worked hp quality center qcapplication life cycle management alm testing technology test system actively participated phases testing life cycle including document reviews project status meetings participated daily scrum meetings weekly project planning status sessions involved creating test cases carefully reviewing functional business specification documents used rational manager rational clear quest writing test cases logging defects performed functional regression system integration end end testing extensively used sql inner joins outer joins subqueries data validations based business requirements performed file detail level validation also tested data flown source target involved testing pervasive mappings using pervasive designer tested standard adhoc sql server reports compared results database writing sql queries tested 3 websites borrower website partner website fsa website performed positive negative testing