Leading General Resume
5.00/5 (Submit Your Rating)
SUMMARY:
- 5 years of experience in DW Design, development and Implementation of solutions using Microsoft Business Intelligence focussed on SQL Server, SSIS, SSAS and SSRS & MDX.
- Worked with client operating on Insurance business domain.
- Has good experience in ETL methodology, workflow development, Analysis and Reporting mechanisms using SQL Server Business Intelligence Tools (SSIS, SSAS, SSRS) and SQL Server (2005, 08, 12) database and MDX.
- Actively involved as a developer in project involving requirements gathering with business users, design analysis, development and testing.
- Worked as an Analyst Developer in building Enterprise Data Warehouse (EDW) and has good experience in reporting area based on SQL and MDX querying.
- Possess good knowledge on data warehousing concepts and had worked on creating SSRS reports using SQL queries and MDX queries on top of SSAS cube.
- Direct interaction with clients’ for Business Requirements, carrying out the analysis, design, development and testing of the modules.
- Worked in agile methodology project which needs active participation in stand - up meetings with the clients on day to day basis.
- Exceptional written and oral communication skills, with an ability to work independently and also in a team.
- Worked as a Build Master in integrating the code developed by the developers in coordination with the team members and deployed it to Production environments.
- Worked as developer from offshore in delivering minor enhancements in the form of releases. Also worked as support resource during Weekly and monthly loads.
TECHNICAL SKILLS:
Domain: Insurance
Data Warehousing Tools: SSIS, SSAS, SSRS, MDX, Power BI, Business Objects XI 3.1 & Informatica.
Databases: Oracle 10g, MS SQL Server 2005/2008/2012.
Testing Tools: Manual Testing.
Scheduling Tools: Maestro.
PROFESSIONAL EXPERIENCE:
Confidential
Leading general
Responsibilities:
- Participated in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation, defect tracking, deployment and production support)
- High level and Low level design documents.
- Creation and updating data models using Datanamics by Dezign.
- Build and deployment of code to Non-Prod and Prod environments using TFS 2012.
- Worked in co-ordination with DW testing team in Integration Testing and system testing.
- Participated in code and design peer reviews and also used code formatting tool for code quality improvements.
- Unit test case documents and auto reconciliation queries.
- Automation of regression testing using SSIS package.
- Auto reconciliation of data flowing through various layers using SQL queries.
- Extensive experience in Development, Maintenance and Production Support projects.
Confidential
Project developer
Responsibilities:-
Development of SSIS packages to fulfil the business requirements.
- Preparation of the requirements specification document which mentions all the transformation rules involved as part of coding.
- Analyzing the already developed code to improve the performance.
- Design applications that can reduce the rework or the timeframe involved in achieving a particular job.
Confidential, North Carolina.
Application Maintenance
Responsibilities:
-
Manages end to end communications with Clients from Requirement Analysis to Implementation.
- Providing weekly project status report of the ongoing projects to the Managers.
- Providing estimations for new Enhancements.
- Participate in creating application architecture document to provide deliverables in line with architectural requirements.
- Perform high and low-level design, provide pseudo codes, implement the prototype and conduct design reviews.
- Ensure that the deliverables meet the design requirements and quality standards of the project as per the SDLC
- Review work products of subordinates, Drive Unit Testing and Code Reviews.
- Providing solutions to the technical challenges faced by the team.
- Solution road map for future growth, process architecture and mapping of DR Functions
- Provide inputs on solution architecture based on evaluation/understanding of solution alternatives, frameworks and products.
- Interact with clients to elicit architectural and non-functional requirements like performance, scalability, reliability, availability, maintainability.
- Anchor proof of concept (POC) development to validate proposed solution and reduce technical risk.
