SUMMARY:

• 10 years experienced IT professional with experience in Data Base Design, Dashboard Design, Requirements Gathering and developing ETL and Reporting solutions using SQL server/Microsoft BI Suite and Tableau Technologies.
• Expertise with various Reporting and Analytics tools like SSRS, ProClarity, Tableau, Power BI, Performance Point
• Expertise in building Dashboards and Scorecards using Tableau Desktop.
• Experience with Healthcare and Financial Domains.
• Experience with Tableau APIs.
• Experience with Cloud Technologies, Microsoft Azure.
• Experience with Data Mining using statistical concepts and machine learning.
• Over 2 years of leadership experience.
• Quick learner of new technologies and processes.
• Expertise assessing requirements and designing cost - effective BI solutions for different firms.
• Proficient in Logical and Physical Database design & development.
• Highly Experienced in T-SQL Programming, PL-SQL Programming, Fine Tuning of Database and procedures for Improving Performance, troubleshooting and resolving issues.
• Experience with the Agile and Waterfall methodologies of SDLC.
• Experience with Migration Projects
• Assisted, trained and mentored users, members of the technical/production support.
• Published articles in sqlservercentral.com.

TECHNICAL SKILLS:

DBMS: Cassandra, MS SQL Server 2000/2005/2008/2008 R2/2014, Oracle 8i/9i/10g, Netezza, IBM DB2, MS Access.

Database Tools: Big Data, Talend, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, R, SSRS, SSIS, SSAS, SSMS, Azure, BI, DTA, Business Objects, Crystal Reports 9.0/10, SharePoint, Microsoft Project Server 2010, Control-M scheduler, Red Gate SQL Compare, SQL Data Compare, Power BI tools, Tableau 9/10, Tableau Bridge, Pentaho

Programming Languages: SAS, No SQL, SQL, TSQL, PLSQL, Python, VB.NET, C#, XML, C++, Java, VB 6.0.

Scripts: JavaScript, VBScript, HTML, XML ERwin and MS Visio.

Web Tools: MS: Front Page, Macromedia Suite, IIS

Applications: Microsoft Office, Visio, Visual SourceSafe and Team Foundation Server (TFS), Subversion.

CRM Tool: Epiphany Interaction Advisor 6.5.2

PROFESSIONAL EXPERIENCE:

Confidential

Consultant

Responsibilities:

• Migrated ETL processes from SAS PC to SAS EG that helped reduce costs.
• Recreated processes from MS Access to SAS and Tableau.
• Created Tableau Dashboards by consolidating several SAS programs.
• Coordinated with multiple teams both offshore and onshore and designed standard Renaissance dashboards that serve all the teams.
• Designed and developed Dashboards in Tableau which helped find the outliers and prioritize the work to be done.
• Developed solutions using Tableau API Extracts for successful maintenance of Tableau server and users.
• Developed detailed documentation related to the projects.
• Helped with Performance tuning on several reports.
• Mentored team members and other teams with Tableau.
• Created and set up TDE refreshes in Dev and Prod environments.
• Helped create sites, projects and user groups based on the security requirements.
• Synchronized and scheduled refreshes from the Active Directory.

Environment: SAS PC 9.4, SAS EG 7.1, SQL Server 2012/2014, MySQL, PostgreSQL, Microsoft Office, Windows 2003/2000, SSMS, BIDS, Visual Studio, T-SQL, PL SQL, Tableau 10, MS Project, JIRA, Looker, SAS, Oracle, DB2, Hadoop, Python.

Confidential, Frisco, TX

Sr Business Intelligence Developer/Lead

Responsibilities:

• Gathered User Requirements, took ownership on several Tableau Dashboard projects for different Confidential customers, Standard KPIs and scorecard reports.
• Designed and developed Forecast and Trending Dashboards and conducted Demos to customers.
• Mentored juniors and performed code reviews to make sure the team adheres to best practices.
• Collaborated with Sr. Executives, cross teams, business and developers on a regular basis.
• Designed and developed a DataMarts for a Carrier Analysis Dashboard project and Financial Dashboard Project. Tableau was used to build the Dashboard.
• Developed solutions using Tableau API Extracts for successful maintenance of Tableau server and users.
• Implemented Agile and Waterfall methodologies based on the project creating project road maps, PBIs/Stories and scheduled standup meetings.
• Participated in product/technology road map and budget discussions.
• Implemented a solution using SSIS to manage hundreds of SSRS subscriptions in the organization.
• Worked as a part of Migration project converting SSIS packages and Cubes to version 2014.
• Developed detailed documentation related to the projects.
• Helped with Performance tuning on several reports.
• Developed Data Mining solutions and Dashboards using Tableau, Power BI, and SAS, Excel and pivot tables and Azure Machine learning Studio.
• Worked on enhancing and troubleshooting SSAS cube, Tabular Model.
• Helping with cleaning up legacy reports and Subscriptions by creating and using Report Execution Dashboard.
• Helped troubleshoot subscription issues. Worked on several site helpdesk tickets.
• Created and set up TDE refreshes in Dev and Prod environments.
• Created Dashboards that show the login activity and usage of the existing Dashboards.
• Helped create sites, projects and user groups based on the security requirements.
• Synchronized and scheduled refreshes from the Active Directory.

Environment: SQL Server 2012/2014 SQL Azure, MySQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL server Analysis Services (SSAS Multidimensional and Tabular), Microsoft Office, Windows 2003/2000, SSMS, BIDS, Visual Studio, T-SQL, PL SQL, Tableau 9, Tableau 10, MS Project, JIRA, Looker, SAS, Power BI.

Confidential, Dallas, TX

Consultant

Responsibilities:

• Worked with Education, Financial and Healthcare clients to provide them BI solutions.
• Interacted with Business Analysts and SMEs extensively in gathering the requirements and analyzing the needs of the end users
• Developed several Reporting Solutions using Qlikview, Crystal reports, SSRS and Tableau.
• Worked on tuning several stored procedures that run against the data warehouse to enhance performance of reports.
• Worked on several bug fixes and enhancements to the existing reports.
• Wrote complicated scripts to find and fix com objects that are not working to decrease the number of tickets from the customers
• Worked on scripts and SSIS packages to create and load a common database to hold information of common reports to increase maintainability.
• Written MDX queries for Account balance Analysis reports and modified existing cubes.
• Worked on fixing issues related to SSIS packages that load a Data warehouse and performance tuning for a financial client.

Environment: SQL Server 2012, Netezza, SQL Server Integration Services (SSIS), Talend, SQL Server Reporting Services (SSRS), Microsoft Office, Windows 2003/2000, SSMS, BIDS, Visual Studio, T-SQL, Crystal Reports, Tableau, Cassandra, Qlikview

Confidential, Carrolton, TX

Senior BI Developer

Responsibilities:

• Interacted with users extensively in gathering the requirements and analyzing the needs of the end users
• Designed, modeled and created OLTP and OLAP databases.
• Designed and developed solutions using TSQL procedures, functions, views, tables and indexes, SSIS packages and SSRS reports for the Queue Manager Automation Project.
• Created and modified complex stored procedures using features like for xml, Merge and Pivot to reduce the number of lines of code in the procedures.
• Performed Schema, Data, and SSIS and SSRS modifications to enable Stickers on HeathID cards as a part of HealthID Stickers Enhancement project.
• Split the Vendor Export SSIS packages to run parallel for different HealthID clients and tuned procedures for faster processing of pdf documents.
• Created SSIS packages for import and export process for a few clients. Troubleshoot and resolve export and import using logging, error handling techniques in SSIS packages in development and testing phases of the project.
• Created required design and support documentation.
• Scheduled jobs using Control-M, ftp batches using Ipswich, performed comparison, analysis and deployments using Red Gate SQL Search, SQL Compare, and SQL Data Compare.
• Converted DTS packages to SSIS.
• Strong understanding of the replication and version control policies, coding standards.
• Developed the backend process for the Queue Manager UI, also helped junior .NET developers understand the processes.
• Took initiative to design, develop and schedule SSIS packages to check for the modified objects and check in automatically to subversion repository each night.

Environment: SQL Server 2008R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Crystal Reports, Microsoft Office, SharePoint Server, Windows 2003/2000, SSMS, BIDS, Visual Studio, T-SQL, C#, ASP.NET, CSF

Confidential, Irving, TX

Senior BI Developer

Responsibilities:

• Designed a generic schema using Oracle SQL developer Data modeler to host archive data based on several discussions with the business users.
• Designed, developed and deployed SSIS packages to import data from flat file sources and other database sources (using linked server to OracleDB) to the generic schema in Oracle 10g.
• Designed, developed, deployed and secured generic reports using SSRS 2008 R2 and integrated reports with SharePoint 2010 environment.
• Developed comprehensive documentation needed for business and IT.
• Completed training in Applimation/Informatica Lifecycle Management (ILM) tool for data archiving and retirement.
• Developed C# code to deploy SSRS Reports and Datasets in various folders.
• I worked on several SIW Analysis services cube enhancements which involved the modification and creation of Dimensions and Measures based on the business requirements.
• Delivered the Design and Support documentation required for the project.
• Analyzed the OLAP cube processing times, implemented parallel process to run cube partitions using the Parallel Process Utility. Automated the Cube processing based on the schedule requirements..
• Rebuilt the SIW Analysis Services 2000 OLAP cubes using SSAS 2008 R2 for Data Mining and reporting.
• Developed Reports on SSAS 2008 R2 cubes using SSRS and Excel 2007.
• Managed Report Users and Roles using PAS (ProClarity Analytics server) Admin Tool.
• Used ProClarity Professional to create new reports and modify existing reports
• Wrote complex SQL queries to obtain the reports information from the PAS databases which helped in cleaning up the reporting environment.
• Troubleshooting reports which involved writing several complex pl/sql queries.
• Actively and effectively communicated with the business in working out the requirements and design.
• Used MDX extensively to modify and create reports based on the processed cubes.

Environment: C#, SQL Server 2008R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services(SSAS), Analysis Manager, Query Analyzer, ProClarity Analytics Server Administration tool, ProClarity Web/Professional, SQL developer, Enterprise Manager, Microsoft Office, Windows 2003/2000, SSMS, BIDS, Visual Studio, T-SQL, PL/SQL, SQL Data Modeler.

Confidential, Dallas, TX

Senior SQL Server Developer

Responsibilities:

• Developed Design Documents with Data Model and Deployment Documents with implementation procedures required for the project phases Iteration II, Iteration III and Iteration IV.
• Created and modified Tables, Views, Stored Procedures, Functions, Indexes, complex T-SQL scripts required for the .NET Portal, SSIS packages, Reports and Report Models.
• Developed SSIS packages to load Customer and Transactional Data from Staging to Reporting database.
• Created and Modified Report Models “DVI Model”, “OF Model” and “ Corporate Model” to enable users to create ad hoc reports which required strong understanding of OLAP data model principles.
• Implemented Row level security in OF and DVI Models.
• Developed drill down and drill through SSRS Reports with interactive features per business requirements.
• Created and modified VB, C# scripts used in SSIS packages to implement business logic.
• Provided SSRS training to NAOps team. Created the required training materials.
• Developed several SSIS packages to perform mass update of data as requested by the business.
• Created several Named Queries and Named Calculations to the Report models to help users create ad hoc reports with ease.
• Experience using performance tools including SQL Profiler for troubleshooting, Query Analyzer Execution Plans for performance tuning.
• Actively participated in Design Review, Code Review, Deployment, Knowledge transition and Status Meetings.
• Developed 19 SSIS complex packages to automate the E-price Data Load Process.
• Created and scheduled jobs as a part of data automation.
• Developed complex stored procedures to monitor job status and perform tasks based on the status.
• Developing Delta Reports that show products and pricelists for which the prices are affected.
• Developed Support, Design and Deployment Documents required for the project.
• Developed Delta check logic to limit the number of products for which the Calculation Engine runs to increase the efficiency
• Tuned several procedures and made modifications to the queries as required.
• Worked on several production support requests for the business.

Environment: SQL Server 2005/2008R2, Project Server 2007, SQL Profiler, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Office, Windows 2003/2000, SSMS, BIDS, Visual Studio, T-SQL, VB, C#.

Confidential, New York, NY

Senior SQL Server Developer

Environment: SQL Server 2005/2008, MS Excel, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Office, Microsoft Project Server 2010, Windows 2003/2000, SSMS, BIDS, Visual Studio, T-SQL, VB.NET, C#, VBScript, Extended JavaScript, Perl, AS400.