SUMMARY

• 8+ years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2000/20 R2/2012.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, Strong understanding of BI application design and development principles.
• Extensive working experience in:
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.)
• Writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Programming in SQL Server .net- Stored Procedures, Triggers, User-defined Functions and Views, Cursors
• Performance tuning of Stored Procedures and T-SQL Queries
• Implementing SQL Server Indexing and Query optimization using Indexes
• Good exposure or knowledge working on C#, VB.NET framework
• Logical & Physical Data modeling, data architecture designs etc.
• Understanding existing data models, data flows and data dictionaries
• Creating new data models, data flows and data dictionaries
• Normalization and De-Normalization techniques
• Involved in Backing up databases and refreshing Data across environments
• Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
• Creating data load and Upgrade scripts for data migrations, data formatting and data validations implementing all high availability techniques like clustering, log shipping, replication
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS-Excel spreadsheets and Power Pivot.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 ) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports
• Created Scorecard/Dashboard pages in Performance point server (PPS)
• Used ProClarity tool to analyze the data in the cube by using different features like Chart view, Decomposition Tree, Performance Maps, etc.
• Defined group level security standards for Tableau.
• Used Tableau to visually analyze data and create consise and actionable dashboards
• Generated reports from Analysis Services cube by using ProClarity tool.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Expertise in defining the business process flow and gathering business requirements.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Good presentation, summarization, structuring and refinement skills. Proven track record of execution capabilities for strategic as well as tactical plans, both within and through functional boundaries.
• Worked as a QlikView Technical Consultant for a wide variety of business applications.
• Enthusiast and Experienced QlikView developer- the pioneered in-memory Dash boarding tool.
• Worked with QlikView 10.x, SQL Server, Oracle, SAP, Excel, flat files.
• Suggested new database technologies and processes such as data warehouse and related reporting technologies.
• Create a mining structure by using the CREATE MINING STRUCTURE statement, and add a mining model to the mining structure by using the ALTER MINING STRUCTURE statement.
• Create a mining model and associated mining structure simultaneously by using the CREATE MINING MODEL statement to build an empty data mining model object.
• Export a mining model and associated mining structure to a file by using the EXPORT statement. Import a mining model and associated mining structure from a file that is created by the EXPORT statement by using the IMPORT statement.
• Copy the structure of an existing mining model into a new model, and train it with the same data, by using the SELECT INTO statement.
• Completely remove a mining model from a database by using the DROP MINING MODEL statement. Completely remove a mining structure and all its associated mining models from the database by using the DROP MINING STRUCTURE statement.
• Coding, Code Reviews & Unit Testing.
• Reviewing and tuning SQL and PL/SQL code.
• Good understanding of RDBMS Concepts, Oracle PLSQL, SQL.
• Develop business object in accordance to clients' needs and requirements.
• According to Kimball et al., this phase is the start of the Lifecycle. It is a planning-phase in which project is a single iteration of the Lifecycle while program is the broader coordination of resources. When launching a project/program Kimball et al. suggests following three focus areas Define and Scope project, Plan project, Manage project.
• The Kimball Lifecycleis a methodology for developingdata warehouses, and has been developed over many years.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, Dynamic SQL, MDX, C, C++, C#,ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting, Tableau, Qlikview.

Databases: MS SQL Server Denali,2012,2008R2,2008,2005,2000, Oracle 9i/10g (SQL, PL/SQL, Stored Procedures, Triggers)

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports.

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS),Crystal Reports, Power Pivot, ProClarity, Microsoft Office, Excel Power Pivot. Excel Data Explorer, Tableau, Business Analyst.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Sherman Oaks, CA

SQL BI Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Perform all SDLC phases related to extract, transform, and load (ETL) processes usingSQL Server Integration Services (SSIS) andSQLServer stored procedures within MSSQLServer 2012 environments
• Participate in on-call support rotation for nightly ETL batch cycles
• Worked on WCF, MVC, IIS, and Automated unit testing.
• Assist in the definition of the database requirements; analyze existing models and reports looking for opportunities to improve their efficiency; and resolve technical problems
• Develop optimizedSQLServer stored procedures, functions, and database views
• Translate business requirements intoBIapplication designs and solutions
• Worked on COSMOS Workgroup Feed Import. The Automated feed will update tables from COSMOS Data.
• Performance monitoring, tuning and capacity planning
• Develop ETL audits and controls to ensure quality of data meets or exceeds defined standards and thresholds Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
• Worked on Tabular solutions, which uses relational modeling constructs such as tables and relationships for modeling data.
• Worked on CIS Solaris 10 Benchmark v4.0, and CCS for Reporting and Analysis components.
• Have written Reports, Sub Reports, drill down reports using various features like Charts, graphs, filters, parameters, indicators, gauges, spark lines.
• Worked on Microsoft Light Switch, and Microsoft Silverlight
• Worked on VB.NET, C#, ASP.NET, ADO.NET, Entity Framework, and LINQ.
• Created stored procedures to use as datasets for the Report Design.
• Written scripts using C # programming to customize the reports in SSRS environment.
• Designed VB forms using the forms and crystal reports were made for business reporting purpose.
• Worked on .Net framework 4.0 and Asp.net as a programming part.
• Maintained and implemented technical specification and documentation.
• Involved in generating reports for Forecasting Revenues based on the historical data and used various delivery mechanisms and formats to deliver Reports
• Extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0 and 8.1 as a Developer and Analyst.
• Experience includes technical support, troubleshooting, report design and monitoring of system usage.
• Preparing Dashboards using calculations, parameters in Tableau.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• End to end experience in designing and deploying data visualizations using Tableau.

Environment: MS SQL Server Management Studio 2012, Visual studio 2012, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

Confidential, Oakbrook Terrace, IL

Lead Senior SQL Server Developer

Responsibilities:

• Contribute to the Software development lifecycle including gathering and understating of requirements.
• Database and Report development using SQL Server 2008 Business Intelligence Development Tools
• Develop Stored Procedures, Functions, Views and indexes for use in Analysis and Reporting Using Microsoft SQL Server.
• Create Queries to provide ad-hoc reports and datasets based on business needs.
• Perform Data analysis and data validation by writing SQL queries using SQL Server Management Studio.
• Using SSIS to Create ETL packages to validate, Extract, Transform and Load Data to Data Warehouse databases.
• Create Parameterized SSRS Reports and ETL packages using SSAS Cubes.
• Create SSIS Package to provide Data feeds to Business users.
• Work with Subject Matter Experts (SMEs) in Understanding, documenting and Deploying the Code Changes.
• Work with the Business teams to determine the Requirements and working on BI Solutions including developing, Modifying and Optimizing Database Objects.
• Conduct Post Deployment and Analysis on Production Server for the new Code Changes
• Involve in Unit Testing, Integration Testing and System Testing and identifying the defects In the code and fix them to deliver better product for the business
• Developed dashboards pertaining to KPI monitoring using QlikView10.x.
• Developed complex QlikView scripts to build model, to support various KPIs and time comparison.
• Responsible for positioning and delivering QlikView projects and cross building applications into new and existing customer base.
• Created and Scheduled Weekly QlikView reports to distribute on email using NPrinting and publisher.
• Maintained Server for smooth QlikView development. Checked and updated environmental file, assigned task, path and triggers for QMC, QEMC.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

Environment: SQL Server 2008/2012,SSMS, SSIS, SSRS, SSAS, DTS, VSS, XML,MS Access, SharepointServer,Windows 2005/2008 Server,Visual Studio 2008,TFS 2013.

Confidential, Charlotte, NC

SQL Server BI Developer

Responsibilities:

• Worked on the file import framework process for the various flat files structures to get data imported into our database.
• Created the Stored Procedures, tables, Views depending upon the project requirement.
• Experience in monitoring SQL Server Performance tuning in SQL Server 2008R2/2012 using SQL Profiler, Query Analyzer.
• Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table. Generated ASP.net objects from tables and presented these DOM objects which are capable for easy communication, to the Business applications.
• Created the deployment scripts after the development is done for every project.
• Automated the SSIS Packages using the SQL Server Agent Jobs.
• Troubleshooted the SSIS/SQL job Agent whenever necessary.
• Constructed cubes based on data volumes mostly adhering to Star Schema.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2012 Analysis Services.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Used custom .NET assemblies for Script Task in SSIS
• Hands on knowledge of TFS and Bug Tracking and Reporting through TFS bug tracking tool.
• Imported the various files provide by the clients into the relational database systems.
• Used the BCP to load the large volumes of data from files into tables.
• Worked with Business Analysts and Users to understand the requirement.
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.
• Documentation for all kinds of reports andSSISpackages.
• Used Visual Source Safe as Version Control Tool.

Environment: SQL Server 2012, SQL Server Business Intelligence Development Studio 2012, SSIS, SSAS, SSRS, T-SQL, EXCEL, Performance Point Server, T-SQL, C#, Visual Source Safe, SQL prompt.

Confidential

SQL Server Developer/ETL Designer

Responsibilities:

• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Created reports from database onto excel spread sheet using DTS.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Involved in creating maintenance plans in SQL Agent to backup the database.
• Involved in creating Users and Roles, and managing security and permission of database, managing Jobs and error logs.
• Worked with development teams in the design of physical databases and in modification.
• Involved in analyzing MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.

Environment: SQL Server 2005, Windows Enterprise Server 2003, Windows SharePoint Service 2.0, IIS 6, Visual Source Safe 2003, Crystal Report 10, Crystal Enterprise 10, Microsoft Visio 2000

Confidential

SSIS and SSRS Developer

Responsibilities:

• Logical and Physical design of database for projects on basis of user requirements using ERWIN.
• Created new tables, wrote stored procedures for application developers and some user defined functions. Created SQL scripts for tuning and scheduling using T-SQL.
• Defined Check constraints, Indexes, Views, Created Triggers to enforce data and referential integrity.
• Used the Control Flow and Data Flow Tasks and Transformations in Creating SSIS (ETL) Packages.
• Worked on SSIS (ETL) Packages, Import/Export for transferring data from Heterogeneous Databases to SQL Server.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse.
• Enabled Logging, Database mirroring, Replication for the SSIS (ETL) packages.
• Configured Server for sending automatic mails to respective people on SSIS (ETL) process failure or success.
• Generated various reports based on business requirements using SSRS that could be used to send information to diverse group of users, clients and managers.
• Created various Weekly and Monthly reports showing detailed information in SSRS.
• Created Cross-Tab, Drill-down, Parameterized and Sub-Reports using Report definition Language (RDL).
• Defined Star Schema, OLAP Cubes and Dimensions with SSAS.
• Created the Data source views to analyze the metadata based on multiple data sources during development without an open connection to any underlying data source using SSAS.
• Analyzed the Cubes by performing calculations, perspectives, actions and Key Performance Indicators (KPI’s) in SSAS.
• Modified the measures, dimensions, attributes, hierarchies, measure groups and deployed the changes to the deployed cube in SSAS.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Tuning Advisor.

Environment: SQL Server 2008/2005 SSIS, SSRS, SSAS, Visual Studio 2005, Windows Enterprise Server 2003, ADO.NET, Team Foundation Server(TFS), XML, HTML, Erwin.

Confidential 

QA Analyst and SQL Developer

Responsibilities:

• Involved in installation and configuration of SQL server 2000 on servers.
• Defined various facts and dimensions in the data mart including Fact less Facts and designed the Data Mart defining Entities, Attributes and relationships between them.
• Implemented and maintained database security.
• Implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Fine tuned Stored Procedures, using Execution Plan in T-SQL for better performance.
• Troubleshoot and minimize production down issues.
• Designed new job process, new database maintenance plans, DTS programs and did Performance tuning of the existing processes.
• Created, Scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Data conversions and data loads from various databases and file structures.
• Generated reports using Crystal reports.
• Monitored failed and long running MS SQL Server jobs.
• Maintained User account administration for Different domains.

Environment: SQL Server 2000, T-SQL, DTS, MS Visual Studio 2005 (SSRS, SSIS, SSAS), Crystal reports 7, Windows 2000 Server, .Net Programming, VSS 4.0.