Name: Saradkumar Patel Cell: 917-***-**** Email: adbhcf@r.postjobfree.com

Professional Summary:

Over 10+ years of strong experience in the IT industry as a MS SQL Server 2012/2008/2005/2000 Developer/BI Developer in various domains likes financial services, banking. Maintained positive communications and working relationship at all levels. An enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills with good work ethics.

10+ years of strong experience in multiple domains with expertise in MSBI full stake SSIS,SSAS,SSRS,T-SQL.

Expert in planning, designing, developing, implementing, administering, and maintaining MS-SQL Databases with some experience in Oracle and MySQL, Mongo and Cassandra DBs also.

Experienced in Logical and physical database design and development, data conversion and data modeling using Erwin and SQL Server Enterprise manager.

Proficient in database performance and troubleshooting at backend.

Experienced in normalizing databases for OLTP environments and de-normalizing tables for use in OLAP

Experience working in Azure DevOps, utilizing Continuous Integration and Continuous Delivery (CI / CD) with the Azure platform or SQL Server products strongly preferred.

Experience in Data architects, Datawarehouse, Data Pipe Line to obtain information from multiple source, process data, store data and create visualization on top of those data.

Experience in Experience in SQL objects like CTE, Functions, Triggers, Views, Stored Procedures, SSIS, Containers, Data flow tasks, SSAS cubes, SSRS reporting, Tableau visualization, Teradata database, Hive.

Experience in Big data technologies such as Scala, Spark, Hive, Python, HDFS, AWS, Looker, etc.

Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.

Extensively worked on understanding the business requirement, data modeling, ETL structure and convert manual process to automation using end to end data pipeline with visualization.

Experience reading click stream data, process click stream data and create visualization.

Experience in identifying areas of improvement and assist in overall delivery roadmap deliverables.

Experience in resolving on-going maintenance issues and bug fixes with development effort.

Worked on administration tasks such as Data loading, Batch Jobs, Data unloading, Backup & Recovery, User and Application Table Management, upgrades, creating Databases/File groups/Files/Transaction logs.

Ability to work independently or as part of the team to accomplish critical business objectives and to make decisions under pressure.

Actively looking for time and opportunity to learn and apply emerging technologies.

Excellent analytical. Communication and interpersonal skills.

Skill Set:

MS SQL Server Database, SQL, SSIS, DataStage, SSRS,SSAS, Teradata, C, C++, SQL, T-SQL, MS VISUAL STUDIO, MS ACCESS, Crystal Reports 8.5/ 9/10, ERWIN 7, Power BI, Workbench, Teradata SQL Assistance, Putty, Oracle, Tableau 10.5, Win SCP, Informatica, Tableau, Congnos, Looker, Spark, Hive, Scala, Python, Splunk, AWS, Big Query, MongoDB, Cassandra, Java, Unix/Linux.

Education Qualification /Certifications:

Master’s Degree in Computer Science, University of Bridgeport, USA 2009

Master’s Degree in Computer Application, North Maharashtra University, India 2007

Bachelor’s Degree in Computer Application, South Gujarat University, India 2004

Certifications:

Microsoft Certified Professional (70-433), Microsoft 2012

Advance Diploma in Computer Hardware and Networking, Jetking Institute, 2004

Seton Health Alliance, Austin TX Mar 2019 – To Present

Integration Developer

Seton Health Alliance is a clinically integrated network of nearly 2300 healthcare providers. Seton Health Alliance directly works for Accountable Care Organization (ACO). It is partnered with insurance company, Hospitals, Employers and patients for detecting early diagnostics and saves the life to deliver value-based care to central Texas location. Seton Health Alliance trying keeping patients Healthy.

Responsibilities:

Participating in gathering business requirement and implementation process.

Design and Develop application to meet data Integration and Processing requirements.

Developed end to end data pipeline, data products and analytics that needs to build and enhance to put financial, practice management, care management in position to succeed.

Developed T-SQL objects such as Stored Procedures, Functions, Triggers, CTES, Views, etc.

Create and troubleshoot complex SSIS Package for data integration process.

Developed SSRS, Tableau visualization reports.

Involved in creation of fact and dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services (SSAS).

Maintain metadata dictionary during end to end data pipe line process.

Created confluence documentation for all the product map and objects involved during data processing and visualization.

Created data pipeline using python.

Efficient in building hive, pig and map Reduce scripts.

SME’s for healthcare claims and membership attribution process.

Worked on data mapping for healthcare data.

Developed algorithms for healthcare simulation model.

Involved in performance tuning of SQL objects.

Experienced in Importing and exporting data into HDFS and Hive using Sqoop.

Worked on Spark, Scala, Hive to read data from AWS S3.

Administer and maintain development, test, production system.

Working in Scrum/Agile/Kanban methodology environment.

Ability to clearly communicate technical details to business and management.

HomeAway, Austin TX Aug 2017 – Mar 2019

Database Engineer/ Big Data Developer

HomeAway offers vocational rental to every traveler in the world through online marketplace.

Responsibilities:

Actively participated in performance tuning of existing database objects.

Developed new objects views, stored procedures, tables, CTE, tables, functions as per business requirements.

Performed data cleansing by creating tables to eliminate the dirty data using SSIS.

Migrated SQL procedures to spark framework using spark and Scala.

Worked on click-stream data to process on AWS S3 and HIVE.

Developed dashboard using Looker.

Developed validation script/ tools using spark and python.

Retrieve data from google using big query and created help portal dashboard using spark and looker.

Developed ETL process to load data from SSAS cube for finance metrics.

Worked on big data technology Spark, Scala, Hive, Qubole, Looker, AWS, Tableau, SQL tools.

Developed visualization dashboard for business personnel using Looker, Tableau, SSRS.

Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.

Developed data processing pipeline using spark and hive

Converted SQL stored procedure to Spark-Scala framework.

Actively involved in query and database optimization to increase performance.

Created documentation for all the objects, process for end used and future references.

Frontier Communication, Allen TX Mar 2016– July 2017

Sr. Database Engineer

Frontier offers a variety of services to customers over its fiber-optic and copper networks, including video, high-speed internet, voice and Frontier Secure digital protection solutions

Responsibilities:

Actively involved in gathering business requirements from business users and turned it into functional and technical specification.

Developed end to end process by retrieving data from OLTP systems, Flat files, and process to Data warehouse.

Architect and design database objects and processes for various stages of Data warehouse.

Developed processes to validate and ensure of data quality.

Developed data pipeline using, SQL stored procedure, SSIS Packages, SSAS Cubes, and visualization.

Involved in creation of fact and dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services (SSAS).

Converted the Oracle DB objects to MS SQL Server 2008 DB objects like Tables, Views, and Stored Procedures.

Developed and maintained a combined data store for reporting purposes.

Developed SSRS, Splunk reports for end users.

Designed a new schema for the data mart databases.

Actively involved in data warehouse architect for fact tables, dimension tables and data marts.

Used SQL Server Profiler to trace the slow running queries and the server activity.

Ability to learn quickly and deliver high quality code in fast-paced team environment.

Plan and execute technical program including developing, validating, executing, and delegating project technical processes and procedures. Serve as escalation point for technical project issues.

Proficient with software development lifecycle (SDLC) methodologies like Agile, Test- driven development.

Sirius-XM, Irving TX July 2015 – Feb 2016

Sr. MSBI Developer

Sirius XM is leading satellite Radio Company & provides telematics services in addition. I was responsible for Creating and maintaining data marts to help the company analyze the market for telematics services which helps in making appropriate business decisions.

Responsibilities:

Team member of agile project and responsible for project planning for sprints, participated in story building for multiple sprints.

Develop detail design documents, data structure diagrams and code assets supporting the Reporting implementation.

Collaborate with application developers, business owners, and operations to ensure the creation of production Business Intelligence designs and implementations

Provide technical assistance to the team on various MS BI Stack technologies

Develops Extraction, Transformation and Loading (ETL) processes to acquire & load data from internal and external sources using SSIS, SSAS and SSRS for visualization.

Collaborate performance tuning of BI process.

Developed strategies for ETL process, Report implementation, data acquisition, data quality and archive recovery.

Created SSIS DB Catalog and Deployed SSIS packages to catalog using Project deployment model.

Analyze, design, develop, unit test, document, and implement reporting applications using SQL Server Reporting Services SSRS and other related technologies.

Designed a new schema for the Data warehouse using Dimensional Modeling and developed it using the Erwin tool.

Perform weekly database checkup, shrink database according to instructions, and document weekly database activities.

Performed data cleansing by creating tables to eliminate the dirty data using SSIS.

Created documentation on the all the tables, stored procedures, views and user defined functions.

Verizon Irving, TX May 2012 – June 2015

Sr. MS SQL Server/ Teradata Developer/ DBA

Verizon is the leading wireless/wire line Telecommunication. Verizon creates advanced broadband and wireless solution that enhance our customer lives and drive growth across our industry and the economy.

Responsibilities:

Worked with business and operations teams to gather requirements.

Worked as SME for SQL, SSRS, and SSIS related issues, advising on several issues related stored procedures, ETL packages, reports and helping with any other technical issues.

Performed source system data analysis in order to manage source to target mapping.

Developed end to end data pipeline for Video On Demand product.

Developed ETL (SSIS packages) to load data from various sources into SQL server tables.

Developed stored procedures, CTE, Functions, Triggers, Views, for complex business logic.

Extensively used T-SQL to manipulate and architect to produce results for users.

Proficiently worked on various Teradata utilities Like BTEQ, MLOAD, FEXP, OLELOAD.

Architected and developed Fast Load and MLoad scripts in control file.

Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations using MDX.

Identified and modified the Key Performance Indicators (KPIs), measures in co-ordinance with the requirement.

Rebuild the indexes at regular intervals for better performance.

Involved in performance tuning of code using execution plan and SQL Profiler and added Indexes to improve performance on table.

Developed SSAS cubes for slice and dice for business users.

Developed Visualization reports and dashboard using SSRS, EXCEL, SSAS.

Responsible for ETL operation which extract and transform the data to Data Warehouse.

Documented all the processes involved in maintaining the database, ETL process for future reference.

Efficient in building hive, pig and map Reduce scripts.

Worked with offshore teams to synchronize development efforts to achieve deadlines.

Lender Processing Services, Jacksonville, FL Jan 2012 – May 2012

MS SQL/BI Developer

Lender Processing Services, INC (LPS) is a leading provider of mortgage and consumer loan processing services, mortgage settlement service, default solutions and loan performance analytics as well as solutions for the real estate industry, capital markets investors and government office.

Responsibilities:

Planned & Designed data based on business requirement and provided documentation.

Designing and implementing Data Marts, Facts, Dimensions and OLAP cubes having Star schema using dimensional Modeling principles in SSAS.

Implemented and delivered MSBI platform solutions to developed and deployed ETL, Analytical, reporting using SSAS, SSRS, SSIS.

Developed logging for ETL load at package level and task level to log number of records

processed by each package and each task in a package using SSIS.

Worked on Creation of extended properties for database table columns.

Worked on Performance tuning of SQL queries and stored procedures

Supporting the business and technical professionals in process improvement, technical designs, and quality assurance.

Creating dynamic queries to perform ETL operations by looping through multiple database servers and tables.

Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.

Documented and prepared project status report updates and audit reports

Ropes & Gray PPL, Boston., MA Oct 2011 – Dec 2011

MS-SQL/ ETL Developer

Ropes & Gray LLP is a leading global law firm Client by client to build a reputation for high quality work, a positive outlook and the highest standards of service and ethics.

Responsibilities:

Actively participated in rigorous team to decide on how to integrate the data.

Worked on SSIS project deployment, configure different environments, catalogs, environment parameter mappings and configured log settings at the server level for packages deployed in integration services catalogs.

Developed SQL programs and stored procedures as required for the ETL processes and data integration activities.

Used highly complex TSQL queries and SQL Scripts to perform efficient data load based on complex business rules and produced results for users.

Designing and developing SSIS ETL packages to validate, extract, transform and load data from OLTP systems to the data warehouse.

Used SSIS Package configuration to export various package properties to make package environment independent.

Converted the Oracle DB objects to MS SQL Server 2008 DB objects like Tables, Views, and Stored Procedures.

Created several ETL packages to import data from Oracle, SQL, Teradata, SharePoint, and files.

Worked on recursive CTE, to work with hierarchical data sets.

Emerging Health Information Technology, Yonkers, NY Jan 2011 – Mar 2011

MS SQL Developer

Emerging Health Information Technology (EHIT), Montefiore IT has the team, technology and tools to take you to a new level of patient care, revenue cycle optimization and operational efficiency.

Responsibilities:

Involving in requirement gathering, analysis, implementation, development, and production.

Optimizing the performance of queries with modifications in TSQL queries, removing unnecessary columns, and eliminating the redundant and inconsistent data.

Designing and developing the SSIS packages to import and export data from MS excel, SQL server 2005 and flat files.

Developing SQL programs and stored procedures as required for the ETL processes and data integration activities.

Developed Various SSRS reports for business and users and management.

Created dynamic reports using SSRS for the monthly connections and details of all locations, generated report models using report builder for the end users.

Indsoft System, Mumbai, India May 2007 – Nov 2007

SQL/ Dot.Net Developer

Effective communication is a key to ensure customer satisfaction and success for business of any size. Online communication is a form of correspondence that incorporates messengers. Forums, voice and video chat, photo and file exchanges and chat room.

Responsibilities:

Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Involved in the Data modeling, Physical and Logical Design of Database

Extensively using joins, stored procedures and sub-queries to simplify complex queries involving multiple tables.

Experience on normalization and de-normalization of existing tables for faster query retrieval.

Created documentation on the all the tables, stored procedures, views and user defined functions.

Contact this candidate