SUMMARY:

• Having 7+ Years of IT experience in the Analysis, Design, Development, Implementing and Testing Client/server application using Confidential SQL Server and BI suite.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2014 and SQL Server 2016 .
• Expertise in SQL Server Integration Services ( SSIS ) and SQL Server Reporting Services ( SSRS ) with good knowledge on SQL Server Analysis Services ( SSAS ).
• Strong experience in design and developing ETL using MS SQL Server Integration Services (SSIS). Worked with various versions starting 2000, 2005, 2008, 2008 R2 2012 and 2014.
• Experience in report writing using SQL Server Reporting Services ( SSRS ) and creating various types of reports like drill down, drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional Table, Matrix, Chart and Sub Reports.
• Solid knowledge of Power BI Desktop & report performance optimization.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Derived column, Conditional Split, Bulk Insert, Merge and union all.
• Developing SSRS reports on SQL Server, Good understanding of SSAS, OLAP cube and Architecture.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T - SQL .
• Worked Extensively on ETL process using SSIS package.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Good understanding of Data Warehousing concepts and ability to utilize star schema and snow flake schema according to the requirement.
• Experience in using T-SQL in SQL Server 2000 , 2005and 2008 platforms.
• Experience in Performance Tuning and Query Optimization.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Transformed data from one server to other servers using tools like Bulk Copy Program ( BCP ), Data Transformation Services (DTS) and SQL Server Integration Services ( SSIS )
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), and Power BI.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
• Good knowledge of System Development Life Cycle ( SDLC ), Agile and Waterfall development environments.
• Experience in Code Check-in, creating and updating tasks in Scrum based Projects, etc. using tools like Visual Studio Online ( VSO ).
• Good understanding and hands-on experience on XML, XSL ( XSLT, XPath, XSL-FO ).
• Experience with defect tracking and analysis using different defect tracking tools such as TFS ( Team Foundation Server )
• Good knowledge of the principles of DW using Fact Tables, Dimension Tables, Star and Snowflake Schema Modeling. Written MDX query in OLAP databases.
• Experience in creating Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.

TECHNICAL SKILLS:

Databases: SQL Server 2000/2005/2008/2012/2014/2016, SQL Server 2008 R2, MS Access, ORACLE 10g/11g, MySQL, Teradata, DB2.

Database Tools: Business Intelligence Development Studio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service, SQL Server Management Studio, Power BI.

ETL Tools: SQL Server Integration Service (SSIS), DTS

Languages: T-SQL, MS Access, MySQL, C/C++, HTML, P.H.P, JavaScript, Unix, C#, .Net, VBScript, ASP.Net.

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Report, Work day, Power Bi , Tableau.

Office Tools: MS WORD, MS EXCEL, MS VISIO, MS Power Point.

Operating Systems: Windows Server 2000, Windows NT Server, Windows Server 2003, Windows XP, Windows 2008, Windows 7, Windows 8, HTML, XML.

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

SQL BI (SSIS/ SSAS/ Power BI) Developer

Responsibilities:

• Involved in generating the reports which was built on the top of multidimensional cube and migrated into tabular modal.
• Did different POCs like Process Control Framework POC - To verify multiple worker thread under one PCF master job.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Tabular With 500 Million Rows - To test performance and scalability of tabular.
• PNL Report - To avoid customization like in existing PNL report using tabular cube.
• Troubleshooting of the burning issues in tabular and multidimensional cubes.
• Worked in a sprint environment where there is 2 weeks sprint.
• Used Visual Studio Online ( VSO ) and TFS for code check-in, creating, updating tasks etc.
• Created complex Stored Procedures , User Defined functions, Triggers, Indexes, Tables, Views, SQL joins and defined roles and privileges to implement business rules and control access to database.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
• Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Created New Reports by using SSRS & did the performance of SSRS Reports.
• Designed dynamic DTS and SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Established the relationships among the tables in the database by assigning primary keys, Foreign keys and established the referential integrity.
• Involved in Planning, Defining and Designing database depending on business requirements and provided the documentation.
• Created complex Stored Procedures, User Defined functions, Triggers, Indexes, Tables, Views, SQL joins and defined roles and privileges to implement business rules and control access to database.
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS .
• Extensively involved in the design of SSAS & Tabular storage, partitions and aggregations and developed different calculated members, KPIs, actions by using the MDX & DAX while designing the cube using SSAS
• Created Tabular Models using DAX queries in analysis services and deployed it.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Created POWER BI Visualizations and Dashboards as per the requirements.
• Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc.

Environment: T-SQL, MS SQL Server 2016, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, SQL Server Analysis Services (SSAS), Visual Studio 2016, OLAP.

Confidential, East Chicago, IN

SQL BI/ SSIS/Power BI Developer

Responsibilities:

• Experience in Extract, Transform and Load Process/design, source-target mapping, reviewing, writing, tuning Complex ETL jobs - daily and high frequency.
• Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity.
• Exposure to complete development life cycle of Enterprise Data Warehouse design and Development.
• Developed data warehouse in start schema, fully participated in Dimension modeling using Kimball model.
• Experience working with Medicare Advantage Organizational Health Plan and also strong in SQL/SSIS .
• Experience in SSIS, SQL Stored procedures development experience dealing with large volume health care data processing and analytics.
• Involved in performance tuning of the database and T-SQL queries using Execution Plan.
• Manage workload to deliver according to business priorities.
• Created a SQL Server Reporting Services (SSRS) and SSIS Infrastructure that pulls data from different sources and provides a simple to use reporting environment.
• Created and Published Tableau Dashboards into Tableau Server.
• Involved in designing and publishing visually rich and intuitive Tableau dashboards for executive decision making.
• Created Sets, Groups and Data Bins as per user requirements. Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc.
• Provided visual/graphic analysis based on data content.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Created several ad hoc reports, drill down, drill through, sub, linked, cached and snapshot reports using SSRS and deployed them in Native mode.
• Monitor database performance and analyze issues, primarily with Confidential SQL Server 2012/2014.
• Customized columns and tables utilizing Named calculations and Named queries in SSAS .
• Developed stored procedures with advanced programming techniques includes minimal logging, accurate execution plans and index seeking methodologies
• Created Tabular Models using DAX queries in analysis services and deployed it.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Deployed SSIS packages with package/project deployment models for testing and production.
• Wrote custom support modules for upgrade implementation using Pl/SQL, Unix Shell Scripts.
• Involved in physical and logical data modeling using Erwin along with the architects.
• Prepared daily and weekly status reports and collaborated with other team members.

Environment: T-SQL, MS SQL Server 2012/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, Tableau, SQL Server Analysis Services (SSAS), Visual Studio 2013, OLAP, XLST, XPATH, C#, Tableau.

Confidential, OH

BI ETL Developer

Responsibilities:

• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Created new ETL packages to validate, extract, transform and load data into data warehoused databases using SSIS packages.
• Designed and developed SSIS packages to import and export data from MS Excel, SQL Server and Flat files.
• Developed packages in SSIS with error handling.
• Involved in data cleaning to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformation.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Migration of DTS packages to SSIS packages.
• Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 using SSIS .
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Upgradation of System Configuration.
• Planned, Configured, Installed, Maintained SQL Server in environment of Multi-Node Cluster with Mulch-instances.
• Configured and Monitored Database Mirroring for Application Development environment
• Designed Cubes with Star Schema using SQL Server Analysis Services ( SSAS )
• Involved in Installation, Configuration and Deployment of Reports using SSRS
• Actively involved in developing complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts, and Graphs.
• Involved in SQL Server Configuration, Administration, Implementation and Troubleshooting for Business work.
• Controlled, coordinated installations (Security Patches, Service packs) and evaluated the performance before deployment.
• Involved in daily code drops and archives on the production databases during maintenance windows.
• Scripted OLAP database backup and scheduled a daily backup using SQL Server agent job.
• Performed Regular Database Maintenance process, checking the disk Defrag procedures in different environments.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector and also created roles using SSAS to restrict cube properties.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels
• Performed Database consistency checks with DBCC , Defrag, Index tuning and monitored error logs
• Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Work involvement in performance monitoring of Memory, Processor, Disk I/O and fine tuning.
• Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks.

Environment: SQL Server 2014/2012/2008, Query Analyzer, SSIS 2014, T-SQL, Excel, Confidential SQL Reporting Services 2014 (SSRS), SQL server 2014/2012/2008 . Analysis Services (SSAS), DTS, T-SQL, Windows Server 2012 R2, XML, MS Excel, MS Access.

Confidential, Atlanta, GA

MSBI Developer

Responsibilities:

• Conducted database administration, execution estimation and execution tuning for new databases and existing databases by utilizing SQL Profiler, Data Engine Tuning Advisor.
• Developed complex projects in T-SQL , composing Stored Procedures, Triggers and Queries with best execution design.
• Develop SQL parameter based, custom code, SSRS reports for intervention and corporate level HEDIS performance level reporting, HEDIS SQL based reports for Provider, Member, Claims, and Encounter information, create Excel heat mapping custom reports. Create drill through, sub-report, nested data regions, drilldown action reports.
• Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.
• Developed multi-table SQL procedures to extract healthcare data from back-end database for HEDIS reporting.
• Develop SQL and SSIS business intelligence solutions to migrate source data into a centralized data mart structure, for HEDIS and SSRS reporting, SSIS flat file processing. T-SQL to create schemas, tables, views, stored procedures, alter tables and columns, table indexes, pivot/unpivot queries, CTE's, data de-duplication, data cleansing/conversion, ETL Automations
• Rewrote SQL questions to redesign SQL Server execution utilizing SQL Server 2008
• Defined Check imperatives, Business Rules, Indexes, and Views.
• Optimizing Stored Procedures and long-running questions utilizing ordering methodologies and inquiry advancement strategies.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Used the SSIS Import/Export, relocated the Heterogeneous Database, for example, Oracle and Access database, level documents to SQL server 2008 .
• Managed up degree of DTS bundles to SSIS bundles
• Responsible for creating, observing and conveying SSIS bundles.
• Configured SQL mail operator for sending programmed messages when a SSIS bundle is fizzled or succeed.
• Created questions for creating drill down reports in SSRS 2008 . Organized the reports utilizing the Global factors, articulations and Functions.
• Created Linked Servers to associate OLE DB information sources and suppliers.
• Designed different reports utilizing diverse detailing highlights, for example, amass by and penetrate through and so on.
• Created the Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS .
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using MDX.

Environment: SQL Server 2008, T-SQL, Excel, Confidential SQL Reporting Services 2008 (SSRS), SSAS 2008, DTS, Windows Server 2008, MS Excel, MS Access, Power BI.

Confidential

SQL Developer

Responsibilities :

• Analyze client requirements and translate them into technical requirements.
• Created Stored Procedures, T-SQL , Triggers, Views and Functions for the database Application.
• Created various Tabular, Cross-tab, Matrix and Ad-hoc reports using SSRS.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
• Developed data access queries/programs using SQL Query to run in production on a regular basis.
• Created report snapshots to improve the performance of SSRS .
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Performed ETL process by pulling large volumes of data using SSIS, BCP into the staging database from various data sources like Access, Excel.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created alerts, notifications and emails for system errors, insufficient resource, fatal database errors and hardware errors. Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa
• Defined the report layout and identified Datasets for the report generation. Built drill down reports, and also parameterized reports using SSRS.
• Extensively used Report Builder and Report Manager in SSRS .

Environment: Windows NT, Windows 2003, SQL Server 2005/2000, ETL Tools, DTS, SSIS, SSRS, T-SQL, SQL Profiler, Visual Source Safe, MS SQL Reporting Services.