Sudheer Kumar Munjeti
Associate BI Lead
Hyderabad,TG
Summary
Bachelor of Technology in Information Technology
Overview
10
10
years of professional experience
Work History
Associate BI Lead
EMids Technologies Pvt Ltd
02.2020 - Current
- Led a team of 4 Dot Net developers.
- Developing and maintenance of SSIS packages and SSRS reports issues.
- Loading data from multiple sources like flat files, oracle, and SQL server and transforming, cleansing, validating data and loading into Destination.
- Good Experience in Implementing Checkpoint, Transactions, and logging for SSIS packages.
- Creating Validation rules in SSIS packages as per the client requirement.
- Analyzing the Packages and find the Route Causes to fix the SSIS Packages.
- Build and Deployed SSIS Packages to SQL server and Scheduling Packages in SQL Agent Job.
- Creating SSRS Dash Boards , Sub Reports, Linked Reports and Subscriptions.
- Designed Different Types of reports like Drill Down, Drill Through, Sub Reports and Parameterized Reports.
- Development of reports using different SSRS Functionalities like sort prompts and cascading parameters, Multi Value Parameters.
- Scheduled Reports Daily, Weekly and Monthly basis as per the Client Requirements.
- Involved in the maintenance and support operations.
Associate BI Lead
Trantor Software Pvt Ltd
04.2019 - 01.2020
- Led a team of 4 developers in developing and maintenance of SSIS packages and SSRS reports issues
- Loading data from multiple sources like flat files, oracle, and SQL server and transforming, cleansing, validating data and loading into Destination
- Good Experience in Implementing Checkpoint, Transactions, and logging for SSIS packages
- Creating Validation rules in SSIS packages as per the client requirement
- Analyzing the Packages and find the Route Causes to fix the SSIS Packages
- Build and Deployed SSIS Packages to SQL server and Scheduling Packages in SQL Agent Job
- Creating SSRS Dash Boards , Sub Reports, Linked Reports and Subscriptions
- Designed Different Types of reports like Drill Down, Drill Through, Sub Reports and Parameterized Reports
- Development of reports using different SSRS Functionalities like sort prompts and cascading parameters, Multi Value Parameters
- Scheduled Reports Daily, Weekly and Monthly basis as per the Client Requirements
- Involved in the maintenance and support operations.
Senior Software Engineer
Trantor Software Pvt Ltd
05.2015 - 03.2019
- Created Stored procedures, Views and Triggers in SQL Server
- Written complex SQL statements using joins, sub queries and correlated sub queries
- Actively involved in improving System Performance by tuning SQL queries and stored procedures
- Created the Table and Matrix reports in Power BI as per the requirements
- Created Area and Bar charts in Power BI and deployed to the services
- Worked for Functional and Technical design to speed up the process and query optimization.
Senior Software Engineer
Divensi Solutions
08.2014 - 01.2015
- Extensively worked in data Extraction, Transformation and Loading from source to target system using Integration Services
- Created the packages using transformations such as the Derived Column, Union All, Conditional Split, Row Count and Audit Component and Aggregate Transformation
- Applying the standards like Checkpoints, Logging to package
- Experiencing loading incremental data load to target table using Lookup transformation
- Creation of different kinds of reports as per end user requests
- As per the Client Requirements Rendering the reports in the form of PDF, Excel and .CSV formats.
Junior Engineer
Electronics Corporation India Limited (ECIL)
- Installing MSSQL Server 2008R2, Applying service packs and security patches
- Upgrading databases from SQL Server 2000 to SQL Server 2008R2
- Backup databases and perform restore on different servers
- Configuring and monitoring replication between different database servers
- Performance Tuning of queries by creating new indexes
- Executing the scripts as per the requests from the superiors
- Troubleshooting SQL Server Memory and CPU issues.
Education
B.Tech - Information Technology
Aditya Institute of Technology and Management
JNTU Kakinada, Andhra PradeshSkills
DataBase: SQL Server 2008R2, SQL Server 2012, SQL Server 2016, SQL Server 2019, SQL Server 2022, SnowFlake
- ETL Tools: SSIS (developing, Maintenance and Testing)
- Reporting Tools: SSRS, Power BI and Knowledge on Qlikview
Others: Data Warehousing, Data Modeling, Visual Studio2019, JIRA Management Tool, Bit Bucket, Git Hub, Jenkins
Timeline
Associate BI Lead
EMids Technologies Pvt Ltd
02.2020 - Current
Associate BI Lead
Trantor Software Pvt Ltd
04.2019 - 01.2020
Senior Software Engineer
Trantor Software Pvt Ltd
05.2015 - 03.2019
Senior Software Engineer
Divensi Solutions
08.2014 - 01.2015
Junior Engineer
Electronics Corporation India Limited (ECIL)
B.Tech - Information Technology
Aditya Institute of Technology and Management
Similar Profiles
Pavithra DCPavithra DC
Senior Business Analyst/Product Owner at EMIDS TECHNOLOGIES PVT. LTD.Senior Business Analyst/Product Owner at EMIDS TECHNOLOGIES PVT. LTD.
Digvijay Kumar TiwariDigvijay Kumar Tiwari
Sr Technical Lead at Emids Technologies Pvt LtdSr Technical Lead at Emids Technologies Pvt Ltd
Madhu GurukarMadhu Gurukar
Associate Technical Lead at Emids technologies pvt ltdAssociate Technical Lead at Emids technologies pvt ltd
THRIGUN MUNIYAPPATHRIGUN MUNIYAPPA
Business Analyst Manager at EMIDS Technologies Pvt LtdBusiness Analyst Manager at EMIDS Technologies Pvt Ltd
Devi Priyanka JinkaDevi Priyanka Jinka
Business Development Associate at PURSUIT FUTURE TECHNOLOGIESBusiness Development Associate at PURSUIT FUTURE TECHNOLOGIES