SUMMARY

• Around 8 years of experience in Database Design, Development & Support of MSSQL Server in Production and Development.
• Strong technical knowledge in MS SQL server development and Microsoft BI Tools.
• Strong working experience on SQL Server 2000/2005/2008/ R2/2012/2014 including SSIS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Experience in creating tables, stored procedures, views, triggers, functions, indexes, data integrity, data dictionaries, and relational database models.
• Expertise in design, development, testing and support of ETL process for large scale Data warehousing using SQL server (2005, 2008, 2012)
• SQL server integration services (SSIS/DTS), SQL server reporting services (SSRS) and Analysis services (SSAS) and DWH concepts.
• Experience in creating complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008/2012 and Transformation.
• Experience on Performance Tuning, Client/Server Connectivity, Query Optimization, running database consistency check with DBCC Commands.
• Experience in SQL Server OLAP database development including KPIs, Data mining, working with changing dimensions.
• Used different type of slicers available in Power BI for creating reports.
• Experience in Extraction and Migration of data from various data sources like Excel, MS Access and Oracle to MS SQL Server by using import/export Wizard, DTS/SSIS, BCP and Bulk Insert utilities.
• Create reports in Power BI preview portal utilizing the SSASTabularvia Analysis connector.
• Experience in Error and Event Handling using Precedence Constraints, Break Points, Check Points and Logging.
• Strong knowledge on Row Transformations, Partial Block and Block Transformations.
• Experience in creating Ad - hoc reports and data driven subscription reports by using Report Builder.
• Experience on publishing Power BI reports on dashboards in Power BI server.
• Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.
• Worked with both live and import data in to Power BI for creating reports.
• Experience in RDBMS database and tables design Normalization, De Normalization, Clustered, Non clustered, Unique, primary, foreign keys and Indexes.
• Experience in creating Jobs,SQLMail alerts and schedulingSSISPackages usingSQLServer Agent.
• Experience in defining Queries for generating drill down and drill through reports in SSRS 2008.
• Experience in Full Software Development Life Cycle (SDLC) including Analysis, Design
• Review of Business and Software Requirement Specifications; Development, Testing as per Agile software development methodology.
• Managed relationship between tables in Power BI using star schema.
• Knowledge in designing project related document templates to upload to Sharepoint site.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Worked on creating theAzureGateways,AzureScheduler and maintaining Pipelines.
• Proficient in using SQL Server Profiler for monitoring the performance of an instance of the SQL Server Database Engine, Analysis Server and Integration Services.
• Exceptional versatility and adaptability, extremely diligent having excellent communication skills and ability to work both as individual and as a team member.
• Effective Team Player with excellent Analytical, Programming, Written and Verbal Communication skills.
• Proven ability to approach and solve problems effectively and independently.

TECHNICAL SKILLS

Relational Databases: MS SQL Server 2005/2008/R2/2012/2014, Oracle, MS Access.

Reporting Tools: SSRS, Report Builder.

Database Tools: SQL Server Business Intelligence Development studio(BIDS), SQL Server Management Studio, Analysis Services (SSAS), Visual Studio, Query Analyzer, SQL Profiler, TFS.

Languages: SQL, T-SQL, PL/SQL, VB.Net, V.B 6.0, C, C++, ASP.Net.

Web Technologies: HTML, XML, XSL

Data Modeling Tools: ERWIN, ETL, Visio, Microsoft Office Suite.

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services(SSIS), SQL Server Analytical Services (SSAS).

Operating Systems: Windows 2000/XP/2003/2008, UNIX, LINUX.

PROFESSIONAL EXPERIENCE

Confidential, IL

SQL Server BI Developer

Responsibilities:

• Build SQL queries, stored procedures, views and functions as needed.
• Worked on new Data ware house design for ETL and Reporting projects using SSIS, SSRS andAzure.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Extracted data from various OLTP data sources, such as MS Access, MS Excel, Flat files, CSV files into SQL Server 2014 databases.
• Installed Personal gateway on the server and used to configure the refresh schedule for dashboard.
• Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
• Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
• Implemented Event Handlers and Error Handling inSSISpackages and notified process results to various user communities.
• DevelopedSSIS,SSRS/ T-SQLCode and schedules jobs for Jobs Monitoring Automation.
• Worked on PowerShell Script onAzureAutomation account for creating the scheduling jobs on SSAS cube processing on daily basis.
• Configuring and Deploying of all the Reports (RDL, RDS) across various SDLC environments.
• Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
• Experienced in SSAS tabular data modelling.
• Developed Scorecards/Reports for the system usingSSRS, PowerBI.
• Create Daily/Weekly/Monthly power view reports using Power View Reports and schedule them on the SharePoint for the refresh.
• Created Power BI Dashboards to show KPI's in the project.
• Generated reports likeTabularReports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Designed, coded and implemented ad hoc reports in SSRS.
• Worked on formatting SSRSreports using the Global variables and expressions.
• Used various advanced SSIS functionalities like complex joins, conditional splitting, column conversions for better performance during package execution.
• Create reports in Power BI preview portal utilizing the SSASTabular.
• Designed and implemented SSASTabularCube as the reporting layer.
• Create Power View reports using Power Pivot Data models.
• Developed impactful reports usingSSRS, MS Excel, Pivot tables and Tableau to solve the business requirements.
• Worked on Data Analysis Expressions (DAX) for accessing data directly fromtabularSSAS database.
• Import data from SQL Server databases and Analysis services into power pivot data model.
• Maintained the physical database by monitoring performance, integrity and optimizeSQLqueries for maximum efficiency usingSQLProfile
• Created Power BI Reports using theTabularSSAS models in Power BI desktop and published them to Dashboards using cloud service.
• Created various kinds of reports using Power BI and SSASTabularbased on the client's needs
• Responsible for debug, performance checks and performed index tuning and query optimization.
• Created data base backups and restored in several environments.
• Created designs and process flow on to how standardize Power BI Dashboards to meet the requirements of the business.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.
• Created data maintenance plan for backup and restore and update statistics and rebuild indexes.
• Granted access to the data base users by creating logins with appropriate role permission.

Environment: SQL Server 2014, T-SQL, SQL Profiler, SSIS, SSRS, SSAS, C#, TFS, SSAS, MS SQL Server 2012/2014 R2,Oracle10g, Query Analyzer, Power BI, Power Pivot, Windows 2010, MS Excel.

Confidential, VA

SQL SSIS/SSAS/Power BI Developer

Responsibilities:

• Configured and installed SQL Server on Windows Server and migrated databases from different databases to MS SQL Server.
• Initially loaded data into staging tables using different transformations, control flow tasks, loop containers and data flow tasks, then moved the data into dimension and fact tables.
• DevelopingTableauDesktop reports & dashboards both as standalone and as secureTableau Server reports.
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Created Data-data packages inSSISas part of the automating the process for billing method.
• Scheduling and MaintainingSSISPackages and batch jobs thru SQL Server Agent and using Shell Scripts, C# Script and batch (.bat) files on a day to day basis
• Publish the developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data.
• Involved in performance tuning to optimize queries and enhance the performance of databases, SQL queries, and stored procedures using SQL Profiler, Execution Plan and Index Tuning Wizard.
• Wrote complex Stored Procedures, functions and triggers as and when needed and to convert data logically as per the business requirements to improve the productivity of the claims processing system.
• Experience in configuring with checkpoints, error logging and package logging to redirect error rows and fix the errors inSSIS
• Set up different kinds of transformations like Derived Column, Conditional Split, Lookup, Merge, Row Count, Data Conversion etc., in all the SSIS Packages.
• Set up ETL Jobs to run on a nightly basis into the Data marts by Scheduling SSIS Packages via SQL Server Agent.
• Documented all kinds of Reports and SSIS ETL Packages.
• Designed and developed various types of reports usingTableau.
• Worked with complex reports for Batch process usingTableauand with building the portal to access all the reports.
• Designed and DevelopedSSISPackages using various Control Flow and Data Flow items to Transform and load the Data from various Databases and into Siemens Servers usingSSIS.
• ImplementedSSRSsolutions, used dashboards and gauges to enhance for the business users.
• Created Parameterized reports and Linked reports with the knowledge of report server architecture. (Table, chart and matrix report).
• Used Team Foundation server (TFS) to check in the code changes on daily basis & to keep track of the changes in the team.
• Involved in testing the SQL Scripts for report development,Tableaureports, Dashboards, Scorecards and handled the performance issues effectively.
• Connected to the FTP Server and pull the group of Excel sheets into the SSIS from the folder located on FTP Server.
• Experienced in creating Ad-hoc reports, data driven subscription reports by using parameters, queries and reports in SSRS Report Builder, Developed data-driven subscription to end-users.
• Extracted data from various sources like SQL server 2005/2008, Oracle, CSV, Excel and text file from Client servers and through FTP.
• Responsible for Deploying, Scheduling Jobs, Alerting and MaintainingSSISpackages using integration services catalog.

Environment: T-SQL, SSIS, SSAS, SSRS, MS SQL Server 2012, TableauDesktop (Desktop, Server), Microsoft Visual Studio,Tableau, SQL Server Management Studio, MDX, Excel, Windows server 2008, Visual Studio 2008/2010, TFS

Confidential, Plano, TX

SQL Server Developer

Responsibilities:

• Analyzing the transactional data in DB2 and other source systems using Data Profiler.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like (Progress Database, Excel, CSV, flat file, Text Format Data).
• Developed SSIS packages using various Control Flow and Data Flow items to Transform and Load the Data usingSQLServerIntegration services (SSIS)
• Created new logical and physical design of database to fit new business requirement and implemented new design intoSQLServer.
• Experienced in implementing complex dynamic SQL commands such as Stored Procedures, Triggers, Functions, Indexes, Tables, Views,SQL joins and other T-SQLstatements.
• Utilized Extract, Transform and Load (ETL) process in SQL Server Integration Service (SSIS) to migrate databases from Heterogeneous data Sources (DB2, Access, or Excel) to a centralized IT destination.
• Experienced in Developing, Monitoring, Configuring and Deploying SSIS packages.
• Monitored performance and optimizedSQLqueries for maximum efficiency.
• Worked with Flat Files, OLE DB Source, and Excel Source loading.
• Involved in Deployment of SSIS Packages across various Production, QA environments.
• Experienced in generating reports like matrix, parameterized and drill through reports using SSRS and developed stored procedures using functions to generate various kinds of reports using SSRS.
• Strong conceptual, analytical, and design skills with leadership qualities.
• Able to work with a team or individually with excellent communication skills, and ability to meet deadlines in a fast-paced work environment.
• Created various reports according to the business requirements. Individually authored, installed, deployed and managed reports using SSRS 2008.
• Generated various Report models on Views and deployed them on to the production reportingserver.
• AnalyzedSQLqueries using Execution plan, Query Analyzer,SQLProfiler and database Engine tuning Advisor.
• Hands on experience in using tools like Index Tuning Wizard,SQLProfiler and Windows Performance Monitoring.

Environment: SQLServer2012/2008R2,MS Excel, MSSQLQuery Analyzer, Crystal Reports,SQLProfiler, SSIS, ETL, MSSQLServerReporting Services, MSSQLServerAnalysis Services.

Confidential

SQL Server Developer

Responsibilities:

• Installed and configured MSSQLServerand Applied service packs and hot fix.
• Logically and physically designed database for projects on basis of user requirements using ERWIN.
• Created complex Stored Procedures.
• Used Query Analyzer to optimizeSQLQueries.
• Wrote various Stored Procedures for the purpose of application development
• Converted variousSQLstatements into Stored Procedures thereby reducing the Number of database accesses.
• Ensured constraints and writing triggers to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.
• Successfully loaded data from an EXCEL, Access into aSQLServerdatabase Table.
• Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.
• Scheduled Backups and performed Restore operations for system test data.

Environment: MSSQLServer2012, T-SQL, Enterprise Manager, Windows Server, MS Office, Erwin.