• Building end to end Data warehouse solution using T-SQL and Microsoft Business Intelligence.• Design depict Logical and physical data models in Oracle and Microsoft SQL Server databases.• Involving in implementation of T-SQL,PL/SQL packages, stored procedures, views, functions, triggers.• Building interactive reports using Data Visualization tools like Tableau and Microsoft Power BI.• Build data integration solutions on distributed systems• Co-coordinating with Onshore team and Business stakeholders for clarifications, requirements gathering, technical approaches, estimates and guidance.• Involving in release coordination and technical support during code migration with DBA team.• Involving in query optimization.• Involving in preparing the technical artifacts (design, LLD, HLD, SAD) related to project.• Enhancing competency in NoSQL, Big Data and Hadoop technologies.• Involving in organizational wide technical trainings and recruitment.

• Building end to end Data warehouse solution using T-SQL and Microsoft Business Intelligence.• Design depict Logical and physical data models in Oracle and Microsoft SQL Server databases.• Involving in implementation of T-SQL,PL/SQL packages, stored procedures, views, functions, triggers.• Building interactive reports using Data Visualization tools like Tableau and Microsoft Power BI.• Build data integration solutions on distributed systems• Co-coordinating with Onshore team and Business stakeholders for clarifications, requirements gathering, technical approaches, estimates and guidance.• Involving in release coordination and technical support during code migration with DBA team.• Involving in query optimization.• Involving in preparing the technical artifacts (design, LLD, HLD, SAD) related to project.

• Analyzing the business requirements and preparing an approach for implementation of business software. • Building software products using MSBI tools (SSIS, SSRS & SSAS) • Writing computer programming using T-SQL, PL/SQL packages, stored procedures, views, functions, triggers.• Analyzing the business requirements and preparing an approach for implementation of business software. • Overall responsibility in implementation of coding standards, checklists, guidelines as recommended by Process Manager• Overall responsibility for project coordination and day-to-day interaction with team members on technical areas• Installation and Configuration of Microsoft products (SQL Server Management Studio, MSBI/SSDT) based on the customer requirement.• Advance knowledge in RDBMS concepts, Conceptual/logical/physical data models, and Dimensional Star/Snow Flake schemas.• Project Configuration and software release activities.• Planning/Estimating the development, deployment and implementation activities for smooth run in the project.• Assuring Quality for the implementation activities delivered to the customer.• Contributed towards reusable components• Ensure proper interaction with client – both through mails and over teleconferences which would include effective responses, and cascading the relevant information to the management and the team• Verifying the computer programs done by the offshore development team to ensure that the customer business specifications are met.• Database development, database design and performance optimization.• Mentoring the junior resources in the team.• Mentoring the QA team for database awareness.• Conducting Organizational level training on database platform• Mentored and supervised interns in the team with technical guidance and delegation of work.

o Building software products using MSBI tools ( SSIS, SSRS & SSAS) o Writing computer programming using T-SQL,PL/SQL, Packages , Stored Procedures, and Functions etc.o Analyzing the business requirements and preparing an approach for implementation of business software. o Database development, database design and performance optimization.o Conducting Organizational level training on database platform

o Building software products using MSBI tools ( SSIS, SSRS & SSAS) o Writing computer programming using T-SQL, Stored Procedures, and Functions etc.o Database development, database design and performance optimization.