SUMMARY:

• Over Eight (8+) years of extensive experience in database design, development and administration of Microsoft SQL Server versions 2008/2008R2/2012/2014 using SSIS, SSAS, SSRS.
• Experience in Database Development and Data modeling such as Creation of Tables, Stored Procedures, Views, Functions, Triggers (DDL and DML), indexes, and functions.
• Good understanding of Normalization and De - normalization, Normal Forms in creating Database Objects with Constraints like Primary key, Foreign Key, Unique and Default.
• Good Experience in various packages of SSIS, SSAS and SSRS designing, constructing and deployment
• Expertise in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures, dimension members using Microsoft Analysis Services (SSAS).
• Experience in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for operational data.
• Experience in providing Logging, Error handling using Event Handler and Custom Logging for SSIS Packages
• Experience in design and implement processes for deploying, managing and extracting data using SQL Reporting Services SSRS and SSAS.
• Good experience in data modeling and metadata services.
• Knowledge on Tableau Reporting Tool.
• Good understanding of TIBCO Spotfire platform.
• Good experience in Spotfire for loading data from databases and creating visualizations.
• Hands on experience in identifying and resolving performance issues in various levels like sources, mappings.
• Hands on experience in optimizing SQL scripts and improving performance in loading warehouse.
• Experience in creating tabular, matrix reports (crosstab or pivot), charts and graphs using SSRS and Power BI.
• Expertise in executing workflow from COSMOS to SQL DB using MSFT Internal tools.
• Proven experience in front end design and development using HTML, XML, JavaScript.
• Strong knowledge development processes, Agile and scrum methodologies.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills also, strong analytical skills.

TECHNICAL SKILLS:

Languages & Web Technologies: Confidential -SQL, SSRS, SSAS, SSIS, SQL-Server, Java, PHP, MySQL, C++, C#, HTML, CSS, Java Script, AJAX, XML, SOAP

SDLC: Agile, Waterfall

RDBMS: SQL Server ( Confidential -SQL), MySQL, Oracle

Reporting Tools: SQL Server Reporting Service (SSRS)

BI Tools: Power BI, Tableau, TIBCO Spotfire, Micro Strategy

ETL Tools: SQL Server Integration Services (SSIS), Import Export Data

OLAP Tools: SQL Server Analysis Services (SSAS), OLAP Cubes

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, SQL Server Management Studio, SQL Server Query Editor, SQL Profiler, Analysis Manager, Reporting Server

Data Modeling Tools: Erwin, MS Visio

Operating Systems: Windows 7/Windows server 2008 R2 / 2008, Linux, COSMOS

Applications: MS Word, Excel, PowerPoint, Outlook, Adobe Photoshop

Web Servers: Apache Tomcat

Design and Development: Visual Studio, SSMS, Eclipse, IBM Rational Rose

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. SQL BI Developer

Responsibilities:

• Involved in gathering requirements and designing database workflow.
• Developed scripts in OLTP environment to insert, update and delete data in SQL Server database tables.
• Created complex queries with joins, correlated sub queries
• Optimized queries using indexing and SQL profiler
• Designed SSIS packages with Error handling and scheduled jobs for data migration from different sources into OLAP environment.
• Actively monitored loggings, transactions, deployments and configurations.
• Worked with different methods of logging in SSIS and advanced data mapping.
• Implemented master-child package techniques to manage ETL projects efficiently.
• Implemented event handlers, loggings, breakpoints, and data viewers to debug and repair errors.
• Improvised analytical information by creating OLAP cubes.
• Process the cubes (SSAS), partitions as and when required
• Designed, implemented and optimized SSRS reports with snapshots, caches, embedded data sets, execution log views, expressions, and stored procedures.
• Generated SSRS reports utilizing Excel spreadsheets with Power Pivots, deployed with SharePoint integrated mode

Confidential, Salon, OH

Data Analyst

Responsibilities:

• Involved in designing of both logical and physical database.
• Created complex SQL queries, derived tables, user defined functions, views both indexed and materialized.
• Wrote complex stored procedures, cursors and database triggers.
• Understanding and analysis of the requirements provided by the clients and the dependencies of external systems.
• Managed and created and altered Databases, Tables, Views, Indexes and Constraints with business rules using Confidential -SQL.
• Evaluated data modeling, database administration, and database backup and recovery tools and made recommendations.
• Created efficient SSIS Packages using SSIS Control Flow Tasks and Transformations, also, SQL Jobs to run SSIS packages on scheduled basis.
• Worked on crystal reports and Actuate reporting tools
• Worked on generating layout view, managed data sets using the actuate reporting tool.
• Involved in code and chart editing using Actuate Reporting tool.
• Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports
• Participated in discussions about the status and bugs reported.
• Participated in DATA migration testing.

Confidential, San Diego, CA

SQL BI SSIS/SSAS / SSRS Developer.

Responsibilities:

• Developed database applications by collaborating with DBAs and business analysts to identify requirements.
• Created SQL datasets for Power BI and Ad-hoc Reports.
• Converted and loaded data from different databases and files.
• Created SQL scripts to create objects such as views, tables, and functions.
• Designed views as per the requirements to present data on web pages.
• Involved with Transact SQL ( Confidential -SQL) Coding, writing queries, cursors, functions, views, & triggers.
• Modified existing stored procedures to improve performance and implement business logic.
• Documented functionalities of functions, stored procedures and dependencies of multiple objects.
• Involved in sharing information through network using Java Web Services.
• Generated various reports (SSRS) in Visual studio environment.
• Performed troubleshooting of client's database related issues during implementation, maintenance and upgrading and migration process.
• Followed Agile methodology in project delivery.
• Created Tabular, Matrix reports, Charts and graphs as per customer requirements Using SSRS and Power BI.
• Worked with SharePoint Server 2007 while deploying SSRS reports.
• Used Team foundation server (TFS) as a source control.
• Used Performance Point Server 2007.
• Responsible for maintaining UAT (User Acceptance Testing) and Production environment.

Confidential, St. Louis, MO

SQL Developer

Responsibilities:

• Involved in gathering requirements for the project.
• Implemented the Waterfall SDLC concept.
• Used Rational Rose for UML diagrams and ER diagrams.
• Developed a web application using C#.net and ASP.net.
• Involved in building an extensive OLAP data warehouse using SSAS.
• Designed SSIS packages with Error handling and scheduled jobs for data migration from different sources into OLAP environment
• Wrote complex queries, performance tuning and optimized SQL queries using Confidential -SQL, SQL Profiler in SQL Server 2005.
• Created user controls for login pages and used validation controls.
• Provided authorization to control user access to application features.
• Managed SQL Server logins, user accounts, passwords and database object permissions.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Created reports and designed graphical representation of analyzed data using reporting tools

Confidential

SQL Developer

Responsibilities:

• Installed and configured SQL server 2005 on development server for designing and testing, applying service packs.
• Provided User Access Confidential different levels for both the network and the SQL Server databases.
• Involved in creating Databases, tables with different constraints, Views, Stored Procedures, Triggers and Defaults.
• Involved in merging existing databases and designed new data models to meet the requirements and perform daily for asset management.
• Converted Data Transformation Services (DTS) applications to SQL Server Integrated Services (SSIS).
• Involved in creating and storing Java web services in SSIS and query the Results.
• Configured and audited SQL Server security.
• Monitored the performance of Database Server.