| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Sr. SQL BI Developer Data Analytics Data EngineerEMAIL AVAILABLE Mobile: PHONE NUMBER AVAILABLEProfessional Experience: Detail-oriented and results-driven Business Intelligence developer and/or data analytics with over seven years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using SQL Server 2000/2005/2008/2008R2/2012. Proven experience with Azure Synapse Analytics and Databricks, ensuring efficient data workflows and optimizing data pipelines for enhanced business intelligence. Proficient in designing databases and creating different database objects like tables, views, functions, stored procedures, and triggers and performance tuning and query optimizations. Worked on relational and dimensional modeling and used different modeling tools like Visio, Erwin, and oracle SQL developer data modeler. Worked on creating different visualizations tools like Power BI, Tableau and SSRS Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot Experienced in creating ETL solutions using SSIS, Azure data factory and informatica Cloud. Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL query and Performance tuning of SQL Queries and Power BI reports. Used different Power BI components/functionalities like power query, DAX, data models, Datasets, Dashboards, KPI Scorecards, and Implementing row-level security. Expert in creating and developing Power BI Dashboards in to rich look. Experienced in building Data warehouse using star and snowflake schema. Experienced with agile methodology and the different agile ceremonies. Strong adaptability and versatility in diverse project environments. Expertise in defining the business process flow and gathering business requirements. Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative, and the ability to think outside the box. Good knowledge of Data Marts, Operational Data Store (ODS), MDM, OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services. Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS. Good knowledge of Data Marts, Operational Data Store (ODS), MDM, OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services. Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.Education: Bachelors in computer science (MIS)Technical Certification: SQL Server Database, SSIS and SSRS, Python for Data analyst, Power BI Training: Microsoft Azure Data Engineering SQL server DBA +TSQL programming SQL Server BI (SSIS, SSRS, SSAS, Power BI, MDX, TA, DW, DAX)TECHNICAL SKILLS:Languages SQL Server, MS Access, MySQL, Pl/SQL, JavaScript, Unix, C#, .Net, Python Databases SQL Server 2008/2012/2014/2016/2017/2017, MS Access, ORACLE 10g/11g, MySQL, Teradata, DB2, Snowflake, RedshiftDatabase Tools Business Intelligence Development Studio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service, SQL Server Management Studio ETL Tools SQL Server Integration Service (SSIS), ADF, Informatica, AWS Glue Reporting Tools SQL Server Reporting Service (SSRS), Crystal Report, Workday, Power BI, Tableau. Office Tools MS WORD, MS EXCEL, MS VISIO, MS Power Point Operating Systems Windows Server 2000, Windows NT Server, Windows Server 2003, Windows XP, Windows 2008, Windows 7, Windows 8, HTML, XML. Data Engineering: ETL processes, data modeling, data warehousing Cloud Platforms: Azure (Azure Synapse Analytics, Azure Databricks) Programming Languages: Python, SQL, Scala Big Data Technologies: Apache Spark, Hadoop Database Management: SQL Server, Azure SQL Database, Azure Data Lake Storage Data Integration: Azure Data Factory, Apache NiFi Version Control: Git DevOps: CI/CD pipelines, Azure DevOps Collaboration: Strong team player, effective communication skills Professional Experience:Client: Gainwell Technologies October 2022 present Role: Senior Data Engineer/BI Developer Supported information requests from inception to delivery, translating client requirements into appropriate reporting objects that tell a story with data including, but not limited to analytic scorecards, dashboards, and reports. Collaborated with Business Systems Analysts to ensure database compliance and performed impact analysis of changes. Implemented data pipelines on Azure Synapse Analytics, ensuring optimal performance and scalability. Collaborated with cross-functional teams to gather requirements and design data models for analytical purposes. Utilized Databricks for big data processing, implementing Spark-based solutions to handle large datasets. Led the design and implementation of data warehousing solutions using Azure Synapse Analytics. Developed and maintained scalable ETL pipelines to process and transform data from various sources. Collaborated with data scientists and analysts to provide data engineering support for advanced analytics projects. Implemented version control strategies using Git for tracking changes in code and configurations. Worked on data integration projects, ensuring seamless data flow between on-premises and cloud environments. Conducted performance tuning and optimization of Spark jobs for enhanced processing speed. Developed complex T-SQL code for stored procedures, triggers, functions, indexes, and views, employing techniques such as CTE and temporary tables. Tuned and optimized T-SQL queries using MS SQL Profiler, Index Tuning Wizard, and SQL Query Analyzer. Utilized Power BI and BI components (Oracle, SQL, SSIS, SSRS, SSAS) for data management and monitoring. Imported data from various databases to Power BI, cleaned datasets and created DAX queries for computed columns and measures. Implemented row-level security (RLS) and scheduled data refreshes in Power BI service. Utilized Azure Cloud Service and Azure Analysis Service and Data Factory. Designed and supported ad-hoc access to large databases. Environment: MS SQL Server 2012/2014/2019, SSIS, SSRS, Erwin, Excel, Windows Server, Flat Files, Team Foundation Server (TFS), Jira (Atlassian) Client: Rocket Mortgage, Detroit, MI March 2021 September 2022 Role: SQL/BI Developer Collaborated with users, DBAs, and technical managers to gather and fully understand system requirements, ensuring alignment with business objectives. Generated Ad hoc reports using Excel Services, SSRS, and Crystal Reports, providing timely insights and resolving production issues within strict timeframes. Employed advanced SQL techniques, including complex joins and sub-queries, to optimize queries across multiple databases. Developed Power BI models for financial reporting, specifically Profit & Loss and Headcount, enhancing business decision-making. Designed and documented the architecture for Power BI proof of concept (POC), providing a blueprint for future implementations. Wrote and optimized complex DAX functions in Power BI and Power Pivot to deliver sophisticated data analysis. Automated Power Query refreshes using PowerShell scripts and Windows Task Scheduler, streamlining report updates. Integrated data from various sources, including SQL Server, SAP BW, Oracle, and SQL Azure, into Power BI for comprehensive data analysis. Installed and configured both Enterprise and Personal gateways in Power BI Service, ensuring secure and efficient data access. Created workspaces and content packs in Power BI for user access, improving report dissemination and usability. Scheduled automatic refreshes in Power BI Service, ensuring up-to-date data for business users. Delivered weekly presentations to business users, gathering feedback and making necessary adjustments to reports. Managed and developed reports for different timeframes, including yearly, quarterly, monthly, and daily, catering to diverse business needs. Prepares ETL packages for deployment to development, test, and production environments following all release Management policies. Utilized SSIS extensively for ETL processes, handling complex transformations and data migrations across systems. Designed and deployed SSIS packages for data integration, validating, extracting, transforming, and loading data into SQL Server. Migrated legacy data from MS Access to SQL Server 2008 using SSIS, improving data accessibility and performance. Implemented high availability techniques such as clustering, log shipping, and replication to ensure data integrity and availability. Developed complex web forms using ASP.NET with C# and the .NET Framework 3.5, enhancing user interface functionality. Administered Tableau, managing user access, performing installations, and creating backups, while using Tableau for data visualization and dashboard creation. Defined security standards in Tableau, ensuring compliance and data protection. Utilized MS SQL Server 2012 SSIS to perform data scrubbing and validation checks during data staging, enhancing data quality. Developed multidimensional cubes using SSAS and implemented Key Performance Indicators (KPIs), supporting business intelligence initiatives. Created and optimized SSRS reports, including matrix, tabular, and ad-hoc reports, with features such as drilldowns and drill-throughs, tailored to executive and analyst needs. Scheduled SSRS reports for various business functions, ensuring timely delivery of critical insights. Regularly updated staging and dimensional databases, rebuilt dimensions and cubes in Analysis Services, and addressed troubleshooting and performance tuning needs. Implemented version control and managed complex code using TFS, ensuring consistent and reliable code deployment across environments. Mentors other team members in areas of expertise and ETL processes and standards and participates in code reviews Informs Management of project issues; escalates issues in a timely manner and asks for assistance when needed. Environment:Windows2003 Advanced Server, ASP.Net, MS SQL Server 2005/2008/2012/2014, TSQL, Pl/SQL, Visual Studio 2013/2015, Oracle 11g, SharePoint 2007/2010, Power BI, SSRS, SSIS. Client: T - MOBILE, CHICAGO, IL USA Jan 2017 Feb 2021 Role: SQL Server/ BI Developer Created databases and schema objects (tables, indexes, constraints) and developed functions, stored procedures, and triggers to support application connectivity. Proficient in SSIS Control Flow (For Loop, Execute SQL Task, Script Task, Send Mail Task) and Data Flow items(Conditional Split, Data Conversion, Fuzzy Lookup, Pivot). Hands-on experience in Disaster Recovery (DR) processes, including Log Shipping and Database Mirroring. Built and optimized SSIS packages for ETL processes, integrating data from various sources (flat files, Excel, legacy systems) into SQL Server. Designed and implemented ETL packages for data transformations across different sources (SQL Server, Flat Files, XML) using SSIS. Implemented high availability techniques, including clustering, log shipping, and replication, to ensure data integrity and uptime. Experience with DMExpress for ETL data filtering and SQL Server 2012 features like Columnstore Indexes, Table Partitioning, and in-memory OLTP databases. Developed and published complex SSIS packages, stored procedures, triggers, and SQL statements, ensuring efficient data processing and application performance. Configured and optimized SQL Server Reporting Services (SSRS) for generating drill-through, parameterized, and linked reports. Designed and deployed Power Pivot reports and multidimensional cubes using SSAS, incorporating Key Performance Indicators (KPIs) and MDX calculations. Conducted performance tuning, including index optimization, schema redesign, and query optimization using execution plans and SQL Profiler. Created dashboards and migrated Performance Point Server reports to SharePoint 2010, resolving conversion errors and connection issues. Provided DBA support for SharePoint 2007 to 2010 migration and collaborated closely with the team to meet project deadlines. Utilized DDL scripts for generating tables, views, and functions, and maintained data integrity through checks and constraints.Environment: Windows 2003 Advanced Server, ASP.Net, MS SQL Server 2005/2008/2012/2014, TSQL, Pl/SQL, Visual Studio 2008, Oracle 11g, SharePoint 2007/2010, Cognos, Qlikview, Lotus Notes, SSRS, SSIS, OBIEE, Informatica, Erwin. Client: Hertz Corp, Alexandria, VA Nov 2015 Dec 2016 Role: Power BI Developer Project was primarily focused on the migration of Tableau reports to Power Bi report server. Manage, monitor, and improve Power BI environment including ongoing changes and active product backlog. Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports. Cleaning up datasets using marge queries, append queries, and sort data column to properly fit our reports. Created Dax Queries to generated computed columns in Power BI, also applied DAX calculated measures and columns. Generated computed tables in Power BI by using Dax. Involved in creating new stored procedures and optimizing existing queries and stored procedures. Created Azure Blob Storage for Import/Export data to/from .CSV File, also assess and analyze dataset and KPIs to create reports. Used Power BI to created visualization tools intended for diverse users. Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps. Explore data in a variety of ways and across multiple visualizations using Power BI. Used Power BI Gateways to keep the dashboards and reports up to date. Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services. Published reports and dashboards using Power r BI, DAX, and Power Query Environment: Environment: Windows2003 Advanced Server, ASP.Net, MS SQL Server 2005/2008/2012/2014, TSQL, Pl/SQL, Visual Studio 2013/2015, Oracle 11g, SharePoint 2007/2010, Power BI, SSRS, SSIS. |
