Home

vikas - data analyst

srikanth.sidda@syntechitsolutions.com

Location: Reston, Virginia, USA

Relocation: yes

Visa: h1b

VIKAAS C Senior Data analyst (240) 720 - 7796 | vikaaschikoti255@gmail.com SUMMARY Developer around 9 Yrs experience in BI Reporting domain. Expertise in entire reporting lifecycle Gathering Requirements, development of ingestion routines, design and development of Reports and Dashboards in various reporting and dashboarding platforms. Adept in navigating data models to extract useful KPI s and metrics and to aid development of new Key Performance Indicators and Optimizing the utilization of data to further Business Insights. Strong experience as an SQL Developer. Experience extends to Azure Data Factory Includes design, develop, and implement database systems using MS SQL Server and Oracle Databases for both OLTP and Data Warehousing applications in domains like finance, pharmaceuticals, and manufacturing. Possess excellent knowledge of Azure Cloud services, including Azure Cloud, Azure Data Factory, Azure Data Lake Analytics, Azure Data Bricks, GIT, Azure DevOps, and Azure SQL Data Warehouse. Expert in using tools like Bulk Insert Task (BCP) in SSIS and have developed reports on SSAS and SSRS on SQL Server. Strong understanding of SSAS, OLAP cubes, and architecture, along with extensive experience in writing SQL queries. Experience encompasses analysis, design, development, testing, and implementation of projects. Capable of handling responsibilities independently and working as a proactive team member. Well-versed in Software Development Life Cycle (SDLC) methodologies like Agile and Scrum. Delivered high-quality solutions, reports, and dashboards using Power BI in response to diverse business requirements. Proficient in Power BI designer, Power Pivot for Excel, Power View for data visualization, and DAX for calculated columns. Conducted data analysis, data validation, data mining, data modelling, DBMS, MDX, ETL, data mapping/design, and have a strong background in effective Data Visualization. Experience in data cleaning, feature scaling, and feature engineering using Pandas, Flask and NumPy in Python. Extensive experience in handling and transforming large-scale datasets using Big Data and NoSQL technologies, including Hadoop, Hive, and Apache Spark. Adept at using Azure Databricks for scalable data processing and advanced analytics. Skilled in managing and automating the deployment of Power BI reports, data models, and data pipelines using Continuous Integration and Continuous Deployment (CI/CD) practices. Experience with Git for version control of Power BI artifacts (such as reports, datasets, and Power Query code), ensuring a streamlined, efficient development process and maintaining code consistency across teams. Comfortable with in-depth analysis of information from multiple data sources, including web analytics data, using Google Analytics to provide insights into online results. Familiar with various filtering techniques, such as Cognos, Filters, Context Filter, Quick Filter (Normal Filter, Date Filter, Cascading Filter, and Filter Sharing). Experience in creating reporting objects like Hierarchies, Sets, Groups, and Calculation fields. Expertise in formatting data using Legends, Marks, Colours, Size, Text, and Shape, and experience in developing actions with worksheet/dashboard reports and applying Key Performance Indicators (KPIs). Experience in collecting, processing, and analysing socioeconomic and spatial data using R, SQL queries, Git/GitLab also developed Shiny Dashboards and R packages and applied machine learning techniques. Analysed, manipulated, and queried existing application data using various data mining techniques, Microsoft SQL Server, and the PyCharm tool. Additionally, utilized web scraping techniques (e.g., Beautiful Soup) to extract and organize data from web portals using Python. Created numerous reports with various filtering and parameterization options, including table filters, single value parameters, multi value parameters, and dependent parameters. Experience in designing complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Drill down Reports. Strong skills in MS Word, PowerPoint, MS Access, and Excel, with expertise in Pivot tables, VLOOKUP, Data Validations, and Macros. TECHNICAL SKILLS BI & Analytic Tools Tableau Cloud, Microsoft Power BI Ecosystem, QlikView, SSAS Data Integration SSIS, Azure Data Factory, APACHE Airflow Databases Oracle, MS SQL Hive, Server, MySQL, Snowflake, PostgreSQL, MS Access, MS Excel, Teradata, NoSQL, Cosmos DB, Microsoft Azure, Hadoop, AWS Redshift, AWS Glue Languages Python, SQL, Java Script, Unix Bash Scripting OS Environment Windows, Linux (RHEL, CentOS, SLES) Design/ Development Tools Visual Studio, Eclipse, Jupyter, Power BI Report Builder SQL Tools SQL Server Query Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) Others Snowflake, Sas, Dynamic 365, Google Suite, Access, IBM Cognos, PROFESSIONAL EXPERIENCE MetLife || Remote Senior Data analyst Feb 2023 - Present Description: MetLife, Inc. ( MetLife ) has helped generations protect their families and finances worldwide. We are one of the world s leading financial services companies, providing insurance, annuities, employee benefits, and asset management to our individual and institutional customers. Responsibilities Leveraged advanced data analysis techniques to extract meaningful insights from complex data and establish key performance indicators (KPIs), effectively measuring the impact and effectiveness of various business modules. Designed, developed, and implemented large-scale, enterprise-level data solutions using AWS analytics services in conjunction with third-party tools such as Spark, DynamoDB, and Redshift to support robust data processing and storage. Integrated and managed data from diverse sources, including Dynamics 365 CRM, S3 Data Lake, SAP BW Data Warehouse, and Snowflake Databases, to support comprehensive reporting and business insights. Developed & Administer the Power BI service, including user access, workspace management, & monitoring report usage. Created complex SQL scripts and PL/SQL procedures to extract and process data from OLAP and OLTP databases, enabling targeted data analysis and optimized reporting. Built interactive dashboards with enhanced user features such as quick filters, parameters, and actions for efficient data exploration. Utilized Power BI, Power Query Editor, Power BI Embed, Power BI Service, and Tableau for distribution and SSRS for additional reporting needs. Developed and manage scheduled data refreshes for live dashboards and reports deployed over the Power BI service. Actively participated in technical reviews, defect assessments, and walkthrough meetings throughout the project lifecycle, collaborating with stakeholders to develop solutions and documenting implementation approaches. Employed SharePoint for centralized document storage, improving team collaboration by providing easy access to shared resources and facilitating seamless file sharing. Designing and developing cloud solutions based on Microsoft Power Platform using Power Apps, Power Automate, Power BI, Power Apps Portal and Common Data Service. Created complex calculated columns and applied DAX functions (aggregation, counting, logical operations, text, and date functions) to enhance data calculations within Power BI dashboards, supporting complex analytical requirements. Ensured all reports and analyses complied with legal and internal policy requirements, maintaining data integrity and confidentiality throughout the reporting process. Conducted data validation using Python and MS Excel for statistical accuracy, ensuring that data-driven insights were grounded in reliable data checks. Worked on POWER BI as it integrates with other components of the Power Platform, such as Power Apps for building custom apps, Power Automate for automating workflows Implemented time-series analysis to support insights over various time periods (e.g., year-to-date, quarter-to-date, rolling averages) and geospatial analysis for enhanced data context, enriching the depth of reporting for stakeholders. Analyse, and document both functional and non-functional requirements to ensure robust product development. Environment: Power Bi, AWS, Dax, Power apps, Power Platform, Share point, PL/Sql, SQL, analysis, spark, redshift, ec2, MS Excel Keywords: cprogramm continuous integration continuous deployment business intelligence sthree database active directory rlang information technology business works microsoft procedural language