SUMMARY

• Over 7 years of experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC), using MS SQL Server 2005/2008/2012 , DTS/SQL Server Integration, Reporting and Analysis Services.
• Extensive SQL Development experience in Banking, Insurance and Healthcare industries with a strong understanding of data & analytics
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Creating SSIS Packages for integrating data using OLE DB connection from sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Built Efficient SSIS packages for processing facts and Dimension tables with complex transforms.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Created drill down, drill through, Cascading, Conditional, Table, Matrix, Chart, linked reports using MS SSRS 2008 as well as managed the subscription of the reports
• Experience in Advanced Excel like Power View, Power BI, Power Pivot and Excel Data Connection.
• Solid expertise in Database development for both OLTP (Online Processing & Batch Processing) and OLAP Systems (SSRS, SSIS, SSAS) using SQL Server 2005/2008/2012 .
• Widespread experience in creating, configuring, deploying and testing SSIS packages for ETL and Business Intelligence processes.
• Excellent ability in defining queries for creating stylish report layouts and generating parameterized & drill down reports in SSRS.
• Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optmal Performance.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Excellent knowledge of Scheduling Jobs and Alerts using Control - M Job Agent.

TECHNICAL SKILLS

Databases: MSSQL Server 2000/ 2005/20 /2016 , MS ACCESS.

Database Utilities: Enterprise Manager, SQL Server Management Studio, BI Development studio, Visual Studio, Configuration Manager, SQL Server Profile, SQL Query Analyzer, SQL Refractor, SQL Server Agent.

BI Tools: Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Crystal Reports, ETL.

Languages: T-SQL, PL/ SQL, C/C++, C#, .NET, HTML, CSS, XML, Python.

RDBMS: MS SQL Server 2012/2008R 2/2008/2005/2000 , MS Excel / MSWord / MS Access.

OS: Windows 2010/2008/2007/2003/2000/ NT Servers, XP, Vista, UNIX.

Other Technologies: Erwin/Power Designer (Data Modeling), Visio, Visual SourceSafe, MS Office suite

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

PROFESSIONAL EXPERIENCE

Confidential, Long beach, CA

MS SQL/SSIS/SSRS Developer

Responsibilities:

• InstalledSQLServer 2014,2016 with latest Service pack and established connectivity with the database created, configured and maintained database maintenance plans.
• Created T- SQLqueries, stored procedures, triggers, views, Indexes, Constraints and user defined functions (UDFs) on various database objects to create, modify and/or maintain databases.
• UsedSQLProfiler and Database Tuning Advisor for troubleshooting, monitoring, optimizingSQL Server and T- SQLstatements.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Worked in configuration of report server and report manager scheduling, give permissions to different level of users inSQLServer Reporting Services (SSRS)
• Worked SSRS on dimensional modeling, creating cached reports, drill-down reports, linked reports, report snapshots, parameterized reports and report optimization.
• Preparing SSRS Reports with Report subscriptions and Email Delivery mechanisms throughSQL Scripts that run-on Report Server Databases.
• Used Power BI along with R-language for creating dashboard reports,drill down reports to implement BI solutions that drive to informed decision making for deeper business insights.
• Used Excel, Power Pivot, Power Query to create power pivot tables and power pivot charts.
• Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQLstatements usingSQLprofiler.
• Installing, configuring, administering and securing production and non-production servers. Installed and configuredSQLServer 2014 on the server, provide connections and manage databases.
• Worked in automating processes like creating jobs, and error reporting using Alerts,Control-M job agent.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Used various control flow tasks like For each Loop, execute package/SQL tasks, Script task, send mail task and different data flow tasks/transformation.
• Created packages with different Control Flow options and Data Flow Transformations such as Fuzzy Look Ups Conditional Split, Multicast, Union All etc.
• Extract Transform Load(ETL) development Using SQL server 2014 and migration SQL server 2016, SQL 2014 Integration Services(SSIS).
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Used SSIS for creating database maintenance plans, taking Backups of databases.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: MSSQLServer 2014,2016, T-SQL, SSIS, SSRS, Power BI,SQL Profiler, Excel,Control-M, XML, ASP.NET, Subversion Server (SVN).

Confidential, Dallas, TX

MS SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in Data Analysis and Migration of Data.
• Involved in complete Software Development Cycle (SDLC).
• Created SSIS packages to load data into SQL Server using various transformations in SSIS.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems.
• Capture business objectives and processes and design and develop a comprehensive application and solution.
• Extract the data from various sources like SQL Server, Text files, and access into Data Warehouse
• Works with SQL Server, SSIS technologies and has a good Data Warehouse knowledge and tools.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Documentation for all kinds of reports and SSIS packages.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Successfully conducted root cause analysis to identify the underlying issues and design solutions accordingly.
• Worked with users and helped Build a Tabular Data Model and published it to Share Point
• Involved in the data mapping sessions and creation of Data dictionary.
• Migration of the data from one environment to other environment. Testing and analysis of the migrated data.
• Identify and replace manual processes and exchange of data with an Automated System.
• Implement the best design patterns in data migration to adapt for future changes.
• Review several test plans and test scenarios with the QC team for each project worked on.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, Parameterized Reports.
• Worked on Performance tuning of ETL transformations, data validations and Stored Procedures.
• Worked on XML along with PL/SQL to develop and modify web forms
• Created SSAS OLAP Cubes and Partitioning Cubes, monitored and full and incremental load using cube wizard.
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS.

Environment: SQL Server 2012, SSIS (2012/2008), SSRS (2012/2008), Visual Studio 2010/2013, MS Excel 2010, Cognos 8.2/3/4 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection), Power Designer.

Confidential, Mclean, VA

SQL BI Developer/ETL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Installed and configured SQL Server 2012 successfully.
• Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2012.
• Created SSIS Packages which contained different transformations and tasks.
• Analyzed the existing data and performed the migration steps to SQL Server 20012.
• Business function knowledge of ERP including Financials, Project Management, Human Resources, Payroll, etc.
• Troubleshoot SSIS Packages and convert to SSRS Reports.
• Responsible for Debugging reports using Stored Procedures.
• Created Cross-Tab, Drill-down, Drill-through, Parameterized and Sub-Report using SSRS.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy Lookups, Lookups.
• Developed SSIS packages using various transformations such as Conditional Splits, Fuzzy Look Ups, Aggregations, and Multicasting.
• Developed the reports using stored procedures by adding variables such as Language translation and Time zone by considering different scenarios according to business requirement and Executed to get the required output.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Evaluate current reporting infrastructure to find bottlenecks and recommend improvements.
• Responsible for creating/migrating undocumented crystal/SSRS reports.
• Developed and optimized stored procedures using input, output, table valued parameters and Query Analyzer.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Verified different packages using Views using SQL Integration services 2012.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Developed multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).

Environment: MS SQL Server 2012, MS Analysis Services 2012, Oracle 11g, MS Access, Import & Export Data, Windows 7/8.

Confidential, Houston, TX

SQL/SSRS /SSIS Developer

Responsibilities:

• Involved in requirements gathering from users and documenting them for development.
• Worked on different new and existing Data models.
• Worked with Stored procedures, triggers, functions, views.
• Tuning SQL scripts, applying Indexes and monitoring for any high-performance of TSQL code.
• Involved in designing, developing and deploying reports in MS SQL Server environment using BIDS 2008 and also involved in Creating SSIS packages.
• Created SSIS package for data migration cross servers.
• Extracting and loading of data from different files on to the SQL server.
• Worked with Control and Data flow transformations, Parameters for effective data extraction using SSIS packages.
• Performed daily administration, monitoring, and documentation of SQL Servers
• Responsible for tuning data, indexes, and queries
• Created alerts and notifications for system errors, insufficient resources, fatal database errors
• Extensively used embedded SQL in VBA front end.
• Created parameter driven reports in Access and Excel running thru Access VBA front-end.
• Created Generic Query Tool to provide enhanced reporting interface using VBA.
• Modified/Created MS Access and Excel applications to run on and off Citrix environment.
• Wrote scripts to make the VBA Applications compatible with other OS\'s and MS Office Versions.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation
• Worked on logging, Event handlers and Custom logging for SSIS packages.
• Worked with Package Configurations for SSIS package deployment.
• Involved in C# scripting for Script component in SSIS packages.
• Involved in creating efficient stored procedures for SSRS Reports.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data

Environment: MS SQL Server 2008 R2 Management Studio, SSIS, SSRS, SSAS, T-SQL, Crystal Reports XI, MS Access.

Confidential - Milwaukee, WI

SQL Server/ BI Developer

Responsibilities:

• Involved in requirements gathering from users and documenting them for development.
• Worked on different new and existing Data models.
• Worked with Stored procedures, triggers, functions, views.
• Tuning SQL scripts, applying Indexes and monitoring for any high-performance of TSQL code.
• Involved in designing, developing and deploying reports in MS SQL Server environment using BIDS 2008 and also involved in Creating SSIS packages.
• Created SSIS package for data migration cross servers.
• Extracting and loading of data from different files on to the SQL server.
• Worked with Control and Data flow transformations, Parameters for effective data extraction using SSIS packages.
• Performed daily administration, monitoring, and documentation of SQL Servers
• Responsible for tuning data, indexes, and queries
• Created alerts and notifications for system errors, insufficient resources, fatal database errors
• Extensively used embedded SQL in VBA front end.
• Created parameter driven reports in Access and Excel running thru Access VBA front-end.
• Created Generic Query Tool to provide enhanced reporting interface using VBA.
• Modified/Created MS Access and Excel applications to run on and off Citrix environment.
• Wrote scripts to make the VBA Applications compatible with other OS\'s and MS Office Versions.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation
• Worked on logging, Event handlers and Custom logging for SSIS packages.
• Worked with Package Configurations for SSIS package deployment.
• Involved in C# scripting for Script component in SSIS packages.
• Involved in creating efficient stored procedures for SSRS Reports.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, Windows XP, Management Studio.

Confidential

MS SQL Developer

Responsibilities:

• Installation and Configuration of SQL Server 2000.
• Monitor the performance of SQL server using Windows Performance Monitor and Spotlight.
• Used SQL DTS to setup ETL processes.
• Promote databases from QA to Production environment.
• Development and modification of document related to systems and operational procedures.
• Tuned Stored Procedures and Queries for optimal Database performance.
• Consolidation and Migration of databases from decommissioned servers to newly built blade servers
• Materialized views, dimensions and stored outlines for optimal performance.
• Create and implement logins and user permission to databases.
• Creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting.
• Modified databases in QA and Production environment as per need and user’s request.
• Developed multiple reports using reporting services.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2005, SQL Server 2005, T-SQL, Visual Basic, Excel