| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Forth Worth, TX, Street Address
PHONE NUMBER AVAILABLEEMAIL AVAILABLESummaryOver 5 years as MS SQL Server/ETL/Business Intelligence developer, designing T-SQL queries, ETL packages, and reports.Proficient in SQL Server versions 2022 to 2008 R2, Visual Studio, SharePoint, and Windows Server environments.Expert in T-SQL, developing Stored Procedures, UDFs, CTEs, Triggers, and optimizing queries for performance.Experience in query optimization, performance tuning, and analysing Execution Plans.Expertise in creating, documenting, and deploying ETL packages for data warehouses and data marts.Leading experience in data cleansing, validation, and loading using SSIS transformations.Proficient in designing and developing reports in SSRS, including Sub-Reports and Parameterized Reports.Tableau skills for creating visualizations, building dashboards, and customizing reports.Strong understanding of Enterprise Data Warehouse (EDW)/Operational Data Store (ODS) modeling concepts and SDLC methods.Strong analytical, problem-solving, and communication skills; capable of working independently or in a team in a fast-paced environment.Knowledgeable in data modeling with Erwin tools, Data Warehouse concepts, and front-end interface development.Experience in UNIX, SQL Loader, and Oracle-supplied standard packages, with a proven ability to plan and implement Full Life Cycle software development projects.TECHNICAL SKILL SET:RDBMS/OLTP: MS SQL Server 2022/2019/2017/2016/2012/2008 R2ETL: SQL Server Integration Services(SSIS), SQL Server Data Tools(SSDT)Reporting: SQL Server Reporting Services(SSRS), SQL Server Report Builder 1.0/2.0/3.0, Tableau 8/9/10Performance Tuning: Execution Plan Analysis, SQL Server Profiler, Database Engine Tuning Advisor, Index Design, Table PartitioningLanguages: T-SQL, C++, MatLabDevelopment Platforms: Visual Studio 2022/2019/2017/2015/2012/2008, SharePoint,Windows Server 2012 R2, Team Foundation Server(TFS)PROFESSIONAL EXPERIENCE:SQL /POWER BI DEVELOPER TENET HEALTHCARE DALLAS, TEXASNov 2022 PresentEnvironment: MS SQL Server 2008/2012/2014 (Query Analyzer, SQL Profiler), SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services), SSAS (SQL Server Analysis Services), Power BI, Power View, Business Intelligent Studio, SQL Server Management Studio, Confidential -SQL, MySQL, OLTP, Oracle 11g, MS Excel, Windows XP Professional, TFS, MicroStrategy10.x/9.xResponsibilities:Collaborated with managers and end-users to define business requirements and implemented effective business intelligence solutions.Developed T-SQL queries, stored procedures, triggers, and user-defined functions for performance improvement.Designed and implemented ETL processes for data migration and data warehouse maintenance.Designed and implemented CI/CD pipelines using Python, Perl, and AWS APIs to streamline deployment processes.Administered, configured, and engineered technical systems on the AWS platform, ensuring high availability and scalability.Led application migrations to AWS Cloud, providing continuous support for cloud-based and on-premise applications.Led the migration of on-premises databases to AWS Cloud, leveraging AWS services such as Lambda, Glue, and Step Functions.Designed and implemented data pipelines using Snowflake, ensuring seamless data flow and integrity.Developed, debugged, and optimized complex SQL statements, PL/SQL packages, and procedures.Utilized Aurora Postgres to enhance database performance and scalability.Managed API to database connections using relational database drivers including Oracle and PostgreSQL.Implemented CI/CD pipelines using Maven, Jenkins, Terraform, and GitHub, streamlining development and deployment processes.Ensured data quality and governance across various projects, adhering to industry best practices.Developed and maintained scripts for automation of routine tasks, enhancing efficiency and reducing manual intervention.Ensured data integrity and security through best practices in AWS architecture and deployment strategies.Utilized SSRS and Tableau for report and dashboard development.Created SSIS Packages for loading the data from various interfaces like Orders, Adjustments, and Objectives.Worked on SSIS package, DTS Import/Export for transferring data from database (Oracle and Text Format data) to SQL Server.Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files.Involved in writing Stored Procedures and User-Defined Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.Installed and Configured MS SQL Server successfully.Developed and implemented integration solutions using Dell Boomi AtomSphere platform to connect cloud-based and on-premise applications.Conducted unit testing, system testing, and user acceptance testing to ensure the quality and reliability of software solutions.Developed multiple dashboards with Power BI depicting differing KPIs for business analyses.Implemented Power BI for data visualization and reporting purposes.Utilized Azure and AWS services for cloud-based data storage and analytics solutions.Implemented High Availability Concepts, Database Mirroring, Replication, and log shipping in SQL Server environments.SQL/SSIS/SSRS DEVELOPER VIZIENT, INC IRVING, TEXASFeb 2021 - Oct 2022Environment: MS SQL Server 2008 R2, MS SQL SERVER 2014/2016, SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services), SSAS (SQL Server Analysis Services), Power BI, Power View, Visual Studio 2008, SharePoint, SQL Server Management Studio, ASP, Toad Data Modeler 5.1, SAS Enterprise Guide 4.3, Teradata SQL assistant, MicroStrategy10.x/9.x.Responsibilities:Migrated data from Oracle legacy system to SQL Server using SSIS packages.Designed ETL packages for data transformation and loading, ensuring adherence to business requirements.Implemented data mapping, business unit mapping, and verified data structure using SQL queries.Developed and deployed reports using SSRS, including parameterized and drill-down reports.Created SSIS reusable packages to extract data from multi formatted Flat Files, Excel, XML files into UL Databases and DB2 Billing system.Developed, deployed, and monitored SSIS packages.Wrote complex SQL queries using joins, subqueries, and correlated subqueries to retrieve data from the database.Created Data Mapping Document (DMD) by analysing various OLTP data sources.Implemented Business Logic utilizing CTEs, Temporary Tables, Table Variables, Dynamic SQL, and System/Aggregate/Ranking Functions.Scheduled reports for daily, weekly, and monthly reports; created reports for executives, business analysts, and customer representatives based on business needs.Worked on POWER BI to collect the data and update Excel reports as per business requirements.Conducted data profiling and analysis to ensure data accuracy and consistency.Integrated DevOps practices to automate and monitor data workflows using tools like Ansible and Jenkins.Provided technical expertise in data lineage and governance, ensuring compliance with data policies.Imported Data from Multiple data sources Teradata/SAS/SQL server, including Web files, MS-Excel, through OLEDB and ODBC connections, Text, CSV files.JR. SQL DEVELOPER FIRST CONVENIENCE BANK GRAPEVINE, TEXASFeb 2019 - Jan 2021Environment: SQL SERVER 2008 R2/2008/2005, SSIS, SSRS, Confidential -SQL, SQL AZURE, Power shell, SSMS, Operations workbench, SCOM, IIS, SCSM, Windows 2008 R /NT/XPResponsibilities:Developed T-SQL queries, stored procedures, and views for data integration and extraction.Optimized ETL package performance and deployed them using SQL Server Agent.Created financial analysis reports and dashboards using SSRS/Tableau.Ensured data integrity and security through integrity constraints and database triggers.Supported and configured high-availability solutions for mission-critical SQL Server databases, including clustering, mirroring, and Transactional replication.Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, critical server events, and security alerts.Managing permissions for user/logins and assigning server/database roles.Troubleshooted and resolved database issues, including connection string from application in web config, and coordinated with web services tier to resolve.Performed daily operations including monitoring, storage management, backups, and index maintenance.Resolved complex issues and advanced troubleshooting production OLTP Databases.Error handling, monitoring, and troubleshooting SQL server Agent jobs.Tier 3 Support for database issues escalated 24x7 including nights and weekends.Key Achievements:Successfully improved performance on existing stored procedures and queries through analysis and tuning.Implemented effective naming conventions for SSIS/SSRS packages, enhancing tracking and management.Migrated data from Oracle legacy systems to SQL Server, improving overall system efficiency. |
