Career Objective
Aspiring for a challenging position to utilize knowledge and experience acquired on Data Warehousing and Business Intelligence contributing to the success of organization that enable individual professional growth.
Professional Summary
IT professional with total of 7 years of experience.
Responsible for Business Analysis and Requirements Collection document.
Responsible for creating detailed project road maps, plans and work breakdown structures.
Tracking project progress to ensure project milestones were completed on time with desired results.
Defining processes and tools best suited to each project. Moved between agile and waterfall approaches depending on project specifies and client goals.
Identifying project risks and scope creep to identify potential problems and proactively identifying solutions to address them in advance; Monitoring team performance and motivating team to generate positive energy.
Extensive hands on experience in designing data modeling for Data warehouse or reporting data base depending on the project.
Good domain knowledge in HR Processing, HR Payroll, Leadership & Training, ITSM, Hedge Funds, Retail,E-Discovery.
Preparing ST mapping document for dimensions and facts for Data warehousing project.
Hands on Experience in developing ETL Strategies using Talend Data Integration, Talend MDM, Pentaho Data Integration and SAS Data Integration Studio.
Extensive hands on experience in Generating Reports, Dashboard’s and implementing role based securities using Jaspersoft.
Good experience with Pentaho report designer, C Tools and Data integration.
Good knowledge on Postgres, SQL Server Management Studio and MySQL in writing with SQL Queries.
Good knowledge on fine tuning Postgres data base server in dealing with large data.
Good knowledge on Linux machines includes Ubuntu and AWS.
Excellent Analytical, Presentation, Communication and Interpersonal skills with proficiency in demonstration and highly adaptable to new technologies & business environment.
Good Team player with excellent trouble shooting and problem-solving skills.
Multiple onsite client experience for requirement gathering, knowledge and solution deployment.
Won Star Performer, Mentor of the year Awards for exceptional performance.
Experience with Talend.
Involved in building the ETL design for job and Source to Target mapping to load data into Data Warehouse.
Created mapping documents to outline data flow and metadata information from sources to targets.
Extracted the data from the Mysql database into staging area and populated onto Data warehouse.
Used various transformations like tMap, tAggregator, tFilter Row, tJoin, tPreJob, tPostJob, tSystem, tSort Row, Stored Procedure, and Union to develop robust mappings in the Jobs.
Implemented custom error handling in Talend job and worked on different methods of logging.
Developed mapping parameters and variables to support Job.
Developed mappings to load into staging tables and then to Dimensions and Facts and Used Type 2 SCD mappings to update slowly Changing Dimension Tables.
Prepared document for Unit test cases from each Flow of Data and designed ETL Job for
Testing Involved in Performance tuning at source, target, mappings, sessions, and system levels.
Experience with Jaspersoft Server.
Generating reports both on ireport and Jasperstudio.
Integration of D3 charts with in Jaspersoft server by using html component on older version.
Plug-in development for additional functionality like saving dashboard.
Creating landing JSP pages to display dashboard / report based on user role login.
Implementing custom input controls using visualize.js.
Creating basic themes.
Load Balancing (i.e. creating clusters to balance load on server).
Customization of Jasperserver.
Preparing a test cases and implementing the same to validate report data with raw data.
. EDUCATION QUALIFICATION
1. Masters of Technology in Software Technologies from IIIT,Pune.
2. Bachelor of Technology in Computer Science Engineer from JNTUH, Hyderabad.
TECHNICAL SKILLS
Business Intelligence: Jaspersoft Server, Pentaho Designer.
ETL Tools: Talen Data Integration, Talend MDM, Pentaho Data Integration
Database (SQL, PL/SQL): PostgreSQL, SQL Server, MySQL and Oracle.
Current Employer Infor Software: [2020 January - Till Date]
Q City, Blocks B, Financial District, Nanakaram Guda, Hyderabad, Telangana, Pin code – 500032
Previous Employer DST Worldwide Services Pvt Ltd: [2017 July – 2019 December]
Q City, Blocks A & B, Financial District, Nanakaram Guda, Hyderabad, Telangana, Pin code – 500032
Previous Employer Helical IT Solutions Ltd: [2012 Nov - 2017 July]
Plot No 7, House No: 1-10/66/A, Near Holy Trinity Church, Chikoti Garden, Begumpet, Hyderabad, Telangana, Pin code – 500016
Regards
Venkatnaveen Dasari
