SUMMARY

• 7+ Years of IT Experience in Database Design, Development and Business Intelligence of Microsoft SQL Server 2016 CTP 3/2014/2012/2008 R2/2008 in Development, Test and Production Environments
• Over 6+ years of overall experience with majority experience in multiple tools of the MSBI suite of products (SSIS/SSRS/SSAS/Power BI(View, Pivot, Query,Map)
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
• SQL Server database modeling, design and development with complex SQL scripts, Stored procedure, Views, Defined Functions, Triggers
• Experience in writing highly efficient, complex SQL queries, triggers, and functions; and develop Stored Procedures and functions in SQL server environment
• Experience in developing, monitoring, extracting and transforming data using SSIS, Import Export and Bulk Insert
• Extensive experience in Relational Data modeling for creation logical and physical design for databases and proficient in creating E - R diagram using Erwin and Visio
• Excellent knowledge in creating Databases, Tables, Views, User defined data types, functions, Cursors and Indexes using T-SQL
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power BI
• Setup code repositories like SVN, GIT, and TFS and managed plugins for Jenkins for scheduled automatic checkout of code
• Worked Extensively on ETL process using SSIS package
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files
• Experience in Performance Tuning and Query Optimization
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables
• Developing reports on SSRS on SQL Server ( 2016/2014/2 R2/2005)
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS
• Experience in developing data driven subscription reports and Ad-hoc reports using Report Builder in SSRS
• Expertise in creating various SSRS Reports - Parameterized, Cascaded, Linked, Drill-through and Drill-down reports
• Strong experience in creating dashboards using gauges and charts for analysis using SSRS 2008 R2
• Experienced in understanding the security requirements for Hadoop and Integrating with Kerberos Authentication Infrastructure- KDC server setup, creating realm
• Worked in an agile development team to deliver an end-to-end continuous integration/continuous delivery product in an open source environment using tools like Chef & Jenkins
• Involved in POC's with memsql Database, Kognitio Database to get the better performance on the workbooks
• Developed Tableau Visualizations and dashboards using Tableaudesktop
• Developed Tableau Workbooks from multiple data sources using Data Blending
• Experience in Designing, Building Dimensions, Cubes with Star schema and Snow-flake schema using SQL Server Analysis Services (SSAS)
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS

TECHNICAL SKILLS

• MS SQL Server 2016/2014/2012/2008 R2/2008/2005
• MS SQL Server Analysis Services (SSAS)
• MS SQL Server Integration Service (SSIS)
• MS SQLServer Reporting Services (SSRS)
• Power BI
• Tableau
• Cognos 11g
• PL/SQL
• Microsoft Excel
• Outlook
• MS SQL Profiler
• SQL Query Analyzer
• MemSQL
• Hadoop
• MS SQL Server Index Tuning Wizard
• Excel VBA
• T-SQL
• MS Visio
• HTML
• XML
• SVN
• Swish
• TFS
• WinSCP
• Jira
• GitHub and Bit Bucket

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL/ETL/MSBI Developer

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
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing various kinds of transformations using SQL Server Integration Services (SSIS)
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources
• Involved in Data Modeling, used ER-Win /MS-Visio to design and create the Flow docs. Developed Interface Agreement and FRD design docs for the SSIS processes/ETL
• 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
• Experience creating data sources using queries from ASP.Net/C# data readers
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases
• Design, Development and Documentation of various sqoop scripts to pull the data into Hadoop eco system
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle
• Upgraded Hadoop to 2.7.2 version. Well Verse with Security administration.
• Involved in assisting Business analysts in developing, maintaining and supporting operational reports, dashboards, and scorecards using Microsoft Power BI
• Scheduled the Reports to run on daily and weekly basis in Report Manager and emailing them to director and analysts to be reviewed in Excel Sheet
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring during execution
• Programmed solutions inC#, .NET Framework and SQL Server
• Created SSIS packages to migrate data fromDB2, Teradata to SQL Server 2016.
• Data migration (Import & Export using BCP) from text to SQL Server 2016.
• Involved in database backup, recovery procedures
• Planned back up strategy for disaster recovery
• Responsible for log backups and restoration

Environment: Windows2003 Advanced Server, Advanced SQL, MS SQL Server 2005/ 2008/2, PL/SQL, ER-Win, MS Visio, C#, .Net, Oracle, COBOL, Notes, SSRS, SSIS, SSAS, Power BI, Query Analyzer, DB2, Azure, Erwin.

Confidential

SQL/MSBI Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2)
• Extracted and Transformed data into Staging Servers named as PStaging Server for historical data and TStaging Server for load increment
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes
• Involved in architect design and did Data Modelling using ER-Win and created Requirement Traceability Matrix doc
• Used For-Each Loop Container, Sequence Container, Script task, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs
• Created and modified various Stored Procedures used in the application using T-SQL
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS
• Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.
• Created Project Expense Statements in all Data marts and other Financial Reports using SSRS and developed yearly and quarterly company expense reports
• Worked with Control Version SVS, C#, .NET Framework, Microsoft SQL Server
• Created dashboards that displays key information for decision making purpose using Heat maps, Geo maps, Tree maps, Pie charts, Bar charts, Circle views, Line charts, Area charts, Scatter plots, and Bullet graphs
• Utilized Data story telling in Tableau to provide more dynamic and more effective stories from the hidden insights locked in the data
• Responsible for Deployment of the report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports
• Used VB.net, C# to integrate .net framework with SSRS reports
• Tuned SQL query for better performance using SQL Profiler
• Documented all work, so user can easily understand the flow of process.

Environment: MS SQL Server 2012/2014, SQL Server Reporting Services(SSRS)-2008R 2/ 2008/2012/2014 , SQL Server Integration Services (SSIS)- 2008/2012/2014 , Tableau, Microsoft Visual Studio, T-SQL, ERWIN, Database Engine Tuning Advisor, SQL Server Profiler, MS Excel

Confidential

SQL/MSBI Developer

Responsibilities:

• Involved in requirement gathering and design documents for developing the project.
• Designed Domain model for the application.
• Created new database objects like tables, procedures, functions, indexes and views using T-SQL in development and production environments.
• Worked on creating mapping documents for data conversion from legacy to new model.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Data flow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Created summary and basic reports using SSRS as per the business requirements. Scheduled reports using subscription in SSRS.
• Worked on gathering requirements from users and all third parties' data and provide them efficient data solutions to improve business by using best technique of BI.
• Created joins, sub queries for complex queries involving multiple tables, SP's for SSRS report and SSIS.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Created new reports & optimized with gauges, maps, drill through reports, click-through reports, dashboards & Power BI Reports with custom code as needed in VB.Net
• Wrote MDX queries and KPI's using SQL server 2008/2012 SSAS.
• Optimize SSAS cubes with calculated measures, confirmed dimensions, Fact-less Facts, partitions etc. based in scaled business reporting needs
• Write Technical specification for the related work for each SSAS Tabular model.
• Built configurable SSIS packages and deployed them on the respective target servers.
• Involved in Analyzing, designing, building & testing of OLAP cubes with SSAS and in adding calculations using MDX.
• Monitored and modified performance using execution plans and Index tuning, stored procedures by fetching the information regarding the CPU, memory and Disk utilization.

Environment: SQL Server 2008 R2/2008, SharePoint 2010, SQL Server Data Tools, T-SQL, SSIS, SSRS, Power BI.

Confidential

SQL/MSBI Developer

Responsibilities:

• Created new database for the customer and export other monitoring scripts
• Implemented database refresh using full export for table level and full database defragmentation, resulting improved performance and effective space management
• Created SSIS packages to capture the Incremental changes for the Data warehouse
• Designed and developed SSIS packages to load data from Flat files, Excel to Data warehouse
• Developed complex mappings using SSIS to transform and load the data from various source systems like Oracle database,DB2 and Teradata database, Excel, Flat files into the SQL Server 2008 R2 target staging database
• Used SSISto create ETLpackages to validate, extract, transform and load data into data warehouse and data mart
• Extensively worked in the performance tuning of programs, ETLprocedures and processes
• Developed Dashboards, Gauges, Tabular, Matrix, Charts, Crystal reports Parameterized and Sub-reports in SSRS 2008 R2
• Developed many crystal reports using T-SQL, JDE Report Design
• Managed and resolved design issues during development stage. Worked closely with developers
• Generated reports from the database using PL/SQL and SQL
• Added more new features to existing analysis software tools.

Environment: SQL Server 2008 R2/2008, SharePoint 2010, SQL Server Data Tools, T-SQL, SSIS, SSRS.

Confidential

SQL Server Developer

Responsibilities:

• Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word
• Responsible for the management of the database performance, backup, replication, capacity and security.

Environment: MS SQL Server, SQL Server Reporting Services (SSRS), MS Excel, SSIS, BCP, T-SQL