| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Email: EMAIL AVAILABLE PHONE NUMBER AVAILABLEHighly skilled SQL/MSBI Developer with a proven track record of designing and implementing robust BI solutions. Proficient in data analysis, ETL development, report generation, and data warehousing using industry-leading tools such as SQL Server, SSIS, SSRS, Power BI, and Tableau. Strong expertise in database management, optimization, and project management methodologies. I am a dedicated team player with exceptional communication and problem-solving skills.Technical SkillsDatabases System& Visualization: SQL Server Management Studio, SSIS, SSRS, SSAS, Power BI, Tableau, and Alteryx, NoSQL.Programming Languages: Python, C#, Java, CSS, HTML5, XSLT.Project Management: SDLC, Agile, Scrum, Workday Studio.Cloud Technologies: Azure Data Factory, Azure SQL Database, Microsoft Fabric, Azure DevOps, CI-CD, Azure Blob Storage, and Rest API.Source Control: GitHub, Team Foundation Server (TFS)Data Cleaning and Transformation: MS Word, MS Excel, Power Pivot, Power Query, M language, DAX, and MDX.Event Streaming Platforms: Apache Spark, KafkaProfessional SummaryDatabase and Datawarehouse Maintaining: Installations Configurations, managing security, backups Restore, Performance Tunning, and Disaster recovery strategies in SQL Server Management Studio environments.Working Environment:Excellent knowledge of entire Software Development Life Cycle (SDLC) methodologies like Agile, Scrum, Waterfall, and Project Management Methodologies like JIRA, and Azure DevOps.Requirements Analysis: Gathering, understanding, and validating project specifications to ensure alignment with business requirements.Design, Develop, and Testing T-SQL Query:Designing and developing Transact-SQL commands including complex queries, views, functions, stored procedures, cursors, and triggers on SQL Server Management Studio.Designing and developing Data Warehouses, Data marts, and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schemas.Develop and review complex SQL queries, joins, CTE, Normalization, Index, and stored procedures to perform the Back-End Testing of the data.Create and maintain SQL Scripts to perform Unit Testing, Database Testing & ETL testing.Extensive knowledge of health information and health care services regulatory environment including HIPAA, Medicaid/Medicare, and EDI.Experienced in various Healthcare areas like Provider, Member, Claims, Medicare Medicaid, and Implementation of HIPAA key EDI (ANSI X12) transactions.Enrollment to a health plan, 835, and 837 for a smooth transition into the EDI environment.Data Extraction and ETL Process:Experience in Data Extraction, Transforming, and Loading ETL between Homogenous and Heterogeneous Systems using the ETL tools SSIS and Informatica.Implementing various SSIS packages with different tasks and transformations, including lookup, filters, aggregators, scripts, and multicasts, derived.Performing migration of large amounts of data from OLTP to OLAP by using ETL Packages.Skilled in creating and managing data pipelines using Azure Data Factory, orchestrating ETL workflows across on-premises and cloud data sources.Experience managing Azure Data Factory (ADF) and Azure Blob Storage, integrating with other Azure services, and orchestrating data movement from various sources and destinations.Data Modeling and Visualization:Designing, developing, and testing various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.Writing complex DAX (SUM, CALCULATE, DIVIDE) expressions to create calculated columns, measures, and calculated tables for accurate data analysis and reporting, including working with Aggregates.Implementing Row Level Security in Power BI.Experienced in generating various reports using SQL Server Reporting Services (SSRS), including parameterized, cascaded, drill-down, crosstab, and drill-through reports.Documentation:Document data architecture, processes, and workflows to ensure clarity and maintainability of the data infrastructure.Cloud Environment: Experienced with deployments, Maintenance, and troubleshooting applications on Microsoft Cloud infrastructure Azure. Designed and built cloud service models including Infrastructure-as-a-Service, Platform-as-a-Service, and Software-as-a-Service.Understanding of event streaming platforms such as Apache Spark and Kafka are used for data collection, processing, storage, and integration.Security and Compliance:Implement and maintain data security measures and ensure compliance with data governance and regulatory requirements.Financial Performance Analysis:Conducted an in-depth financial performance analysis of a leading computer accessories manufacturer, revealing a growth in operations and gross margin but a decline in net profit.Source Control:Experience with version control systems like GIT, and Azure DevOps.Education & CertificationMaster of ScienceMicrosoft Certification: DP 900 Azure Data FundamentalWork ExperienceSQL/BI DeveloperCigna HealthcareBloomfield, Connecticut, United StatesJune 2021 - PresentThe Cigna Group is a healthcare and insurance company that provides medical, dental, disability, life, and accident insurance and related products and services,Responsibilities: Installations, Configurations, managing security, backups Restore, Performance tuning, and Disaster recovery strategies in SQL Server Management Studio environments. Gathering, understanding, and validating project specifications to ensure alignment with business requirements.Designing and developing Transact-SQL commands including complex queries, views, functions, stored procedures, cursors, and triggers on SQL Server Management Studio.Designing and developing Data Warehouses, Data marts, and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schemas.Experience in Data Extraction, Transforming, and Loading ETL between Homogenous and Heterogeneous Systems using the ETL tools SSIS and Informatica.Implementing various SSIS packages with different tasks and transformations, including lookup, filters, aggregators, scripts, and multicasts, derived.Performing migration of large amounts of data from OLTP to OLAP using ETL Packages.Skilled in creating and managing data pipelines using Azure Data Factory, orchestrating ETL workflows across on-premises and cloud data sources.Experience managing Azure Data Factory (ADF) and Azure Blob Storage, integrating with other Azure services, and orchestrating data movement from various sources and destinations. Worked on Data Factory V2 Data orchestration tool to load the data from on-premise to Azure Data Lake. Manage Azure Data Factory Storage Account, Azure Data Factory Studio, Pipeline, Activities, Trigger, and data movement from various sources and destinations.Designing, developing, and testing various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.Writing complex DAX (SUM, CALCULATE, DIVIDE) expressions to create calculated columns, measures, and calculated tables for accurate data analysis and reporting, including working with Aggregates.Implementing Row Level Security in Power BI. Work with version control systems like GIT, and Azure DevOps.Understanding of event streaming platforms such as Apache Spark and Kafka are used for data collection, processing, storage, and integration.SQL DeveloperDonnelley FinancialChicago, Illinois, United StatesAugust 2019 May 2021Donnelley Financial Solutions (DFIN) is a leading global risk and compliance solutions company. They make smarter decisions with insightful technology, industry expertise, and data insights at every stage of your business and investment lifecycles. As markets fluctuate, regulations evolve and technology advances, were there. And through it all, they deliver confidence with the right solutions in moments that matter.Responsibilities:I am involved in Installations, Configurations, managing security, backups Restore, Performance tuning, and Disaster recovery strategies in SQL Server Management Studio environments.Excellent knowledge of entire Software Development Life Cycle (SDLC) methodologies like Agile, Scrum, Waterfall, and Project Management Methodologies like JIRA, and Azure DevOps.Gathering, understanding, and validating project specifications to ensure alignment with business requirements.Designing and developing Transact-SQL commands including complex queries, views, functions, stored procedures, cursors, and triggers on SQL Server Management Studio.Designing and developing Data Warehouses, Data marts, and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schemas.Experience in Data Extraction, Transforming, and Loading ETL between Homogenous and Heterogeneous Systems using the ETL tools SSIS and Informatica.Implementing various SSIS packages with different tasks and transformations, including lookup, filters, aggregators, scripts, and multicasts, derived.Performing migration of large amounts of data from OLTP to OLAP by using ETL Packages.Designing, developing, and testing various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.Writing complex DAX (SUM, CALCULATE, DIVIDE) expressions to create calculated columns, measures, and calculated tables for accurate data analysis and reporting, including working with Aggregates.Experience with implementing Row Level Security in Power BI.Developed new reports using existing data sources and models, or created entirely new data models from scratch using SSRS.Conducted an in-depth financial performance analysis of a leading computer accessories manufacturer, revealing a growth in operations and gross margin but a decline in net profit.Experience with version control systems like GIT, and Azure DevOps.ETL DeveloperLeidos - New York, NYSeptember 2017 - July 2019Leidos, a global leader in integrating information technology, engineering, and science, offers a diverse range of high-technology products and services. Leidos provides various hardware and software solutions, including automatic equipment identification technology, sensors, and nondestructive imaging and security instruments.ResponsibilitiesInstallations Configurations, managing security, backups Restore, Performance Tunning, and Disaster recovery strategies in SQL Server Management Studio environments.Excellent knowledge of entire Software Development Life Cycle (SDLC) methodologies like Agile, Scrum, Waterfall, and Project Management Methodologies like JIRA, and Azure DevOps.Gathering, understanding, and validating project specifications to ensure alignment with business requirements.Designing and developing Transact-SQL commands including complex queries, views, functions, stored procedures, cursors, and triggers on SQL Server Management Studio.Implemented complex business logic with user-defined functions, and views and also created User Defined data types, Clustered and non-clustered Indexes.Managed the Clustered environment databases and fixed the errors when they arose.Created stored procedures for maintaining SQL Server, and Written Stored Procedures for Web-App Developers.Designing and developing Data Warehouses, Data marts, and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schemas.Experience in Data Extraction, Transforming, and Loading ETL between Homogenous and Heterogeneous Systems using the ETL tools SSIS and Informatica.Implementing various SSIS packages with different tasks and transformations, including lookup, filters, aggregators, scripts, and multicasts, derived.Configured SSIS packages using the Package configuration wizard to allow packages to run on different environments.Monitoring nightly ETL process from various highly different source systems and sources including SQL-based databases and Excel Files. Also ensured that nightly backup jobs cube processing or other ETL jobs didn't interfere with each other.Performing migration of large amounts of data from OLTP to OLAP by using ETL Packages.Designed and developed matrix and tabular reports using SSRS with drill-down, drill-through, and drop-down menu options.Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.Created multi-dimensional cubes with different dimensions and measures in them using SSAS.Experience with version control systems like GIT, and Azure DevOps.SQL BI DeveloperGila Corp, Austin, TXJan 2015 - August 2017Gila, a Navient company, offers outsourced collections, payment processing, and call center services to governmental entities, and financial and higher education institutions nationwide. The company provides a full suite of receivables management solutions, tailored to each client's specifications. Responsibilities:Installations Configurations, managing security, backups Restore, Performance Tunning, and Disaster recovery strategies in SQL Server Management Studio environments.Excellent knowledge of entire Software Development Life Cycle (SDLC) methodologies like Agile, Scrum, Waterfall, and Project Management Methodologies like JIRA, and Azure DevOps.Gathering, understanding, and validating project specifications to ensure alignment with business requirements.Designing and developing Transact-SQL commands including complex queries, views, functions, stored procedures, cursors, and triggers on SQL Server Management Studio.Implemented complex business logic with user-defined functions, and views and created User Defined data types, Clustered and non-clustered Indexes.Managed the Clustered environment databases and fixed the errors when they arose.Created stored procedures for maintaining SQL Server, and Written Stored Procedures for Web-App Developers.Designing and developing Data Warehouses, Data marts, and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schemas.Designed and developed matrix and tabular reports using SSRS with drill-down, drill-through, and drop-down menu options.Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.Created multi-dimensional cubes with different dimensions and measures in them using SSAS.Experience with version control systems like GIT, and Azure DevOps. |
