Responsibilities:
• Installation and configuration of SQL Server 2008R2/2016
• Implementation and delivery of BI platform solutions in developing and deploying ETL Packages, Analysis Services and Reports using SQL Server 2008R2/2016 (SSIS, SSAS, SSRS, SSMS).
• Maintained user/groups access and security permissions in accordance to policies and procedures.
• Developed Transact-SQL (T-SQL) Queries, Stored Procedures, Triggers, User Defined Functions (UDF), Views, Indexes, and User Defined Data Types strictly following the Data Integrity using Constrains, Rules and Default.
• Involved in Migration of Databases from SQL Server 2008R2 to SQL Server 2016 using SSIS.
• Used Fuzzy Lookup transformation to perform data cleaning tasks such as standardizing data, correcting data, and providing missing values.
• Created various types of reports including matrix, sub reports, list, chart and linked reports in various formats (PDF, XML, HTML, and CSV).
• Created filters, prompts, and business calculations in Report Model of SSRS. This enabled end users in increasing the speed of Ad-hoc report generation.
• Used SQL Server Analysis Services 2008R2/2016 (SSAS) to create OLAP Cubes and defined data source, data source views, dimensions, measures, user defined hierarchies, calculated measures, KPIs and roles. ENVIRONMENT: SQL Server 2008R2/2016, MS-Access 2003/2007, MS-Excel 2003/2007, MS-Visio, Windows 2000, Windows XP, Windows Vista, Windows 2003 Server.

Responsibilities:
• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs with solution options.
• Developed Transact-SQL (T-SQL) Queries, Stored Procedures, Triggers, User Defined Functions (UDF), Views and Indexes strictly following the Data Integrity using Constrains, Rules and Default.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to Staging and Staging to Data Warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more.
• Wrote complex SQL queries using joins, CTE, sub queries and correlated sub queries to retrieve data from the database.
• Involved in migration of DTS packages (2008) to SSIS (2012) and troubleshoot migration issues.
• Deployed and scheduled reports using SSRS to generate all daily, monthly and quarterly reports including status. ENVIRONMENT: SQL Server 2008R2/2012, T-SQL, SQL SSIS, SSRS, SSAS, XML, Windows 2000, Windows 2003 Server.

Responsibilities:
• Installing network and computer systems.
• Maintaining, repairing and upgrading network and computer systems.
• Diagnosing and fixing problems or potential problems with the network and its hardware, software and systems.
• Monitoring network and systems to improve performance ENVIRONMENT: MS-Windows XP, MS-Access 2010, MS-Excel 2010, MS-Word 2010, MS-PowerPoint 2010.