Your Name
Summary
I 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 and passion for data.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Sr. BI Developer and Data Analyst
Ari Network Services
03.2013 - Current
- BI Solution architecture and development, involving data integration, cleaning, data modeling, DWBI development.
- ETL creation to integrate, filter and transform data set frommultiple source systems.
- SSRS, Power BI, Power View and Power Pivotreport/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 anddevelopment 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 Projecttasks to Management. Ensuring project deliverable meet Cognizant QualityStandards (conduct QA audit/C2/Risk Portal updating etc.).
- Coordinated with systems partners to finalize designs and confirm requirements.
Business Intelligence Developer and Data Analyst
Apex Systems
03.2011 - 02.2013
- 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.
- Weekly reporting of Project tasks to Management. Ensuring project deliverable meet Cognizant Quality Standards (conduct QA audit/C2/Risk Portal updating etc.).
- Trained resources on COSMOS/SCOPE big data and Online Advertisement business overview.
Data Engineer
Apex Systems
10.2009 - 02.2011
Data Engineer
Accenture Services Pvt. Ltd.
08.2007 - 10.2009
- 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.
Education
Master of Science - Computer Science
Sikkim Manipal University Sikkim Manipal University
Bangalore, India2010
Bachelor of Science - Computer Science
City College - Bangalore University
Bangalore, India2007
Skills
- DatabaseSQL Server 2008, 2012, 2014
- ETL ToolSQL Server Integration Services
- Reporting ToolSQL Server Reporting Services, Microsoft Power BI, Excel Power View/Power Pivot Reporting
- OLAP ToolSQL Server Analysis Services, Tabular Cube
- Data/Dimensional Modeling and Database design
- Programming & Scripting TechnologiesC# - ASPNet, JavaScript, VB, SCOPE, T-SQL, Python, Hive
- Big DataMicrosoft COSMOS and Scope Language, Hands-on Azure cloud platform - Blob storage, HDInsight, Data Lake, Data Factory, Azure ML
- Other ToolsMS Office 2013/2016, O365 Power View Reporting, PowerShell scripting
Accomplishments
- Over all 9.5+ years of IT experience in Business Intelligence solution development and Data analysis.
- Expert knowledge on SQL Server, T-SQL, Data/Dimensional Modeling, MSBI Tools - SSIS/ SSAS/ SSRS, Python, Hive and VB scripting, Power BI & Power Pivot Reporting.
- Have passion for data and deriving quick data driven insight/solutions to answer business problems.
- Good knowledge in Data modeling, DW/BI dimensional modeling, Star Schema and Snowflake multi-dimensional modeling.
- Expertise in analyzing multiple data sources, data investigation, cleaning, profiling, applying business rules/transformations and Data Integration into Data Mart.
- Worked on Big Data analytic with Petabyte data volumes on Microsoft\'s Big Data platform (COSMOS) & SCOPE scripting.
- Hands-on experience in Python and Hive scripting. Knowledge on Microsoft Azure and Cortana Analytics platform – Azure Data Factory, Storage, Azure ML, HDInsight, Azure Data Lake etc.
- Experience in SDLC - Requirement Gathering & Analysis, Design, Coding, Code reviews, Configuration control, Testing and Performance Tuning.
- Actively involved in customer meetings to understand problem statement and business needs and come up BI solution to solve business problem.
- Expert in Agile/SCRUM model with onshore-offshore model.
- Have got strengths like commitment towards work, self-determination, passion to excel & innovate, flexibility and good learner & planner.
- Excellent communicator, good listener and admirable team player.
Certification
- Microsoft SQL Server 2008 – Business Intelligence Development and Maintenance (070-448)
- Microsoft Azure platform- Design and Implement Big Data Analytics Solutions (070-475)
- Microsoft Cloud Platform University: Practical Data Analytics with the Microsoft Cortana Intelligence Suit
- Microsoft Accredited Professional (Microsoft AdCenter)
- Basic Python Programming certification from edX
- Accessing Hadoop Data using Hive certification from IBM Big Data University
- Certified MCPDEA (Microsoft Certified Professional Developer: Enterprise Applications) - .Net
Additional Information
- "ASE Achievers Award" for exceptional performance during the first year with the organization (Accenture).
- TESCO Value Award for outstanding contribution towards Technology and Domain for TESCO Business.
- "Rain Maker" Award given by Cognizant for outstanding contribution to project deliverables.
- "iTree Innovator" Award given by Cognizant for various automation to reduce manual effort and improve process.
Timeline
Sr. BI Developer and Data Analyst
Ari Network Services
03.2013 - Current
Business Intelligence Developer and Data Analyst
Apex Systems
03.2011 - 02.2013
Data Engineer
Apex Systems
10.2009 - 02.2011
Data Engineer
Accenture Services Pvt. Ltd.
08.2007 - 10.2009
Master of Science - Computer Science
Sikkim Manipal University Sikkim Manipal University
Bachelor of Science - Computer Science
City College - Bangalore University
Similar Profiles
Valerie TalleyValerie Talley
Account Manager at ARI Network ServicesAccount Manager at ARI Network Services
Christine ZaneChristine Zane
Sales Team Lead OPE at ARI Network Services, IncSales Team Lead OPE at ARI Network Services, Inc
Simon TranSimon Tran
Wait Staff Member at ARI ARI GARDEN CITY PTY LTD (ARI ARI KoreanWait Staff Member at ARI ARI GARDEN CITY PTY LTD (ARI ARI Korean
Rohini MasarapuRohini Masarapu
Sr. BI Developer/Data Analyst at Credit SuisseSr. BI Developer/Data Analyst at Credit Suisse
ABDI ARBASABDI ARBAS
Sr. Data Analyst/Power BI Developer at PenFed Credit UnionSr. Data Analyst/Power BI Developer at PenFed Credit Union