SUMMARY

• 8+ years of professional experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2000/2005/2008 /2008 R2/2012/2014 and Teradata
• Expertise in Microsoft Business Intelligence Tools including Integration Services (SSIS) and Reporting Services (SSRS)
• Experienced in Project-based analytics including Customer Segmentation and Market Basket analysis.
• Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Proficient in:
• Experience in Data Management using Teradata (SQL), Fast Load, UNIX Shell Scripting, SAS and Excel.
• Good knowledge in Unix Shell commands.
• Writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Creating indexes, Views, Cursors, complex Stored Procedures, user defined functions, joins, relational database models, data dictionaries, derived tables to facilitate efficient data manipulation and data consistency.
• Building SSIS packages with complicated transformations like Lookup, Derived Column, Condition Split, Multicast, Sort, Union All, Cache Transform, and Conditional split etc.
• Using SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.).
• Implementing SQL Server Indexing and Query optimization using Indexes.
• 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, database design solutions in collaboration with programming team.
• Written SQL queries using slowly Changing Dimension (SCD) strategy.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Proficient in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Extensively followed Ralph Kimball and K-12 Methodologies.
• Involved in developing Crystal reports.
• Experience in loading database tables from source files using SQL*Loader.
• Excellent Knowledge in RDBMS concepts and construction along with Database Objects creation such as tables, user defined data types, Stored Procedures, Views, User defined functions and triggers.
• Worked on Data modeling technique for defining business requirements for a database.
• Extensive knowledge in visual studio, visual studio .NET and versioning tools like Visual Safe Source (VSS), Subversion (SVN), clear case, GitHub, Team Foundation Server.
• Experience in Database Analysis/Design/Normalization/Manipulation processes using SQL Server
• 2000/2005/2008 , Oracle10g and MS- Access. practical understanding of the principles of DW using Fact Tables, Dimension Tables, dimensional modeling, Star schema modeling and Snowflake schema modeling.
• Experience in Performance tuning and Query Optimization.
• Good Hand on working experience with using all kinds of SQL Server constraints (Primary keys, Foreign Keys Unique Keys).
• Experience in handling business and technical issues & communicating with both business and technical users.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, C, C#, Mat lab

Databases: Teradata, SQL Server 2008/2008R 2/2012/2014/2016 , MySQL, MongoDB

ETL Tool/IDE: Informatica Power Center 9.01/9.5, Visual Studio 2010/2008/2005 , ASP.NET

Operating Systems: UNIX Shell Script, Windows XP, MS DOS

Software Applications: MS Office (Word, Excel, PowerPoint, Access), MS Project 2000

BI Tools/Visualization Tools/Others: Power BI, Tableau, SSIS, SSRS, SQL* Loader, Quality Center 9.2, Clear Quest

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

SQL/BI Developer

Responsibilities:

• Used SQL server integration services (SSIS) for importing files and performing various Extract Transform and Load operations.
• Develop and maintain SSIS packages in SQL server environment.
• Build complex packages to perform backend processing using SSIS.
• Research and resolve production related issues.
• Develop and create new and existing SQL Server Reporting Services(SSRS) reports.
• Create reports, dashboards, stories and visualization reports by using SSRS, Power BI and Tableau Reporting.
• 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, database design solutions in collaboration with programming team.
• Leads cross-functional initiatives, with deliverables and meets quality standards, on time
• Creates Application and System Design Documents€
• Creating complex stored procedures and objects, performance tuning by using SQL Server Advanced T-SQL
• Creating Metadata view and dynamic view by using advance T SQL
• Troubleshooting and resolving problems related to database integrity, performance, deadlocking and blocking
• Diagnosing and resolving performance problems and opportunities
• Created and Developed Power BI Reports of companies Hotfix pipeline
• Designing relational schemas
• Implementing data security
• Develops Applications / Reports / Systems / Enterprise Solutions€
• Designs, Develops and Implements Complex Business Rules
• Responsible for fulfilling end-user requests
• Provides on call support as required

Confidential, Weston, FL

SQL/Power BI/Tableau/SSRS Developer

Responsibilities:

• Worked as Business analyst as well as developer.
• Worked on Requirement analysis, design and development of modules using Power BI, Tableau, SSIS, SSRS. worked on client problem understanding, requirement building, documentation and translation of the requirements into dashboard solutions.
• Building, publishing customized interactive reports and dashboards, report scheduling using both Power BI and Tableau server.
• Created stored procedures and SQL queries to pull data into power pivot model
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks, Power BI reports and dashboards from multiple data sources using Data Blending.
• Developed Unit testing of the modules.
• Designed power BI data visualization using cross tabs, maps, scatters plots, pie, bar and density charts.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations that are available in Power bi query editor
• Weekly presentation to the business users about the reports and their changes as required.

Confidential

SQL/SSRS Developer/Tableau/Power BI

Responsibilities:

• Purpose of the project to migrate Crystal Reports to SSRS and Power BI by using SSRS 2017 Due to Migration from Chancery to Infinite Campus and new tableau reports.
• Worked with SME’S to gather and Document requirements and ensured that the solutions meet their business needs.
• Developed new SSRS reports by following the complete RDLC (Report Development Live Cycle).
• Developed Reports in various styles such as tabular, matrix, drilldown, drill through, main reports with conditional sub reports and Dashboards.
• Tested SSRS reports thoroughly by teaming up with business Analysts prior to user testing.
• Used visual Studios Team Foundation Services for source control.
• Designed and developed Store Procedure, Queries, Views and CTE’s necessary to support SSRS Reports.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks, Power BI reports and dashboards from multiple data sources using Data Blending.
• Modified legacy Store Procedures to be utilized for reports.
• Helped SIS team to extract the data from external sources by using SSIS and Loaded into DW.

Environment: SQL Server 2016/2017, Enterprise Manager, Visual Studio 2017, Management Studio, SQL Profiler, SQL Query Analyzer, MS SQL Server DTS, SSIS, GIT, JIRA, SSRS, Practice Management, Progress

Confidential, San Antonio, Texas

SQL/BI Developer/Tableau/Power BI

Responsibilities:

• Worked on Red Point Data Management tool to extract data from various databases and Transformed the data to generate reports for the business team
• Build projects to extracts the weekly and monthly revenues from various databases of different clients
• Created Reconciliation project and set up a job which runs daily and weekly to check and maintain the process of data flow between different databases
• Gathered and analyzed the customer information and used finding to define migration strategy
• Identified the prospective issues in Azure migration and suggested the feasible solutions to the clients creating, validating and reviewing solution and efforts estimated for the data center migration to azure cloud environment and conducting the proof of concept for latest azure cloud based services
• Involved in designing the red point projects to export data from production databases to a flat file sources worked on client problem understanding, requirement building, documentation and translation of the requirements into dashboard solutions.
• Building, publishing customized interactive reports and dashboards, report scheduling using both Power BI and Tableau server.
• Created stored procedures and SQL queries to pull data into power pivot model
• Developed Automation for all the individual projects and also combining individual projects to one which runs daily, weekly and monthly
• Extracted and loaded data in to SQL server Databases by using SSIS and Red Point
• Worked with data extraction using SSIS Red Point and Data Warehouse staging
• Involved and created packages to migrate the data from Data Stage to SSIS

Environment: SQL Server 2014/2016, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, MS SQL Server DTS, SSIS, Azure, SSRS, SSAS, Practice Management, Progress, GIT, JIRA, Remedy Force Console