| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Contact No: PHONE NUMBER AVAILABLE E-mail ID: EMAIL AVAILABLECareer ObjectiveSeeking a career with a progressive organization where I can utilize my technical skills, experience and provide proactive solutions to address the technology needs which contribute to the growth of the organization as well enhance my knowledge, skills and personal growth.Experience SummaryHaving 8+ years of IT experience in MSBI Tools, Business objects data integrator (BODI).Good experience with SQL Server 2012, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services). Experience in requirement analysis, coding and testing various modules in a software development life cycle.Good understanding of RDBMS concepts and experience in writing Joins, Sub queries, Views, Stored procedures, Functions using SQL Server.Extensive database programming Experience in writing SQL Stored procedures, User Defined Data Types, Triggers, Constraints and Indexes using various DDL and DML commands.Good knowledge in SQL joins, sub queries.Used Control Flow Tasks like For Each Loop Container, Sequential Container, Execute SQL Task, FTP Task and Data Flow Task in Designing packages.Proven proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, sort, data Conversion, Union All, Merge Join, SCD and OLEDB Command to load data into SQL Server destination.Communicating with the users and business to fix the issues in Production.Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, cascaded reports etc.Creating the reports as per clients requirements in the form of table, matrix, Chart and list.Scheduling the Reports Weekly and Monthly basis as per the Client Requirements.Good communication, inter-personnel skills and good team player.Self-motivated individual with strong analytical and problem-solving abilities, Proactive, Dedicated, enjoy learning new technologies and willing to take on extra responsibilities to get work done.Work ExperienceHaving 8+ year of experience in Green Square Software Technologies as Software Engineer from Oct 2015 to till dateTechnical SkillsTechnologies : Microsoft Business Intelligence Tools (MSBI), Business objects data integrator (BODI)RDBMS : SQL Server 2012/2014ETL Tools : SQL Server 2012/2014 Integration ServicesOLAP Tools : SQL Server 2012/2014 Analysis ServicesReporting Tools : SQL Server 2012/2014 Reporting ServicesProject Details:PROJECT:1 British Cars Auction (BCA)ClientTGB(TOYOTA), UKTechnologiesSQL server, SSIS, SSRS and BODIDescription:This project was Developed a comprehensive project for Toyota cars auction in the UK, facilitating access to vehicle information, sales, and extended warranty services for business owners and customers. Designed a robust system capable of extracting vehicle details from diverse third-party vendors, transmitting data to BCA. Post-sale facilitated the transmission of vehicle sales-related information by BCA to generate invoices, while also ensuring the timely updating of service details for each vehicle.Roles and responsibilities:Proactively, associated with the business users to jointly come up with initial user requirements.Formulated HLAP (High Level Approach Plan) reviews with business Client.Participated in the implementation of the Low-Level Design documents for ETL.Working as a technical lead in BCA application development and production support and direct reporting to Project manager.Involved the development of database including SQL views, function and stored procedures.Successfully, developed packages that have dynamic package configuration and Error event handling using On Error, SSIS Logging and has Failure email notification as well as storing SSIS error log into tables.Steered the process of deployment of packages and configured in SQL Server Agent job.Accountable for building Package deployments and package Configurations.Play a pivotal role in the ETL team support and Development activities.Monitoring Daily SQL Server agent jobs on production server as part of the production support.Participate and provide inputs during business weekly meetings.Project: 2 EDW (Enterprise Data Warehouse)TechnologiesSQL Server, SSIS, SSRSDescription:This project is developed to give discount on products. We have discounted product as compared to the market. When a product is avail, we send coupon code to customer and at the time of purchase he/she can use that code to purchase the product from our website.Roles and responsibilities:Database Management and Development and Design of Schemas And their relationships as per the RequirementsInvolved in writing views, stored procedures, functions and packages to enhance and improve functionality using SQL.Database Restoration, Backups, Import, Export, Merging, maintenance and migration.Created SSIS Packages and deploying it on Sql server. And scheduling it through Sql Server Job agent as per the clients requirement.Created packages in SSIS Designer using Control Flow Tasks and Data Flow Transformations to implement Business Rules.Using Control Flow elements like Containers, Execute SQL Task, Execute Process Task, File System Task and Send Mail Task etc.Generated the Reports Weekly and Monthly basis as per the Client Requirements.Handled the issues of Back-end and to apply proper validation.Interacting with clients and team if any issue occurs and resolving them.PROJECT:3 Electronic Medical Record (EMR)ClientMed Lite, USATechnologiesSSIS, SSRSDescription:This system, which was developed for U.S. healthcare service provider, aims at providing corporate information and hospital statistics that can be viewed by Directors and management or by those who are authorized to see it. This system is the complete solution designed for an enterprise wide-area networked environment to implement a totally paperless office by allowing patient records to be accessed at the actual point-of-care via a stationary PC and by managing all clinical, administrative and follow-up processes electronically. This system is using five different modules Cardiology, Diabetology, Pediatric, Neurology, and Eye Care.Roles and responsibilities:Involving in Data Extraction, Transforming and Loading (ETL) between Heterogeneous System using SQL tools (SSIS, and Bulk Insert)Creating packages using SQL Server Integration Services platform by using Control flow and Data flow components.Using different Transformations like Lookups, Derived Column, Merge Join, For Loop, ForEachLoop, Conditional Split, Union all etc.Involving controlling the packages by using control flow components like sequential containers, for loop containers, for each loop containers.Creating drill through reports and cascading parameters in Reporting ServicesCreated different Parameterized Reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.Generating the reports weekly and monthly wise and rendering the reports in the form of PDF, EXCEL as per the client requirements.Interacting with clients and team if any issue occurs and resolving them.Date: Candidate's Name e> |
