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 .
• 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, Redmond, WA

SQL BI/ Power BI Developer

Responsibilities:

• 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.
• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.
• 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
• 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 storage, partitions and aggregations and developed different calculated members, KPIs, actions by using the MDX 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/ 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 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.

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.
• Generated occasional reports in view of the factual investigation of the information utilizing SQL Server Reporting Services ( SSRS )
• Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.
• 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.