SUMMARY

• Extensive experience developing and working wif diverse collection of applications and 11+ years of professional experience in Database Solutions and BI Solutions using Microsoft Technologies.
• Highly experienced in MS SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 wif Business Intelligence in SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Extensively performed database administration tasks: Installing, Configuring, Managing, Monitoring and Troubleshooting MS SQL Server 2012/2008R 2/2008/2005/2000 on Windows 2003/2003R2/ 2008/2008R 2/2012/2014/2016 servers.
• Excellent problem solving, analytical, technical, interpersonal and communication skills wif strong leadership abilities and an extremely diligent strong team player wif anInvolved in take new roles.
• Possessed Excellent T - SQL Programming skills and effectively used Advanced Programming concepts like CTE’s, Windows Functions, Table Partitioning, Apply Operators, Table Valued Parameters, Output Clause, Merge Statement, Pivot, XML, Dynamic SQL, Table Valued Functions etc.
• Highly experienced in creating complex Views, Stored Procedures, DDL/DML Triggers and User-
• Ability to develop ETL pipelines in and out of data warehouse using combination of Python and Snowflake’s Snow SQL and Involved in write SQL queries against Snowflake.
• Experience in implementing and develop scripts (Unix, Python etc.) to do Extract, Load and Transform data
• Involved in provide production support for Data Warehouse issues such data load problems, transformation/translation problems etc.
• Experience in implementing integrate on premise infrastructure wif public cloud (AWS, AZURE) infrastructure
• Experience in implementing translate requirements for BI and Reporting to Database design and reporting design
• Experience in implementing understand data transformation and translation requirements and which tools to leverage to get the job done
• Experience in implementing understand data pipelines and modern ways of automating data pipeline using cloud based and on premise technologies
• Actively test and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions.
• Experienced in building Data Warehouse from the core usingAWSData Pipelines and MySQL.
• Extensively used various AWS Nodes,SQL Activities, S3 locations etc. to ensure proper and efficient migration of data.
• Experience in implementing different types of Replication models like Snapshot, Transactional and Merge.
• Hands on experience in AmazonRedshift, MySQL,SQLServer databases.
• Involved in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Involved in monitoring database maintenance plans for checking database Integrity, Rebuilding, Reorganizing Indexes, Shrinking Databases, updating statistics, Creating and Scheduling SQL Server Agent Jobs.
• Used Some of T-SQL 2012 New Features like Sequencer, Throw Statement, Fetch and Offset and Functions Like Lead (), Format (), Concat (), First Value (), Last Value (), EOMonth (), TRY Convert () etc.
• Designed ETL packages dealing wif different data sources (SQL Server, Oracle, Flat Files, Excel Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed SSIS Packages wif Custom error handling, Logging using event handlers, Send E-mail Task and Used Checkpoints to rerun Packages from Point of Failure.
• Experienced in working wif different data sources like OLE-DB, flat files and Excel to source data in SSIS and proficient in creating SSIS packages from scratch and deploying them.
• Designed SSIS Packages wif Dynamic Tasks and Connections Using Variables, Expressions and Packages Configurations and followed best practices to maintain Optimized performance.
• Loaded Data warehouse Fact Tables and Dimension tables of type 1 and type 2 attributes Using Transformations Lookup, Merge Join, Conditional Split and Using T-SQL 2008 Merge Statement.
• Debugged the Packages Using Break Points, Data Viewers, Script Task, Deployed the Packages Using Dutta Commands, Deployment Utility and Scheduled Packages wif DTExec Commands.
• Knowledge of scripting languages, Python and Java.
• Developed entire frontend and backend modules using Python on Django Web Framework wif GIT.
• Highly proficient in T- SQL for developing Stored Procedures, Triggers, Views, User Defined Functions, CTE's using dynamic-queries, sub queries, Relational Database models and Data Integrity, and SQL joins
• Designed and Deployed several SSRS reports such as Drill down reports, Drill through reports, Parameterized reports, Cascaded reports, Cached reports, Snapshot Reports, linked reports, Sub reports.
• Experience wif Visual Studio 2008/2010/2013 , C#, and TFS, GIT or similar source code management tool.
• Utilized Git-Lab along wif Tortoise- Git as the DevOps tool dat enhanced the software development life cycle and performance 200% faster wif version control system and wif revertible possibilities of any changes made point in time on the application and the databases.
• Created projects, pulled, pushed, merged, committed and deployed project Using Gitlab DevOps Tool and evolved in peer code reviews
• Used Report Manager to assign roles, permissions and Created report schedules and Subscriptions.
• Proficient understanding of source code versioning tools and techniques especially SVN and/or GIT as well as JIRA.
• Experience implementing Cloud based Linux OS in AWS to Develop Scalable Applications wif Python.
• Expert in creating traditional as well as Web-based interactive reports using SSRS.
• Experienced in creating reports using SQL Server Reporting Services sourcing OLAP cubes and data warehouse, data marts as well as transactional systems.
• Experienced in building Star schema and Snow Flake schema depending on business requirements.
• Defined Relationships between Dimensions and Measure Groups like Fact Relationship, Many-to-Many Relationship, and Defined Dimension Granularity wifin a Measure Group.
• Object oriented programming in Python C/C SQL Unix/Linux/Mac/Windows Perl Shell scripting.
• Experienced in developing and modifying cubes and dimensions in cubes using SSAS.
• Skilled in developing Data Warehouses, Data marts using Star Schemas and Snow Flake Schema.
• Experienced in Developing, Deploying and Processing SSAS Cubes and writing MDX queries.

TECHNICAL SKILLS

Data Warehousing/BI Tools: MS SQL Server Business Intelligence (MSBI) Development - SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS) 2000/2005/2008/2008 R 2/2012/2014/2016 , Visual Studio (VS) 2005/ 2008/2 /2016.

SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, SSRS, SSIS, SSAS

RDBMS/DBMS: MS SQL Server 2000/2005/2008/2008 R 2/2012/2014/2016 , ORACLE 9i/10g, MS Access, DB2, Sybase

Data Warehousing/BI Tools: MS SQL Server Management Studio (SSMS), Performance Monitor, Power Pivot, SSIS Documenter, SQL Agent, SQL Mail, Erwin, Team Foundation Server (TFS) 2008/2010/2012 , Microsoft Visio 2003/2007/2010/2013 , Visual SourceSafe (VSS), Import/Export Wizard.

Web Technologies: T-SQL, CSS, HTML, ASP.NET, C#, .NET Framework, HTML, DHTML, XML, IIS, Apache.

Programming Languages: T-SQL, PL/SQL, C#.net, Core Java, C, Java Script, VB Script, XML, HTML, Python.

Operating Systems: Windows 8/7/Vista/XP, Windows Server 2000/2003/2008/2012.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. MSBI (SSIS/SSRS) /Tableau Developer

Responsibilities:

• Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the Application team, Reports team during development. T-SQL development included queries using joins, sub-queries, Ranking functions, Derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF), constraints & Database triggers.
• Improved the performance of SSIS packages by enabling Parallelism in the Control and Data Flows, usage of synchronous transformations.
• Build data visualizations and reports from DW and OLAP cubes using Power BI, SSRS, and possibly Tableau.
• Ability to develop ETL pipelines in and out of data warehouse using combination of Python and Snowflake’s Snow SQL and Involved in write SQL queries against Snowflake.
• Experience in implementing and develop scripts (Unix, Python etc.) to do Extract, Load and Transform data
• Involved in provide production support for Data Warehouse issues such data load problems, transformation/translation problems etc.
• Experience in implementing integrate on premise infrastructure wif public cloud (AWS, AZURE) infrastructure
• Experience in implementing translate requirements for BI and Reporting to Database design and reporting design
• Experience in implementing understand data transformation and translation requirements and which tools to leverage to get the job done
• Experience in implementing understand data pipelines and modern ways of automating data pipeline using cloud based and on premise technologies
• Actively test and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions.
• Deployment of SSIS packages to the conversion server and create and schedule SQL Server Agent jobs to automate the run of SSIS packages on a weekly basis.
• Experience in creating master and child packages, using package configurations (SQL Server) and SSIS logging.
• Developed the logical data models and physical data models dat capture current state/future state data elements and data flows usingERStudio.
• Generated Tableau Dashboard wif quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.
• Created Apache Directory Server for local network and Integrating RHEL instance wif Active Directory inAWSVPC.
• Responsible for migrating the data and data models from SQL server environment to Oracle 10g environment.
• Experience in working wif other Database teams on extracting data using Ref Cursors to the csv or flat file and transfer the report to internal and external clients via email, sftp, ftp or ndm.
• Managed security groups onAWS, focusing on high-availability, fault-tolerance, and auto scaling using Terraform templates.
• Created Tableau Dashboards wif interactive views, trends and drill downs along wif user level security.
• Uses different set of ETL tools likeAWSGlue (Python/Scala), Modillion forRedshift, Informatica Power.
• Expertise in constructing T-SQLand Oracle PL/SQLTables, Stored Procedures, Views, Functions,
• Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using (SSIS).
• Experience in writing complex DAX functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Created Workspace and content packs for business users to view the developed reports.

Environment: Erwin, SQL Server 2008 R2/2012, Business Intelligence Development Studio (BIDS 2008 R2), SSIS, SSRS, SSAS, Visual Studio 2012/2010, Team Foundation Server 20012/2010, BI Xpress V4.0.0, .NET Framework, AWS, T-SQL, MS-Excel, XML, Window 2007 Server, Crystal Reports, Share Point Server 2010.

Confidential, Austin, TX

Sr. SQL Server Developer

Responsibilities:

• Interacted wif Business Users and Analyzed user requirements and built reporting solutions such as relational database reports, OLAP reporting, dashboards and scorecards.
• Involved in the dimensional modeling of Data warehouse using Erwin tool.
• Created complex T-SQL Queries, Stored Procedures, Indexes, Functions and Views to support efficient data storage and manipulation in SQL server management studio (SSMS).
• Created appropriate Triggers to assist efficient data manipulation and data consistency.
• Migrated DTS Packages of SQL Server 2005 to SQL Server 2008 as per business requirement.
• Responsible for ETL Operation which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS).
• Developed Python and Perl HPC software for NextGen Sequence Data Bioinformatics Analysis Pipelines.
• Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
• Created Tableau Dashboards wif interactive views, trends and drill downs along wif user level security.
• Automated data warehouse build includingAWSinfrastructure and Modillion process flows.
• Extensively usedSQLfor migrating reports from Tabular model to AmazonRedshift.
• Create Common Table expressions (CTE) and temp tables to facilitate the complex the queries.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Created Terraform modules to create instances inAWS& automated process of creation of resources isAWSusing terraform.
• Experienced and helped wif other teams in web and client/server applications QA testing
• Extensively used transformations, control flow tasks, containers and event handlers.
• Used checkpoints to implement the restart ability of the packages in SSIS.
• Implemented custom logging in SSIS using event handlers and execute SQL task.
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
• Implemented Error Logging using Event Handlers and implemented logging in SSIS Packages in visual studio (MSVS).
• Advanced noledge in creating complex reports wif business intelligence and visualization tools like Power BI, Tableau and SSRS by using T- SQL scripts and stored procedures.
• Created dynamic Package Configuration of type SQL Server table.
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations dat are available in Power bi query editor
• Created stored procedures and SQL queries to pull data into power pivot model.
• Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Involved in Optimization and Performance of queries and stored procedures using SQL Execution Plan.

Environment: Erwin, SQL Server 2008 R2/2012, Business Intelligence Development Studio (BIDS 2008 R2), SSIS, SSRS, SSAS, Visual Studio 2012/2010, Team Foundation Server 20012/2010, BI Xpress V4.0.0, .NET Framework, T-SQL, MS-Excel, XML, Window 2007 Server, Crystal Reports, Share Point Server 2010.

Confidential, GA

Sr. MS SQL Database Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS.
• Developed several reports wif consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Created SSIS package in which records were loaded daily, also from other data resources such as Excel, Access, flat file, Oracle and XML in order to create and maintain a centralized data warehouse. noledge in TCP/ IP suite and IPAM, routing protocols, such as OSPF, EIGRP, ISIS, and BGP.
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Created drill down and sub reports from SSAS cubes dat can be browsed on web.
• Worked on wif Report Manager, Report Builder, and Reporting Security and Reporting Services Configuration manager.

Environment: MS SQL Server 2008/2008R2, SSRS, SSIS, SSAS, T-SQL, MS-Excel, XML, Windows 7.

Confidential, IA

Sr. MS SQL Database Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Created SSIS packages for importing the Excel layouts into the database using SSIS.
• Used BIDS to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS. Scheduled the job to do dis task periodically.
• Experience in SSIS script tasks, look up transformations and Data flow tasks using T- SQL, C# and Visual Basic scripts.
• Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server.
• Expert in Data Extraction, Transforming and Loading (ETL) using Business Objects Data Integrator XI (BODI), Data-services xi3.2, 4.0(BODS)
• Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping.

Environment: Erwin, SQL Server 2008 R2/2012, Business Intelligence Development Studio (BIDS 2008 R2), SSIS, SSRS, SSAS, Visual Studio 2012/2010, Team Foundation Server 20012/2010, BI Xpress V4.0.0, .NET Framework, T-SQL, MS-Excel, XML, Window 2007 Server, Crystal Reports, Share Point Server 2010.

Confidential, Atlanta, GA

Sr MSBI Developer

Responsibilities:

• Based on business requirements, developed the complex SQL queries wif Joins and T-SQL, Stored Procedure, Views, Trigger to implement the business rules and transformations.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Created Subscription of Reports in different formats like pdf, excel etc. to be executed automatically on daily, weekly or monthly basis using MOSS (Microsoft Office SharePoint Server) tool.
• Connected various applications to the database.
• Created databases and schema objects including tables, indexes, views and applied constraints.
• Created reports from complex SQL queries and MDX queries.
• Performed daily tasks including backup and restore by using SQL server 2005/2008 tools.
• Responsible for maintaining UAT (User Acceptance Testing) and Production environment.

Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services 2008, MS SQL Server Integration Services 2008, SQL Server Analysis Services 2008, Windows XP, Excel, Acrobat Reader, Microsoft Office SharePoint Server.

Confidential

Sr MSBI (SSIS/SSRS) Developer

Responsibilities:

• Created Logical and Physical data models using Erwin 4.0 data modeling tool.
• Developed complex Stored Procedures, Functions, DTS (Data Transformation Service) packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Migrated the data from various sources using DTS.
• Scheduled and performed data transfers using DTS including filtering appropriate to the data mart for data analysis.
• Compressed data files by removing empty database pages and updating index statistics.
• Developed and edited many complex reports wif Crystal Reports 10.0.
• Designed and implemented user log in and security.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan and worked in Enterprise Manager for job scheduling and batch queries.
• Planned the complete back-up of databases for disaster recovery (DR) scenarios.
• Reorganized database structures as needed, automated procedures Confidential regular intervals.
• Optimized long running Stored Procedures and Queries for effective data retrieval.
• Involved in project planning, scheduling for database module wif project managers.

Environment: MS SQL Server 2000 Enterprise Edition, MS Access 2003, DTS, T-SQL, Query Analyzer, BCP, SQL Profiler, Windows 2003 Server, Crystal Reports 10.0