SUMMARY:

• 8+ Years of extensive IT experience as a Microsoft SQL Server Developer in creating Business Intelligence Solutions like SSIS, SSAS, SSRS and expertise in designing and implementing Relational Database model as per business needs in different domains like Insurance, Banking, Retail, Finance and HealthCare.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Functions, User Defined Data - Types, Rules, And Defaults.
• Scheduled and maintained daily and monthly loads of OMS, Orders, Objectives and Adjustments data through jobs, tasks, and alerts.
• Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP, Cubes and Normalizations.
• Successfully implemented Log Shipping Technique to maintain a standby server backup for Disaster Recovery.
• Experience in writing complex Stored Procedures, Indexed Views and Triggers for data consistency and manipulation.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Power BI experience in designing Interactive Reports and Data Visualization using Power BI Desktop.
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Broad working experience on administrative tasks such as Data loading/unloading, processing batch jobs, creating databases/File groups/Files/Transaction logs, Backup and Recovery.
• Working experience on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
• Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Experience using performance optimization tools like Database Engine Tuning Advisor, SQL Profiler, and Index Tuning Wizard.
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Experience with C# and VB.Net scripting when using SSIS packages.
• Expert in handling parameterized reports in SSRS 2005/2008/2012.
• Experience in creating Multidimensional cubes using SQL Server Analysis Service (SSAS).
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis.
• Experienced in client requirement Analysis, Logical and Physical design & development of databases (using MS Visio, Erwin, normalization, and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server DTS, SSIS, SSAS and SSRS.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Flexible, enthusiastic and project oriented team player with excellent communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2000, 2003, 2008 and 2008R2. Unix, MS Windows (95,98,NT,2000,XP)

SQL Server and Database Tools: SQL Server 2008/2012/2014/2016. MSBI Tools - SSIS(Integration), SSAS(Analysis), SSRS(Reporting), Power BI.

Languages: MDX/DMX, VB.Net, VB Script, Transact-SQL, PL/SQL, HTML, DHTML, XML, ASP, C and C++.

Reporting Packages: SQL Server Reporting Services, Import Export Data, Bulk Insert, Business Objects 6.5/XI/XIR2, Crystal reports, MS Excel.

Data Modeling and Configuration Tools: Erwin, MS Visio, Toad Data Modeler 5.1

Methodologies: Agile, SCRUM, Waterfall.

Testing Tools: Quick Test Pro, Mercury Quality Center, TOAD (Tool for Application Developers).

PROFESSIONAL EXPERIENCE:

Confidential, Louisville, KY

Sr. SQL BI Developer (SSIS/SSRS/SAS)

• Wrote complex SQL queries using joins, sub queries, and correlated sub queries to retrieve data from the database.
• Implemented error handing techniques such as try catch and error functions to create robust T-SQL
• Created data mapping document (DMD) by analyzing various OLTP data sources.
• Optimized the performance of existing TSQL queries with utilization of query optimization techniques such as indexes, table partitions, CTE's, execution plans, and made structural changes to queries.
• Developed reports and deployed them on server using SQL Server Reporting Services(SSRS)
• Implemented business logic utilizing CTEs, temporary tables, table variables, dynamic SQL,and system / aggregate / ranking functions.
• Created views and stored procedures for generating report datasets in SSRS.
• Scheduled reports for daily, weekly, and monthly reports; created reports for executives, business analysts, and customer representatives based on business needs.
• Tuned SQL queries by analyzing execution plans, reorganizing/rebuilding indexes.
• Experience in creating scheduling Jobs, Alerts.
• Used Execution Plan,SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Setting up ODBC connections with Teradata, SAS, SQL servers on machine to extract data.
• Involved in Understanding the Existing Reports that are generated in EXCEL.
• Imported and exported data from other data sources such as Excel, Access.
• Ran SQL queries Via Teradata SQL assistant.
• Worked on POWER BI to collect the data and update on the EXCEL reports as per the business requirement.
• Imported Data from Multiple data sources Teradata/SAS/SQL server which also includes Web files, MS-Excel through OLEDB and ODBC connections, Text, CSV files
• Worked closely with the Business Analysts to gain a good understanding of the specifications and time lines.
• Extended full support for the team regarding issues, feature discussions, and/or enhancements.

Environment: MS SQL Server 2008 R2,MS SQL SERVER 2014/2016, SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services),Power BI, Power View, Visual Studio 2008,Tableau,SharePoint, SQL Server Management Studio, ASP, Toad Data Modeler 5.1, SAS Enterprise Guide 4.3, Teradata SQL assistant

Confidential, Jersey city, NJ

Sr. SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Installed and Configured MS SQL Server successfully.
• Expertise in Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Involved in gathering requirements in conceptual data modeling phase.
• Involved in designing database using MS Visio.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.
• Worked as a developer in creating complex Stored Procedures, triggers, cursors, Indexes, tables, and views and other SQL joins for building various applications.
• Created and managed Clustered indexes and Non-Clustered indexes and optimized queries using execution plan.
• Developed multiple dashboards with Power BI depicting differing KPIs for business analyses.
• Implemented pivot/un-pivot, transpose features of Power BI to load data into excel Power Pivot.
• Employed bar charts, bubble charts, and Power map to answer business questions with Power BI
• Created and maintained logins, roles and permissions on the SQL instances and databases and provided required privileges according to the user's requirements.
• Used MS Access for creating the tables.
• Developing the reports using POWER BI, Power Pivot and SSRS and SSIS, SSAS

  Adding the feeds and Scheduling the jobs

• Experience in writing complex queries and table joins using Oracle
• Implemented High availability concepts, Data base Mirroring, Replication and log shipping.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in development, enhancement, testing and performance tuning of the application.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Resolved various performance issues by running DBCC command.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Worked on various kinds of Transformations like Import Column, Export Column, SCD and Lookup in SSIS as per the client's Requirement.
• Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.
• Involved in writing stored procedures and User Define Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Used SSIS features like package event handlers, property expressions, and package configurations, transactions in packages, checkpoints and protection levels.
• Used C# and VB.Net scripting when performing SSIS packages.
• Utilized SSRS reporting services to generate several types of reports from the database.
• Created Report Subscription using SSRS.

Environment: MS SQL Server 2008/2012/2014 (Query Analyzer, SQL Profiler), SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services), Power BI, Power View, Business Intelligent Studio, SQL Server Management Studio, ASP, Crystal Report, Erwin, T-SQL, MySQL, OLTP, Oracle 11g, Enterprise Manager, MS Excel, Windows XP Professional, TFS.

Confidential, Rochester, NY

Sr. MS SQL BI Developer (SSRS/SSIS)

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Monitoring SQL Server performance using SQL Server Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.
• Expertise level of knowledge as a data analyst in data conversion and data cleansing from the raw data sources.
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Intensive testing on improving performances of databases. Hands on experience in controlling Jasper repositories and handed data processing.
• Involved in gathering reports requirements and then generated reports on Jasper.
• Initially used Jasper ETL pro for doing the same later on moved to Talend Integration Suite (TIS) for developing the ETL jobs.
• Huge experience in working with complex stored procedures, joins, taking advantage of set based approach in order to replace time taking cursors, indexes and many more.
• Responsible for making an analysis of transactions of the client and determining solution for settlement of the client account.
• Proficient in usage of SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Employed bar charts, bubble charts, and Power map to answer business questions with Power BI
• Mapped millions of records over Bing maps from Excel data model and discovered actionable
• Having hands on experience in DR Processes including Log Shipping and Database Mirroring.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.

Environment: Windows Advanced Server, MS SQL Server 2008/2012, TSQL, PL/SQL, MS Visio, SSRS, SSAS, SSIS, T-SQL, Visual Studio 2008, Oracle 11g, Jasper Reports 6.1.0 API, SharePoint 2007/2010

Confidential, Richfield, MN

SQL/Crystal Report Developer (SSRS/SSIS)

Responsibilities:

• Developed complex T-SQL stored procedures using joins and unions to create crystal reports and optimized SQL queries for efficiency and the front-end developer with their queries and procedures.
• Developed crystal reports using Crystal Reports 10 for detail information to the sales team regarding sales of all stores according to the criteria given, which helped the sales team to take their decisions.
• Developed E-R diagram for reports which gives all the relationships of the tables from huge De-normalized database using Microsoft Visio.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Developed various functions using SQL Server 2008 for the interfaces which were automatically run on daily, weekly and monthly basis using SQL server task in SSIS.
• Responsible for optimization of the T-SQL queries to give the faster results from whole bunch of data using SQL Profiler and also provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.
• Developed temporary tables and views of the databases for faster use and faster retrieval of the data and helped developer's team to reduce the complexities of fetching data and access complex database.
• Developed Demo Results of the reports which are useful for the UAT phase to get the approval from the key users.
• Involved in Data conversion to clean the legacy database and reuse it for annual decisions of the sales and also created mapping between legacy tables and current tables in the database.

Environment: MS SQL Server 2008, Windows Server, DTS, SQL profiler, SSAS, SSIS, SSRS, Performance Monitor, Query Optimizer, T-SQL, Microsoft Visio 2007, MS Visual Studio 2008, Crystal Report 10.

Confidential, Columbus, OH

SQL Server Developer (SSRS/SSIS)

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Writing complex queries and generating reports.
• Extracting queries from multiple databases like Teradata and AS 400
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Debug and analyze VBA code/ SQL stored procedures.
• Develop and modify stored procedures/ VBA code.
• Experience with MS Office software (Excel, Accessand Word).
• Worked on Teradata insert, Update, modify and Dynamic SQL to transform and load Summary tables built on Core Data Warehouse
• Extensively worked on Performance Tuning of Teradata SQL using explain plan and understanding Joins and Data distribution.
• Extensively worked on Maestro to schedule jobs as daily batch.
• Involved in writing Automation Testing scripts using Shell and Perl to schedule these scripts in DEV.
• Build, test, and execute one-off procedures as needed to support business commitments. Answer business user questions. Investigate and resolve issues or problems that arise. On call for production troubles.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and deployed SSRS reports.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, MS Reporting Services 2008, MS-Excel, MS Access, MS Visio, Teradata, T-SQL, Erwin, LDAP, AS400, Visual Studio 2008, VBA, PERL, BTEQ.

Confidential

MS SQL/BI Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created Tables, Stored procedures, databases and defined functions. Created SQL scripts for tuning and scheduling, Dashboards using SSRS.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Migrated all DTS packages to SQLServer Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQLServer Reporting Service 2008.
• Involved in relational database modeling like, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
• Worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly basis, file-transfers from one location to other.
• Created complex SSIS packages using appropriate control and data flow elements with SSIS Standards like error handling, logging and working with package config files.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to the local DB Server using SSIS.
• Reduced the overall ETL time by SQL Query performance Tuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Enhanced and deployed the SSIS packages from development server to production server and scheduled jobs.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, MS Visio, Erwin, LDAP, BCP, T-SQL.