Sql Server Technology Specialist
Resume:
Murali Kundrapu
PROFESSIONAL SUMMARY:
Around 16 years of Professional experience in IT industry as a SQL Server /BI developer /Data Modeler /Report Analyst
Microsoft certified technology specialist (MCTS) and certified information technology professional (MCITP) in SQL server 2005
Microsoft certified technology specialist MCTS for business intelligence
Information gathering, analyzing the information gathered, documenting the functional or business requirements
Good SQL Server 2000/2005/2008/2012/2014/2017 and 2019 Administration skills including user authorizations, Database creation, backup, restore, replication, scheduling and clustering
Familiarized with Snowflake SQL in Microsoft Azure
Worked on Front End Application Like Salesforce, MS Dynamics and custom-built apps with .net, Delphi
Exposed to Cloudera technologies to AWS with open Source Hadoop frame version (hartonworks)
Experienced in pulling data from Upstream Sources into staging and eventually destinations using SSIS
Converted reports from crystal and MS Access to SSRS
Used C# for script task within SSIS, both to call Rest API and retrieve data through Flat Files, Outlook
Expertise in Manual Testing, Mainframe Testing, Automation Testing and Database Testing
Excellent understanding of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Test Methodologies from project definition to post deployment
Good experience with writing and utilizing SQL queries for data verification in Oracle and other RDBMS
Upgrading data to recent versions from earlier versions using MS Access, SQL server
Experienced in using Data Modeling tools like Visual Studio, ERWIN, MS-Visio
Extensively used crystal reports, SSRS to generate reports based on the client needs
Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS/SSIS Packages.
Experienced in converting crystal reports to SSRS reports
Understand the Map-Reduce algorithms and make use of horizontal Computing in Cloud Storage
Experience in Data Conversion and Data Migration from earlier versions to current SQL server using SSIS and DTS services across different databases like Oracle, MS access and flat files.
Extensive exposure in SSIS, SSRS and SSAS and charting tools like graphical charting
Good knowledge of share point 2007 in managing documents creating workspaces. Exposure towards moss 2007 and performance point.
Knowledge on MES, TFS, MDX, Replication understanding C#, .net (validated applications using asp.net) concepts
Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.
TECHNICAL SKILLS:
Operating Systems
Windows 2003 / NT / XP/ME/9.X, UNIX (Solaris 8.0/9.0)
Languages
C, C++, VB 6.0, T-SQL, VB Script, C#
Web Technologies
HTML, WML, XML
Databases
MS SQL SERVER 2016/2014/2012/2008 / 2005 / 2000 / 7.0, MS Access 2003, ORACLE, MySQL RedShift, DybamoDB
Packages
G-Track, JIRA, MLH, MS Visio, MOSS 2007, ERWIN, CSS, VSS, TFS, Visual Studio, Sarema Dimensions, Workfront, JIRA, Salesforce, Eloqua
Testing
Win Runner, Load Runner
ETL tools
DTS, SSIS, SSAS, SSRS, InformaticA, ProClarity, Crystal Report 9/11,Power Bi
Database Tools
SQL Enterprise Manager, SQL Profiler, SQL Agent, SQL Alerts, SQL Mail, SQL Client Configuration utility, Backup Server, Replication server, OLAP Services, Replication Tools
EDUCATION & CERTIFICATIONS:
Master’s in computer science/IT, NMT (NEW MEXICO TECT)
Bachelor’s in information technology, Madres University
[70-768] Developing SQL Data Models in SQL SERVER 2016
Microsoft certified technology specialist (MCTS) in SQL SERVER 2005
Microsoft certified in designing database solutions using SQL SERVER 2005
Microsoft certified (MCITP) in designing and optimizing using SQL SERVER 2005
Microsoft certified (MCTS) in SQL SERVER 2005 Business Intelligence
Certificate of Appreciation: Molina Healthcare, Inc.
SIGNIFCANT PROJECTS - EXPERIENCE:
First American Title Insurance, Remote Jan 2024 – Present
SQL Developer / BI Developer / ETL Developer
Project Description:
To consolidate All State and County to a National Wide Implementation
Created new Tables, Stored Procedures and Functions as per the technical document.
Worked with Snowflake to write ETL’s based upon CDC on SQL Server Tables
To establish a single process and application that supports the process for complaint capture, product analysis, and vigilance reporting, and trending at a franchise level
Implemented Normalized database from scratch, Using Stored Procedures and SSIS Packages
Troubleshoot Stored Procedures either to improve performance or identify the bug ‘s reported and worked toward the fix
Designed and automated different types of reports using SSRS.
Used Snowflake SQL to Write ETL’s and Query Materialized views.
Create joins and sub-queries for queries involving multiple tables.
Data migration using ETL scripts, in order to create a new environment to avoid the discrepancies while doing reporting
Environment: SQL Server, SSRS, SSIS, DTS, MS-Visio, Snowflake, Microsoft Azure
PivotBio/Dwebware-Remote Aug 2021– Dec 2023
SQL Server / SSIS Developer / Report Analyst
Project description:
This Project is primarily about marketing and making the Rep’s to sell more nitrogen and other agriculture related to the lamd/farms throughout the world
Involved in re-writing reports/SQL Queries from OLTP environment to support reporting in Tableau.
Designed and engineered the flat file data formatted and automated the process to pull data and post it to Share Location
Used VB Script to format excel files for various trustees.
Involved in Database Administration roles like monitoring, production support and assigning roles
Designed packages using SSIS to load legacy data and to call web service tasks
Worked with XML Files to load/ pull data to/ from database.
Hands-on experience using PL/SQL while converting procedures from SQL Server to Oracle
Worked with other clients to deploy reports (SSRS) to various environments
Experienced in Creating linked, sub reports to enhance the drop down and drill through capability.
Migrated DB; s to AWS RDS as part of server Upgrade and moving to Cloud Environment
Made use of the Tablix report object to created reports and to avoid unnecessary grouping
Environment: SQL Server 2016/2019, SSRS, SSIS, DTS, MS-Visio, T-SQL, RDS
AvanGrid, Rochester, NY Feb 2020 – Aug 2021
SQL BI/backend/Admin
Project Description: Physical Security
Experienced working Air-Gap Environments, worked under Nerc-Cip standards to tightly secure retrieving the Data From DB
Have Setup both SSIS and SSRS to retrieve data into a Common Point and have reports run from the Collection Point, Parsed Json Files
To establish a single process and application that supports the process for complaint capture, product analysis, and vigilance reporting, and trending at a franchise level
Worked with business users to define and analyze problems, create logical data model, implement physical data model, and the implications of business solutions to the current and future environment
Worked in Agile environment following full SDLC
Supported Veeam Backup failures and handled addressing issues in both full/incremental Backup’s
Identified new process, finding out gaps in existing process, arranging training modules for new process development, and implemented.
Create joins and sub-queries for queries involving multiple tables to retrieve data into the UI from SQL Server
Have Support HA Environment/Standalone Clustering
Manually applied Patches on a monthly basis and also addressed issues incase of dead Locks
Environment: SQL Server 2014/2016/2019, IBM Rational 6.6, Json, SolarWinds Orion, Windows 10
NextGen HealthCare, Rochester, NY June 2018 – Feb 2020
SQL/backend Architect
Project Description: Workstream EDH Tool Enhancements
EDH tool is an UI interface to healthcare providers and doctors to see various metrics of patients and bring them back to be at good health while closely monitoring /analyzing the history of the patient
Created new Tables, Views and Functions as per the technical document
To establish a single process and application that supports the process for complaint capture, product analysis, and vigilance reporting, and trending at a franchise level
Worked with business users to define and analyze problems, create logical data model, implement physical data model, and the implications of business solutions to the current and future environment
Worked in Agile environment with two-week sprints following full SDLC
Identified new process, finding out gaps in existing process, arranging training modules for new process development and implemented
Worked on DynamoDB, redshift and orchestration instances of AWS
Worked on Java(datamover) to move data between DataBases
Create joins and sub-queries for queries involving multiple tables to retrieve data into the UI from MySQL
Created Patches to migrate data into DynamoDB and initialize aggregations for the metrics defined at each tenant level
Environment: Java, MySQL, AWS, python, Putty, GIT, JIRA, VScode
Getty Images, Seattle, WA Mar 2017 – June 2018
SQL Server \ Data Warehouse \Application Developer
Project Description: Eloqua Data Flow Management
Eloqua is a marketing component and an email hub to send appropriate emails to its cutomer’s/client’s based upon the type of flow(new customer, uncoverted cart etc) they are involved and part of their flows also interact with Sales force for the sales rep to directly interact and work towards the closure of an aspect
Involved in re-writing SQL Scripts and SSIS Packages to enhance performance within EDW environment
Worked on C# Scripts with SSIS to call Rest API to retrieve and push data to Eloqua
Reverse engineering and De-bugging SSIS packages and Data Flows as part of PS
Worked with the marketing team to gather requirements as per their needs for several campaigns
Unit tested and code reviewed Proc’s following SDLC life cycle
Used different database objects to fix the existing issues
Handled and addressed various ad-hoc and Data Extract Workfront Tickets on a priority basis
Worked on T-SQL scripts to make changes and load data into Data Warehouse
Worked on C# to break up data from Various Sources to load tables as per the requirements
Used Cozy/Roc within SSIS to Integrate with Salesforce Objects
Involved in Migrating/storing Database Using AWS utilizing S3 Storage into Cloud
Utilized Gsync to build groups and scheduled them to migrate data to Cloud Systems
Exposed to Hive SQL and worked on Hive database to query back data from the cloud systems
Environment: SQL Server 2016/2014, C#, TFS, SSIS, SSRS, Eloqua. Warfront, Salesforce Workbench, AWS
Microsoft, Bellevue, WA Oct 2014– Dec 2016
SQL Server \ SSIS Developer
Project Description: Partner Incentive calc engine
PI is all about distributing incentives to their customers based upon the sales, it has different calc engines based upon the location those engines were triggered and incentives were calculated and checks will be written and mailed
Good understanding of Partner Incentives Program and its relationship to business requirements
Extracted data from Upstream Sources to stage, cleanse and transformed data into SQL server using SSIS
Proficiency in Azure SQL Databases and directly querying the cubes/DW from Azure Cloud
Tracing the log information within SSIS packages to fix the issues encountered on a daily basis
Used profiler to trace the issues within data flows when encountered Issues
Developed Packages and Increased performance by tuning the Procedures and ETL Design
Gained good knowledge and used TFS as a source control, build to deploy to various environments
Created Stored procedure to pull data for reports
Used SSRS to build reports both for external and internal users maintain security
Worked on C# to call API and breaking up data from Various Sources to load tables as per the requirements
Environment: SQL Server 2012/2014, C#, MS Visio, TFS, SSIS, SSRS, EXCEL 2007, Azure
Experian, Costa Mesa, CA & Denver, CO Oct 2013 – Oct 2014
SQL Server Database Engineer \ ETL Developer
Project Description: UK Credit Management
This project is all for the UK customers who emnrolled for their credit service products. They are timely enhancements to these products and enhancements are implemented following agile methedology
Involved in re-writing reports from OLTP environment
Increased the performance of existing Stored Procedures by writing Sargable code
Unit tested and code reviewed Proc’s following SDLC life cycle
Used different database objects in order to fix the existing issues
Handled and addressed various ad-hoc and Data Extract Tickets on a priority basis
Worked on T-SQL scripts to make changes and load data into Data Warehouse
Environment: SQL Server 2012, MS Visio, Sarema Dimensions Team track/Dimensions, SSIS, XML, VB Script
Auction.com, Irvine, CA Apr 2012 – Oct 2013
SQL Server / SSIS Developer / Report Analyst
Project description: Asset Management
Auction.com is an organization where it helps the customers/Banks to sell their properties and makes profi by getting incentives both from buyer and the seller
Involved in re-writing reports from OLTP environment to Data Warehousing environment
Used VB Script to format excel files for various trustees
Involved in Database Administration roles like monitoring, production support and assigning roles
Wrote data driven and time valued subscriptions as per the report and business requirement
Made use of the Tablix report object to created reports and to avoid unnecessary grouping
Environment: SQL Server 2008, SSRS, SSIS, DTS, MS-Visio, VSS, JIRA, VB Script, T-SQL, PL/SQL, C#,SQL Server 2012, Sarema Dimensions Team track, XML, VB Script. C#
Animas Corporation, West Chester, PA Sep 2009 – Apr 2012
SQL Developer / BI Developer / ETL Developer
Project Description: Migration of Delphi to Siebel
Accessit was written in delphi and maintained by Animas, where it has been migrated to Siebel application globally used by Johnson & Johnson
Created new Tables, Stored Procedures and Functions as per the technical document
Data migration using ETL scripts, in order to create a complete new environment to avoid the discrepancies while doing reporting
Environment: SQL Server, SSRS, SSIS, DTS, MS-Visio, MS Access, Erwin, G-track, PL/SQL
Molina Healthcare, Columbus, OHIO Jan 2008 – July 2009
SQL developer/SSRS developer
Project Description: Migration of Access/Excel manual Reports to SSRS
This project is all about migrating the manual reports used within the organization to a reporting Site using SSRS
Responsibilities:
Automation of reports using SSRS through stored procedures and parameters
Used ProClarity as the reporting and analyzing tool as a Dashboard for the cube structures
Assisted fellow developers with OLAP and Doing ETL in transformation of cubes
Assisted in migrating cubes from 2000 to SQL server 2005 using SSIS
Used SSIS packages to load date from spreadsheet into the data base and also used packages to move data between databases (oracle, flat-files) on different servers
Migrated reports from crystal and MS Access to SSRS and scheduled them appropriately
Environment: MS SQL Server 2005, Erwin, SSIS, SSRS, SSAS, ProClarity, Visual Studio, MOSS 2007
Contact this candidate