SUMMARY:

• Over 6+ years of experience in IT as a SQL Developer with specialized skills in SSIS, SSAS, and SSRS.
• Experience in managing security of SQL Server 2014/2012/2008 R2/2008/2005 databases by creating database users and roles and assigning proper permissions according to business requirements.
• Strong SQL Server 2014/2012/2008 R2/2008 development skills including writing stored procedures, user - defined functions, triggers, views, and indexes.
• Proficient with SQL Server, BI Stack (SSIS, SSAS, and SSRS), Power BI, and Tableau within large and complex environments.
• Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Server Reporting Services(SSRS)/Power BI.
• Having experience in developing end-to-end Business Intelligence solutions in accordance with Standard OLAP Methodologies using Tableau.
• Created and maintained numerous Crystal Reports including financial and operational Reports.
• Used TFS 2010 to check in SQL scripts, reports and Integration packages. Involved in documenting the entire technical process.
• Extensive experience in designing, developing, and delivering business intelligence solutions using Power BI, SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Validation of the scripts and to check in the scripts like tables, views and stored procedures in to TFS.
• Strong Transact-SQL query writing skills (DDL, DML, and DCL).
• Excellent command writing ad hoc queries utilizing dynamic SQL.
• Extensive experience on Business analysis and Enterprise reporting solutions delivery using Crystal Reports.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS process design architecting the flow of data from various sources to target.
• Expert in SQL Server Business Intelligence suite of products like SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS).
• Expertise in creating reports of all types in SSRS, like ad hoc, drill-down, pivot, and tabular reports.
• Experience in creating DTS/SSIS packages with ActiveX scripting for transferred data modifications.
• Expert in creating complex Crystal Reports (Ad-hoc Reports, Frequency Reports, Summary Reports, Drill Down, Dynamic Grouping, Graphical, aging Reports).
• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Develop optimized SQL Server stored procedures, functions, and database views
• Experience using SSIS tools like Import/Export Wizard, Package Installation, and SSIS Package Designer.
• Strong experience in defining referenced relationships and identifying KPIs in SSAS 2008/2005.

TECHNICAL SKILLS:

Operating systems: Windows XP/Vista/7/2008R2

Databases: SQL Server 2005/2008/2008 R2/2012/2014, Access

Database tools: SQL Enterprise Manager, SQL Profiler, DTS Import/Export, SQL Client Configuration utility, Backup Server, Replication Server, Microsoft OLAP Services, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), EDI

ETL tools: DTS, SQL Server Integration Services, SQL Server Analysis Services, EDI Kit

Reporting tools: SQL Server Reporting Services (SSRS), Crystal Reports

Development skills: Transact SQL (T-SQL), PL/SQL

Languages: C, C++, HTML, XML, VB.NET, ASP.NET (C#)

Application packages: Microsoft Office Suite

PROFESSIONAL EXPERIENCE:

Confidential - Dallas, TX

SQL Server/ETL/SSIS/SSRS Developer

Roles& Responsibilities:

• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Developed reports and visualizations using Tableau Desktop as per the requirements.
• Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.
• Created Crystal Reports Repository objects (Reports template, commands)
• Involved in the data analysis and database modeling of both OLTP and OLAP environment.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Developed custom reports using SSRS/Power BI.
• Designed, Managed and published various reports using SQL Server Reporting Services 2012 and Power BI.
• Collaborated in dramatically increasing OLTP transactions on systems handling several billion transactions weekly through the implementation of advanced database techniques such as join optimization, table structure and fragmentation analysis, bulk inserts, analysis of indexes and locks, creation of custom timers to detect bottlenecks.
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
• Migrated and translate legacy reports into Power BI from SSRS environment.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Developed number of business oriented reports utilizing SSRS, Power BI and Tableau.
• Responsible for creating the Complex Crystal Reports (on demand, AdHoc reports, Frequency reports, Summary reports, Sub reports, Drill-Down, Crosstab, Dynamic Grouping, Csross-Tab, Graphical, Aging reports) and modifying the existing reports.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Developed Tableau data visualizations using Cross Map, Scatter Plots, Geographic Map, Pie Charts, and Bar Charts.
• Extract dataset from different data source including SQL Server, excel and flat file prepare datasets for Power BI.
• Using TFS for proper documenting and implementing of codes on all environments.
• Created highly complex SSIS packages using various Data transformations like Conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2014 and unit test SSIS load processes for performance check.
• Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.
• Created multiple data visualization solution for initial Power BI environment business preview.
• Involved in migration and Conversion of Reports from SSRS .
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.

Environment: SQL Server 2014/2012 Enterprise Edition, .Net 3.5, SQL BI Suite (SSAS, SSIS, SSRS), OLTP, OLAP, Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access & Windows Server 2008R2, Oracle, Crystal Reports, Cogon's, Business Objects, SharePoint, Tableau 9.1(tableau desktop, tableau server, tableau online).

Confidential - Weehawken, NJ

SQL Server BI Developer Domain: Consumer

Roles& Responsibilities:

• Responsible for analyzing each case individually based on case details and interact with business user regarding each individual case.
• Responsible for converting functional requirements to technical aspects by providing optimal solutions to the business users.
• Implement technical solutions into design, development, deploy, Test into different environments by utilizing SQL Server and Visual studio and excel.
• Responsible for writing DDL scripts for creating SQL objects and utilizing objects like tables, SP’s, Functions, Triggers, Views etc.
• Responsible for writing complex SQL for extracting data from the heterogenous systems using SQL objects and utilizing these objects as per the need for the business.
• Responsible for performing Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Experience in working with different control flow elements like Data Flow Task, Bulk Insert Task, Active X scripts, Execute SQL Task, Script Task, Send Mail Task, and XML Task.
• Experience in working with different data flow elements like Flat File, OLEDB, Excel Sources and Destinations, Data Conversion, Term Extraction, Conditional Split, Derived Column, Pivot etc.
• Deployed different SSIS packages on development and test environments.
• Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads.
• Experience in migration of parts from Visual source safe (VSS) 2005 to Team foundation server (TFS) 2010.
• Involved in development and deployment of the Cube.
• Responsible for working on Facts and dimensions of the Cube.
• Developed complex Stored Procedures and Views to generate various Drill-through reports, Parameterized Reports and Linked Reports using SSRS.
• Designed Report Templates, Bar Graphs and Pie Charts based on data.
• Experience in querying data for Creating On-demand Reports using Report Builder in SSRS and send the reports via email.
• Created Reports and integrated reports into ASP.Net Application.
• Scheduled reports to run daily, weekly and monthly based on the requirement Report Manager.
• Defined Report Layouts for formatting the report design as per the need.
• Generated test data and tested new database consistency with existing databases.
• Created Jobs, Alerts, Activity logs, Error logs to capture any possible errors using SQL server Agent.
• Enhanced performance using optimization techniques such as Normalization, Indexing and Transaction Isolation levels.
• Implemented best practices in structuring SQL queries, Debugging Unexpected SQL Results etc.
• Responsible for unit testing, SDET and creating design documents and uploading it to share point server.

Environment: MS-SQL Server 2014, 2012, 2008R2, Oracle SQL Developer, Oracle SQL developer, MS-BIDS, SAS, SharePoint Server 2010, XML, MS Office 2013, MS Visio 2010, VB.Net, C#. Net, Visual Studio 2010/2008, Windows Server 2008, TIDAL, SQL CMD Utility JIRA.

Confidential

SQL Server Developer/DBA

Roles& Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Designed Logical and Physical data models using ERWIN data modeling tool
• Involved in deployments activities, enhancements and maintenance of data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
• Involved in data analysis performing GAP Analysis and Function Point Analysis to estimate the benefits of the new system v/s. the existing system
• Maintained security by creating users and giving appropriate permissions to users.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and maintaining logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.
• Responsible for Cleansing up database for Maintenance of the database.
• Responsible for unit testing, writing design documents and uploading it to share point server.

Environment: SQL Server 2012/2008/2005 , Oracle 9i, MS .NET Framework, MS Visio, MS-Office 2007, HTML, XML, VB.NET, SQL Profiler, Windows 2003 Server, TFS /Visual source safe(VSS).