Home

Sai Krishna - Senior Data Engineer /SQL DBA SSIS,SSRS

[email protected]

Location: Dallas, Texas, USA

Relocation: Yes

Visa: H1B

PROFESSIONAL SUMMARY 11+ Years of Professional experience in Database Design, Programming, Development, and Implementation of Client-Server Applications & Database systems using MSSQL, Oracle, Informatica and Business Objects BO Crystal Enterprise 2013/2008. Led the implementation of Microsoft Fabric to streamline data management and analytics, improving data processing efficiency by 30% across network systems. Integrated Microsoft Fabric s data lake and data warehouse services into existing network architectures, enhancing scalability and reliability of data handling. Implemented advanced security features of Microsoft Fabric to safeguard sensitive network data, ensuring compliance with industry regulations and standards. Developed and enforced data governance policies using Microsoft Fabric s built-in tools to maintain data security and compliance across the network. Utilized ADF s cost management features to monitor and manage data pipeline expenses, ensuring cost-effective use of resources and optimizing data processing costs. Designed and implemented data integration solutions using Azure Data Factory (ADF), enabling seamless ETL /ELT processes across heterogeneous data sources. Developed complex data pipelines to automate data movement and transformation, optimizing data workflows and reducing manual intervention. Proficient in deploying and scheduling ADF pipelines to automate data processing and ensure timely delivery of information. Developed and deployed interactive dashboards and reports that improved business intelligence capabilities, providing key stakeholders with real-time insights into critical business metrics and performance indicators. Implemented data models and reporting frameworks that enhanced the organization s ability to monitor and analyze operational and financial data, leading to a 30% increase in reporting efficiency. Experience leveraging Python or Spring boot App to call service end points for retrieving data to load to tables for reporting. Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS. Created data sharing between two Snowflake accounts and created internal and external stage and transformed data during load. Redesigned the Views in Snowflake to increase the performance. Unit tested the data between Redshift and Snowflake. Experienced in Agile development mythology like SCRUM. Knowledge of experience with Git and Python. Experience working with Onsite offshore model and able to handle a team. TECHNICAL SKILLS: Database Technologies SQL Server, Oracle 10g SQL, PLSQL, Azure Programming Languages SQL, T-SQL, Python, DAX, Power Pivot, R Business Intelligence Tools MSBI (SSIS, SSRS & SSAS), Power BI, MS Access, Tableau, Snowflake Other Tools MS Office Suite, OLAP, OLTP, TFS, JIRA, Wrike, Python ETL Tools Data Transformation Services (DTS) Export/Import, SQL Server Integration Service (SSIS), Informatica, Cisco TIDAL, Azure ADF, Microsoft Fabric Reporting Tools Power BI, Snowflake, Tableau, SSRS, Power Query, Excel slicers. PROFESSIONAL EXPERINECE: Verizon Dallas, TX July 2023 Till Date Sr. SQL Developer / Data Engineer Led the migration of SSIS packages to Azure Data Factory (ADF), leveraging ADF s Integration Runtime to replicate existing ETL processes and enhance scalability in a cloud environment. Successfully re-engineered and deployed over 50 SSIS packages to Azure, optimizing data workflows and ensuring seamless integration with Azure cloud services. Analyzed and optimized legacy SSIS packages for performance improvements during migration, resulting in 50% reduction in data processing time and increased efficiency. Implemented Azure-optimized data flows and pipeline activities, achieving a 90% improvement in data throughput and reliability. Built and maintained scalable data pipelines in ADF to ingest, process, and transform data from various sources including SQL databases, cloud storage, and SaaS applications. Configured ADF pipelines to integrate migrated SSIS packages with Azure services such as Azure SQL Database, Azure Data Lake, and Azure Synapse Analytics, enhancing data accessibility and analytical capabilities. Utilized Azure Data Factory s mapping data flows and custom activities to extend and enhance functionalities originally built in SSIS. Monitored and managed the costs associated with running ADF pipelines and activities, optimizing resource allocation, and implementing cost-saving strategies during the migration process. Engineered solutions leveraging Microsoft Fabric s distributed computing resources to enhance network performance and scalability, supporting a 50% increase in data throughput. Monitored and fine-tuned Microsoft Fabric deployments to ensure optimal performance across high-demand network environments. Applied performance tuning techniques to ADF pipelines and activities, ensuring efficient resource utilization and minimizing operational costs. Integrated ADF with other Azure services such as Azure Data Lake, Azure SQL Database, and Azure Synapse Analytics to build comprehensive data solutions. Implemented data governance and security measures within ADF, adhering to best practices and compliance requirements. Leveraged ADF s data transformation capabilities to cleanse and normalize network data, ensuring consistency and quality for downstream analysis and reporting. Automated data pipelines to synchronize network configuration changes and performance updates with centralized data repositories for enhanced visibility. Integrated Oracle databases with network management systems to streamline data flow and improve network monitoring and reporting capabilities. Conducted performance tuning and optimization of Oracle databases to handle high volumes of network data, enhancing query performance and reducing latency. Developed and optimized dynamic SQL queries to handle complex data retrieval and manipulation tasks, improving query flexibility and performance for dynamic reporting needs. Utilized dynamic SQL to build parameterized queries and stored procedures, allowing for adaptable and scalable data access in response to changing business requirements. Managed data migration projects involving SQL Server, including the transfer of data between systems and databases, ensuring accuracy and consistency during dynamic data integration scenarios. Environment: ADF, Microsoft Fabric, Oracle SQL Developer, SSIS, Visual studio, MS SQL Server, Azure, TFS. HPHood Inc. Dallas, TX September 20 June 2023 Sr SQL Server Developer / Data Integration Developer Developed and optimized ETL workflows using SSIS to integrate and transform sales and manufacturing data from diverse sources, enhancing data accuracy and reducing processing time by 40%. Utilized Azure Data Factory (ADF) to orchestrate and automate data pipelines, enabling seamless data movement and transformation from on-premises and cloud sources into central data repositories. Designed and implemented multidimensional data models using SSAS, creating OLAP cubes that facilitated complex sales and manufacturing data analysis, improving query performance, and enabling more insightful business reporting. Built robust data warehouses for sales and manufacturing data, integrating disparate data sources to provide a unified view and support advanced analytics and reporting. Created interactive dashboards and reports in Power BI, providing actionable insights into sales performance, production metrics, and supply chain efficiency, leading to a 25% increase in decision-making speed. Developed custom Power BI reports that highlighted key performance indicators (KPIs) for sales and manufacturing processes, allowing stakeholders to easily monitor and analyze operational performance. Optimized SSAS cube performance by refining aggregations and improving query execution times, resulting in a 30% reduction in report generation time and enhanced user experience. Implemented data quality checks and validation rules within SSIS and ADF to ensure accuracy and consistency of sales and manufacturing data, minimizing errors, and enhancing data reliability. Established data governance policies to maintain high data standards and compliance across sales and manufacturing data sources, utilizing SSAS and Power BI for effective data stewardship. Collaborated with sales and manufacturing teams to identify key metrics and reporting requirements, ensuring that BI solutions were aligned with business objectives and supported strategic decision-making. Conducted in-depth analysis of sales trends and manufacturing performance using SSAS and Power BI, providing actionable insights that drove process improvements and operational efficiencies. Created and managed OLAP cubes in SSAS, enabling advanced analysis and reporting on sales performance and manufacturing metrics, enhancing data-driven decision-making. Designed and implemented interactive Power BI dashboards and reports, providing real-time insights into sales performance, and manufacturing efficiency, leading to a 25% increase in actionable insights. Optimized data processing and reporting workflows by tuning SSIS packages and SSAS cubes, resulting in a 30% reduction in report generation time and improved user satisfaction. Scheduled and monitored SSIS packages to run as part of automated data workflows. Collaborated with business stakeholders and IT teams to identify requirements and troubleshoot issues related to data integration. Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers. Worked with Cross Platform teams in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects. Environment: Power BI, Tableau, SSAS, SQL Developer, SSIS, Visual studio, MS SQL Server 2016, Azure, TFS. Dean Foods (Dairy) Dallas, TX July 19 September 20 Sr. SQL Server Developer / Consultant Design Created various SSIS packages to extract data from one data source and load it into other data warehouse. Created SSIS packages to import the data into SQL server. Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes. Involved in Troubleshooting of the already existing SSIS packages. Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling. Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging. Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources. Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management. Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis. Produced attractive visuals/dashboards to convey the story inside the data. Evaluate Snowflake Design considerations for any change in the application. Build the Logical and Physical data model for Snowflake as per the changes required. Define roles and privileges required to access different database objects. Define virtual warehouse sizing for Snowflake for different types of workloads. Changes to existing SSIS packages to handle SCD Type 2 Dimension and Lookup Transformation. Environment: Tableau, Snowflake, Power BI, SQL Developer, SSIS, MS SQL Server 2016, Informatica, Visual studio, TFS, VSTS. DaVita Medical Group, Los Angeles, CA March 19 July 19 Sr SQL Server Developer Experienced in designing and development of Tableau visualizations and creating business requirement documents and plans for creating dashboards. Designing, creating, and publishing customized interactive reports, dashboards, and scheduling using Tableau Server. Created action filters, sets, parameters, and calculated sets for preparing worksheets and dashboards in Tableau. Created Tableau scorecards, dashboards using bar graphs, scattered plots, stack bars geographical maps, Gantt charts using show me functionality. Created detailed level summary report using Trend lines, Statistics, log axes, groups, and hierarchies. Created reports based on research solutions to payors, insurers and their partners which help them build healthcare ecosystems that optimize value. Delivered reports that value proposition to payers within accounts to convince them of product value. Wrote Complex SSRS Expressions and built the reports in Ad hoc Tool called Report Builder, Used Drill down, Drill Through, Parameterized functionality in the reports. Created SSIS packages to capture the Incremental changes for the Data warehouse. Responsible for collection, analysis and maintenance of data focused on the department's goals. Created dashboards using Tableau and SSRS, Designed and Developed reports from multiple data sources by blending data on a single worksheet in Tableau Desktop. Created different Ad hoc reports for Inpatient and outpatient assigned care managers and loaded in to report manager and scheduled reports daily, weekly basis. Create and manage Reports subscriptions and schedules SSRS reports. Environment: MS SQL Server 2012/14, SSRS, Tableau, Oracle/SQL Developer, SSIS, Visual studio 2008,10,14. Health Net (Centene) - Sacramento, CA April 18 February 19 Senior SQL Developer: Lead in building architecture and programming reporting tools, acting as lead to troubleshoot technical issues and refine SQL coding for reporting, and maintain databases as necessary. Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task. Created SSIS packages to import the data into SQL server. Developed SSIS packages to fetch data from source DB, manly for running multiple scripts in parallel and Performing bulk insert using SSIS Script task. Completed 6 major Reports/Data visualization using Power BI and gain strong application development and understanding on Payor and provider business. Developing SQL script in a way to fetch data from several old databases and store it to the staging Developed various types of reports by using excel slicer tool that shows providers performance on region, county levels. Environment of Umbria system as delta pull. Developed SQL scripts to transform and populate data into the production environment ensuring execution Environment: MS SQL Server 2014,2016, MS Access data base, SQL Server Reporting Services, SQL Server Integration Services (SSIS), Power BI, Excel Slicers, ETL, Visual Studio, OLAP, SharePoint. Superior Vision - Sacramento, CA April 16 March 18 Sr. SQL BI Developer Worked with end users in understanding the requirement and have designed the reports accordingly. Identified the required data objects in the database and created various T-SQL and PL/SQL complex queries to pull data for reports. Created reports on claims, Billing/Finance, Provider Relations, Accounts Management and Fulfillment using SSRS and Crystal Reports. Experience with SQL Server Reporting Services (SSRS) and Power BI to author, manage and deliver paper- based, Web-based reports and Interactive Dashboards. Created reports using SSRS from OLTP and OLAP data sources and deployed on report server. Generated custom and parameterized reports using SSRS. Created Parameterized reports, linked reports, Crosstab reports, Drill down reports & Summary reports by Using SSRS. Created various types of SSRS reports like drill down, drill through, sub reports, Nested Chart reports and create report parameters included single valued parameters, multi-value parameters which also consisted of different parameter type s queried and non-queried parameters. Developed SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails. Created various SSIS packages to extract data from one data source and load into other data warehouse. Environment: MS SQL Server 2012, 2014, 2016, SQL Server Reporting Services, SQL Server Integration Services (SSIS), ETL, Business Objects XI 4.0/3.1, Crystal Reporting 2013/2008, Info View, CMC, Visual Studio, OLAP. TransUnion, Chicago, IL. Oct 15 March 16 Sr. SQL BI Developer Involved in database development using stored procedures, triggers, views, and cursors. Converted, loaded, and integrated data from Access, Excel, text.csv files and internal database applications including the mainframe with data captured for security applications Developed complex reports like Drill capabilities, Complex freehand SQL queries, Functions, Master Detail, and Cross Tab with multiple breaks. Implemented SSIS data transformation scripts, created maintenance procedures, and provided data integrity strategies. Generated reports using Crystal Reports and Developing SQL stored procedures, views, and triggers. Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files. Environment: SQL Server Data Tools, SQL Server Business Intelligence Development, SSRS. arRGee Solutions, India July 13 March 15 Database Developer Designed logical and physical models for staging database and data warehouse using Erwin database modelling tool. Created database projects for staging database and data warehouse in visual studio 2008, to store all related objects at one centralized location. Designed the entire ETL process involving the access, manipulation, analysis, interpretation, and presentation of information from both internal and secondary data sources to the business. Created complex ETL (SSIS) packages to pull data from DB2/Oracle, load monthly data from Excel to SQL server. Create SSRS reports against Team Foundation Server Database. Environment: SQL Server 2008, Transact-SQL, SQL Server Integration Services, Visual studio, C#.Net, Windows Server EDUCATION: Master s in computer science from Northwestern Polytechnic University, USA, 2015. Bachelors in Electronics and Communications from TRR engineering College, India, 2013. Keywords: csharp business intelligence database active directory rlang information technology microsoft procedural language California Illinois Texas