jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary 7 years experience bi developer proven track record business intelligence bi data warehouse dwh data analytics related consulting projects proven ability identify business needs develop valuable solutions drive accuracy process efficiency experienced developing implementing documenting monitoring maintaining data warehouse extracts transformations etl process various industries like financial health care retail industry sales marketing inventory management supply chain finance domains delivered bi reporting solutions power bi reporting services ssrs expertise data warehousing architectures including etl design staging transformations deltachange data capture starschemas cubes history loading skilled writing tsql queries dynamicqueries subqueries joins generating stored procedures triggers user defined functions views cursors experience phases software development life cycle sdlc agile methodologies delivered team member team lead independent consultant medium large scale projects skills databusinesssystems tools ms sql server integrationssis analysis servicesssas metl databases sql server 20122016netezza 72 oracle 11g azure development skills tsql dax mdx c education bachelor science information technology 052013 gmr institute technology rajam india experience sr data analystsupport engineer 052020 current honeywell gladstone mo client citi bank irving tx bi reporting tools power bi reporting services services ssrs data quality standards agile methodology programming languages tsql c vb scripting working level2 support engineer data pipelines retail customer applications azure data staging analyzed large amounts data identify trends find patterns signals hidden stories within data developing supporting devops repos code pipelines etls tasks jobs developed standard etl integrations extract communityloanlocation data mainframes system implemented business rules confirm data experience creating managing ssas tabular models creating dimension fact tables responsible data administration tasks maintenance plans performance tuning backup security ms sql server systems primarily involved data migration using sql sql azure azure storage azure data factory ssis powershell integrated custom visuals based business requirements using power bi desktop developed complex sql queries using stored procedures common table expressions ctes temporary table support power bi ssrs reports developed complex calculated measures using data analysis expression language dax embedded power bi reports salesforce portal page also managed access reports data individual users using roles provided continued maintenance development bug fixes existing new power bi reports sr bi data developer 082018 052020 butler technical group opa locka fl led development data mart supply chainmarketing departments along analysis existing data warehouse performance improvements worked phases data warehouse development life cycle gathering requirements implementation testing training support interviewed business users data warehouse business analysts understand troubleshoot existing bottlenecks problem areas developed applications designed processes transformation data management companywide databases developed automated data dictionary enterprise data warehouse using ssrs sql completed thorough analysis issues cube processing query processing identify bottleneck existing facts dimensions designed developed etl packages facilitate incremental load process created aggregates partitions attribute relationships user defined hierarchies goal reduce cube processing time query processing time created stored procedures performed index analysis slow performing ssrs reports bring report rendering time developed enterprise wide cascading reports ssrs used throughout agency monitor performance cube logging nightly etl loads also monitor active users cube created robust highperforming etl mappings using ssis metl migrated existing selfservice reports adhoc reports power bi developed custom calculated measures using dax power bi satisfy business needs assisted users accessing databases troubleshooting malfunctions removing systembased barriers task completion sr etl developer 112016 072018 kairos technologies inc city state client cvs caremark irving tx worked ambitious project develop enterprise wide drug plan record system data warehouse connecting insurance companies drug manufacturers cvs caremark worked business intelligence manager plan bi strategies create bi road map budget plans deliver organizations business intelligence needs assessed impact current business processes users stakeholders developed multiple dashboards analytical reports kpis interactive reports based business requirements using ssrs support executive business needs transferred data various data sourcesbusiness systems including ms excel ms access flat filescosmos etc sql server using ssis implemented query optimization performance tuning slow performing sql queries involved writing complex tsql queries stored procedures perform data transformations support ssrs reports involved creating user security roles reporting services parent level report level supported maintenance data quality services dqs knowledge base development master data services database business data analyst 072013 042016 tata consultancy services city state client sun trust bank us designed implemented aided endtoend data migration project using microsoft ssis assisted creation internal applications marketing customer relations departments including financial reporting tools reports designed ssis packages extract data various data sources excel spreadsheet flat files load data destination databases data analysis reporting performed rigorous business case analyses proposed various process improvements used excel access applications visualizing data functionality led initiative convert excel files used inhouse timeexpense reporting wherein automated process find discrepancies timesheets creating tables views using stored procedures client marks spencer uk improved business direction prioritizing customers implementing changes based collected feedback analyzed open orders backlog sales data provide sales team insights created tables define relations using foreign key primary key relationship involved creating database objects using stored procedures triggers functions views tsql joins using tsql performed normalization database reduce redundancy achieve maximum system performance wrote custom tsql stored procedures triggers improve performance preserve referential integrity provide additional application functionality worked etl developer endtoend implementation operation data warehousing project responsible data integration transformation using ssis formulated documented physical etl process design based business requirements system specifications strong etl design skills created source target mappings transformations lookups aggregations expressions involved scheduling reports creating snapshot reports subscription reports using ssrs