jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary proactive etl developer 11 years carefully handling transforming data loads suit customer needs versed dominant information modeling designs mapping technologies dedicated flawless etl integrity impeccable data security database maintenance modification tasks skills informatica ofsaa oracle plsql automic scheduling unix scripting experience ca7 obiee terdata mongodb 012021 current lead etl developer allegis group catonsville md designing etl approaches extracting data heterogeneous source systems creating stories relate etl work jira distributing among team based workload developing etl mappings configuring sessions workflows creating ca7 jobs scheduling etl workflows production preparing etl environment creating odbc connections mongodb power exchange connections mainframe systems creating packages snapshots migrate code uat qa prod creating crs servicenow reviewing rtb team following approvals implementation crs preparing run book supporting production failures environment technologies informatica mongodbmainframe unix jfrog artifactory worked business analysts gather define project requirements defined database design specifications based upon project requirements 082018 122020 lead etl ofsaa developer american medical association washington dc developed various informatica mappings workflows load data implemented audit checks data load building table table t2t transformations ofsaa manual file uploads configuring dq rules ofsaa umm scheduling executing jobs creating sql maintain ofsaa configurations validating scd process handle dimensional hierarchies involved analysis data issues upstream downstream applications associated ofsaa datamarts created data quality check key elements ofsaapfs application developed ofsaa t2tf2t pft rules pfs application create multiple ofsaa components like batches process rules hierarchy data transform run performed data model changescustomizations using ca erwin tool cloned environments prepare test cert validations sprint code provided l1 l2 support ofsaa bath failures troubleshooting verifying logs ofsaai implemented table partitioning creating indexes collect stats hints improve performance ofsaa batches extensively worked informatica mappings workflows development load multiple sors data fsdf stg automic database provided technical solutions debugging experience created sr oracle creating model tables views partitions indexes advisednotified mangers team members issues impact new changes moving prod involved unit testing mappings ensure delivering flaw less code sit uat environments fixing defects implementing change requests sit uat phases involved developed creating scheduling jobs workflows automic environment technologies ofsaa informatica automic oracle unix jira project 7 122013 072014 senior bi developer panjiva virtual mt gathering client requirements designed data models frame work manager meet clients report requirements working coordination client team developed various kinds list cross tab chart dashboard report using cognos 84 cognos 10 scheduling reports based clients requirements using ibm cognos connection developed various dashboards mutual funds business banking investments insurance dashboards understanding existing stored procedures migrated existing bo reports various cognos list crosstab chart reports using cognos handling complete datacenter migration environment technologies ibm cognos bi sql server windows 7 sap bo 082008 062014 bi developer jwacity state interacting designers requirement design clarification cocoordinating onsite team terms fulfilling requirements moving reports across environments created pivot table views analyzing data implemented join relationships physical layer bmm layer organized tables presentation layer created new logical columns bmm layer made changes presentation layer well created hierarchies bmm layer education training 042008 bsc computer science sri krishna devaraya university ananthapur india accomplishments created ofsaa icc batches tasks configured different types ofsaa ootb objects like transform data executables tasks using operations framework worked developing gl reconciliation mappings using run rule framework rrf experience fsdf data model customizations using erwin tool uploading data model using data model management sound knowledge fsdf data model gl reconciliation module working ofsaa utilities batch operation data management data quality rrf frameworks experience objects migration using object migration xml utilities cloned environments configured key dimensions load using scd drm loader functions tasks additional information experience troubleshooting batch failures using logs message log tables automic schema config schema tables strong knowledge data warehouse architecture ofsaa internal architecture experienced dimensional modeling data modeling tool erwin knowledge data processing lrm alm modules extensively worked informatica created complex mappings using different transformations created sessions build dependency sessions used different tasks workflows involved performance tuning jobs extensively used informatica client tools source analyzer target designer mapping designer mapplet designer informatica workflow manager informatica workflow monitor optimizing informatica mappings sessions improve performance extensively worked automic scheduling tooluc4 creating jobs scheduling creating workflow per dependency extensively worked oracle 11g teradata creating teradata stored proceduresplsql tuning building complex sqls skilled design logical physical data modeling using erwin data modeling tool expertise obiee 11g12c oracle bi publisher technologies architecture concepts work process architecture concepts ardent analyst flair adapting quickly dynamic business environments resolving complex business issues deft interacting clients understanding current business processes gathering new business user requirements developed modified tested unix shell scripts necessary test plans ensure successful execution data loading process extensively worked various domains like banking risk regulatory sales supply management manufacturing