jessica claire 9 resumesampleexamplecom 555 4321000 montgomery street san francisco ca 94105 summary 9 years experience expertise analysis design development implementation data warehousing applications using etl bi tools oracle teradata databases windowsunix platforms professional experience phases software development life cycle forte successful project implementations analyzing systems understanding defining requirements development technical designs reviews project planning sound knowledge data data warehouse concepts primary competency oracle teradata sql informatica power center unix shell scripting qlik sense business objects microsoft ssrs ca workload automation strong informatica technical knowledge areas informatica designer components source analyzer warehouse designer mapping designer mapplet designer transformation developer workflow manager workflow monitor expert teradata oracle sql concepts 9 years strong working experience writing largecomplex sql queries expertise creating tables triggers macros views stored procedures functions packages joins hash indexes teradata database worked teradata utilities like bteq fast export fast load multi load export load data tofrom different source systems including flat files experience dimensional data modeling slowly changing dimensions type ii iii ods star snowflake schema modeling fact dimension tables olap oltp systems technically proficient debugging performance tuning existing mappings sql queries analyzing data flow evaluating architecture extensive experience scrum waterfall software development methodologies involved data analysis development implementation data warehouse technical trouble shooting business intelligence data governance application development database performance tuning optimization working experience unix shell scripting knowledgeable python language clear documentation skills working knowledge creating project deliverable documents like functional requirement specifications detailed design document system integration unit test cases results lest cases proactive resultoriented team leader adept mentoring motivating dynamic teams problem solver passion technology skilled grasping big picture conceptualizing implementing solutions partnering closely business leaders stakeholders enabling effective solutions leading high customer satisfaction low operational costs effective communicator excellent relationship interpersonal skills skills informatica 101 91 ca workload automation olik sense jun 2019 msbi ssrs 2008 r2 business objects 65 xir31 oracle 11g 10g teradata 1510 1620 unix shell scripting mks integrity client data quality management data analysis data validation reporting data mining education training anna university chennai india 052010 bachelor science electronics communications engineering experience microsoft corporation sr data engineer charleston sc 022018 current requirement analysis work business team understand requirement dashboard accountable business requirement evaluation analysis determining project scope system design handling build testing activities create data model flexible design expand semantic layer future scope used informatica 101 powercenter extraction loading transformation etl data loading data various data sources like flat files teradata oracle teradata warehouse using teradata parallel transporter multi load fastload odbc connections informatica powercenter performance tuning including collecting statistics analyzing explains determining tables needed statistics increased performance 40 situations performed sql tuning application tuning using various tools like explain plan autotrace development several complex mappings informatica powercenter using variety transformations mapping parameters mapping variables mapplets parameter files mapping designer developed advance sql procedures triggers functions indexes implement business logic teradata written pre post session sql command ddl dml create file lists execute shell scripts examined workflow log files assigning ticket informatica support based error error extensive analysis troubleshooting data queries raised business experience developing unix shell scripts automation etl process created file transfer protocol jobs transfer files vendor location informatica unix server creating complex views teradata usage downstream bi tools adhoc reports assigning prioritizing tasks enforcing project processes policies monitoring project results significant deviations ensuring adherence quality standards processes planning directing coordinating activities various project phases delivering quality artifacts formulating estimates timelines project activities analysis design implementation execution integration test cases configuration environment setup integration testing documentation f changes integrating changes existing operation documents get approval business project deliverables migration etl code database objects development qa production environments maintaining versions mks integrity client performed postproduction support maintenance etl process creation project deliverable documents like functional requirement specifications detailed design document system integration unit test cases results developed various adhoc reports depending custom requirements business two95 international inc sr etl developer alamo ca 012016 012018 team lead development enhancement support abbvie us commercial systems sales marketing data warehouse care model data warehouse realworld data warehouse creation maintenance complex etl process generate incentive compensation extracts using monthly prescription sales data source iqvia symphony specialty pharmacies developed complex teradata sql procedures triggers functions implement incentive compensation business logic teradata development several complex mappings informatica powercenter using variety transformations mapping parameters mapping variables mapplets parameter files mapping designer used teradata utilities tpt update tpt stream multi load fast load odbc connection load data teradata tables using informatica development unix shell scripts preprocessing source files provided data vendor built automated data validation tool teradata unix server saved clients 10000 man hours every month developed elaborate etl process store sales inventory referral claims physician payor data abbvie new product brands care model data warehouse vala provided insights activities business behind new product launches sme onboarding new datasets vendor files care model data warehouse realworld data warehouse data quality management involved business technical requirement analysis coordinates clients design clarifications migration etl code database objects development qa production environments maintaining versions mks integrity client ran workflows daily weekly basis using ca workload automation tool extensive data analysis address data questions business trouble shooting existing etl process implement process performance improvements implementation itil service management managed services jpmorgan chase co etl developer newark nj 072012 012015 team lead enhancement operational support longitudinal patient data mart commercial data warehouse systems namely national level audits regional sales analytics sme onboarding new data vendors data quality management dqm system working customer technical resources address business information application needs development etl processes onboard specialty pharmacy provider data files abbvie data warehouse warell developed unix scripts automate preprocessing multiple specialty pharmacy files involving business technical requirement analysis coordinating business analysts clients translating requirements logical data models physical data models playing major role analysis design implementation etl architecture using informatica 91 responsible estimates given client new requirements migration etl code database objects development qa production environments maintaining versions mks integrity client ran workflows daily weekly basis using ca workload automation tool extensive data analysis address various data questions business trouble shooting existing etl process teradata stored procedure implement process performance improvements automation manual etl process reduce operational costs responsible developing technical specifications business requirements understandings business requirement external source systems perform cleaning standardization generate match case clusters worked system integration testing user application testing etl process changes project 4 project name transact customization client abbott laboratories ipss corp programmer analyst princeton nj 052010 062012 involved business technical requirement analysis report development testing migration version maintenance coordinated onsite technical lead design clarifications worked offshore team understanding complex business requirements communicated technical aspects business team helped team work collectively better output phases played major role driving testing phase bi project involved unit testing system integration testing user acceptance testing uat played key role deployment initial production phases application accomplishments informatica certified power center data integration 9x developer specialist certified teradata v2r6 practitioner level certified domain expert life sciences industry innovation title data integrity framework dif