Softwareentwickler/in

➢ Relevant 5+ years of experience in MSBI projects with extensive usage
of :
✓ ETL & Reporting tools like SQL Server Integration Services (SSIS) and SQL Server reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
✓ Build extensible data acquisition and integration solutions to meet the functional and non-functional requirements of the business.
✓ Well versed experience in analysis the data and design and develop the SDLC process flow
✓ Working closely with users and business team for requirement gathering and issues clarifications
✓ Sound hands on experience in ETL data staging, analysis, design and develop the data to a meaningful data.
✓ Develop data integration standards according to the organisation’s information services policies as well as best practices
✓ Writing MSSQL and Oracle SQL queries for data mart creation, initial loading and incremental loading basis on mapping sheet requirement
✓ Looking towards the production issues and ETL optimisation if any change required at times with proper discussion and documentation
✓ Well versed experience in Data Warehousing concepts
✓ Sound knowledge of TABLEAU(10.0) desktop for designing reports,
creating dashboards and for data visualisations and data blending
✓ Extensive use of BUGZILLA tool for open defects, bugs tracking with
clients to keep track of outstanding problems by using MYSQL database.
✓ Good understanding of Agile methodologies

• Includes 4+ year’s experience in data extraction, transformation and loading (ETL) using SSIS SQL Server 2008/2008 R2 and SQL Server 2012
• Writing SQL queries for initial loading and incremental loading
• Using T-SQL for constructing Trigger, Cursors, Stored Procedures, Constraints,
Functions, Views, Indexes, joins
• Writing PLSQL queries , data masking and data cleansing
• Experienced in Logging, Check points in SSIS packages, tuning ETL work flows designed with MS SQL Server Integration Services (SSIS)
• Performing ETL batch data loading

➢ Basically used to handle Flipkart HR domain database
➢ Extracting data from multiple sources like flat files, OData Source, web applications for transforming, cleansing and validating the data to load into final Destination.
➢ Designed packages Using SSIS which includes Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task and Data Flow Task.
➢ Design SSIS packages using SQL queries to filter data from multiple web applications and making changes in data types.
➢ Loading Incremental packages scheduling and monitoring the Incremental packages
➢ Error configurations , check points and again checking bad job on daily basis
➢ Deploying the packages and finally prepare the reports
➢ Data visualization, data cleansing and analyze the data as per business requirement.
➢ Writing SQL queries like stored procedures, triggers etc.
➢ Also engaged in DWH and prepared data model as per business requirement.

➢ Extracting data from multiple sources like flat files and SQL server for transforming, cleansing and validating the data to load into final Destination.
➢ Designed packages Using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task and Data Flow Task.
➢ Extracted data from sources and transformed the data using different transformations like data conversion, derived columns, look up, Conditional Split, Aggregate, Union all, Joins and Multi cast transformations.
➢ Data Extraction, Transformation and Loading (ETL) using SSIS SQL Server 2008/2008 R2
➢ Designing reports in SSRS like cascading parameter, drill down, drill through reports, shadow borders, fill, legend, data rendering , charts,
Adhoc report, matrix reports etc as per the business requirement
➢ Analysis daily intake and EOD data and share the same with onshore partners Claims Processing (3 months)
• Complete work allocation to the team looking to the TAT
• Claims Ageing reports
• Maintaining production report for the team
• Auditing claims for new hires
• Verify the patient insurance details and medical records
• Working on client escalation and high dollar claims
• Follow the daily business checklists

Anderes Zertifikat

–

–