PROFESSIONAL SUMMARY:

• Around 8 years of experience in the analysis, design, development, implementation, testing, maintenance, and documentation of Database and Client Server applications.
• Experience in Logical &Physical Data modeling, data architecture designs.
• Good Experience in Data Warehouse development starting from inception to implementation and ongoing support, Strong Understanding of BI application design and development principles.
• Excellent command with MS SQL Server 2016/2014/2012/2008/2005 worked on Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).
• Experience in ETL from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, and BULK INSERT.
• Analyzed the source data, Coordinated with Data Warehouse team in developing Relational Model. Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets, and sessions.
• Good Knowledge in Microsoft SQL Server 2016, 2014, 2012, 2008 and 2005 backend programming.
• Designed and developed DS data flows and ETL components.
• Outstanding skills in using Client/Server architecture in implementing MS SQL Server based applications.
• Experience with Backup and Recovery of MS SQL 2016/2014/2012/2008/2005 Server Databases.
• Good Experience in creating SQL objects like Tables, Complex Stored Procedures, Triggers, Views, Indexes, and User Defined Functions to facilitate efficient data manipulation and consistent data storage.
• In - depth knowledge of T-SQL (DDL and DML).
• Experience in Database design, Development, Data Modeling, Administration, ETL packages using DTS / SSIS, Performance Tuning, Stored Procedures for Database applications using MS SQL Server 206/2014, 2012, 2008 R2, 2008, 2005.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Well experienced in SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, and SQL Query Analyzer.
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel
• Experienced in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Experienced in SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, and SQL Query Analyzer.
• Installed, configured, and maintained SSRS server.
• Experienced in creating ad-hoc reporting in SSRS.
• Experienced in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using tools like SSIS import and export and SSIS packages.
• Excellent in creating reports, dashboards, standardize templates setting up new parameters and implementing the reports in different process with writing observations, insights, recommendations in the reports.
• Good Experience in Data Visualization development using Tableau to create complex, and innovative dashboards. Notify admin team for changes in user, user groups, and scheduled instances for reports in Tableau reports.
• Experience in reports validating and modeling data with the purpose of understanding or making conclusions from the data for decision-making.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, Dynamic SQL, MDX

Databases: MS SQL Server 2017/2016/2014/2012/2008 R 2/2008/2005/2000

DWH/BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual studio 2 /2010/2008, Crystal Reports, Tableau 9.0/10.3, Info Advantage

Database Design Tools and Data Modeling: Star Schema/Snowflake Schema modeling, FACT and Dimensions tables, Physical and logical data modeling and De-normalization techniques, RDBMS, OLTP, OLAP

Packages: MS Office, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities:SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Power Pivot, Microsoft Office, ALM

Operating Systems: Windows 2003/2000/VISTA/XP/7/8, NT & Windows 9x, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer

Responsibilities:

• Gathering the requirements from the Client and design.
• Create the proof of concept and get the approval for BRD from the business team.
• Maintaining the data warehouse Structures, databases.
• Integrating the SQL into databases and into Reporting Engines and responsible Loading Medical and Pharmacy Claims into data warehouse
• SSIS changes based on business requirement document need to create objects for new mappings.
• List down all source and target systems for new mappings.
• Use different transformations like source qualifier, expression, lookup, router, filter, stored procedure, sequence transformations which can meet the requirements.
• Create reusable SSIS objects if the logic can be reused in any other mappings.
• Create new mappings to extract from multiple data sources like flat file, database and transform using different transformations and load to target system like database, flat files.
• Create Enhancement is to improve processing time without any change in existing business logic.
• Check mapping and list down all sources, transformations, and target points with current business logic.
• Creating Complex SQL scripts to transform Legacy Data in Staging area using ETL Process.
• Modify Queries which are used in source qualifier transformation are tuned to improve processing time.
• Modify Queries which have issues are ran in production database, by checking query explain plan cardinality.
• Use multiple combinations of hints and get the best tuned query in execution time.
• Database development to provide Reports for the Insurance companies/Medical Companies and providers.
• Automating process in SQL Server Integration services.
• Generating Ad Hoc Reports for Clinical teams using SQL Server Reporting Server.
• Sending data between vendors and providers back and forth securely.
• Modifying existing SQL process to support specialty and Accordant programs, as well as creating new processes.

Environment: Windows2010 Advanced Server, Advanced SQL, MS SQL Server 2016/2017, Notes,SSRS, SSIS, SSAS, Compare, Ultra Edit, Epic.

Confidential

SQL BI Developer

Responsibilities:

• Plan, design, and implement application database code objects, such as stored procedures and views.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Adept at developing and supporting analysis solutions, data transformations, and reports.
• In-depth understanding of all stages of software development life cycle (SDLC).
• Perform quality assurance and testing of SQL server environment.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Supported all production operation activities, with focus on integration and development of new and existing products and services.
• Worked with internal and external clients for import and normalization of third-party data.
• Responsible for performing SQL development and SSIS /SSAS/SSRS development
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, merge join, execute SQL flow task, data flow task to extract data from different databases and flat files.
• Created complex SQL queries by joining multiple tables, dynamic SQL and sub queries in TSQL.
• Worked on migrating data from non-relational database to relation database.
• Used Microsoft Power BI to Build and maintain the reports and dashboards. Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
• Experience in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snowflake Schema.
• Created auto generated emails using stored procedures.
• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
• Improved the performance of long running views and stored procedures.
• Improved performance by adding indexes, removing unnecessary columns in the inner views, and adding conditions to get only required data.

Environment: Windows2008 Advanced Server, Advanced SQL, MS SQL Server 2016/2017, Notes,SSRS, SSIS, SSAS, Power BI, Query Analyzer, TFS

Confidential, Los Angeles, CA

Power BI Developer (SSIS/SSRS)

Responsibilities:

• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Created SSIS packages to validate, extract, transform and load data-to-data warehouse databases.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions, and package configurations.
• Created SSIS/DTS packages to copy tables, schemas, and views and to extract data from Excel and Oracle.
• Migrated data from legacy system (text-based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS) and stored procedures to overcome the transformation constraints.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Written complex stored procedures and SQL queries.
• Worked on tuning the queries and fixing the stored procedures to get the data consistency.
• Data migration (Import & Export using BCP) from text to SQL Server 2016.
• Semantic Layer setup for the self-service BI, building tabular cubes, for Power BI and implementing DAX expressions.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS).
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front-end application using SSAS 2015.

Confidential, Charlotte, NC

SQL BI (SSAS SSIS SSRS) Developer

Responsibilities:

• Analyzing and Establishing security features in SQL Server Reporting 2016 Environment.
• Worked on Full life cycle development (SDLC) involving in all stages of development.
• Involved in system study, analyze the requirements by meeting the client and designing the complete system.
• Involved in designing technical specifications for building Data Warehouse.
• Involved in project cycle plan for the data warehouse, analyzing the source data, deciding the exact data extraction, transformation, loading strategy & Dimensional modeling. Backup & recovery.
• Developing reports using SQL Server Reporting Services in SSRS 2016. Creating various value sections in Parameters list, designing cascading parameters, matrix dynamics and more features in Reporting Service.
• Used advanced features ofT-SQLto design and tune T-SQL to interface with the Database and other applications in the most efficient manner and createdstored Proceduresfor the business logic using T-SQL.
• Worked on SQL Profiler, Tuning Advisor in SQL 2016 to increase the performance of the reports.
• Developed SSIS packages to extract data from OLTP to OLAP systems and schedule the same as jobs using SQL.
• Server Agent.
• Worked with report subscriptions in SSRS 2016 to send the weekly run automated reports to end users.
• Worked with Report Snapshots
• Develop complex MDX, Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Designed and developed OLAP using MS SQL ServerAnalysis.
• Use DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
• Scheduling daily, weekly, monthly Reports in crystal Enterprise to run at a particular time. Creating users, groups and giving them required permission.
• Scheduling of someReportsbased on event server.
• DistributingReportsby e-mail, FTP or via web access.
• Designed Web basedCrystal Reportsuser interface, Security System Interface, Parameterized Reporting.
• Created dimension model for reporting system by identifying required dimensions and facts using ERWIN.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Created Grouping, sorting columns and writing expressions per the business requirements.
• Extensively worked with SSIS tool suite, designed, and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Wrote stored procedures and User Define Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using PowerPivot/Unpivot in T-SQL.
• Involved in developing Data Access Components to access the SQL Server Database using ADO.NET.
• Created Crosstab, Drill-down, Drill-through and Sub drill down reports -Report using RDL. Promoted RDLs to Reporting Service Server.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly, and quarterly Reports including status.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, SQL server Reporting Services (SSRS) 2014/2012/2008.
• Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.
• Created Data Warehouse Cubes inSQL Server Analysis Service (SSAS).
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Involved inTabular Data warehouseandDAXoperations for SSAS 2012 and 2008 OLAP databases.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.

Environment: SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS),SQL Server Analysis Services(SSAS),SQL Server Management Studio 2014,MS Visual Studio.NET# 2012/2015, TFS, GIT, SVN, Rally and Windows 2008 Server.

Confidential

SQL Server Developer/SSRS

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Writing complex queries and generating reports.
• Extracting queries from multiple databases like Teradata and AS 400
• Optimized the performance of variousSQL scripts,stored procedures,andtriggersby using embedded UDFs,CTEsand System stored procedures.
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
• CreatedSub-Reports, Drilldown-Reports, Summary Reports, andParameterizedReportsin SSRS.
• Generatedad-hocreports using MS Reporting services andCrystal reports.
• Debug and analysis VBA code/ SQL stored procedures.
• Develop and modify stored procedures/ VBA code.
• Experience with MS Office software (Excel, Access, and Word).
• Worked onTeradatainsert, Update, modify and DynamicSQLto transform and load Summary tables built on Core Data Warehouse.
• Extensively worked on Performance Tuning ofTeradataSQLusing explains plan and understanding Joins and Data distribution.
• Extensively worked on Maestro to schedule jobs as daily batch.
• Involved in writing Automation Testing scripts using Shell and Perl to schedule these scripts in DEV.
• Build, test, and execute one-off procedures as needed to support business commitments. Answer business user questions. Investigate and resolve issues or problems that arise. On call for production troubles.
• UsedSSRS to create reports, customized Reports, on-demand reports, ad-hoc reportsand involved in analyzing multi-dimensional reports in SSRS.
• Createdreports using SSRSfromOLTPandOLAPdata sources and deployed on report server.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown,Ad hocand Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and deployed SSRS reports.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Functionality includes CGI Advantage Finance & HCM integrated with Info Advantage Reporting, Recruiting& Applicant Management, and KRONOS Time & Leave.
• Create custom reports for a variety of functional areas inInfo Advantage web intelligence software.

Environment: MS SQL Server 2008, MS Reporting Services 2008,Info Advantage Reporting,MS-Excel, MS Access, MS Visio, Teradata, AS400,Visual Studio 2008, VBA, PERL, BTEQ.