SUMMARY

• Presently working at Confidential as a Sr Digital Analyst for Confidential eCards and feeln.
• Worked at Confidential as a data analyst for Financial services and Home loan business unit.
• Worked at Confidential for 3.5 yrs as a senior programmer & business intelligence analyst in MSBI.
• Expertise in business intelligence, data mining and object oriented analysis, design and programming.
• Proficient in problem formulation, statistical and probabilistic techniques, business objects and warehousing.
• Expertise in Agile scrum software development framework and in V model of SDLC.

TECHNICAL SKILLS

SAP Tools: SAP Netweaver, Xcelsius, Crystal Report, BEx Query designer.

Microsoft Tools: SQL Server Reporting Services 2008, SQL Server Management Studio.

Development Tools: Tableau 9.0/8.2/8.1, Ultraedit, Putty, Base SAS, SAS Enterprise guide, XL Miner.

Documentation Tools: Microsoft Excel, Microsoft Project, Microsoft Visio, PowerPoint.

Languages: C, C#, ASP.Net, Java Script, T - SQL, Shell script, R.

Databases: SQL Server 2008, Teradata, Amazon Redshift, MySQL.

PROFESSIONAL EXPERIENCE

Sr. Digital Analyst

Confidential

Responsibilities:

• Created dashboards in tableau 9.0 and maintained them on Tableau online.
• Understood entire business process to fix problems related to data on existing dashboards. Highlighted discrepency in data.
• Wrote complex SQL code for MySQL and Amazon Redshift database. Created views, tables as per the requirements.
• Created Churn analysis dashboards for feeln(subscription based movies plateform) and e-Cards.
• Created Cohort analysis dashboards for Feeln and e-Cards. Showed pattern in subscribers behavior.
• Beginner in R. Earned 4 certifications in R programming and statistical concepts.

Data Analyst

Confidential

Responsibilities:

• Created and managed tables in Teradata. Wrote SQL queries and validated data in tables for reporting. Enhanced the performance of queries.
• Wrote Proc SQL queries and SAS commands to fetch and analyse data from excel files and pushed it in Teradata after cleansing operations.
• Gathered requirements, objectives and features for reports. Led a small team to create rich graphic dashboard.
• Created and maintained dashboards using calculations, parameters in Tableau 8.2 for financing and Home loans.
• Extensive experience in using various reporting objects like facts, attributes, hierarchies, filters, parameters and calculated fields etc.
• Created Dashboard reports for the key performance indicators for senior managers and business units.
• Designed & deployed rich graphic visualization with drill down, drop down menu option & parameterized using Tableau.
• Wrote Unix shell scripts and used putty to automate the execution of SQL scripts, manage them on server.
• Used Ultraedit to review the scripts of group and modify the already existing scripts as per requirements in bulk.

Data Analyst

Confidential

Responsibilities:

• Created stored procedure, updatable views and SQL queries.
• Created reports in Tableau 8.1 on performance matrix of different units for company. I was also responsible for data validation in those reports.
• Develped tableau data extract using SQL and excel.
• Enhanced the performance of several Tableau dashboard reports by using context filters.
• Developed reports with graphs and pivot tables to understand trends and forcasting in MS excel useing functions like logical, lookup, forcast, statistical etc.
• Ran regression analysis in excel to get residual plots, coefficients, F & P-values, establish relationship b/w variables.

Software Engineer Intern

Confidential

Responsibilities:

• Created requirement matrix documents and technical design documents.
• Wrote complex stored procedure and SQL queries. Created reports in Tableau on geo based parameters.
• Created linear regression, ANOVA, forcasting, Trend using several parameters in excel to project the sales of services.
• Worked on powerpoint to creat presentation slides for seniors using graphics, visual theams, charts etc.

Software Engineer Intern

Confidential

Responsibilities:

• Designed story board, wire frame, flow chart and requirement documents for android OS version 4.2 applications.
• Created reports for clients in MS excel with statistical, financial, database and financial functions.
• Created stored procedures in T-SQL those were used by development team.

Software Engineer Intern

Confidential

Responsibilities:

• Created interactive dashboards and business presentations by importing data from different data sources using Tableau.
• Designed and developed various metrics, analytics like speedometer, interactive charts, alerter and goals for creating dashboards using Xcelcius.
• Involved in creation of desktop intelligence and web intelligence reports with different functionalities like dynamic cascading prompts, drill down, linking reports, charts and graphs, ranking and alerts.

Senior Programmer and Business Intelligence Analyst

Confidential

Responsibilities:

• Interacted with the clients, garnered requirements, analysed complexities, acuminated them to solution.
• Worked with sales management and marketing analysis team. Used Hoovers and OneSource to create profiles of potential clients (companies) and marketing & business analysis documents.
• Created requirement documents, technical design documents and knowledge sharing documents.
• Involved in complete Software Development Life Cycle including system study, interaction with users & management, designing, coding, testing and deployment of the system.
• Developed chart reports, parameterized reports, drill down report, drill through report, matrix reports, master detail reports.
• Accountable for data quality & analysis using & excel data parsing using macros, lookup functions and pivot tables.
• Developed SQL server 2008 R2 stored procedures, data mappings for data importing, exporting and parsing etc. extracted, masked, cleaned and validated. Wrote MDX queries.
• Used Microsoft SharePoint to create and design pages for SSRS reports for specific requirements given by clients.
• Developed SSIS packages with various tasks like - FTP, file system, for-each-loop, execute package, data flow task, execute SQL task, custom script task, analysis services task, data mining task.
• Sourced data from various types of relational databases, flat files, excel files.
• Experienced in working on dimensional data warehouse, dimensions, facts, slowly changing dimensions.
• Shared knowledge transfer to new joiners in project, support team and testing team. Created blue prints for development team. Gave presentations on MSBI as a part of people development in company.
• Worked in complete SDLC for web application in .net. Followed 3 layer architecture. Ensured quality of code.
• Done Assembly testing/ Product testing and prepared test scripts. Handled production support and bug fixing.

Programmer

Confidential

Responsibilities:

• Done software development in C#/ASP.Net/SQL server on windows platform. Prepared test scripts.
• Developed complex SQL code using complex joins, group by, having, sub queries, correlated sub queries, functions, user defined functions.
• Stored procedures using temp tables, cursors, table type variables.