SUMMARY:

• Over 8 years of IT experience in Development, Modeling, Implementation and Testing of Decision Support Systems using SQL Server, Sybase and Oracle Technologies
• Extensive experience in developing Stored Procedures, Views, Triggers, Functions and other database solutions
• Expert in Microsoft Business Intelligence tools SSIS, SSRS and SSAS
• Experienced with MS SQL profiler and database tuning adviser to create proper indexes on various data warehouse tables to achieve the optimum performance of report queries.
• Successfully created logical and physical data models for relational and multidimensional databases using Power Designer, MS Visio, Enterprise Architect and Erwin .
• Designed and developed high performance ETL business solutions using SSIS Packages, Stored Procedures and Shell Scripting
• Expert in business intelligence tools Tableau, Business Objects and Crystal Reports
• Designed and Implemented Billing and Payment Databases
• Experienced working with several operating systems, including UNIX, LINUX, Windows and Mac OSX
• Experienced in UNIX Shell Scripting and Perl programming
• Excellent business and systems analysis skills to understand business requirements and customizing client applications
• Excellent communication skills, experienced in client interaction, providing technical support and knowledge transfer
• Lead production support team and closely worked with business stakeholders, DBAs and System Engineers
• Expert Enterprise Data Modeler with a deep understanding of developing transactional enterprise data models that strictly meet normalization rules, as well as enterprise data warehouses using Kimball data warehouse methodologies.
• Extensive experience and proficiency on the design, construction and implementation of ( Star, Snow Flakes ) schema data models for enterprise Data Warehouses

TECHNICAL SKILLS:

• MS SQL Server 2014/2012/2008/2000/2000
• Visual Studio 2013/2012/2010/2008
• Subversion
• DTS
• SSIS
• OLAP
• Business Intelligence Development Studio
• T - SQL
• MDX
• MS Access
• Sybase IQ
• Oracle
• HTML
• V BScript
• JavaScript
• Microsoft Visio
• Power Designer
• SSRS
• Tableau
• Crystal Report
• Qlik View
• SharePoint
• VB6
• .Net
• Windows
• LINUX
• UNIX
• Mac OSX

PROFESSIONAL EXPERIENCE:

Confidential

Lead Business Intelligence/ ETL Developer

• Migrated existing OAI data process from Oracle to Sybase IQ
• Closely worked with Airlines Industry analysts and converted the requirement document to a detailed project plan
• Designed SAP Power Designer ETL data models for manual and legacy data process
• Coded data load and quality check ETL procedures
• Converted processes coded in Perl and Unix Shell Script to SQL Procedures
• Designed Crystal Reports and wrote complex report queries
• Designed and successfully Implemented story telling Tableau View Dashboard Reports
• Designed various reporting objects like Facts, Attributes, Hierarchies, Transformations, Filters, Prompts, Calculated Fields, Sets, Groups, and Parameters in Tableau View.
• Developed complex dynamic stored procedures to populate data for multiple reports from a single piece of code.

Confidential

Business Intelligence Developer

• Designed data models using MS Visio ( Logical, Physical data models)
• Designed ETL packages using SSIS and Stored Procedures
• Wrote Stored Procedures and Views for report datasets
• Resolved database and report performance issues and Implemented best practices
• Designed and implemented SSRS and Tableau reports
• Created facts, dimensions and Star Schema Model for the data mart
• Created and modified SSAS cubes (dimensions, facts, members, calculations, etc.) including relational side design

Environment: MS SQL Server 2008/2012,SSIS, SSRS, SSAS, MS Office 2007, MS Visio, Windows Server 2003/2008,SERENA, SharePoint, Visual Studio 2010, TFS, Tableau

Confidential, Washington, DC

Business Intelligence Developer

• Lead production support team and worked on full software development life cycle from requirement to deployment
• Troubleshoot production issues and maintained wide range of applications
• Worked as part of SCRUM development team
• Converted DTS packages to SSIS packages and database stored procedures
• Created packages using BIDS Designer for Extract, Transform, Load of data using control flow tasks and data flow transformations. Schedule jobs, Deployment of processes.
• Lead development efforts and worked with team to modernize USAC’s Legacy applications and automate manual processes
• Migrated USAC’s SQL server 2008R2 databases to SQL server 2012
• B u ilt relat i o n sh ip s w i th t e a m m at e s in o ther d epa r t m e n ts a n d f o un d wa y s t o s t r e a m li n e p r o ce s s es, i d entify p r o j e ct r o a db l o c ks, a n d c r ea t e i n n ov a ti v e s o l u ti o n s
• Developed and maintained Billing, Invoicing and disbursement databases
• Developed and maintained database applications with multiple dependencies
• Designed and developed USAC’s Billing Invoices Using Crystal Report

Environment: MS SQL Server 2008/2012,SSIS, SSRS, SSAS, MS Office 2007, MS Visio, Windows Server 2003/2008, Windows XP, SERENA, SharePoint, Visual Studio 2010, TFS

Confidential, Chicago, IL

MS SQL BI developer

• Created packages using BIDS Designer to Extract, Transform and Load data.
• Created admin level ad-hoc report models and configured it with named query and named calculations using SQL server 2008 reporting services.
• Installed and Configured SQL server 2008 and all its components on the standalone test server and deployed the entire application on that along with canned and ad-hoc reports.
• Created SSIS package to transform data from multiple sources to SQL database using SSIS. Implemented Control Flow elements like For each loop and Sequence container, Execute SQL task, Execute Process task, Execute package task and Script task, File System task Send Mail Task
• Fine-tuned various complex stored procedures using Query tuning advisor and Query Execution plan.
• Wrote insert, update and delete triggers on database table to capture any DML changes happened and populate the Audit trail report with these data

Environment: MS SQL Server 2005/2008, 2000, SSIS, SSRS, SSAS, MS Office 2007, MS Visio, Windows Server 2003/2008, Windows XP, SERENA, SharePoint, Crystal Reports.

Confidential

Data Modeler

• Designed and developed database models with MS Visio, that can handle fulfill client’s dynamic reporting need.
• Worked on the data warehouse consolidation project and created different SSIS packages
• Created SQL server replication for improving better performance on reports by setting up separate replicated database for reports.
• Created SSIS packages to generate Insert script which can fill in the data to SQL database tables using various data flow elements of SSIS.
• Created SSIS packages to sync up the data between staging and production server.
• Worked with the logic of generating sub-report and linked report to provide client a best possible solution to fit into the reporting requirement.
• Created some drill through and drill down reports to make some lengthy reports compact and with the flexibility to view each piece of data by state and city.
• Extensively worked with Query execution plan and database tuning adviser tool to fine tune report query in order to achieve the best performance of the report.
• Used the derived table approach in each report queries to achieve the best performance and avoided the use of cursors to optimize the SQL query performance.
• Developed complex views, stored procedure and functions to generate various static and operational reports.