Sql Server Ms
Resume:
Sirija
******.*.****@*****.***
Professional Summary:
●Over 6+ Years of IT experience which includes System Analysis and Design, Development including SSRS & Support of MS SQL Servers 2008/2008 R2/2012, 2014, 2016, 2017, 2019 in Production, QA and Development Environments.
●6 years of IT experience in designing and development of database/BI application using MS SQL Server, Data and Business analysis, ETL Development.
●6+ years of experience in IT as Sr. Microsoft Business Intelligence Developer, working in various domains such as HealthCare, Telecom, Finance, Retail, and Insurance using MS SQL Server 2017/2016/2014/2012/2008R2/2008 SQL Server Integration, Reporting & Analysis Services.
●4+years of experience in PowerBI Desktop, Tableau, Tableau Desktop, Tableau Analyst, PowerBI Service, PowerBI Pro, PowerBI Premium.
●4+ years of experience in Azure Cloud, Azure Data Lake Storage, Azure Data Factory, Azure Analytical Services, Azure Blob Storage, Azure Analysis Services, Azure Synapse, Apache Spark, Python, Data bricks.
●Created SSIS/SSDT Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2019/2016/2012
●Experience with Stored Procedures, Stored Functions, Database Triggers, and Packages.
●Strong SSRS technical & business background encompassing the complete lifecycle of project – design, development, testing, validation, deployment and support with strong focus in Report Development using TFS and SVN tortoise for versioning
●Strong experience with SQL in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables.
●Ability to work in all stages of System Development Life Cycle (SDLC).
●Experience in Error handling and debugging coding issues and troubleshoot production problems.
●Strong Azure Administration and troubleshooting existing Issues with Azure Data Factory and Azure Data Lake
●Experience using troubleshooting tools to identify performance problems like SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance, Wireshark, Active Directory LDAP etc.
●Experience using Toad for use different DB tools like Sybase, Oracle 11g, Oracle 12c
●Extensive experience on building Dashboards using SSRS and Power BI
●Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
●Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
●Experience Using SSIS creating Pkgs using Control flow, Data Flow, For Loops, For each, Script tasks, Flexible File Tasks Azure tasks
●Created SSIS/SSDT Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2019/2016/2012
●Experience working in a DW doing data loads and transformations from different sources excel files, db, flat files etc.(ETL)
●Experience in Managing Security of SQL Server 2008 R2 and 2012 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
●Experience in developing Dashboard, Ad-hoc and Parameterized Reports, Create complex reports (ex: drill down reports using different objects) using SSRS.
●Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
●Experience in .NET/C# application development environment to use SQL Server Databases.
●Experience with JDA Workforce Management for Retail tool 2017, 2018, 2019 EP and Persona.
Educational Details:
Bachelors from Ellenki University in 2015 (Hyderabad, India)
Masters from Concordia University in 2023 (IL)
Skills & Technologies:
Tools & Packages: SSMS, SQL Profiler, SQLServer, Visual Studio, DTS, Report Builder 9.0, SSRS, SalesForce lighting, CA Service Desk Manager, Jira, Service Now, Sharepoint, Azure Kubernetes, LDAP, CA Siteminder, CA Federation, Wireshark, Pycharm IDE, Flyway, Azure Data Factory, Azure Data Lake, File Shares
BI Tools: SSRS, PowerBI, Xtraction, Tableau, SSIS, SSRS, SQL*Loader, Quality Center 9.2, Clear Quest
Databases: MS SQL Server 2008R2/2012/2014, 2016, 2017 Oracle 10g, 11c, Sybase, PostgreSQL, Cassandra
Language: T-SQL, VB.net, C# (.NET), DAX, Python,
Operating Systems: Windows 10, Windows Server 2003/2008/2012, 2016, 2019, Linux CentOS, MacOS Catalina
Programming: T-SQL, C, C#, LINUX (Shell Scripting), .NET, Python
PROFESSIONAL EXPERIENCE:
Cigna Health Care CT Apr2024 - Present
SQL Developer
The Cigna Group is a global health company committed to improving health and vitality. Cigna relentlessly challenge ourselves to partner and innovate solutions for better health. Cigna global workforce of more than 70,000 colleagues work through Cigna Healthcare and Ever north Health Services to fulfill our mission to improve the health and vitality of the more than 178 million customer relationships and serve in more than 30 countries and jurisdictions. The goal of this project is to design systems to store and process data in a way that can be used by applications, business users, and BI systems using SQL Server Data Tools. And to Design, develop, maintain Power BI reports and assist in an overall data, business intelligence and reporting strategy.
Responsibilities:
●Involved in Analysis, Planning and Defining data based on business requirements and provided documentation.
●Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts
●Utilized Power Query in Power BI to Pivot and Un-Pivot the data model for data cleansing
●Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
●Embedded PowerBI reports into salesforce and web page using PowerBI URL parameters
●Collaborated with business and technical stakeholders to understand requirements, identify data gaps, and deliver actionable, data-driven solutions.
●Implemented data validation processes, troubleshooting issues to ensure high-quality data outputs and integrity across systems.
●Developed and created new and existing SQL Server Reporting Services (SSRS) reports.
●Created reports, dashboards, stories and visualization reports by using SSRS, Power BI and Tableau Reporting.
●Designed and normalized the databases, have written T-SQL Queries and created different objects like Tables, Views, Stored Procedures, User defined functions and Indexes.
●Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
●Responsible for development of orchestration for ingesting data, and in building and visualizing reports in self-service mode by using Power BI using Azure Synapse
●Used various Spark Transformations and Actions for cleansing the input data.
●Implemented Spark using Scala and Spark SQL for faster testing and processing of data.
●Responsible for performing sort, join, aggregations, filter, and other transformations on the datasets using Spark.
●Extracted appropriate features from data sets in order to handle bad, null, partial records using Spark SQL.
●Analyzed the SQL Scripts and designed the solution to implement using PySpark
●Created, provisioned different Databricks clusters, notebooks, jobs and auto-scaling.
●Implemented Spark using Scala and Spark SQL for faster testing and processing of data.
●Data sources are extracted, transformed and loaded to generate CSV data files with Python programming and SQL queries.
●Worked on data pre-processing and cleaning the data to perform feature engineering and performed data imputation techniques for the missing values in the dataset using Python.
●Used Copy Activity in Azure Data Factory to copy data among data stores located on-premises and in the cloud
Environment: MS SQL Server 2017/2016/2014, SQL Server Management Studio, BIDS, Snowflake, Power BI, PowerApps, DAX, Tableau Desktop, Tableau, Jupyter, T-SQL, Visual Studio 2017, U-SQL, Python, R, R Studio, Apache Spark, Scala, Azure Databricks.
Applied Materials Dallas TX Jan 2020 - Jul 2022
ETL&SQL Developer
Responsibilities:
●Developed SSIS packages using Lookup Transformations, Merge Joins, and Derived Columns with Multiple Data Flow tasks
●Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases
●Actively participated in interactions with users, technical manager to fully understand the requirement of the system.
●Analyzed the existing business requirements in Tableau designed and developed various information to diverse group of users, clients and mangers.
●Created conditional filters to filter the data on single worksheets and dashboards with parameters for desired functionality.
●Created SSIS packages to load multiple delimited files into SQL server table.
●Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services
●Interacted with Business analysts to understand data requirements to ensure high quality data is provided to the customers
●Worked on completing the metadata documentation for the projects.
●Good knowledge on Application Programming Interfaces like ODBC drivers for Teradata, JDBC drivers for Teradata, Teradata CLI.
●Created multi-set tables and volatile tables using existing tables and collected statistics on table to improve the performance.
●Performed Dual Data Validation on various Businesses critical reports working with another Analyst.
●Designed stunning visualizations using tableau software and publishing and presenting dashboards on web and desktop platforms.
Environment: SQL, SSIS, Tableau desktop 10.3, HTML, Teradata, CSS, UNIX, Access, MS Excel, MS Power Point, Business Objects.
Great West financial Denver, CO Jul 2017 - Dec 2019
SQL BI Developer (SSIS/SSRS)
Great-West Financial is the nation's second largest insurer in sales of individual life insurance through banks. In addition to term and single premium life insurance, they offer annuity products, executive benefits products and investment services. This company’s financial strength and stability are reflected by strong ratings from major rating agencies.
Responsibilities:
●Key role in team of 4 in bringing 2005 SQL database environment to SQL 2008R2 by migrating, converting and re-writing DTS packages and updating them to SSIS packages.
●Extensively worked on Data Flow tasks like for each Loop Container, execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
●Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.
●Used SQL Server Package Configuration technique to make Dynamic configurations.
●Used Text Files/ SQL Server Logging for all SSIS packages.
●Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
●As a SSRS developer generated various reports like Tablix, Matrix, Graphs Reports and parameterized reports in SSRS 2008.
●Deployed and configured the reports in the Report Server.
●Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
●Generated parameterized/Drilldown, Drill Through & Cascaded reports using SSRS
●Worked with various SSIS packages which involve Transactions, restart ability and roll back techniques.
●Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
●Created SQL Server Reports using SSRS 2008 and exported them to Excel format for managers and QA team for easy validation and Identified and worked with parameters for parameterized reports in SSRS 2008/2005.
●Report Development in SSRS (Reporting services) and delegate work to track the progress.
●Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
●Responsible for rebuilding the indexes and tables as part of performance tuning.
●Monitored performance and optimize SQL queries for maximum efficiency.
●Used SQL Server Agent for scheduling jobs and alerts.
Environment: SQL Server 2012/2008R2/2008/2005, SSRS 2008, SSIS 2008, SSAS, Data Stage, DB2, Visual Studio 2005, XML, XSLT, SSAS, MS Office and Visual source safe.
Reena InfoTech Hyderabad, India July 2015 – Jun 2017
Software Developer
Responsibilities:
●Interacted with Team and involved in Analysis, Design and Developing databases using ER Diagram, Normalization and relational database concepts.
●Involved in Design, Development and testing of the system.
●Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan)
●Applied Normalization rules in designing the database.
●Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
●Developed database objects like Tables, views, stored procedures, indexes etc.
●Tuned SQL statements using views and Stored Procedures.
●Rebuilding the indexes at regular intervals for better performance.
●Wrote various stored procedures for application development.
●Wrote SQL Scripts to select the data from the source. Designed and implemented data access stored procedures and triggers for automating tasks.
●Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
●Implemented Exceptional Handling.
●Creating and automating the regular Jobs.
●Tuned and Optimized SQL Queries using Execution Plan and Profiler.
●Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
●Involved in performing database Backup and Recovery.
●Worked on Documentation using MS word.
Environment: SQL Server 2012/2008R (2)/2005, SQL, T-SQL, BCP, Microsoft Visual Basic 6.0 and Windows 2000
Contact this candidate