SUMMARY:

• Around 8 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.
• 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.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• 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.
• 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.
• Expert 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, 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.

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

Languages: SQL Server, 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, Providence, RI

MSBI Developer

Responsibilities:

• Enterprise Reporting Management of Confidential was used to generate the reports for finance and operations 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 PCS master job.
• 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.
• Translated the existing Reports from Translational to Dimensional in SQL Server Management Studio.
• 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 complex stored procedures to process requirement and generating records between front End and back end.
• 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.
• 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.
• 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, Boston, MA

SQL BI/ 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, NiSource, OH

BI 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 Trouble-shooting 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.