Talent's Information
-
Location
Ahmedabad, India
-
Rate
$15.0 per Hour
-
Experience
9 Year
-
Languages Known
English,Hindi
Available for
Background Verification
40 Hr/Week
About Jitendra
A performance driven ambitious software developer with an extraordinary blend of and technical knowledge. Ability to communicate and motivate team members to enhance strategic goals and bottom line objectives. Creative problem solving and troubleshooting skills complemented by meticulous attention to details that will result in the success of an organization by developing new applications or improving existing ones.
Tech Stack Expertise
-
Microsoft SQL Server
Microsoft SQL Server 2016
4 Years
Work Experience
Data Engineer
- January 2015 - January 2023 - 8 Year
- India
Projects
Business Intelligence And Analytical Solution For
- January 2016 - January 2019 - 37 Months
Technologies
Role & Responsibility
Worked on understating existing implementation of Enterprise Data warehouse.
Worked on correcting Business Logic implemented within ETL process and optimized ETL performance.
Developed Multidimensional SSAS cube in EDW system with calculated measures with business formulas and calculations
Expansion of existing EDW system with new components for BI Solution.
Developed Power BI reports for Safety Observations Listing, Observation Counts, and Top 5 at Risk etc.
Developed Power BI Dashboards for Executive users with overall KPI, score cards with row-level security.
Understood PMD database and respective tables and implemented R code and AML for Fuzzy text
matching using various string-matching methods (Optimal String Alignment (OSA), Levenshtein, Jaro-Winkler), module categories, descriptions, and algorithms.
Sirius Decisions: (Advanced Analytics)
- February 2020 - May 2022 - 28 Months
Technologies
Role & Responsibility
-
Understanding client’s expectations and working with team in developing the analytical solution.
Created a data dictionary using sales force tables and tried to relate all tables and fields to understand for further analysis and use it in Predictive analysis.
Perform data manipulation, cleansing and standardization to provide a framework for advanced reporting capabilities and descriptive analytics
Developed dashboards, operational scorecards, financial models, and data visualizations to drive performance improvement and support business operations
Provides accurate estimates for all works tasks assigned.
Attended meeting with SD Team for understanding sales force tables and their respective fields in detail. Also understood overall sales force workflow cycle from them.
Analyzed SD data and tried to extract relevant fields from the data to predict customer churn.
Prepared master sheets that would help to understand the customer’s behavior by linking customer with the
opportunity.
: Enterprise Data Warehouse Support For A Well-kno
- January 2020 - January 2021 - 13 Months
Technologies
Role & Responsibility
-
Understanding client’s expectations and working with team in developing the analytical solution.
Worked on understating existing implementation of Enterprise Data warehouse.
Developed Multidimensional SSAS cube in EDW system with calculated measures with business formulas and calculations
Expansion of existing EDW system with new components for BI Solution.
Developed Power BI reports for Safety Observations Listing, Observation Counts, and Top 5 at Risk etc.
Developed Power BI Dashboards for Executive users with overall KPI, score cards with row-level security.
Understood the database and respective tables and implemented R code and AML for Fuzzy text matching using various string-matching methods (Optimal String Alignment (OSA), Levenshtein, Jaro-Winkler), module categories, descriptions and algorithms.
Worked on extending existing implementation of Enterprise Data Warehouse and advanced analytic solution with data source as Dynamics AX 2012 and legacy system as main source for reports development using Power BI for material matching
Soft Skills
Industry Expertise
Education
in BCA
Gujarat Uiversity- June 2010 - June 2013
