accomplishments professional summary jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom certifications expertise etl design development implementation testing solid understanding etl design principles good practical knowledge performing etl design processes using microsoft ssis business intelligence development studio informatica powercenter experience phases development including extraction transformation loading etl data various sources data warehouses data marts using informatica power center repository manager designer server manager workflow manager workflow monitor experience writing sql queries plsql stored procedures functions triggers experience performance tuning various levels source target mapping session system partitioning experience agile oriented software projects experience working reporting tools ssrs microstrategy business objects sas thorough understanding involvement sdlc includes requirement gathering designing implementing warranty support testing experience preparing blueprints hlds llds test cases etc experience unix vb script teradata bteq scripting support troubleshooting data analysis experience working databases like sql server oracle teradata greenplum using tool called jira track progress agile project working knowledge mainframe java python experience hadoop hdfs spark sqoop hive pig participated various successful presales rfp activities contributed various technical forums strong coordination skills involve interaction business users understanding business requirements converting technical specifications used development team working onsite location recognized associates quality data alternative solutions confident accurate decision making resourceful creative problemsolver proven aptitude analyze translate complex customer requirements business problems designimplement innovative custom solutions excellent team management leadership communication interpersonal skills experience healthcare insurance finance domains managed small medium size teams delivered many complex projects successfully good knowledge scheduling tools like autosys control etc skills hadoop pig hive hdfs sqoop spark python etl tools ms sql server integration service 20052008 informatica powercenter 8x9x reporting tools ms ssrs microstrategy business objects 41 sas enterprise guide tools utilities oracle clientstoad etc visual sourcesafe win scp putty svn hp quality center autosys scheduler jira databases ms access ms sql server 20052008 teradata 12 db2 oracle languages tsql teradata bteq scripting unix shell scripting vb script java graphics msvisio 2007 ms powerpoint metadata tool metacenter dag ibm iis workbench sql server business intelligence development studio sql server management studio informatica powercenter client teradata sql assistant microsoft visual studio win sql operating environment msdos windows 982000xp78 windows server 20032008 linux work history senior etl developerhadoop developer burlington coat factory corporation 032015 011 roles responsibilities include gather data analyze design develop troubleshoot implement business intelligence applications using various etl extract transform load tools databases responsible partnering requirements team understand expected functional non functional behavior verify proposed solution design meets requirements gather understand requirements business partners convert low level design technical specifications create unit test plans system test plans regression test plans integrated test plans conduct testing different environments various business intelligence based applications facilitatelead reviews walkthroughs technical specifications program code members technical team prepare estimations schedule business intelligence projects implementation big data project using hadoop working closely vendor team understand behavior source data parse xml files accordingly using hadoop load hive data analytics implementation etl solutions provide support existing active applications manage offshore team analyze share work developers offshore review deliverables provide updates client daily basis agile scrum meeting create proof concepts documentation knowledge transfer tools powercenter 96 business objects 41 sas db2 oracle greenplum big data specific tools pig hive sqoop python secior etldatabase developer 072014 032015 cgi group inc education roles responsibilities include understanding business requirements translate technical requirements data needs design code test debug document programs etl processes evaluate user requirements new modified functionality conveying requirements offshore team conceptualizing design preparing blueprints documentation provide technical assistance business users monitor performance etl processes conducting walkthroughs design architect support community obtain sign collaborating project managers prioritize development activities subsequently handle task allocation available team bandwidth maintaining documents design reviews audit reports etl technical specifications unit test plans migration checklists schedule plans tools sql server ssis vb scripting excel macros secior etl developer metadata admin 092012 072014 roles responsibilities include understanding business requirements translate technical requirements data needs certifications additional information conveying requirement offshore build team get code along unit test cases build team ensuring timely quality delivery conceptualizing design preparing blueprints documentation conducting walkthroughs design architect support community obtaining blessing reporting daily status project scrum standup meeting designing developing testing etl processes collaborating project managers prioritize development activities subsequently handle task allocation available team bandwidth maintaining documents design reviews audit reports etl technical specifications unit test plans migration checklists schedule plans managing 6 member offshore team india playing subject matter expert role metacenter tool working metadata management tool called iis workbench working closely different applicationbusiness teams onboard metacenter tool giving metacenter tools demo trainings business folks coordinating vendor tools informatica powercenter 91 teradata sql server ssis dacabase developer lead 102011 092012 na roles responsibilities include designed proposed solutions meet endtoend data flow requirements coordinated onshore team understand newchanged requirements translated actionable items designing developing testing etl processes using informatica managed team 6 developers helped technicallogical solutions required maintained solution design system design documents conducted peer review design code ensuring proper follow business requirements adhering quality coding standards supported testing team preparing test scenarios test cases setting test data closely coordinated upstream streams ensure issue free development setup reported daily development status project managers stakeholders tracking effort task status tools informatica powercenter 91 teradata unix ssis client healthcare company etosql developer 102009 102011 roles responsibilities included gathered customer requirements business team developed functional requirements designed developed tested ssis packages sql server programming provided solutions etl design involved high level detail level design document worked code debugging validation prepared test cases unit system integration testing supported system integration test cycle analyzing fixing defects along code migration performed data validation code review deployment coordinated cross vendors business users uat provided guidance coaching mentoring entry level trainees tools microsoft sql server 2008 sql server business intelligent studio 2008 unix teradata eto developer 112008 102009 roles responsibilities included participated technical training covering various aspects software development lifecycle various software programming application build unit testing system testing integration testing implementation warranty support documentation bachelor technology 2008 gov model engineering college kochi cusat kerala informatica powercenter 86 unix flat files oracle xml academic qualification qualification years school college address major field study electronics biomedical 66 higher secondary school leaving certificate 20012003 ijmhss kottiyoor kerala state board kottiyoor kannur kerala 670651india science mathematics 74 secondary school leaving certificate ijichss kottiyoor kerala state board kottiyoor 2001 kannur kerala na 36 microstrategy certified project designer microstrategy certified report developer powercenter mapping design powercenter advanced mapping sql server declaration hereby declare information provided correct best knowledge jessica swarnnappallil claire