Project Leader
R Systems International
Total years of experience :8 years, 5 Months
Develop SSIS packages to cleanse, transform and load data to reporting database.
Designing, development and enhancement of SSIS Packages using several transformations to perform data profiling, data cleansing and data transformation to load data in to reporting server from various sources like sql server, excel and text files.
Implemented logging and event handling in the SSIS packages.
Developing stored procedures to load data from source to fact tables & dimension tables.
Involve in development of historical & current data reports and dashboard using SQL Server Reporting Services.
Experience in development of drill through, drill down, linked, chart, matrix, and parameterized reports in SSRS.
Develop, design and support interactive Tableau based dashboards and reports.
Used trend lines, graph, map, table, functions & filters in tableau reports.
Create calculations including string manipulation, arithmetic calculations, aggregations, logic statements and quick table calculations.
Optimization of SQL Scripts, SSRS and Tableau reports.
Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for server logons and security checks.
Act as report server administrator to undertake site settings, user creation, permission & authorization and subscriptions.
Develop complex subscription and report and package scheduling on SQL-RD tool.
Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team.
Undertake quality assurance of the deliverables.
Accountable for requirement gathering and ratification.
Analysis of requirements.
Creation of functional and technical specifications.
Development and deployment of dashboard applications.
Development and deployment of Store procedures, Views, Tables, Functions,
MDX and XML scripts.
Code review of the applications and procedures.
Optimization of the applications and procedures.
Involved in preparation of test scripts and test cases.
Provided support to production system to resolve any issues.
Provided support to the cubes.
Understood and implementing the qMail a Messaging Based System.
Involve in data modeling and dimension modeling of the federated database.
Working on federated database to create an integrated data warehouse from various sources.
Seamless data acquisition integration and transformation across multiple operational systems.
Created SSIS packages that included a variety of transformations like Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
Developed the Staging Database and loaded from source to staging and from staging to the destination tables applying different transformations.
Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data.
Implemented Checkpoint, Event handling and logging in SSIS packages.
Development, enhancement and support of Qlikview reports.
Undertake optimization of reports, packages and database scripts for faster performance.
Involve in business verification testing (BVT) and system integration testing
(SIT).
Documentation of procedures and processes to ensure the compliance of
process within the team.
Creation of planning and matrices documents.
Documentation of proposed solution design and architecture
Created dimension, fact tables and measure objects according to business requirements using SSAS 2005.
Created dimension and according to business requirements using SSAS 2005.
Created stored procedure to load data from source, to populate the dimensions.
Developed efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
Designed SSIS Packages to transfer data between servers load data into database using several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more; Scheduled the jobs to do these tasks periodically;
Created parameterized reports, Drill down and Drill through reports using SSRS.
Developed, deployed and supported SSRS reports and SSIS packages.
Master degree in Computer Applications.