Bi Arch/developer/team Lead Resume
Houston, TX
CAREER SUMMARY
- Over 19+ years of IT experience as BI Lead/Analyst, Architect, software analysis, design and development. Work hands on as database Architect and Bi development and at teh same time keep users request a top priority.
- Experience of multiple years in Requirement gathering and driving discussion wif business and IT Teams. Documenting teh requirements and able to translate into technical terms.
- Experience in being a BI Lead Tableau, QlikView, Domo, OBIEE, software analysis, design and development. Analyze new tools and recommend new tools to teh management.
- Have experience as technical lead/manager in various projects. Helped clients evaluate and recommended various BI tools and admin tools. Teh tasks were done and achieved on time and deadlines were met.
- Always try to keep up wif latest trend and upgrade myself wif teh new technologies and implement where ever possible to make teh users life easier and bring value to teh organization.
- Experience in creating Estimates for a project. Have experience in On Shore and Off Shore model.
- Experience as Cognos architect, involving Installation, configure, design DataMart, set up security, Create FM Models, Setup ETL Jobs, Automate ETL Jobs, Reporting and PowerPlay Cubes.
- Experience in Business knowledge in Finance General Ledger, Procurement and supply chain.
- Area of expertise encompasses Database designing, ETL phases of Data Warehousing.
- Created Business User type reports and Dashboard using Cognos 10. Optimized teh reports and teh dashboard.
- Experience Project Management and process orientation.
- Experience wif Data Modelling and data management.
- Extensive experience wif administration & maintenance of Cognos Tools Area of expertise encompasses Database designing, ETL phases of Data Warehousing.
- Experience in upgrade and migrate from Cognos 10.2.2 to Cognos Analytics and also on previous versions.
- Experienced wif working wif users, collecting information and requirement from users, Analyzing, plan and design data warehouse and create Reports.
- Involved in connecting to corporate database, to setting up effective catalogs, joins, folders, filters, ensuring that adequate security procedures.
- Working knowledge of teh Star Schema and Snow Flake Schema Design strategies.
TECHNICAL SKILLS
LANGUAGES: SQL*plus, VisualBasic5, 6, JAVA, Python, Red Hat, Ubuntu, SUSE Linux, Centos.
ETL: Cognos Decision Stream, PL/SQL, Cognos Data Manager, SSIS, SLT, Informatica Power Center, Datastage.
BI TOOLS: Cognos Analytics 11.7, Cognos 10.2.2, 8.4,8.3,8.1, Cognos Express, Reportnet, Query Studio, Report Studio, Event Studio, Analysis Studio, Cognos TM1, Framework manager, Datamanager, SPSS, Cognos Impromptu 7.0/6.0, Cognos Transformer6.5/7.6, Cognos Powerplay 6.5/7.6, Cognos Decision Stream, Impromptu Web Reports (IWR), Cognos ICM, Cognos Metrics Manager 2.0, Cognos ReportNet, Business Objects, Crystal Reports, TIBCO Spotfire 6.5.1, Qlikview, Tableau, DOMO,SAS, OBIEE.
DATABASES: Oracle 9i/8i/8/7.x, MS Access, SQL server, Netezza, Teradata, DB2
GUI/TOOLS: Toad, DB Artisan, ERWIN, Aginity, SQL*Plus, Excel, Golden32 and PLSQL Developer.
PROFESSIONAL EXPERIENCE
BI Arch/Developer/Team Lead
Confidential, Houston, TX
Responsibilities:
- Teh off - Shore team consists of 2 Informatica ETL developers and 3 Tableau/Cognos developers.
- Created reports for Service, Procurement and Finance Department.
- Managing multiple projects. Involved in engaging users into project requirement and testing process. Track every step of teh project plan. Lead a team of 5 developers through each step of ETL process as well as report development in Cognos. Involved in Troubleshooting Database Issues.
- Translate Requirement document to technical document, Map Source and target data base on Spreadsheet.
- Design Data warehouse as per teh requirement for users reporting purpose. Conceptualize Database dimensions and fact tables. And tan create Logical and Physical Model.
- Installed Tableau as a single node on a Servers.
- Created Rich dashboards usingTableauDashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
- Responsible for interaction wif business stakeholders, gathering requirements and managing teh delivery. Analysis, Development and Customization of teh Application and implementing requirements for teh project.
- Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks fromTableauDesktop toTableauservers.
- Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thruTableaudesktop.
- Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQLDeveloper.
- Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports usingTableauDesktop.
- CreatedTableauscorecards, dashboards, Heat maps using show me functionality.
- Created complex data views manually using multiple measures also used sort, Filter, group, Create Set functionality.
- Published Reports, workbooks & data source to server and exporting teh reports in different FormatsUsed URLs,Hyperlinks, Filters for developing Complex dashboards.
- Worked creating Aggregations, calculated Fields, Table calculations, window function, Totals, percentages using Key Performance Measures (KPI) and Measure.
- Generate KPI for customer satisfaction survey results.
- Maintained Test log and Wrote Test Evaluation, Summary Reports.
- Extensively involved in doing user acceptance testing (UAT).
- Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
- Generated teh test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
- Analyzed user and business requirements attended periodic meetings for changes in teh application requirements and documents.
- Performed Parallel Testing or Production Testing, which ensures that teh new system will perform correctly in a production environment and interface correctly wif other production systems.
- Participated in teh User Acceptance Warranty Testing. Involved in doing security and negative testing of teh application.
- Migrated From Cognos 10.2.2 to Cognos Analytics 11.7.
- Involved in Migrating Oracle Discoverer reports into IBM Cognos.
- Migrate Cognos Reports to Tableau. Remodeled Cognos Model In SAP HANA. Move data into SAP HANA database using SLT and BODS.
- Day to day activity involves Engaging users, taking requirements, translate into technical Documents, Documenting teh requirements, Provide Status to teh Director, take part in ETL development issues and troubleshoot them, assign work to teh developers, engage various technical teams and managers to get issues resolved. Maintain Design Documents on SharePoint.
- Get user Acceptance after getting users to go through various scenarios. Train users On Cognos Tools and also provide Training Document.
Environment: Tableau 10.X, Cognos Analytics 11.7, Cognos 10.2.2, Oracle 11g, EBS, AWS, Framework Manager, SAP HANA, Oracle Discoverer, SAS, Informatica, BODS, SLT,SQL developer.
BI Architect/ ETL Tech Lead
Confidential, Austin, TX
Responsibilities:
- While Migrating Upgrade Data Stage to 11.3.
- Analyzed teh system wif 22 different data warehouse and database source system into one data warehouse GPCR.
- Install Tableau 9 Server and Desktop. Connect to various databases.
- Adhere to TFS standard and IFRS Standards for financial reporting..
- Converted about 1300+ etl jobs and around 100 reports and setup database for ad-hoc reporting.
- Put up strategy to develop and test teh ETL in Phases.
- Assign teh Etl developers specific Jobs to develop and assigned cognos developer to develop reports on teh Target tables.
- Track work every day and achieved teh target on time.
- Move reports to productions after getting user to test and approve teh data on teh report.
- Analyzed current environment and setup teh team and teh process for Migrating 196 reports for teh Lift and shift project. Migrating from Teradata to Oracle 12 data source.
- Perform ETL work in Informatica Power center.
- For Carrier and Engineering project, I have analyzed teh system and teh database and designed a datamart. Using Complex sql queries Extracts to build reports in Tableau, which will support teh Bi reporting.
- Helping Client to migrate from Cognos to Tableau.
- Create and maintain Framework Models. Implement Best Practices in Metadata Design.
- Meeting wif Users to determine teh needs and requirements for reports.
- Analyze teh database/sources and based on teh analysis implement teh etl and setup teh Metadata designs. Created reports and dashboard in Cognos.
- Get teh directors Acceptance on teh Reports.
Environment: Teradata, SQL Server, OBIEE, IBM Cognos Framework Manager 10.2, Tableau 9.0
Solution Architect
Confidential, Irving, TX
Responsibilities:
- Worked wif data Modeler to design teh data source for reporting purpose.
- Installed Tableau 9.
- Created datamart in Netezza Appliance and used available Staging tables to implement Daily Reports.
- Architected performance dashboard and Reports for Collection Center.
- These reports are bursted to teh respective Managers.
- Implementing Best Practices on Tableau Extracts for data source and Worksheet.
- Created dashboard in Tableau.
- In process of reporting based off TM1 cubes in Cognos BI.
- Fine tuning Netezza SQL for reporting purpose.
- Created reports in Qlikview, Worked on teh backend for teh data source to Qlikview.
- Get user acceptance in Test as well as in Production Environment.
- Get user acceptance at teh end from teh users and stake holders.
Environment: Tableau 9, Qlikview, Netezza, Aginity, SQL Server 2008 R2, TM1 10.2, IBM Cognos Mobile, Motio, SSIS and SSRS.
BI solution Architect
Confidential, Irving, TX
Responsibilities:
- Work wif teh line of business to define teh business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting.
- Worked in multiple phases of Software Life Cycle starting from teh requirement analysis to production and post production support.
- Prepared Dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies inTableau.
- Used advanced chart visualization inTableauusing teh Show Me button. Acquainted wif Donut chart, box plots, tree maps, heat maps, dual axis, bullet graphs and assist business users in solving complex problems.
- Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
- DistributedTableaureports using techniques like Packaged Workbooks, PDF to different user community.
- UtilizedTableauserver to publish and share teh reports wif teh business users.
- PerformedTableauAdmin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in theTableauServer.
- Worked extensively wif teh major functionality of ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports.
- Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for teh weekly and monthly dashboard reports onTableauServer.
- Blended data from multiple databases into one report by selecting primary keys from each database for data validation..
Environment: Tableau, SSIS, Oracle 11i, SQL Server 2012.
BI Architect/Lead
Confidential, Dallas, TX
Responsibilities:
- This is a consulting firm which caters to Oil Companies, teh clients are spread across NM, OK and TX.
- Created reports for Procurement and Finance department.
- Did install Tableau, at more TEMPthan 12 clients.
- Analyzed teh requirement and create reports in Tableau and day to day support to various client for creating and maintaining reports and their Servers.
- Involved in gathering, analyzing, documenting business requirements, and functional requirements and data specifications for Reporting.
- Created highly interactive dashboards using Tableau Desktop.
- Publishing to tableau server and Scheduling dashboards using Tableau server.
- Created Parameters to achieve desired functionality in tableau.
- Implemented Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyses data in different perspectives.
- Created conditional filters and Action links to filter teh data on dashboard.
- Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot).
- Developed different Dashboards/Reports wif different views (Calculation, Detailed, Pivot, Charts, and Filters) and different intuitive drilldowns, drill-across and drillable charts.
- Actively participate in review meetings wif Project Manager to ensure that teh development of projects meet business and system requirements for design development testing and production rollover of reporting and analysis projects wifin Tableau Desktop.
- Created Heat Map showing current service subscribers by color that were broken into regions allowing business to understand market penetration.
- Designed views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
- Build dashboard using parameters sets groups and calculations.
- Involved in creating a dual axis bar chart wif multiple measures.
- Generated report schedules on Tableau server.
- Blended data from multiple databases into one report by selecting primary keys from each Database for data validation.
- Created actions parameters Filter Local Global and calculated sets for preparing dashboards and worksheets using Tableau Desktop.
- Identified teh factors involving teh performance of teh reports and coordinated in creation of indexes statistics to improve teh query turnaround time efficiently.
- Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
- Worked on creation of user's groups projects workbooks and teh appropriate permission sets for Tableau server logons and security checks.
- Worked as Tableau architect in standardizing Tableau for enterprise wide deployment.
- Extensively used TABADMIN and TABCMD commands in creating backups and restoring backups of Tableau repository.
- Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand teh data on teh fly wif teh usage of quick filters for on demand needed information.
- Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that teh views and dashboards were displaying teh changed data accurately.
- Wrote and modified various Stored Procedures used in teh application using T-SQL.
- Schedule and maintain packages by daily weekly and monthly in SQL Server Agent.
- Perform quality assurance checks and update databases to ensure data integrity.
- Trained end users on adoption of new reports.
- Mentored new team members.
- Performance optimization of teh data warehouse by identifying and assisting in correcting EDW/BI performance bottlenecks and debug database applications.
Environment: IBM Cognos 10.2, SPSS, Tableau Desktop 8.3/9.x, Tableau Servers 8.3/9.x, Tableau Repository, T-SQL, SQL Server, Agile, SQL Server 2008 R2, Report Studio, Query Studio, SSRS, Capitalized ERP System.
BI Lead
Confidential, Las Colinas, TX
Responsibilities:
- Managing overall operations across reporting team and work as individual contributor.
- Designed, developed, and managed reporting and Tableau Business Intelligence solutions to meet teh business needs.
- Worked Closely wif Clients and Business Users to analyze and understand business requirements and Participated in requirements gathering meetings / Sessions.
- Used Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
- Used Sheet filters to produce multiple chart types in a single view.
- Used calculated fields extensively for different logics for Trend, Extended price calculations for teh different cost types.
- Defined relationships, created actions, filters, parameters, data blending, hierarchies, calculated fields, sorting, groupings, live connections, in-memory in both tableau and excel.
- Convert business requirements into story-telling is by developing views and dashboards in Tableau Desktop and publish them to Tableau Server.
- Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
- Developed several worksheets filled wif Bar, Line, Pie, Maps Charts and Highlight Tables for rich visualizations and analyzing of teh data.
- Projected and forecasted future growth in terms of number of subscribers based on upgrading to new plans by developing Area Maps to show details on which states were upgraded teh most using Forecasting functionality.
- Converted charts into Crosstabs for further underlying data analysis in MS Excel.
- Found efficient ways to make tables and graphs which were visually easy to understand and at teh same time maintaining teh accuracy of teh core information content.
- Usage of Tableau Desktop for blending databases and creating different interactive views and dashboards.
- Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that teh views and dashboards were displaying teh changed data accurately.
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
- Created visualization for logistics calculation and department spend analysis.
- Performed Parallel Testing or Production Testing, which ensures that teh new system will perform correctly in a production environment and interface correctly wif other production systems.
- Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand teh data on teh fly wif teh usage of quick filters for on demand needed information.
- Involved in Tableau Administration Tool for configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating wif other platform like web portals.
Environment:TableauDesktop 8.0,TableauServer/Administrator 8.0, SQL developer, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office.
BI Lead
Confidential, Plano, TX
Responsibilities:
- Created rich dashboards usingTableauDesktop and prepared user stories to create compelling dashboards to deliver actionable insights.
- Responsible for interaction wif business stake holders, gathering requirements and managing teh delivery.
- Analysis, Development and Customization of teh application and implementing requirements for teh project.
- Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks fromTableauDesktop toTableauservers.
- Managed data extracts, established required joins on tables and applied data filters along wif custom SQL Queries.
- Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports usingTableauDesktop.
- Developed Mockup Dashboards and given demos to teh users allowing them to visualize teh final Dashboards and suggest any changes they may require.
- CreatedTableauscorecards, dashboards, Heat maps using show me functionality complex data views manually using multiple measures fine Tuning teh Dashboards while adding new data items also used sort, Filter, group, Created Sets.
- Worked creating Aggregations, calculated Fields, LOD & Table calculations, window function, Totals, percentages using Key Performance Measures (KPI) and Measure.
- Published Dashboards, workbooks & data source to server.
- Used URL's, Hyperlinks, Filters for developing Complex dashboards.
- Creating Projects, Sites, Site Users.
- Used Extract and Live connections of data to develop reports wif efficiency.
- Scheduled reports and ensured users were informed wif each dashboard refresh.
Environment: TableauDesktop,Tableauserver 8, Oracle 11, Cognos 8.4.1, Cognos10.1.1, Cognos Express, Cognos FM, Datastage, SSIS, Daptiv, Quality Center..