We provide IT Staff Augmentation Services!

Senior Sql/bi Analyst Resume

Redmond, WA

SUMMARY:

  • Big Data/SQL Consultant with full scale BI Software Development and Test lifecycle experience, including data warehouse project design, testing and implementation using Confidential Cloud Services ADLS (Azure Data Lake Store), ADLA (Azure Data Analytics) built on Hadoop framework and ADF (Azure Data Factory) SQL Server 2008/2008R2/2012 in a high transaction and multi - server production environment
  • Hands-on technology professional accustomed to working in complex, project-based environments. Multifaceted experience in Testing, Development, Reporting and Data Analysis on multiple BI tools and Databases, participated in number of Alpha/Beta and user-acceptance testing
  • Proficient in using T-SQL for testing complex solutions, hands-on over U-SQL scripting for manipulating data on Confidential Cloud Services tools ADLS, ADLA and ADF
  • Scrum Master to facilitate the communication between Product Owner's and other Scrum team members as well as ensuring sprints were accomplished in a timely manner
  • Strong technical expertise implementing various test phases, ranging from Experience in ETL Testing, Database Testing, Sanity Testing, Integration testing, Functional testing, System testing to Regression testing
  • Managed Defect Triage meetings effectively implemented Confidential ’s (root cause analysis of defects) keeping all the stake holders in sync
  • Multifaceted and result driven professional with 9+ years of experience in software Industry
  • Adaptability evidenced by experience in diverse industrial domains - Semi Conductor Industry, BFSI and Telecom OSS/BSS
  • Strong technical expertise implementing various projects, ranging experience on complete Confidential SQL Server Tools SSIS, SSRS, SSAS and Power BI
  • Worked on both SSAS Multi Dimensional Data Mining & Tabular Model modules, used MDX queries while reporting data from Multi Dimensional Model, comfortable working on DAX queries
  • Having exposure on Cosmos DB ( Confidential 's Document database) and hands-on over Scope scripting language
  • Knowledge on other DWH tool's Informatica and Tableau
  • Knowledge Big data tools like Hadoop, Spark

KEY AREAS OF KNOWLEDGE AND EXPERIENCE ENCOMPASS:

  • Good in understanding DW/ETL architecture and business processes
  • Well versed with Normalization/De-Normalization techniques for optimum performance in relational and dimensional database environments
  • Working experience in testing ETL-Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, Data Marts and OLAP-Online Analytical Processing
  • Executed all levels of ETL checks (Data Completeness, Data Correctness, Data Integrity and Data Load Options)
  • Proficient in using T-SQL, U-SQL for testing complex Stored Procedures, Triggers, Tables, Materialized Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing
  • Excellent in High Level Design of Packages for integrating/transforming unstructured data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations

TECHNICAL SKILLS:

Operating Systems: Windows family, UNIX, Sun Solaris, HP

Languages: T-SQL, PL/SQL, U-SQL

Databases & Tools: Confidential Cloud Services (ADLS & Cosmos), SQL Server 2008, 2008 R2 & 2012, Query Analyzer, Profiler, Performance, Monitor, Database Tuning Wizard, SQL Server Agent, TOAD, Oracle 10g

BI Tools: Confidential BI tools (Azure Data Factory, SSIS, SSRS, SSAS, PowerBI), Cognos, Tableau 8.0, Abinitio

Test Tools: Load Runner, Load UI, Quality Center 10.0, Jira

PROFESSIONAL EXPERIENCE:

Confidential

Senior SQL/BI Analyst, Redmond, WA

Responsibilities:

  • Manage the design, test the build and end to end execution of marketing campaigns and components for Cloud and Enterprise Integrated Marketing
  • Created Test Plan/Strategy, Test Summary Reports and Test Metrics, handled defect triage meetings
  • Verified Data quality and validity & ensured data is integrated properly
  • Worked in stringent time lines and achieved project deadlines successfully
  • Work with customers to understand the campaign requirements and build the pipelines and verified final data sets
  • Analyzed and processed data sets using advanced querying, visualization and analytics tools
  • Validated and verified batch processing of structured and unstructured data using Confidential Big data platform (Cosmos & ADLA) build over Hadoop framework.
  • Work with downstream IRIS customers to understand the campaign requirements to build and test the data pipelines
  • Assess marketing campaign performance through IRIS platform and provide recommendations to the marketing team
  • Worked on synchronizing and reconciliation of data from downstream IRIS
  • Audit data with various aspects to capture business KPI’s to later analyze campaign performance and outcome

Environment: Cosmos, Scope Script, ADLS, ADLA, ADF, MS Visual StudioTeam Foundation Server

Confidential

Senior SQL/BI Analyst, Malta, New York

Responsibilities:

  • Participation in project Kickoff meetings
  • Involved in the requirement kickoff meetings, gathered and understood project requirements
  • Handled sprints as scrum master
  • Managed defect triage meetings-built sync-up between all stake holders
  • Studied the design of the database models and the data warehouse architecture
  • Created the Test Plan, developed Test Cases for ETL and Report testing
  • Executed all levels of ETL checks (Data Completeness, Data Correctness, Data Integrity and Data
  • Load Options)
  • Developed SQL scripts to validate ETL mapping and downstream application Reports data analysis
  • Create ETL test data for all ETL mapping rules to test the functionality of the jobs
  • Validated ETL-Transformation, Data Cleansing, Lookups, Business Rules testing
  • Executed Reports data and all the components (Data, Attributes, Report Calculations, Filtering, Sorting, Grouping etc.…)
  • Reported defects in Test Link bug tracking tool
  • Reviewed and updated test cases created by other team members
  • Working closely with developers in resolving defects

Environment: MS SQL Server 2008 R2, Integration Services (SSIS), Reporting Services (SSRS), T-SQL, SQL Server Query Analyzer, MS Visual Studio, Window Server 2008.

Confidential

Senior SQL/BI Analyst, Malta, New York

Responsibilities:

  • Worked with Business Analysts to understand the business and dataflow
  • Created complex stored procedures, triggers, cursors, tables and other SQL joins for applications by using T-SQL in SQL Server 2008 R2
  • Created and managed schema objects such as tables, views, indexes and referential integrity depending on user requirements and converting them into technical specifications
  • Design and test ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
  • Transformation of data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS)
  • Created SSIS packages to extract historical information from the Flat Files like CSV and load them onto the SQL Server Database
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse
  • Responsible for creating DTS (SSIS) packages in T-SQL, scheduling packages in SQL Server 2008 database Improve data load performance by analyzing database design, database modeling, query plans and database settings Also, created DTS packages to generate monthly enrollment and billing files
  • Created SSIS packages and used Analysis Services processing task to update the cube with current data
  • Tested developed triggers, packages, procedures and functions using PL/SQL
  • Involved in analyzing, designing, building, and testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX
  • Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, data mining models, tested developed reports using MDX and SQL
  • Designed dimensional modeling using SSAS packages for end-user; created hierarchies in dimensional modeling
  • Involved in test case execution, functionality testing and bug reporting
  • Designed and deployed various SSRS reports with ad-hoc features in SQL Server 2008
  • Created various ad-hoc SQL queries for customer reports, executive management reports, parameterized reports, report snapshots, linked reports and report types like tables, matrix, sub reports etc
  • Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SSRS
  • Experience in generating on-demand and scheduled reports for business analysis or management decision using SSRS

Environment: MS SQL Server 2008, SSIS,SSRS, SSAS, Business Intelligence Studio, SQL Profiler, Confidential Visio, JavaScript, HTML,MS Office 2007, Excel 2007, .NET Framework, Windows NT/2003.

Confidential

BI Engineer, San Diego, California

Responsibilities:

  • Worked with Enterprise/ Regulatory reporting, responsible for testing build Reports for Retention/NCC and ADHOC reports as per request
  • Created and tested ETL packages with different data sources (SQL Server, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations using SSAS/ SSIS /DTS packages
  • Developed SSIS packages using various transformations such as Conditional Splits, Fuzzy Look Ups, Aggregations, and Multicasting
  • Created subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis
  • Created Stored Procedures to validate the data coming with different data discrepancies using data conversions
  • Generated SSRS Enterprise reports from SQL Server Database (OLTP) and SQL Server and included various reporting features such as groups, sub-groups, adjacent-groups, group by total, group by sub-totals, grand-totals, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
  • Created different Parameterized Reports (SSRS 2008/2008 R2) like standard parameter reports, cascading parameter reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required
  • Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters)
  • Created Linked reports, Ad-hoc reports and etc. Based on the requirement Linked reports are created in the Report Server to reduce the repetition the reports.
  • Participation in project Kickoff meetings
  • Requirements study and preparation of understanding documents
  • Coordination with Business analysts in requirements study and preparation of end to end Business scenarios and Test data
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica jobs
  • Developed SQL scripts to validate ETL mapping and Reports data analysis
  • Executed all levels of ETL checks (Data Completeness, Data Correctness, Data Integrity, and Data Load Options)
  • Validated ETL- Transformation, Data Cleansing, Lookups, Business Rules testing
  • Executed Reports data and all the components (Data, Attributes, Report Calculations, Filtering, Sorting, Grouping etc…)
  • Knowledge transfer to Team
  • Data Validity & Integrity, Check Constraints, Field size validations during DB testing
  • Performed tests on backup databases and recovery
  • Identified all bugs present in database and coordinated with developers and resolved all issues
  • Coordination with various teams (Development/Quality/IT/CM)
  • Conducting daily team meetings and Defect meetings
  • Defect Tracking
  • Preparation of Test Status report

Environment: SQL Server 2008, SSAS,SSRS, SSIS, T-SQL, PL/SQL, Oracle,MS Access, Excel, IIS, Visual Source Safe, Share point Server, Cold Fusion, Net Frame Work, ADO.Net, VB.Net, ASP.Net, XML Parsing, VB6, VB Script, Java Script and C#, SSAS,SSRS, SSIS, MDX Cubes.

Confidential

SQL/BI Data Engineer, San Diego, California

Responsibilities:

  • Participation in project Kickoff meetings
  • Requirements study and preparation of understanding documents
  • Coordination with Business analysts in requirements study and preparation of end to end Business scenarios and Test data
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica jobs
  • Developed SQL scripts to validate ETL mapping and Reports data analysis
  • Executed all levels of ETL checks (Data Completeness, Data Correctness, Data Integrity, and Data Load Options).
  • Validated ETL- Transformation, Data Cleansing, Lookups, Business Rules testing
  • Executed Reports data and all the components (Data, Attributes, Report Calculations, Filtering, Sorting, Grouping etc…)
  • Knowledge transfer to Team
  • Data Validity & Integrity, Check Constraints, Field size validations during DB testing
  • Performed tests on backup databases and recovery
  • Identified all bugs present in database and coordinated with developers and resolved all issues
  • Coordination with various teams (Development/Quality/IT/CM)
  • Conducting daily team meetings and Defect meetings
  • Defect Tracking
  • Preparation of Test Status report, Test planning and Resource task allocation
  • Knowledge transfer to Team, Reviewing the test documents prepared by test team
  • Test execution (Sanity/Integration/Regression/Data Base)
  • Data Validity & Integrity, Check Constraints, Field size validations etc.
  • Updated DB and managed DB with the help of various queries
  • Coordination with various teams (Development/Quality/IT/CM)
  • Conducting daily team meetings and Defect meetings
  • Defect Tracking
  • Preparation of Test Status report

Environment: MS SQL Server 2008R2/2008,T-SQL,SSRS,SSAS,SSIS Packages, MDX, ETL, ODBC, Performance Point Server, Erwin, ASP.Net 3.0, Ado.Net 3.0, C#.Net, Excel, Business, Business Objects Data Integrator 6.5, SharePoint Server, MDX, ProClarity, OLAP, OLTP, DB2, Access, Windows 2003 Server, IIS 6.0.

Confidential

SQL/BI Data Engineer, San Diego, California

Responsibilities:

  • Preparation of Test Plan
  • Involved in QA estimates
  • Understanding Requirement specifications and designing test cases
  • Involved in designing data model
  • Involved in Test cases review
  • Preparation of Data verification scripts
  • Preparation of Traceability Matrix
  • Developed test scripts for test cases
  • Actively involved in knowledge sharing across the team and participated Design meetings
  • Involved in weekly and monthly status meetings and provided detailed status report

Environment: DB 2, J2EE, Web Sphere 7.0, Windows XP, MS Access, MS Word, MS Excel

Confidential

Senior QA Engineer

Responsibilities:

  • Reviewing Business Requirement Documents and the Technical Specification documents for testability
  • Preparation of Test Strategy and Test Plan
  • Preparation of Test data and Preparation of Test input data in xml files
  • Preparation of Injector files and simulators (MQ’s configuration) using Design Specification Document provided
  • Regression testing for each updated version
  • Updating of work package issues with customer and co-ordinated with them to resolve the pending issues
  • Performing Performance Testing on completion of whole delivery on the Environment through Injector files with different Iterations
  • Scheduling tasks and assigning them to respective team member
  • Co-ordination with test manager in Test planning and Resource allocation
  • Reviewing the test documents prepared by test team
  • Test execution (Sanity/Integration / Regression/ Database)
  • Data Validity & Integrity, Check Constraints, Field size validations etc
  • Updated DB and managed DB with the help of various queries
  • Coordination with various teams (Development/Quality/IT/CM)
  • Conducting daily team meetings and Defect meetings.
  • Defect Tracking.
  • Preparation of Test Status report.

Environment: SQL server 2005/2000, Windows 2003 Standard Edition, Windows 2000 Advanced Server, Confidential Share point Portal Server, VSS, SQL Diagnostic Manager, PowerDesigner

Hire Now