Akash Mamidibathula Email & Phone Number

Toronto, Ontario, Canada

• Analyze, design, code, and maintain complex programming modules based on limited business and technical specifications, but with an eye for continuous improvement.
• Apply enhancements, changes, and fixes to existing reports and our reporting systems as required by the business.
• Work closely with our internal clients to review business requirements, clarify business needs, and work collaboratively on designing solutions.
• Develop data integration and ETL/ELT solutions between our various databases and business systems.
• Maintain and enhance database views, functions and stored procedures used in our reporting databases.
• Support and maintain our various reporting systems and help troubleshoot technical issues.

Mississauga, Ontario, Canada

• Design Build and Maintain Databases and Servers as per the Requirements and analyzing applications and Operations.
• Build and create SSISDB using Azure Data factory.
• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Develop code and macros to generate summary tables alerts charts and reports.

Hyderabad, Telangana, India

• Migration of SSIS from SQL Server 2008 to SQL Server 2016.
• Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages.
• Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert).
• Involved in error handling of SSIS packages by evaluating error logs.
• Successfully extracted transformed and load data into data warehouse by building cubes using SQL server Analysis service SSAS.
• Worked with Change Data Capture CDC tasks in SSIS packages to achieve incremental loads.

Hyderabad, Telangana, India

• Designed and developed various abstract classes, interfaces, classes to construct the business logic in Model using C#.
• Serve as Scrum Master to build custom tools for Pre-Bind and Post Bind tools for risk analysis for different models of business in Insurance Industry.
• Developed the reusable framework for the application using the ASP.NET MVC Framework 5.0.
• Involved in development of Web Forms, classes using ASP.NET that incorporates both N-Tier Architecture, and Database Connectivity.
• Implemented Partial views (user controls), Master Pages, Strongly Typed Views, and Complex Views.
• Implemented Get, Post by using Controller actions and Caching by using Action Filters and Child actions in Controller and return Razor HTML to View through Action Results.