SUMMARY:

• Having 8+ years of extensive experience in database design, development and administration with MS SQL Server versions 2016/2014/2 R2/2005/2000 using SSIS, SSAS, SSRS (BI Tools) in various industries.
• Strong experience in creating T - SQL objects, working with DDL/DML, performs most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches Process.
• Proficient in creating Indexed Views, complex Stored Procedures, TEMPeffective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in writing Distributed Queries between SQL Servers.
• Experience in Data Modeling (Logical and Physical Design of Databases) and Normalization of Databases, building Referential Integrity Constraints and De-Normalization techniques for both OLTP and OLAP (Star Schema/Snowflake).
• Expert in using tools like Index Tuning Wizard, database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning Server Performance.
• Dimensional Data Modeling using Star and snowflake schemas for Fact and Dimension tables.
• Handled vast financial data, expert level query optimization and performance tuning experience.
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Expertise in Extraction, Transforming and Loading (ETL) data using SSIS creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities(Data Warehouse, Data mart).
• Expertise in generating reports using SQL Server Reporting Services (SSRS), and Microsoft Access & Excel spreadsheet.
• Experience in Tableau Desktop, Power BI for data visualization, Reporting and Analysis.
• Good experience with change management, deploying code from DEV to TEST and PROD - using deployment groups in Informatica Repository manager.
• Hands on Experience in working with Tableau to generate reports and Dashboards.
• Expert in SQL Server Import/Export wizard to migrate the Heterogeneous databases such as Oracle and MS Access database, flat files to SQL server 2005.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Expert in Developing reports on SSAS & SSRS on SQL Server (2005/2008/2008 R2). Sound Experience and understanding of SSAS, OLAP cube and Architecture using BIDS
• Experienced in Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Experience in creating various reports like drill down, sub reports, parameterized, multi-valued and various Ad hoc reports through Report model creation using SSRS.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Excellent Knowledge of Software Development Life Cycle, RDBMS, Data Warehouse & Data Modeling concepts.
• Good Business and System analysis skills to understand the requirements and customize client applications.
• Developed MDX Queries against SSAS cubes to generate reports using BIDS
• Proficient in creating Power BI Dashboards.
• Efficient in using Power View and Power Map to visualize reports.
• Experience in using Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database
• Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.
• Well-organized, goal-oriented, highly motivated TEMPeffective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS:

Database Technologies: SQL Server (2000, 2005, 2008, 2008R2, 2012, 2014, 2016), MS-Access, Oracle, Teradata, MYDB.

Programming Languages: SQL,T-SQL, Shell Program, Power Shell program, HTML, XML, C, C++

Business Intelligence Tools: MSBI (SSIS, SSRS & SSAS).

IDEs /Tools: MS Visual Studio 2012/2008/2005/2000, SSMS,SQL Agent

Other Tools: MS Office Suite (Word, Power Point, Visio), OLAP, OLTP, Erwin and Power Designer, TFS, SVN.

Operating Systems: Microsoft Windows 98/2000/2003 Server/XP/7/8/2008 Server/2012 Server

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services ( 2012/2008/2005/2000 ),Power Pivots, Power Bi, Microsoft Access 2013, Excel

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Sr. SQL/BI Developer

Responsibilities:

• Designed and developed ETL (SSIS) packages for building a new Data Warehouse by extracting, transforming and loading data from Banks various legacy data warehouse sources.
• Automated SSIS Execution using Windows Scheduler using DTExec Command.
• Created logging, custom logging and error handling SSIS packages.
• Grouped, aggregated and split data using SSIS.
• Developed SSIS packages to automate many FTP’s files and email to required list of clients.
• Developed 50 reports from scratch using SSRS reporting for the Bank’s accounting department.
• Involved in analyzing business requirements that will facilitate the planning and the implementation phase of a data mart.
• Created SQL Server Reports based on the requirements using SSRS 2012, 2014, 2016.
• Create Views, Constraints and Triggers to implement business rules.
• Extensive experience in relational and dimensional data modeling for creating logical and physical design of database and ER diagrams using multiple data modeling tools like ERWIN, ER Studio.
• Responsible for creatingSQLdatasets forPowerBIand Ad-hoc Reports.
• Involved in building the dimensions, cubes with star schema and snow flake schema using SSAS.
• Developing OLAP cubes by identifying tables (fact and dimension), data source and data source views, attributes and dimension members using SQL Server Analysis Services (SSAS)
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Developed SQL ETL packages for updating existing data and loading new data from database tables, Excel files into SQL server 2016/SQL Azure tables.
• Designed and created data extracts, supporting SSRS, Power BI or other visualization tools reporting applications.
• Created Power BI Dashboards on Cloud connecting to Sales force data to be able to drive dash board reporting.
• Involved in Automation of ETL processes and jobs using Power Shell to reduce manual intervention.
• Experience in Logical Data Modelling and Entity relationship diagram (ERD).
• Developed dashboard reports usingTableau.
• Involved in performance tuning of slowly performing stored procedures and queries.
• Worked independently on multiple projects with minimal supervision and in agile SCRUM environment.
• Strong SQL Query experience using various RDBMS like Oracle, Teradata, Microsoft SQL Server.
• By using Microsoft azure using PowerShell 2015 we generating query results from SQL server
• Generating PowerShell scripting to avoid errors and also used for SSRS.
• Developed various charts and graphs like Bar chart (side-by-side, stacked), line graphs, Gantt Chart etc. by using Chart Expert using Crystal Reports XI.
• Developed custom calculated measures using DAX in Power BI to satisfy business needs.
• Analyzed and identified various heterogeneous data sources like XML, SAP HANA, Teradata, FLAT files and Excel sheet and created Data Mapping Documents (DMD) to efficiently in corporate them in ETL strategy.
• Experienced in building applications taking security into account by authentication, and encryption algorithms.
• Designed and developed ETL processes using Informatica to load data from Teradata, Flat Files to staging database and from staging to the target Data Warehouse database.
• Developed and supported the Extraction, Transformation and Load process (ETL) for a data warehouse from various data sources using Informatica Designer
• Used agile methodology in the SDLC for the implementation of the project and provided technical and functional support for the project team.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through, Sub Reports, Charts.
• Worked on to analyze and visualize the data on day to day basis using T-SQL, SSRS.

Environment: SQL Server 2016/2014/2012/2008 R2, informatica, Windows Server 2014/2008, SSDT/SSIS/SSRS, MS Visio, SharePoint 2010, Power Pivot, Power View, Tableau, Visual Studio, Power BI

Confidential -Orville, OH

ETL/SSIS Developer

Responsibilities:

• Wrote complex Stored Procedures and Views to cleanse data in the ADB database before letting the data flow downstream.
• Created a Parent Package which takes care of all the child packages setting configurations to halp the data flow from CPMS to Staging.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2008/2012/2014.
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the halp of SSIS.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using SSRS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Developed thepowerBIreports using the connection string likeSQLserver,SSASand T-SQL statements.
• Experience in developing Database Schemas / Joins, Views, Indexes, Stored Procedures / Data Dictionary.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies and defined Dimension Relationships.
• Created various database objects such as Stored Procedures, Functions, Triggers, Tables, and Views using T-SQL queries to retrieve data from various tables.
• Wrote from simple to complex T-SQL queries in SQL Server Management Studio, for extraction of data from staging environment based on the requirement and pushed the required data to UAT environment.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008.
• Improved Performance of the queries by creating Clustered and Non Clustered Indexes and by optimizing the T-SQL statements using MS SQL profiler, Job Activity Monitor and Performance monitor.
• Experience and knowledge in designing and developing data visualization strategies.
• Imported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.
• Data management and data processing solutions using SSIS, dis includes Error Handling and Slowly Changing Dimensions.
• Created rich dashboards using power BI to deliver actionable insights for end client.
• Demonstrated experience in utilizing design tools, development tools, code management, regression testing and performance tuning.
• Responsible for using different types of Stages such as ODBC Connector, Oracle Connector, Transformer, Join, Sequential File to develop different jobs.
• Worked on performance tuning by identifying the bottlenecks in Sources, Targets, and Mapping enhanced Performance for Informatica sessions using large data files by using partitions.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Production.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Designed and implemented the Tabular Cube for thePowerBIreports to improve the performance of the reports.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Extensive Experience on Cube Development both OLAP & Tabular Cube Environments.
• Extensive Knowledge in SSAS storage Modes, partitions, Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Cascading and Sub Reports using SQL, MDX at Reporting Services 2012.
• Created Sub Reports, Snapshot, Cache and Linked Reports.
• Experience in creating adhoc reports Using Report Builder 2.0 and Report Builder 3.0.
• Created SQL Agents Jobs for SSIS, SSAS Cubes and SQL Scripts.

Environment: SQL Server 2014/2012 & 2008R2, SSIS, SSRS, SSAS, informatica, OLTP, MDX, Tabular Cube, T-SQL, Power Pivots-SQL, power BI,SQL Agent, SQL Profiler, MS Access, Tableau, MS Excel, & Windows 2003 server, C#, TFS

Confidential, OH

SQL Developer

Responsibilities:

• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources. .
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Constructed OLTP and OLAP Databases.
• Worked on building a Data Warehouse and implementing an ETL solution for loading Data warehouse
• Analyzed & designed the business rules for data cleansing that are required by the staging & OLAP and OLTP databases.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Implemented the Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column.
• Involved in design & development of operational data source and data marts in Oracle.
• Used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy and Joiner while migrating data from various heterogeneous sources like Oracle, SQL Server, and Flat files to target data base.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Used various data flow transformation in packages based on the business need such as Data conversion, condition split, multicast, union all merge, merge join, sort, etc.
• Migrated packages from development server to production server using package configuration.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, and Drill through, Sub reports using SSRS.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Created various geographical and time dimension reports of fiscal year, quarter month, week and daily reports for all domains and published through Report Server.
• Created various reports by comparing the growth of company based on each quarter by using bar charts.
• Written complex T-SQL queries and created Stored Procedures, Triggers, functions and Views.
• Responsible for generating annual reports based on the growth of company with respect to customers.
• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Conducted user sessions and supported the requests for enhancements, modifications and new reports.

Environment: MS SQL Server 2008R2, Reporting Services (SSRS), Integration Services (SSIS), Microsoft Performance Point Server 2008R2, OLTP, Microsoft Share point Server, Tableau, T-SQL, .NET, C# MS Access and Excel.

Confidential, New York

SQL Developer

Responsibilities:

• Reviewed and analyzed business requirements of the company and end-users, and delivered timely, accurate, meaningful and standardized reports.
• Created, managed schema objects like Tables, Views, Indexes, Functions, Stored Procedures as per the user requirement.
• Implemented Error Handling Using T-SQL Queries like TRY-CATCH Block, RAISE ERROR.
• Worked on Performance Tuning utilizing in-built tool, SQL Server Profiler to analyze and optimize the execution plans for optimum query performance.
• Deployed SSIS Packages in development and production servers and Involved in ETL framework standards like error processing, reconciliation, validation.
• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Planned, designed and documented the optimum usage of space requirements and distribution of space for the Data Warehouse.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008.
• Involved in Analyzing, designing, building &, testing of reports using Tableau.
• Developed SSIS Packages by extracting data from various data sources such as Excel, Flat files, OLE DB, XML into MS Visual Studio and employed numerous transformations like Aggregate, Audit, Conditional Split, Fuzzy Grouping/Lookup, Derived Columns, Row Count/Sampling, Script Component, Merge and Merge Join, Multicast, Slowly Changing Dimension etc., using variables, parameterized mappings and expressions.
• Created Oracle Stored Procedure, Function, Cursor, Package and Triggers.
• Developed mappings for extracting data from legacy and Oracle Applications into our data warehouse
• Used Informatica - repository manager create new users, repositories.
• Used Informatica Designer for mappings and coding it using reusable mapplets
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Hands on experience using control flow tasks such as Script Task, Execute Task, Execute SQL Task, Sequence Container, For Loop Container, Bulk Insert Task
• Migrated DTS Packages to SSIS Packages and loaded the data from SQL Server 2000 to SQL Server 2005.
• Experience in SSIS error handing using event handlers, breakpoints, SSIS loggings, package configurations.
• Used Send Mail Task in SSIS and worked with SMTP Managers to send alert emails.
• Built the Dimensions, cubes with Star schema and Snow flake schema using SQL Server Analysis Services.
• Extracted data from multidimensional cube and designed Tabular, Matrix, Drill Down, Parameterized and Linked Reports using SQL Server Reporting Service (SSRS).
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS)
• Involved in designing and implementing Terabyte size of SQL Server database systems and experience in designing and implementing multidimensional databases.
• Fair Knowledge of DB high availability concepts like MS SQL Clustering, Replication, Log Shipping and DB Mirroring.
• Used Query Analyzer, Profiler, Index Wizard and Performance Monitor for performance tuning.
• Created complex cubes usingSSASto ensure better application performance and enabled flexible reporting capabilities.

Environment: Enterprise Edition, T-SQL, informatica, SSIS,SSRS, SSAS, DTS, ETL Strategies, BI tools, Visual Studio, .NET, Windows 2000 Advance Server, OLTP, Tableau, Windows 2003 Advance Server, MS Excel, MS Access.

Confidential, Branchville, NJ

SQL Developer

Responsibilities:

• Understanding the report design Requirements and Constraints.
• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Performing query plans and making sure each and every query is using appropriate useful Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• TEMPEffectively worked in Tableau version based environment and used deployment groups to migrate the objects.
• Develop the mappings using needed Transformations in Tableau according to technical specifications.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS).
• Implemented business Intelligence dashboards using MOSS 2007 Report Center and Excel services producing different summary results based on user view and role .
• Designed and developed Data mart using SSAS.
• Build Cubes on Enterprise Date Warehouse (EDW).
• Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
• Scheduled Backups and performed Restore operations for system test data.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), Tableau, MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe.

Confidential

SQL Developer

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins, Temp tables for applications.
• Creating staging tables and Data-Mart or target tables using transformations.
• Loading the data in the systems using Loader scripts, Cursors, Stored Procedures.
• Involved in designing the Data Mart models with Erwin using Star schema methodology.
• Highly skilled and experienced in Agile Development process for diverse requirements
• Good understanding of agile software development lifecycle (iterative and incremental)
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
• Used variousSSIStasks such as Conditional Split, Multicast and Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Use Power pivot to extract, import and join data that coming from different sources and use DAX to create new calculated measures and make dis available in Clients SharePoint Site.
• Assisted in System Test and UAT testing scenarios as required
• Developed and deployed data transfers packages usingSSIS, also maintained the jobs running on Servers.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups usingSSIStasks
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option usingSSRS.
• Created reports having actions like URL and bookmarks, which halped to easily navigate through the report usingSSRS2008.
• Design and deploy various reports such as drill down, drill through, charts, parameterized and linked reports usingSSRSas well as managed the subscription of the reports
• Testing the data in Test Environment, client validation and issues resolution.
• Developed various drill down and drill through reports which involved complex chart based reports.
• Created reports from the OLAP cubes using SSRS.
• Resolved any deadlocks issues with the databases/servers on a real-time basis.In-Depth working knowledge of ODBC.
• Performed T-SQLtuning and optimization of queries for reports that took longer execution time.
• Performed unit and system testing, troubleshooting and bug fixing in Prod and QA environments.

Environment: SQL Server 2012/2008 R2,Windows Server 2008R2, STM, LDM, MDX, Visual Studio 2008, T-SQL, Pl/Sql, SSAS, SharePoint, DAX, Teradata, FACETS, TFS.