SUMMARY:

• Over 8 years of Excellent IT Experience as SQL Server Developer in design, development and testing of business / commercial applications using MS SQL Server 2016/2014/2012/2008 R2/2008 /2005 in healthcare, manufacturing and financial Sectors work in SDLC, Agile and scrum enviroment.
• Excellent experience in migration from different T - SQL code to Tableau for report develop.
• Highly proficient in the use of T-SQL for developing complex creating Database, Tables, Indexes, Views, Triggers, Stored Procedure, User Defined Function, relational database models and data integrity, SQL joins and query writing.
• Extensive experience in Database Design, Normalization, Selective De-normalization, Forward/ Reverse Engineering of Applications, Conceptual, Logical and Physical data modeling using Erwin, E/R Studio and Sybase Power Designer.
• Good Experience in various packages of SSIS, SSRS and SSAS designing, constructing and deployment.
• Experience in Database Development, Modeling, Data Warehousing, Design and Technical Management. Good understanding of Normalization /De-normalization, Normal Form and database design methodology.
• Excellent experience in migration of data from Excel, Flat file to Microsoft SQL Server using SSIS and DTS utility.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in Data Modeling (logical modeling and physical modeling), Entity relationship diagram (ERD) development/normalization and physical database schema design using MS Visio and Erwin.
• SAS base syntax and be able to covert SAS syntax into SQL SSRS code.
• Extensive experience of full software development cycle from analysis and design to test and release of the applications.
• Extensive experience in creating KPI’s, Aggregation, Perspectives in CUBE using SQL server Analysis.
• Excellent knowledge of waterfall and spiral methodologies of Software Development Life Cycle (SDLC) and AGILE.
• Experience in OLTP & OLAP environment that includes Production (24x7), QA and Development databases in SQL Server.
• Using SSRS, Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports, Cross-Tabbed Reports.
• Extensively worked in SQL server Reporting services (SSRS) to create reports that draw content from a variety of data source.
• Expertise in designing ad-hoc reporting for different level of end user.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Experience in creating KPI's, Aggregation, Perspectives in CUBE using SQL Analysis Services.
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting, DTS and Jobs.
• Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills.

TECHNICAL SKILLS:

• MS SQL Server 2012/2008/2005
• MS SQL Server Reporting Service 2012/2008/2005
• MS SQL Server Analysis Services 2008/2005
• MS SQL Server Integration Services 2008/2005
• DTS
• MS Visio 2003
• MS Access
• FrontPage
• Visual Basic 6.0
• ERWIN
• Windows 9x/NT/2000/XP/Server 2003
• T - SQL
• HTML
• XML
• Cognos Report
• VBScript
• Data Model-logical/physical
• ado.Net Entity Framework
• Share Point
• MSAS
• MDX Script
• Oracle and DB2 Sources
• Crystal Report
• Tableau
• MSAS.

PROFESSIONAL EXPERIENCE:

Confidential, Sparks, MD

SQL Developer /Tableau

Responsibilities:

• Identifying Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling.
• Blend data across heterogeneous data source like Excel, CSV, PostgreSQL and Microsoft SQL Server 2012 in order to create as well edit custom SQL procedures using T-SQL for custom data mapping.
• Prepare dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Create and modify analytical reports with visually rich and interactive dashboards at each stage of loan approval using Tableau Desktop.
• Developed customized calculations as required for different areas of post approval processing namely Funding and Book Keeping.
• Use geographic view to understand and leverage the key areas of the business by line of business and geographical area.
• Used Python and Scala for spark coding.
• Used Hive as source to load data in tableau and develop report generated and deployed in Hadoop & AWS.
• Create filter actions to share/send information with other tableau worksheets.
• Provide rich visual interaction between the views, create URL actions to connect the data views Master Data Management, IBM DataStage and worked on Software Development Life Cycle (SDLC) methodologies and tools
• Implement new features of Tableau namely new Visualizations, Forecasting, Data Blending and Hyperlink Objects based on use case.
• Publish the dashboards to report server using Tableau Server.
• Agile mode of project management methodology and participate in weekly sprint resource planning, implementation and tracking using Microsoft Team Foundation Server (TFS).
• Working in Tableau, SAS, T-SQL and whole suite of products like SSIS, SSAS, and SSRS.
• Expert in High Level Design of ETL Package for integrating data from heterogeneous sources like Oracle, Excel, CSV, flat file, Text Format Data. solid knowledge of Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP and OLAP and experience with Working on SSIS, SSAS, SSRS, Data Analysis, and Data Migration.

Environment: MS SQL Server 2012/14 R2, Tableau 9.1.x, Tableau Server (9.1), Oracle 11g, PL-SQL, Teradata, Microsoft Team Foundation Server (TFS), MS SQL Server Reporting Services, MS SQL Server Integration Services, Server Analysis Services, Excel, power point, XML Testing, Kimball Data ware house, Hadoop, Spark, Jira, SAS.

Confidential, Gainesville, TX

MS SQL - BI /Tableau Developer

Responsibilities:

• Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
• Developed Custom Visualization in Power BI such as Liquid Fill Gauge, Bar Charts, etc.,
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel.
• Wrote DAX Expressions, Power Query, Functions in Power BI.
• Extensively worked on administering SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Proficient with Base SAS, Macros, Proc SQL and Statistical analysis using SAS statements, functions and procedures.
• Used BASE SAS and SAS/Macros to extract clean and validate data from DB2 tables. Tested and debugged existing macros.
• SAS programs with BASE SAS and SAS MACROS for Ad-hoc Reports
• Worked on legacy SAS Clinical databases like Oracle Clinical & Clintrial with over 5 years data and performed mapping, conversion and processing of raw data from various databases.
• Rebuilding / monitoring the indexes at regular intervals for better performance. Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Installed and configured SQL Server Reporting Services.
• Excellent experience in Crystal report. Use tables, view, Store Procedure as data Source.
• Handle ODBC, OLEBD. .net Object as Crystal Report Data Source, write Complex Crystal Formula to format report as business logic and also work with parameters.
• Very good experience of Crosstab Crystal Report to provide unlimited dynamic column in report.
• Sub Report in Crystal report to Generate section wise.
• Work with other teams and team members in zodiac to resolve issues related to data. Interact with clients to understand requirements. Maintain proper documentation of the various process and code.
• Extracted data from various source systems like Teradata, Sql Server and flat files.
• Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business users.
• Worked and the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau.
• End to end experience in designing and deploying data visualizations using Tableau.
• Create Jasper IReports with connecting JDBC connectors.
• Worked on building queries to retrieve data into Tableau from SQL Server 2008 and Oracle SQL Developer, and developed T-SQL statements for loading data into Target Database.
• Developed various interface webpages for incoming files for the Vendor Interfaces including service invoice, repair order, finance and insurance, vehicle inventory tracking, parts order using C# and job claims with stored procedures.
• Have hands on experience in Data migration, Analysis, Validations and Reconciliation.
• Performed Unit testing and Functionality testing of the financial module based on test scenarios and validating the data.
• Created Jasper iReport from connecting to JDBC connector.
• R language for progrming and SAS ETL scripting.
• Used VB Script for validating client side data entry screens in SSIS Packages.
• Deployment of Web services for online transactions using C#
• Designed and developed business components using C#.Net 2.
• Expertise in Microsoft Integration Services SSIS (Control Flow tasks, Data Flow tasks, Transformations, Database administration tasks)
• Created packages in SSIS with error handling as well as created complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Look Up, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Consulted on Tableau server performance enhancements; upgrades from version 8.0 to 8.1.5 and server reconfiguration based on workbook complexity and data extraction.
• Customized the Tableau landing page with site listing as icons and descriptions.
• Constructed the reports page for internal strategy group with standardized custom by sections within Tableau
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Used SSIS for ETL processes, SSRS & Tableau for Reporting needs and SSAS for Analytics reporting including SharePoint integration.
• SSRS and Tableau used for report development for monthly, quarterly and yearly basis.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, error handling.
• 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
• Designed SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• 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.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.

Environment: Windows XP, MS SQL Server 2014 and updated to 2016, MS SQL Server Reporting Services, MS SQL Server Integration Services, Server Analysis Services, Excel, Acrobat Reader, Tableau.

Confidential, PA

SQL/Tableau Developer/Jr. DBA

Responsibilities:

• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Created SSIS packages for data Importing, Cleansing, and Parsing. Extracted, cleaned and validated.
• Kimball Data ware house by ETL tool extract Data modeling in Star schema also work on full life-cycle BI implementation and Teradata with Experience with Tableau and Qlik Sense.
• Created SAS/ SSIS Packages to integrate data coming from Text files and Excel files.
• Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology, using industry leading Data Modeling tools like ERWIN and EMBARCADERO ER Studio.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Wrote stored procedures & User Defined Scalar Functions (UDFs) to be used in the SSIS packages & SQL script.
• Tested, Cleaned & Standardized Data meeting the business standards - Fuzzy /exact lookups using SSIS tasks.
• Data management & data processing solutions using SSIS includes Error Handling & Slowly Changing Dim.
• End to end experience in designing and deploying data visualizations using Tableau
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Experience includes technical support, troubleshooting, report design and monitoring of system usage.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Configured report builder and trained business users so that they could create reports from the report models.
• Prepared the Layouts by placing the fields to the appropriate place of the final Report.
• Developed ETL, using SQL Server 2008 R2/2012 Integration Services to migrate data from Oracle data source into a SQL Server 2008 database and creating complex SSIS packages, DTS Packages.
• Wrote T-SQL queries, Store Procedures and used them to build packages and maintain the history of the data.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily.
• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Maintained Data Model and synchronized it with the changes to the database.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project.
• Created Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and ongoing tasks for mapping.
• Deployed and configured reports in SharePoint Server.
• Developed collaboration and digital asset management system based on SharePoint and SQL Reporting service
• Created standard & Data driven report subscriptions. Snapshots report and cache for better performance.
• Creating Logical, Physical data model using SQL server, Erwin, MS Visio.
• Involved in code reviews meetings and designing sessions and get mentored from the tech leads.
• Strong experience in Database design and multi-dimensional modeling (star schema and snowflake schema), data cleansing, scrubbing and integration.
• Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports.
• Deployed and scheduled Reports using SSRS and Tableau to generate all daily, weekly, monthly and quarterly Reports including current status, MIS reporting & MDX Scripting experience with SSRS

Environment: MS SQL Server 2008/2012, T-SQL, SSIS packages, DTS Packages, VSS, SSRS, MS Excel, Visio, Erwin, SQL Server Analysis Services, SharePoint, Teradata, MS Office 2010/2007, Microsoft Office Share Point - 2010, SAS, Tableau.

Confidential, NJ

SQL Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Updated functional specification and technical design documents.
• Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins.
• Involved in Data mapping, logical data modeling, created ER diagrams in ERWIN/Studio and used SQL queries to filter data within the database.
• Created complex ETL strategies to extract, clean and deliver data to OLAP environment.
• Extensive experience in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages.
• Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services (SSIS).
• Experience in creating SSIS packages using different type’s task, with Error Handling, log particular event by creating logging and worked on package configuration to run package on different server.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008
• Generated Sub reports, Drill down reports, Tabular Report and list reports using SSRS and publish PDF
• Managed, monitored the system utilization by using the query optimizer, checking the execution plan.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.
• Established a sound backup and recovery policies and procedures.

Environment: MS SQL Server 2008 R2, MS SQL Server Reporting Services, MS SQL Server Integration Services, Server Analysis Services, Excel, power point, XML Testing, Kimball Data ware house.