We provide IT Staff Augmentation Services!

Senior Bi And Etl Developer Resume

Allen, TX

SUMMARY:

  • Worked as Data Warehouse Analyst and Sr. Analyst with BI development & operations experience.
  • Design / Develop / Implement / Manage in Confidential and Confidential Enterprise Solutions EDW applications including SPOTFIRE, POWER BI, Informatica - DATA Loads, SSRS, SSAS, MSBI, .NET and CRM marketing campaign automation from offshore and coordinating with onshore counterparts and responsible for all deliverables.
  • Hands on with various technologies including Data Warehouse, Business Intelligence and CRM tools. Has a proven track record of successfully delivering mission critical projects and applications spanning multiple platforms and technologies with utmost quality and within the delivery timelines
  • As a Data Warehouse Analyst and Sr. Analyst with BI development & operations experience, I am responsible for
  • Setting clear priorities and coordinating for deliverables and dependencies with all the responsible teams.
  • Working with external partners, maintaining key contacts with vendors like Marketo, ROVI,”Red Ventures” Baylor, Texas Health Care, WIPRO & Accenture etc.
  • Excellent T-SQL Programming skills in creating SQL objects like Stored Procedures, Views, Tables, Indexes, Triggers, Rules, SQL Joins, and User functions.
  • Worked on Teradata 13.1 BTEQ scripts to load data in different Database using UNIX scripts and Informatica workflows.
  • Reviewing the design with enterprise architecture team and make sure all the data flows are in align with corporate policies.
  • Capacity planning with onshore management and then hiring and building teams.
  • Setting up the knowledge acquisition and transition process.
  • Frequently Assessing Project Management areas like Risk Mgmt, Scope Mgmt, and Integration etc.
  • Playing the role of Architect / SME / SPOC (Single point of Contact) for service profile, ticketing, marketing campaigns at offshore.
  • Working with Global PMO team and onshore team to get clearance for all my applications.
  • Weekly & Monthly progress of the projects to top mgmt at VDSI & onshore.
  • Involved in many projects as a liaison between technical development team and top level management.
  • Data and Business analyst with huge background and hands on experience with RDBMS (Sql Server, Teradata and Oracle) and SQL scripts and development.
  • Developing SPOTFIRE and POWER -BI Reports by identifying tables (Lookup and Detail), Data Source and Data Source Views, attributes and from Information link.
  • Implemented “Decomposition Trees “concept with markings in SPOTFIRE
  • Worked on SPOTFIRE Dashboard reports, Cross tab, Data table, Mobile reports.
  • Worked on SPOTFIRE mobile reports using KPI’s for day to day business justification
  • Developed SPOTFIRE reports using different visualization with trellis, subsets, Hierarchy filters
  • Designed SPOTFIRE, SSRS and SSAS CUBES reports with Informatica workflows to bring data from
  • Worked On POWER BI -PILOT project Created data modifications with Data Query and created some Dashboard Visualizations in Score Card data.
  • Water fall model for Product Comparison with break down Filter concept. existing databases to the new data warehouse. By performing different kinds of transformations like lookup transformations, merge joins, Derived columns merge join, conditional split, data conversion with multiple data flow tasks.
  • Experience with the full "lifecycle" process of performing detailed analysis, collecting use cases, documenting requirements, and creating design of object-oriented applications. Performing sufficient specification and design up-front resulted in more effective coding, testing, and debugging phases.
  • Hands-on experience in writing and reviewing requirements, architecture documents, test plans, design documents, quality analysis and audits.
  • Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
  • In-depth knowledge of SPOTFIRE, SSAS, SSRS, SSIS, OLAP, BI Suite, Reporting and Analytics, SQL Server, Oracle, SQL Server 2000/2005/2008 RDBMS database development including T-SQL programming.
  • Knowledge in performing data gap analysis in multiple projects using analytical and technical capabilities.
  • Experience in conducting JAD (Joint Application Development), project meetings, reviews, walkthroughs and customer reviews.
  • Developed reports on SPOTFIRE, SSAS & SSRS on SQL Server ( 2000/2005/2008 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture
  • Experience in creating the MDX cubes and dimensions. (SSAS)
  • Experience in logical, physical and dimensional data modeling, data mapping, and data normalization well verse in ERWIN.
  • Hands on experience in handling large data sets.
  • Strong working knowledge in Data Warehousing environment using Star Schema design and Multi-Dimensional model.

PROFESSIONAL EXPERIENCE:

Confidential, Allen, TX

Senior BI and ETL Developer

Environment: Informatica 9.6, Teradata, Spotfire, Sql Server 2012.

Responsibilities:

  • Developing SPOTFIRE Reports by identifying tables (Lookup and Detail), Data Source and Data Source Views, attributes and from Information link.
  • Implemented “Decomposition Trees “concept with markings.
  • Worked On POWER BI Pilot project with Data Query and Dash Board Visualization.
  • Worked on SPOTFIRE Dashboard reports, Cross tab, Data table, Mobile reports.
  • Worked on SPOTFIRE mobile reports using KPI’s for day to day business justification
  • Developed SPOTFIRE reports using different visualization with trellis, subsets, Hierarchy filters.
  • Developed SPOTFIRE reports “BTN Customer Profile” for Frontier 360-degree customer view report using with different text controls and python script with multiple tabs and controls in text area.
  • Deploying and scheduling Mappings and workflows using Informatica to generate all daily, weekly, monthly and quarterly Data loads in to Data warehouse.
  • Developed Unix shell script and Parameter files for Parameter driven and created list files for daily process.
  • Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis
  • Generated Drill down reports, Drill through reports, Parameterized reports.
  • Generated Sub-Reports, Drill down reports, Drill through reports, Parameterized reports, Toggle reports, Chart reports, Gauge reports, Map reports (by territory, by country, by state) using SSRS.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Worked on Adhoc excel Pivot reporting for top level management on day to day analysis

Confidential, Dallas, TX

Senior SQL Server BI Consultant

Environment: SQL-Server, SPOTFIRE 7.6, SSRS and SSAS CUBES

Responsibilities:

  • Generated Sub-Reports, Drill down reports, Drill through reports, Parameterized reports, Toggle reports, Chart reports, Gauge reports, Map reports (by territory, by country, by state) using SSRS.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Created complex stored procedures, triggers, cursors, views, user-defined functions, SQL Server Traces in SQL Server Profiler to collect a variety of information about SQL Server transactions, server performances and Transact-SQL (T-SQL) statements.
  • Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis
  • Worked on Adhoc excel Pivot reporting for top level management on day to day analysis

Confidential

Senior SQL Server BI Lead

Environment: SQL-Server, SSAS SQL 2005/2008/2008 R2/2012/2014, ASP.Net, CUBES

Responsibilities:

  • Created and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
  • Worked on managing ETL process by pulling large volume of data from OLTP to a staging Database using SSIS for data transformation. Set Conditional Splits
  • Generated Sub-Reports, Drill down reports, Drill through reports, Parameterized reports, Toggle reports, Chart reports, Gauge reports, Map reports(by territory, by country, by state) using SSRS.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Created complex stored procedures, triggers, cursors, views, user-defined functions, SQL Server Traces in SQL Server Profiler to collect a variety of information about SQL Server transactions, server performances and Transact-SQL (T-SQL) statements.
  • Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis
  • Excellent T-SQL Programming skills in creating SQL objects like Stored Procedures, Views, Tables, Indexes, Triggers, Rules, SQL Joins, and User functions.
  • To serve as a common source of all applications reducing reconciliation items between applications
  • Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse
  • By performing different kinds of transformations like lookup transformations, merge joins
  • Derived columns merge join, conditional split, data conversion with multiple data flow tasks.
  • Wrote stored procedures to move content for staging database to actual database in all
  • Analyzed source system data to determine the data model and ETL solution that will meet business Requirements.
  • To provide robust auditing of data loading, ensuring accuracy and sox compliancy
  • To provide summary/detailed historical information for business solutions analysis
  • Eliminate redundant processing of source data
  • Elimination of legacy out-dated hardware
  • Reduction of costly mainframe collection processes
  • Increased process efficiencies due to more robust hardware and architecture.

Confidential

SQL Server BI Developer

Environment: SSAS 2005, SSIS 2005, ASP.Net, SSRS, SQL Server 2008/2008R2/2010

Responsibilities:

  • Involve in the Requirement sessions along with the UI team and understanding functionality and to coordinate with developers regarding the BRD and UI and changes done in code and its implications in testing.
  • Data Analysis and Validation
  • Generating the Reports using SQL Server Analysis Services(OLAP Reports)
  • OLAP Reports daily processing and maintenance
  • Scheduled and monitored all maintenance activities of SQL Server 2000 including database consistency check, and index defragmentation
  • Preparation of Requirement Traceability Matrix and mapping of requirements with changes in the UI and to prepare the Test scenarios and Test cases.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQLcode and SQL joins for applications
  • To serve as a common source of all applications reducing reconciliation items between applications
  • Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse
  • By performing different kinds of transformations like lookup transformations, merge joins
  • Derived columns merge join, conditional split, data conversion with multiple data flow tasks.
  • Wrote stored procedures to move content for staging database to actual database in all
  • Involved in peer reviews, in validating the Test Cases and generate the Review Report.
  • Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
  • Functionality Testing and System Integration Testing - which involves various tasks to be undertaken.
  • To Validate the accounts, Check for the number of services or products and various other details of the customer account by the response send by the CIS ( Accounts are the phone numbers of the customer and are the test data for our Testing. We have to validate the account details with respect to the CIS database.
  • Proper prompts are getting played by the application or not, which the customer hears. Prompts are the static VXML which gets executed by the Voice genie and these are the instructions which the customer hears, like - Welcome to Confidential .
  • Involved in bug tracking, to find out at which point the error is coming or exception is getting raised and reporting of that in the Bug Reporting Tool - Scarab.
  • After fixing of Bug to do Retesting of the application and do the regression testing.
  • Test the Changes in the internal architecture of the application and they validate the data as per the changes. Caching of the data was the internal architecture change done in the application for the fast retrieval of the data, to reduce the customer inconvenience for waiting.
  • Misdirects Analysis/Application Tuning - Suppose the call was to reach the billing center but it reached repair center, so we have to do the root cause analysis for that and sort out the reason for the behavior of the application. This is done by recreating the misdirected call and analyzing the logs to check at which point the application failed and what measures can be taken to reduce the misdirects.

Confidential

Senior Software Developer

Environment: VB.NET, SQL Server2000

Responsibilities:

  • Involved in Designing, Coding and Unit testing.
  • Reports Generation using SSRS and Crystal Reports 8.0

Hire Now