Description
PROFILE: * Motivated and Astute professional with successful 7+ years diverse experience in SDLC for quickly mastering technology and tools - such as MSBI, Informatica, SQL Server, Power BI, Oracle, SSAS (Tabular) HP Quality Center, ALM etc * Flexible and versatile - able to maintain efficiency and productivity under pressure through extended work hours. Poised and competent with demonstrated ability to easily transcend business need for customers. PROFESSIONAL SUMMARY: * Around 7+ years of industry experience in Data warehousing as MS-SQL Server Developer, involved in Design, Development and Support of MS SQL Server 2005/2008/2008R2/2012/2014, SSIS/SSRS/SSAS for both OLTP and OLAP Systems. * Expertise in Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with Extensive working experience in SQL Server Analysis Services (TABULAR). * Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems. * Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, and Excellent knowledge in RDBMS concepts and Data warehouse Concepts. * Extensive working experience in usage of SSIS Control Flow items. * Experience in creating hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts. * Experience in Creating DAX Expressions, create Date to yearly columns and implement partitions in Tabular Models for Power BI. * Experience on publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in power BI server. * Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI. * Proficient in implementing all transformations available on the SSIS toolbox. * Experience in enhancing and deploying SSIS Packages from development server to production server. * Experience in providing Logging, Error handling by using Event Handler. * Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent. * Strong Experience in creating and deploying parameterized reports using power BI. * Experience in creating hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts. * Expertise in Creating DAX Expressions, create Date to yearly columns and implement partitions in Tabular Models for power BI. * Experience on publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in power BI server. * Good knowledge in generating Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI. * Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases. * Experience in deploying created reports in various sources like Web browser, XML and PDF. * Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling. * Expert in writing basic DAX queries with experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2008R2/2012. * Excellent knowledge in RDBMS concepts and Data warehouse Concepts. * Expert in transforming complex business logic into Database design and implemented by creating Stored Procedures, Views, and T-SQL Scripting. * Hands on experience with SQL Server Management Studio and T-SQL in constructing triggers and tables. * Expertise in Software integration testing and SDLC. * Excellent technical, Analytical, Communication and Interpersonal Skills. Proficient in Technical Writing and Presentations and a Good Team Player. is a back-office administrator for financial investment firms (offering retirement and college savings plans) and for banking institutions (offering health savings accounts and IRA Ascensus provides record-keeping administrative and program management services. The company does not offer investment advice Ascensus is one of the largest independently operated retirement plan service providers in the United States servicing more than 40,000 retirement plans through various partnerships. Responsibilities: * Developed T-SQL queries scripts and stored procedures used for extracting validating transforming and loading data provided by clients. * Respond to ad-hoc requests from Business Analyst and Project Managers by providing accurate data/reports in a timely manner. * Designed ETL packages to load the data from staging server to Data marts on Data warehouse. * Worked with various SSIS control flow tasks and data transformation tasks like Data conversion Derived Column Look-up Fuzzy Look-up script task etc. as part of ETL. configuring checkpoints package logging error logging and event handling to redirect error rows and fix the errors in SSIS. * Loaded the data into destination tables: both full and incremental load by performing different kinds of transformations like row count Look-up derived column merge script task using SSIS packages and also performed with truncating modifying and creating tables in data base as per requirements. * Worked extensively creating and maintaining DAX calculations DAX queries and MDX queries. * Provided Operational Support to modify existing Tabular SSAS models to satisfy new business requirements. * Created and deployed parameterized reports using Power BI. * Created hierarchies in Power BI reports using Data visualizations like Bar chart Line chart pie charts forecast charts deployed. * Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages. Automated execution process scheduling deploying of packages using SQL Server Agent by creating jobs and error reports using Alerts SQL Mail Agent and FTP. * Deployed SSIS packages with minimal changes using XML configuration file. * Created SSRS reports using complex SQL Queries/Stored Process which have sub-reports Drill-Down reports and charts. Created data sources connection strings and defined the datasets for generating the report. various Delivery mechanisms of Reports including Email /PDF/Schedules as per the Client requirements. * Created the test data to test the performance and functionality of the SSRS Reports. * Created subscriptions to provide a daily basis reports. * Managed and troubleshoot report server related issues. Created database objects like Procedures Functions Triggers Indexes DML and DDL changes. * Created and managed schema objects such as tables views indexes procedures and triggers & maintained Referential Integrity. * Created copy-only backups from production environment and Applied to Test/Dev. environments to test functionality on the latest data. Environment: Microsoft SQL Server 2014/2012 R2 SSIS SSRS T-SQL Visual Studio/BIDS Windows 2008 C# MS ACCESS EXCEL TFS VSS.
Accomplishments
Highlights:
Keywords
