Sr. BI Developer and Data Analyst Resume

SUMMARY:

Aspire to seek a position to utilize my skills and abilities in the Organization that offers Professional growth and opportunities.
With strong desire to stay ahead and become a BI Solution Architect and Project Manager down the line by utilizing the strengths and skills that I possess to innovate and derive data insight & answers to business problems.

TECHNICAL SKILLS:

Programming & Scripting: T - SQL, Python, JavaScript, VB, C#, SCOPE, Hive, JSON, PowerShell

Database: SQL Server 2008, 2012, 2014, MySQL

ETL Tool: SQL Server Integration Services (SSIS)

Reporting Tool: SQL Server Reporting Services, Microsoft Power BI, Excel Power View/Power Pivot Reporting

OLAP Tool: SQL Server Analysis Services, Tabular Cube

Data/Dimensional Modeling and Database/DW design

Big Data: Microsoft HDFS COSMOS/Scope cluster storage

Cloud: Hands-on Azure cloud platform - Storage, HDInsight, Data Lake, Data Factory, SQL Server and Azure ML. Took AWS training from LinkedIn Learning

Other Tools: MS Excel 2013/2016, Visio, Visual Studio Team Foundation Server

PROFESSIONAL EXPERIENCE:

Confidential

Sr. BI Developer and Data Analyst

Responsibilities:

BI solution architecture and development, involving data integration, cleaning, data modeling, DWBI development.
ETL creation to integrate, filter and transform data set from multiple source systems.
SSRS, Power BI, Power View and Power Pivot report/dashboard creation.
End-to-End solution delivery from requirement gathering, Extraction Transformation and Loading (ETL), BI platform creation and data visualization and reporting.
Analyzing business requirement/queries and development of metrics/KPIs to report business state and performance.
Design, Development of T-SQL scripts, Database design and query optimization.
Documentation of data model and DW design.
Provide effort estimates, delivery planning, version & configuration control and Business problem solution documentation.
Weekly reporting of Project tasks to Management. Ensuring project deliverable meet Cognizant Quality Standards (conduct QA audit/C2/Risk Portal updating etc.).
Coordinated with systems partners to finalize designs and confirm requirements.

Confidential

Business Intelligence Developer and Data Analyst

Responsibilities:

Business/Data analysis of online Advertisement data from COSMOS/Bing AdCenter logs.
Advertiser data analysis, brain storming, root cause finding and suggestion to improve the business metrics performance.
Development of COSMOS/SCOPE script to fetch relevant data from BIG DATA web log files (COSMOS).
Ad-hoc analysis of MSFT AdCenter data using MS Excel 2010 Power Pivot.
Automation of regular analysis report by creation of BI platform, involving ETL of COSMOS log files, data modeling and database creation, Design and Development of SSRS automated reports.
Design, Development of T-SQL scripts. Report optimization and Maintenance of DB.
Coordinating with the onsite-offshore teams for the analytic/development activities.
Provide estimates and Business problem analysis and solution documents.
Trained resources on COSMOS/SCOPE big data and Online Advertisement business model

Confidential

Data Engineer

Responsibilities:

Requirement gathering and involve in customer/end user meetings to understand business needs and report functionality
Source systems (mainframe) data files analysis, data cleaning and profiling
Data modeling and physical data base creation in SQL Server 2008.
Extract Transformation and Loading of mainframe data file to SQL Server by implementing data cleaning, T-SQL scripting and SSIS data pipeline creation.
Development of custom SSRS Payroll reports
SQL Server DBA and project artifacts configuration and management. Optimization of ETL and report performance

Confidential

Data Engineer

Responsibilities:

Preparing the technical design documents and development of the System.
Interacting with client directly to capture business requirement and discuss application functionality.
Developed three - tier Application with User Interface, Business Logic, and Data Access layers using ASP.NET, C#.
Actively involved in customer meetings to understand business needs and the functionality of the project.
Design and develop T-SQL Script, SSIS/ETL packages to implement data integration and business work flows.
Design and developed visualization using SQL Server Reporting Services (SSRS 2005).
Responsible for Reports deployment, Configuration and Release Management.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship