We provide IT Staff Augmentation Services!

Senior Bi /data Analyst / Report Developer Resume

Richardson, TexaS

SUMMARY:

  • Solid IT experience as a Report developer role also as a Data /Business Analyst in deployment of web - based, Client-Server applications, developing business processes and system used on various projects from conceptualization to implementation.
  • Excellent technical writing skills to create Business Requirements Document (BRD), Functional Specifications Document (FSD), Nonfunctional Requirements Document and Use Cases Specifications.
  • Experienced working with developing reports using BI reporting tools (Tableau,Cognos, SSRS,SAP Business Objects) for clients and upper management level and generating reports based on the business requirements.
  • Worked with database development and designing using Oracle SQL, PL/SQL using TOAD and Microsoft SQL server T-SQL, Teradata, Netezza and MS Access.
  • Strong database integration experience using ETL tools with SSIS, Informatica also analyzing data needs, identifying relational databases and coordinating the data modeling and data warehousing environment.
  • Excellent conceptual and working knowledge of System Development Life Cycle, OO Models and UML Methodologies.
  • Fluent in a broad range of technologies, including business process tools such as MS Project, Excel, Access, PowerPoint and Visio.
  • Monitoring all patch management activities for server and network sides, Build graphs, pivot tables, month-to-month trend analysis, risk analysis.
  • Well versed in Requirements/Change Management, Impact Analysis and Gap Analysis.
  • Interacted with SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
  • Strong Analytical and Problem Solving skills; with proven experience in utilizing people and process knowledge to assist enterprises in making critical decision.
  • Worked in conjunction with testers (QA), CRM,developers and other team members in validation and testing of complex projects and in the maintenance of Quality Standards of projects as a Business Analyst in deployment of web-based, Client-Server applications, developing business processes from conceptualization to implementation), Production support, Troubleshooting, Systems analysis.

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, Texas

Senior BI /Data Analyst / Report developer

  • Worked with PM’s on daily /Weekly meetings to get the client requirements .Also worked with production support with deployment after UAT and End to End testing complete.
  • Worked with Data Analysis / Data Mapping with Pharma reporting projects using different data sources for different clients.
  • Identify Market Intelligence for Leverage able Analysis Development / Data .Also contribute / Assist in the Definition of Data Set Specs / Requirements / Methodologies / Improvements to develop the accurate report.
  • Working with SQL server Management studio 2016, writing complex queries, and stored procedures to pull the data based on the requirements documents.
  • Created SSIS packages to design and build to generate reports using Visual studio.
  • Created a schedule job to automate the report based on customer needs.
  • Worked with Teradata, Oracle SQL, Pl/SQL Scripting / Querying - Write Complex / Highly Optimized Queries across Large Data Volumes.

Confidential, Dallas, Texas

Senior Data Analyst / Tableau Report developer

  • Design / develop and generate Reports - Environmental Situation Analysis in Support of Strategic Planning / Growth / Activities Also Identify Actionable Insights within the Strategic Plan / KPIs / Company Initiatives, etc.
  • Identify Market Intelligence for Leverage able Analysis Development / Data .Also contribute / Assist in the Definition of Data Set Specs / Requirements / Methodologies / Improvements to develop the accurate report.
  • Worked with Tableau BI reporting tool to create dashboard reports also upper level management reports also pulling the data from Oracle /Netezza with writing complex queries to pull the data from backend database server.
  • Interfacing with End-Users to Gather Specs / Requirements and worked with BI tableau Report Development and Analytical Tools. .
  • Worked with SQL (Oracle/SQL Server/Netezza/MS Access) implement report and use ETL tool SSIS to load data from one system to another system in Data Warehouse Environment.
  • Worked with hands-On SQL Scripting / Querying - Write Complex / Highly-Optimized Queries across Large Data Volumes.
  • Managed and maintained Home health and Hospice KPI dashboard on a daily basis.

Confidential, Plano, Texas

Senior Data Analyst / SQL/ Tableau Report developer

  • Working on expert and advanced level of Excel and working with Pivot Table and do complex calculations with Vlookups.
  • Supported and coordinate the build activities and production support (including enhancements to production systems), processes and associated tasks such as requirements, functional specification, testing and other client documentation.
  • Worked with writing and reviewing BRD's - Business Requirement Docs and in reviewing HLD and LLD's - high level and low-level design documents.
  • Interacting with platform and technology owners by receiving data, collecting it, analyzing it and import the data to SQL server and writing complex queries with T-SQL and use the SSIS 2014 for Data integration and SSRS and also Tableau BI tool to generate some of the automated reports.
  • Designed ETL packages dealing with different data sources (SQL SERVER, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL SERVER Integration Services (SSIS).
  • Worked with Tableau BI tool to pull the data and generate the report that clients wanted.
  • Created operational, campaign and/or business reports and worked independently as well as with others in a team.

Confidential, Irving, Texas

Senior Data Analyst / SQL/ Report developer

  • Performed basic BSA tasks within the SDLC process; including but not limited to create, maintain, and execute on delivery of business requirements, functional specifications, and test cases/steps.
  • Supported and coordinate the build activities and production support (including enhancements to production systems),processes and associated tasks such as requirements, functional specification, testing and other client documentation
  • Supported and coordinate System Integration Testing (SIT), User Acceptance Testing, and associated activities such as test plan, test cases and test execution as related to enhancements to a production environment.
  • Processed XML data errors and fix all the defects used to come as an error log.
  • Supported Change Management and Issue Management and had experience consulting with external client contacts, but not necessarily as the lead contact, working in a service organization, including but not limited to client facing project and operational activities.
  • Created operational, campaign and/or business reports and worked independently as well as with others in a team.
  • Analyzed processes and/or issues and do perform trouble-shooting activities and tasks and worked with technical staff to design and implement technical solutions with systems development also participated in integration of new development into an existing technical solution.
  • Worked with BI reporting tools (Cognos, Tableau, SAP Business Object) generating KPI reports for clients and management level.
  • Worked with Test experience on MS Dynamics CRM platform, worked on agile projects using CA Agile Central, prepared estimates, testing strategies for testing projects.
  • Worked with Tableau BI reporting tool to generate report for upper level management.
  • Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart and Design, deployment, and maintenance of various SSRS Reports in SQL SERVER.
  • Created and executed SSIS packages to populate data from the various data sources, created packages for different data loading operations for many applications.
  • Experience working within structured software life cycle and development methodologies (e.g., Agile, RUP, RAD) and Team Foundation servers also The Scrum construction life cycle as well as rapid prototype.
  • Worked with Teradata, Oracle SQL and PL/SQL Also with Natezza to generate some reports for upper management level and worked with production support resolving support tickets using web application/Web services, QA/Testing processes and tools.

Confidential, Plano, Texas

Senior BI Report Analyst/SQL Developer

  • Automated and scheduled the reports based on the customer requirements.
  • Worked with BI reporting tools (Tableau, Cognos ) generating reports for clients by pulling data from oracle using Toad for management level reports.
  • Worked with Data integration, building OLAP cubes, dashboards and reports using SSIS,SSAS and SSRS 2012.
  • Created Business Requirements Document (BRD), Functional Specifications Document (FSD), Nonfunctional Requirements Document and Use Cases Specifications.
  • Worked in conjunction with testers (QA), developers and other team members in validation and testing of complex project scenarios and in the maintenance of Quality Standards of projects.
  • Developing and designed executive management reports, to support the information needs using oracle version 11i SQL, PL/SQL procedures, functions and triggers with toad.
  • Worked on Production support which is related mainly any defects or Change request By changing the existing code or add new code using oracle SQL and PL/SQL resolving the trouble tickets everyday basis.
  • Worked with MS Visual studio and T-SQL in SQL server Management studio.
  • Responsible for DBMS installation, sizing, and building data bases and tables, monitoring, tuning, and performance management of the DB environment, definition with client and day-shift groups.
  • Worked within structured software life cycle and also agile system development lifecycle as well as The Scrum construction life cycle .
  • Worked with Microsoft Team Foundation Server environment using version control, work item tracking, team build and data collection and reporting.

Confidential, Richardson, Texas

Database Developer/Report Analyst

  • Designed and developed new application to automate the process for few internal applications.
  • Responsible Worked with oracle SQL, PL/SQL and MS SQL Server T-SQL writing queries and generating reports *Automated and scheduled the reports based on the customer requirements.
  • Wrote PL/SQL procedure using oracle version 11i based on the business rules on customer needs of very large (multi-terabyte) data environment.
  • Worked with database development for both Online Processing & Batch Processing (OLTP) and OLAP Systems (SSRS, SSIS, SSAS) using SQL Server 2005/2008.
  • Worked with Business Analyst to understand to business rules for the write deliverable.
  • Worked as a front end developer using PHP and HTML and JAVA Script.
  • Worked with Informatica ETL project to perform ETL architecture, solution and mapping and development.
  • Worked with Test-Driven Design (TDD) and Disciplined Agile Delivery (DAD) process which includes The DAD agile life cycle.

Confidential, Forth Worth, Texas

BI Analyst / Report Analyst

  • Created Business Requirements Document (BRD), Functional Specifications Document (FSD), Nonfunctional Requirements Document and Use Cases Specifications.
  • Worked in conjunction with testers (QA), developers and other team members in validation and testing of complex project scenarios and in the maintenance of Quality Standards of projects.
  • Developed and designed executive management reports, to support the information needs using toad, using oracle version 10g and 11i SQL, PL/SQL procedures, functions and triggers with toad.
  • Assisted in developing and implementing policies, processes and procedures for project management and the development organization using Oracle on very large (multi-terabyte) data environment.
  • Worked with Star schema using fact and dimension tables in a data warehouse Environment.
  • Worked in conjunction with testers (QA), developers and other team members in validation and testing of complex project scenarios and in the maintenance of Quality Standards of projects* Worked with Requirement Analysis,, Business and Systems reviews and working sessions to understand the requirements and system design.
  • Worked with building data warehouses, ETL architectures used Informatica tool to extract, transfer and load data on very large (multi-terabyte) databases.
  • Worked with running semi-automated standard daily /weekly/monthly reports using Oracle SQL, SQL Server 2008 T-SQL complex queries, delivering reports via email, project management activities.
  • Used Business objects to support the senior Program Manager by working with report stakeholders and recipients (e.g., labs, fundamental network planning, mobility PMs, engineers, etc.) on an ongoing basis to collect feedback, assess report effectiveness and validate the accuracy and comprehensive reflection of program status.
  • Used SQL Loader to Load millions of records to oracle table and also extracting data from oracle database by writing shell script to generate the management reports from there based on their requirements.
  • Responsible for DBMS installation, sizing, and building data bases and tables, monitoring, tuning, and performance management of the DB environment, definition with client and day-shift groups.

Confidential, Plano, Texas

Data Architect / Reporting Analyst

  • Worked on P&L (Profit and Loss) Daily Status & CR related Defects on daily basis for Care/Telegence billing systems by fixing the code using oracle 10g. SQL, PL/SQL with toad and SQL server in the front end.
  • Created Business Requirements Document (BRD), Functional Specifications Document (FSD), Nonfunctional Requirements Document and Use Cases Specifications.
  • Worked with Requirement Analysis, JAD sessions, Business and Systems reviews and working sessions to understand the requirements and system design.
  • Worked in conjunction with testers (QA), developers and other team members in validation and testing of complex project scenarios and in the maintenance of Quality Standards of projects Used ETL tool Informatica for data manipulation in Oracle tables and schemas by creating Informatica mappings to extract data from source databases to target database.
  • Worked on Change Request for Technical design Document and development based on Functional Requirements Document with Traceability for Confidential &T Agency Model/Network module to Allocate BAN level to CTN level.
  • Worked on Production support which is related mainly any defects or Change request from production by changing the code or add new code using oracle PL/SQL procedures.
  • Responsible to make sure system test has been completed for CRs related defects and also all test cases have been executed and have passed the validations in dev before migration to QA through Kintana process.
  • Developed and designed executive management reports, to support the information needs using toad, Oracle 10g SQL and PL/SQL and T-SQL in SQL server 2005 SSRS/SSIS/SSAS.
  • Supported Senior Program Manager with data from multiple external databases used to create ad hoc reports.
  • Used Business objects to support the senior Program Manager by working with report stakeholders and recipients on an ongoing basis to collect feedback, assess report effectiveness and validate the accuracy and comprehensive reflection of program status.
  • Responsible for DBMS installation, sizing, and building data bases and tables, monitoring, tuning, and performance management of the DB environment, definition with client and day-shift groups.
  • Developed plans for testing, implementing, and validating delivered reports, creating reports according to project specifications, addressing data quality issues with users, vendors and management.
  • Worked with WLNP (Wireless local Number portability) Using Clarify CRM tool to update the cases and sub cases with open Escalation and closed functionality.
  • Generated daily. Weekly, monthly reports based on upper management needs.
  • Created new tables, procedure to insert data into table on a timely manner using SQL server.
  • Used SQL Profiler for monitoring and troubleshooting database activity and performance.
  • Proven tracked record in high-transaction, high-volume, web/e-commerce and/or high-availability (24/7/365) SQL Server environment(s).
  • Worked in physical and logical design of medium-large databases (100GB+).
  • Worked in functional / cross-functional teams.

Confidential, Richardson, Texas

Software Engineer

  • Developed and designed executive management reports, to support the information needs using toad, Oracle 9i SQL and PL/SQL procedures, functions and triggers and packages.
  • Worked in conjunction with testers (QA), developers and other team members in validation and testing of complex project scenarios and in the maintenance of Quality Standards of projects.
  • Created logical and physical Data Flow Diagrams and Entity Relationship Diagrams using tools such as Visio and Erwin.
  • Wrote Oracle SQL queries & MS Access/Excel and Crystal reporting to extract data from Oracle RDBMS. Also worked with creating an internal Web sites using Dream weaver, JSP and HTML.
  • Worked on production support by resolving error messages shows up during phone activations on daily and weekly basis for different partners for Care and Telegence billing systems.
  • Developed, designed a database schema based on a web based application tool, also management reports, to support the information needs using Oracle 9i SQL, PL/SQL.
  • Developed and designed this web based Application tool using CGI/PERL in UNIX (sun Solaris) environment for patch writer/Patch approver to create and approve patches for GPS /CDMA wireless software solution group.
  • Worked with CDMA group with their products to gather required information for designing the database.
  • Wrote Oracle SQL & PL/SQL queries, stored procedures and functions and cursor to extract data from Oracle RDBMS.
  • Applied business analysis processes to the development and creation of reporting requirements.
  • Performed data validation tasks via system and process flow analysis using SQL Query.
  • Created various types of internal Web sites using CGI/PERL, Java Script and HTML. On UNIX server.
  • Deployed web pages to intranet sites for internal customers.

Confidential, Richardson, Texas

Reporting Analyst/Data warehouse designer

  • Established Web based reports using Java servlet, Java script and HTML, XML.
  • Placed web-based reports on MCI Intranet for internal and external customers in production support.
  • Responsible for the design, maintenance, and support of Data Warehouse Systems which includes data warehouse configuration, methodology, design, and modeling
  • Retrieved data from Oracle RDBMS using Oracle 8i by creating query, using PL/SQL statements with logical and physical design on the back end and also used JDBC connection from Java servlets to Oracle database to extract data from Oracle database.
  • Documented requirements and applied business logic to the development and creation of reports.
  • Established, Built and maintained reports and databases used MS Access and Oracle PL/SQL and SQL Server.
  • Developed, designed (logical and Physical) model, maintained, transferred data from Oracle to MS Access and Excel.
  • Performed data validation tasks via system and process flow analysis using SQL Query.
  • Involved in data warehouse project with some data mining by sorting through data to identify patterns and establish relationship and utilizing Data Stage.
  • Created logical and physical Data Flow Diagrams and Entity Relationship Diagrams using tools such as Visio and Erwin. Used database macros and modules to automate process, restructured and analyzed ad hoc reports.
  • Added and updated data and transfer the updated merged data as input to SAP MM module
  • Worked with application developers to design and develop database objects and structures according to project specifications, addressing data quality issues with users, vendors and management.
  • Worked with and within a cross-functional development, QA and production team

Hire Now