SUMMARY

• 8 years of IT experience as MS - SQL Server Developer, involved in Design, Development and Support of MS SQL Server 2005/2008/2008 r2/2014, 2016.
• Proficient in Relational Database Management Systems (RDBMS)
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Strong knowledge in Sybase ASE database programming using T-SQL Stored Procedures, Built in Functions, Triggers, Cursors etc.
• Worked on transformations that are available in Power bi query editor.
• Experienced with creating IT solutions for a large inventory of SQL Servers using technologies such as high availability clusters, Always-On, Mirroring, Log-Shipping and Replication.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Expertise experience in installation and configuration of SQL 2016/2014/2012/2008/2005/2000 SQL Server database services.
• Integrated custom visuals based on business requirement using power BI desktop.
• Converting all operational excel report into Power BI Reports.
• Working experience in testing SQL server 2016 new features like Availability group fail-over when there are drive issue.
• Create Power BI dashboards interfacing with multiple financial applications and file systems, including data models, reports, interactive visualizations
• Expertise experience in database Performance tuning, query optimization using DMV’s and DMF’s.
• Executed dashboard setups and data manipulation using DAX.
• Expertise Experience in building complex SSIS and DTS packages using Business Intelligence Development Studio.
• Experience in SQL Server Database partitioning on very large databases (VLDB’s).
• Used Power BI Gateways to keep the dashboards and reports up to date
• Experience in implementation of encryption strategies such as Transparent Data Encryption (TDE).
• Expertise experience in Data scrubbing using TSQL(Optima and TDM).
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by usingv Dax.
• Expertise experience in handling level-one, mission critical applications.
• Experience with on-call problem resolution and triage in SQL Server environments.
• Experience in working with teams such as Infrastructure, Storage, Networking, Development and QA.
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Developed, maintained, and published the Standard Operating Procedures (SOP) for Close Support, Engineering, and Application & Web Development on Share-point
• Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
• Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.
• Been an active team member and has worked on developing utilities using C, SYBASE, ORACLE PL/SQL, with UNIX PERL, UNIX Shell Scripting.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Very good understanding of Partition, Indexing and Optimization Goals of Sybase 15x.
• Good Work experience of Embedded SQL and C Sybase Open servers and remote Procedures.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
• Experience Strong Mainframe skills COBOL, JCL, standard IBM utilities
• Extensive experience in SQL Server Database Architecture, Performance tuning, Performance Monitor, Plan assessment andSQL scripts.
• Proficient in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS and BCP.
• Experience in Cube designing in Business Intelligence Development Studio using SSAS.
• Excellent in High level Design of SSIS packages for Integration and Migration of data from heterogeneous sources like Flat files, Excel, CSV, Text Format Data, and Oracle to MS SQL Server.
• Worked on Crystal Reports XI Designing.
• Hands on experience in trouble shooting database issues.
• Experienced in data loads, database integration/conversions, performance tuning and optimization.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects
• Expert in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Ad-Hoc, Drill down, Drill Through, Parameterized, Matrix, Chart, Cascading, Table and sub reports based on Relational and OLAP databases
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL 2005/2008.
• Excellent SQL Server administration skills including User Authorizations, Database Creation, Tables, Indexes and Clusters creation
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule ETL Packages.
• Worked extensively on all facets of the project (Complete SDLC).
• Experience in Software development methodologies such as Agile, Scrum and RUP models.

TECHNICAL SKILLS

Databases: SQL Server 2014/2008 R2/2008/2005, Oracle 11g/10g/9i, PostgreSQL 9.3, Sybase 15x.

Platforms: Windows Server 2008/2003/2000/ NT, UNIX, WAMPSERVER 2.0, Apache 2.2.

Reporting Tools: SSRS, Crystal Reports,Power BI

Languages/Utilities: SQL, T-SQL, PL/SQL, VB, VB.NET, C, C#, ASP.NET, PL/pgSQL

Tools: Visual Studio 2003/2005/2008 , BCP, BIDS, SSMS, SQLCMD, DTA, Profiler, SQL Agent, MS VISIO, ERWin 4.1/7.0

Web Technologies: HTML, DHTML, XML, CSS, Share Point

ETL Tools: SSIS/DTS, Crystal Reports.

Version Control: VSS, TFS, SVN

Microsoft Office Applications: Excel, Word, Access, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Springfield, IL

SQL Database Developer

Responsibilities:

• Updated existing and created new reports using Microsoft SQL Server Reporting Services. Team consisted of 2 developers.
• Performed front line code reviews for other development teams.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Develop SSRS reports and configure SSRS subscriptions per specifications provided by internal and external clients.
• Used Power BI Gateways to keep the dashboards and reports up to date
• Experience working on MainframeTechnology.
• Knowledge on mainframe systems and application development/maintenance of mainframe application software. develop and unit test the code with varying complexities on mainframe systems
• Work on support tickets, maintenance tasks and assigned projects at discretion of the Reporting Coordinator.
• Developed and Optimized Stored Procedures and Functions using T-SQL
• Created Dax Queries to generated computed columns in Power BI.
• Gathered business requirements and converted it into SQL stored procedures for database specific projects.
• Researched and resolved data issues related to existing data and processes in place before my tenure
• Created and scheduled SQL Agent jobs and maintenance plans.
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Modified and maintained SQL Server stored procedures, views, ad-hoc queries, and SSIS packages.
• Designed and implemented complex SSIS package to migrate data from multiple data sources.
• Assist System Development Manager in developing queries, executing scripts, reports, and monitoring
• Assist System Development Manager in development, setting up and managing automated backups.
• Published reports and dashboards using Power BI.
• Assist System Development Manager in Microsoft SQL Server management and database maintenance
• Assist System Development Manager in performance tuning and database optimization
• Identifying performance improvements to database procedures and data structures and working with Development teams to deliver code changes
• Worked on transformations that are available in Power bi query editor.
• Created SSIS package to extract, validate and load data into Data warehouse.
• Created Stored procedure, Views, Cursors, and functions to support application
• Weekly presentation to the business users about the reports and their changes as required.
• Monitor SQL server and database performance and proactively address potential performance issues
• Extensively created SSRS reports (Executive Summary report for Annual and Quarterly) and Configured Report Server on all the environments. Also automate deployment for SSRS reports for all the environments.
• Implemented multiple grouping into several reports using visibility and toggle options.
• Actively supported Business users for change requests and provide support to team members.
• Provided support by troubleshooting and solving the issues.
• Extensively worked on creating SSIS packages and have used for each Loop containers, Sequence Container for developing processes and loaded data using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
• Wrote several stored procedures, functions, and cursors to build consistent reports.

Environment: MS SQL Server 2012/2008 R2, SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Power BI,MS SQL Server Analysis Services (SSAS), MS Access 2007, XML, MS Excel, Erwin 3.5.2, MS-Visio 11.0.

Confidential, Atlanta, GA

MSBI Developer/DBA

Responsibilities:

• 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.
• Used various sources to pull data intoPower BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.. .
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, Text files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Worked on various tasks and transformations like Execute Sql Task, Execute Package Task and conditional split, Script Component, Merge and Look-up etc.
• Developed Excel PowerView, PowerQuery and PowerPivot dashboards for data analysis
• Executed dashboard setups and data manipulation using DAX.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures.
• Created and deployed various reports like ad-hoc reports, Crystal Reports, simple and parameterized reports using SQL Server Reporting services (SSRS).
• Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment.
• Promoted database objects from test/development to production. Coordinated and communicated production schedules within development team
• Involved in preparing training document for application development and QA/UAT teams.
• Actively involved in agile development methodology.

Environment: MS SQL Server 2012/2008 R2, SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), Power BI, MS Access 2007, XML, MS Excel, Erwin 3.5.2, MS-Visio 11.0.

Confidential, Des Moines, IA

SQL BI Developer/DBA

Responsibilities:

• Involved in designing and implementing database applications using MS SQL Server 2008/2012/2014/2017 and Business Intelligence (BI) tools to support transactions and business decision-making.
• Responsible for creating reports based on the requirements using SSRS. Experience in creating reports using SSRS Report Builder 3.0
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2017.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drill down, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Created different types of reports such as Crosstab, Drill-down, Drill Through, OLAP and Sub reports, and formatting them using both SSRS 2017.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel andtableau.
• Involved in created stored procedures, views, and custom SQL queries to import data from SQL Server totableau.
• Deployed the generated reports on to the server and various environments.
• Advanced extensible reporting skills developed SQL Server reports using SSRS.
• 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.
• Migrated DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Developed stored procedures and used SSIS 2005 to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Designed and implemented SQL Server database objects (Complex stored procedures, functions, views and complex T-SQL/queries) to support reporting and various business processes.
• Created Calculated Columns and Measures in Power BIand Excel depending on the requirement using DAX queries.
• Experience on publishing Power BI reports on dashboards in Power BIserver.
• Managed relationship between tables in Power BI using star schema.
• Used different type of slicers available in Power BI for creating reports.
• Develop and implement new and existing database solutions
• Design, Develop and Deploy Microsoft Power BI reports

Environment: MS SQL Server 2005/08/12 (Query Analyzer, SQL Profiler), SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services), ASP.NET, ETL, Business Intelligent Studio, SQL Server Management Studio, ASP, Crystal Report, Enterprise Manager, MS Excel, Windows XP Professional, TFS .

Confidential, Tampa, FL

SQL BI Developer/ SQL Server DBA

Responsibilities:

• Involved in requirements gathering and participated in all phases of development life cycle.
• Determined the technical requirements of the project and came up with the architecture design. Played a key role in designing the database and created the required entities, attributes and relationships between database objects.
• Created stored procedures, triggers, user defined functions, views, indexes etc.
• Installed, configured and administered SQL Servers on IAAS - Infrastructure as A Service on Microsoft Cloud Environment.
• Installed, configured and maintained high available solutions such as Database Mirroring, Always-on, Replication, and Log Shipping.
• Installed, configured, and administered SQL Server Reporting Services (SSRS) for different purposes like DBA Reports, and user reports using SSRS.
• Developed stored procedures and scripts for automation of several daily maintenance tasks, monitor critical database alerts, monitor any blocking process for more than 3 minutes.
• Implemented partitioning on very large databases (VLDB’s) to improve data archiving process.
• Implemented Transparent Data Encryption on level one database which contains sensitive customer information.
• Worked extensively on developing, deploying, and maintaining SSIS packages in SQL Server Integration Services.
• Monitored and tuned the performance of complex T-SQL queries and stored procedures by analyzing the execution plan.
• Created and monitored SQL Agent job to import delta data every 15 minutes from PostgreSQL database to SQL Server database for more than 100 tables.
• Created Crosstab report (Grid report), Mailing Label report, Blank report, Sub report, OLAB cube report.
• Exported reports to different format as (Excel, word, PDF, database, RTF, text, and CSV). ETL concepts.
• Understand, evaluate, and implement tools and trends in database systems administration.
• Develop and implement core Sybase databases including ASE 12.5 and 15.
• Maintain and manage backup, recovery, storage, and user administration.
• Assist and support in production installations of various ASE releases.
• Designed ETL packages dealing with different data sources (Oracle, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Supported monthly SQL server patch process which included patching SQL servers with latest service pack and time sensitive security patches. Provided user support during post patch validation of the databases and applications
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures.
• Involved in the enterprise Data Warehouse designing using Kimball design methodologies and following DW design best practices.
• Involved in planning and designing SSAS cubes.
• Involved in preparing training document for application development and QA/UAT teams.

Environment: MS SQL Server 2008 R2/2014, SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), Oracle, PostgreSQL, MS Excel, DBSchema

Confidential, HIGHLANDS RANCH, CO

SQL BI Developer/ SQL Server DBA

Responsibilities:

• Involved in requirements gathering and participated in all phases of development life cycle.
• Determined the technical requirements of the project and came up with the architecture design. Played a key role in designing the database and created the required entities, attributes and relationships between database objects.
• Created stored procedures, triggers, user defined functions, views, indexes etc.
• Installed, configured and administered SQL Servers on IAAS - Infrastructure as A Service on Microsoft Cloud Environment.
• Installed, configured and maintained high available solutions such as Database Mirroring, Always-on, Replication, and Log Shipping.
• Installed, configured, and administered SQL Server Reporting Services (SSRS) for different purposes like DBA Reports, and user reports using SSRS.
• Developed stored procedures and scripts for automation of several daily maintenance tasks, monitor critical database alerts, monitor any blocking process for more than 3 minutes.
• Implemented partitioning on very large databases (VLDB’s) to improve data archiving process.
• Implemented Transparent Data Encryption on level one database which contains sensitive customer information.
• Worked extensively on developing, deploying and maintaining SSIS packages in SQL Server Integration Services.
• Monitored and tuned the performance of complex T-SQL queries and stored procedures by analyzing the execution plan.
• Created and monitored SQL Agent job to import delta data every 15 minutes from PostgreSQL database to SQL Server database for more than 100 tables.
• Created Crosstab report (Grid report), Mailing Label report, Blank report, Sub report, OLAB cube report.
• Exported reports to different format as (Excel, word, PDF, database, RTF, text, and CSV). ETL concepts.
• Understand, evaluate and implement tools and trends in database systems administration.
• Develop and implement core Sybase databases including ASE 12.5 and 15.
• Maintain and manage backup, recovery, storage and user administration.
• Assist and support in production installations of various ASE releases.
• Designed ETL packages dealing with different data sources (Oracle, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created and deployed various reports like ad-hoc reports, simple and parameterized reports using SQL Server Reporting services (SSRS).
• Responsible for maintaining existing SSRS reports, developed and deployed different types of customer facing reports like matrix, drill down, sub reports, drill through, chart etc.
• Developed process using tools such as AZ Copy to transfer data between different subscriptions and containers on Microsoft Cloud Environment. Process also included data transfer between on-premise and cloud.
• Used dynamic management views and dynamic management functions as well as DBCC to check database conditions, fix database corruption, rebuild indexes.
• Supported lease replacements of SQL Servers which included identifying servers coming out of lease, providing specifications for provisioning of new servers and migrating databases to new servers.
• Involved in preparing training document for application development and QA/UAT teams.

Environment: MS SQL Server 2008 R2/2014, SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), Oracle, PostgreSQL, MS Excel, DBSchema

Confidential, Costa Mesa, California

SQL BI Developer

Responsibilities:

• Migrated SSIS packages from R2, Developed and deployed new packages.
• Migrated SSRS reports from R2.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in 3 environments (Development, QA and Production).
• Involved in testing SSIS packages in QA environment.
• Worked on various tasks and transformations like Execute Sql Task, Execute Package Task and conditional split, Script Component, Merge and Lookup etc.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures.
• Providing design, development, and testing support to assigned application teams.
• Installing SQL Server products; managed patching and compliance issues.
• Maintaining Transactional SQL Replication between source and target SQL Server databases.
• Involved in migration of SQL Databases using Migration Utility.
• Setting up linked servers between SQL and DB2 data sources.
• Configured SQL Mail where in the SQL Server will send notification through a page on failure of a job on production and email on non-production environments.
• Worked on data modeling projects from starting to finishing, generated scripts for objects, Developed Relationship, and created E-R Diagram using ERWIN.
• Export & Import data from Flat file, CSV file to/from SQL Server databases using DTS, and BCP
• Monitored Database Backup and other jobs in the maintenance plan Restoration and Point-in-Time Recovery.Scheduling of operation and outages.
• Creating, modifying and managing tables, Index, Constraints, Views, Stored Procedures, and Triggers.
• Optimized long running Stored Procedures for effective data retrieval.
• Created and deployed various reports like ad-hoc reports, Crystal Reports, simple and parameterized reports using SQL Server Reporting services (SSRS).
• Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.
• Responsible for scheduling jobs, Alerting and maintaining SSIS packages.
• Involved in preparing training document for application development and QA/UAT teams.
• Prepared documentation for the disaster recovery plan.

Environment: MS SQL Server 2005/2008 R2, SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), Oracle, Teradata, MS Access 2007, XML, MS Excel, Erwin 3.5.2, MS-Visio 11.0.