Description
Over 5 years of IT experience in Data Design and Development on Microsoft SQL Server, T-SQL, Performance Tuning, Troubleshooting, SSIS Package Configuration, SSRS, SSAS and Data-warehousing. * Effective in handling applications with end-to-end responsibilities using Business Intelligence Solutions like SSIS, SSAS, SSRS and expertise in designing and implementing Relational Database model as per business needs. * Specialized in working with both functional and technical teams to interpret, create and implement business requirements into technical specifications, code and deliver. * Worked in Agile environment, Kanban board under various phases of Software Development Life Cycle including development with continuous integration and delivery. * Excellent T-SQL development skills to write complex queries involving multiple tables. * Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, Data Dictionaries and Data Integrity. * Experience in Performance Tuning and Query Optimization. * Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS). * Designed SSIS Packages to import/export data from flat files to SQL Server and other data sources. * Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc. * Experience in Microsoft Visual C# in script component of SSIS. * Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services (SSAS). * Deployed and processed SSAS cube weekly to update information by using SQL Server Agent. * Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS. * Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS. * Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS. * Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008. * Ability to handle Multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
Work Experience
| COMPANY | POSITION HELD | DATES WORKED |
|---|---|---|
| (Confidential) | Programmer Analyst | 6/2018 - Present |
| Oracle Financial Software Services Ltd | Staff Consultant | 3/2016 - 11/2016 |
| Tata Consultancy Services | Oracle Pl/Sql Developer | 1/2013 - 3/2016 |
Accomplishments
Highlights:
Job Skills
Keywords
