SUMMARY

• Around 8 years’ experience in Database Design, Development and maintenance of database applications on SQL Server 2000/2005/2008/2008 R2/2012/2014 in OLTP/OLAP/BI environment.
• As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
• Capable of handling responsibilities independently as well as a proactive team member.
• Create reports in Power BI preview portal utilizing the SSAS Tabular.
• Created Power BI Dashboards with interactive views, trends and drill downs along with user level security
• Used excel connections to retrieve data fromCOSMOSto excel files and createdadhocreports based on them.
• Designed variousScope ScriptsinCOSMOSto fetch data from structured streams and log files.
• Developed Charts and othervisualization using Power View.
• Filter and Sorting Data usingPower View in Excel 2016.
• Developed Power Maps using Excel2016 for Reporting.
• Implemented a report designer UI in Excel using VSTO and windows form to allow the creation of predefined queries or “Building Blocks” which can be shared or used to create report instances.
• Developed Confidential Visual Studio Tools for Office (VSTO) applications, integrating with MS Excel.
• Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.
• Excellent Experience in monitoring SQL Server Performance tuning in SQL Server 2000/ /2012/2014 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule DTS/SSIS Packages.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDXScripting.
• Good experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Extensively worked on Developing SSASCubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
• Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill - down, Drill-through and Cascading reports using SSRS
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
• Worked on end-to-end projects.
• Worked in collaborative team environment with other developers, business analysts, and a project management team

TECHNICAL SKILLS

RDBMS/DBMS: SQL Server 2008/2005/2000/7.0, Oracle 8i & 9i, MS Access.

BI /Data model Tools: Confidential SQL Server Reporting Services 2005/2000/2012, Crystal Reports, DTS, SSIS, Erwin and Visio.

Operating Systems: Windows 9x/Windows 2000/Windows NT/ Windows Server 2003/Windows XP, IIS 5, 6

Programming Languages: T-SQL, PL/SQL, C, Visual Basic 6.0, VB Script, SQL * Plus, VB .NET, ASP .NET

Application Packages: MS Office, MS Outlook.

Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio .NET 2015, SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), ODBC, OLAP, MOLAP, ROLAP, OLTP, DBCC, BCP

PROFESSIONAL EXPERIENCE

Confidential, WA

MS SQL BI Developer

Responsibilities:

• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Worked on various tasks and transformations like Execute Sql Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Responsible to support SQL Servers with ever-changing workloads, and achieving some level of predictable performance (or minimizing variance in plans and performance).
• Responsible for Database and Log Backups and Restoration, Backup Strategies and Scheduling Backups
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Knowledge of developing reports from Cubes using the KPI's for decision making, also debugged data connections, data sources and Data Source Views.
• Creating Ad Hoc and Parameterized Various Reports using SQL server 2008 R2 / 2012/2014
• Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Has used BCP, BULK INSERT to transfer data from and to SQL server database
• Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment: MS SQL SERVER 2008 R2, SQL Server 2014, MS SQL Server 2005/2008/2012/2014, SSIS, SSRS, Confidential Visual Studio 2008, SQL Profiler, Confidential Visio, MS Office 2016, Excel 2016Power BI, COSMOS, Scope.

Confidential, NYC, NY

SQL BI developer (SSRS/SSIS/SSAS)

Responsibilities:

• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS), Report Builder.
• Extracted data from SQL Server 2008 into data marts, views, and/or flat files for Tableau workbook consumption using T-SQL.
• Developed and executed UNIX scripts to schedule loads, through wrapper shell scripts for calling Informatica workflows using PMCMD command.
• Expertise in creatingdatabases, users, tables, triggers,macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, TeradataSQL Assistantand Query man.
• Extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Generated Reports using Global Variables, Expressions and Functions for the reports in SSRS.
• Responsible for scheduling the subscription reports with Data Driven Subscription Windows File share and Email Delivery using SSRS.
• Generated various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the web front end.
• Created the Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS.
• Worked on Data Driven Subscription Tables for Quarterly Reports, Monthly Reports as well as Daily Reports.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
• Developed Power Pivot Reports inExcel 2013 by publishing them to SharePoint 2013 for providing ad-hocreports according to client need.
• Developed Charts and othervisualization using Power View.
• Filter and Sorting Data usingPower View in Excel 2013.
• Developed Power Maps using Excel2013 for Reporting
• Created very complex SSIS Packages with considering all the best practice like error handling, logging, configurations, deployments, maintenance.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2012/2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Implemented a report designer UI in Excel using VSTO and windows form to allow the creation of predefined queries or “Building Blocks” which can be shared or used to create report instances.
• Developed Confidential Visual Studio Tools for Office (VSTO) applications, integrating with MS Excel.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Calculated measures and dimension members using multi-dimensional expression (MDX).
• Involved extensively in designing of OLTP database.
• Created schemas, keys and indexes considering the granularity of the data.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.
• Schedule Data Integrator jobs using Data Integrator Administrator. Develop data staging tables and create indexes in the destination table in order to make the ETL process faster than expected.
• Deploy the packages in Production server ad schedule the packages according to the requirements.
• Deployed SSIS packages and Reports to Production Servers.

Environment: MS SQL Server 2008 R2, MS SQL Server 2012,MS SQL Server 2014, Tableau, Enterprise manager, Query Analyzer, SSIS, SSRS, SSAS, DTS, SQL profiler, Query Optimizer, T-SQL, Power BI, Share Point 2010, MDX, ETL, C#, VB Confidential Visio 2016, MS Visual Studio 2008.

Confidential, Johns Creek, GA

Sr. SQL BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services 2005/2008.
• Designed and deployed Reports with Drop Down menu option and Linked reports.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.
• Expertise in creatingdatabases, users, tables, triggers,macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, TeradataSQL Assistantand Query man
• Extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Experienced in implementation of strong referential integrity and auditing by the use of triggers.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Created new cubes and modified existing cubes using SSAS 2008 to make data available for the decision makers.
• Deployed and processed SSIS Packages and SSRS Reports weekly to update information (As per business logic) by using SQL Server Agent and windows Scheduler.
• Created jobs, alerts to run SSIS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages run sequentially using SQL Server Agent job and windows Scheduler.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Worked with Transactional and Snap-shot Fact-Tables.
• Optimized existing stored procedures to achieve improved performance
• Developed advanced correlated and un-correlated sub-queries in T-SQL to develop complex reports.
• Developed Cross-Tabbed and Sub-Reports in SSRS 2008.
• Generated reports using the Crystal Reports and Reporting Services 2008Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2008.
• Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment
• Designed user defined hierarchies in SSAS including parent-child hierarchy.
• Created complex SSIS packages using various transformations.

Environment: MS SQL Server 2008, Windows Server 2003, Informatica, Enterprise manager, MDX, Query Analyzer, SSIS, SSAS, SSRS, DTS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, Share Point Portal Server 2007 (MOSS 2007), IIS 6.0, .XML, ETL, Confidential Visio 2003, MS Visual Studio 2008.

Confidential

SQL developer

Responsibilities:

• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• Worked closely with developers, end users and Administrators in designing and creating databases and other objects.
• Actively involved in designing databases for the system.
• Developed several database objects such as tables, triggers and views and also stored procedures.
• Created Snapshot Replication for the Development and Testing Databases across different Servers.
• Created and scheduled jobs and alerts.
• Studied the existing environments and accumulated the requirements by interaction with various aspects.
• Successfully loaded data from an EXCEL, Access, Flat files into a SQL Server database.
• Developed & executed several optimized queries.
• Written several stored procedures to achieve various functionalities of the system.
• Created packages using DTS for moving data from MS Access to SQL Server.
• Assisted the Application team in data modeling and T- SQL coding.

Environment: SQL Server 2008, Visual Basic 6.0, Windows NT, T- SQL, EXCEL, Access.

Confidential 

SQL Server Developer

Responsibilities:

• Installing and Configuring of SQL Server 2000/7.0 0n windows 2000/NT OS.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Managing of databases objects like Tables, views, indexes etc.
• Implementing Backups and restoring when necessary.
• Used BCP utility to publish table output to text files.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Developed scripts for maintaining administration tasks.
• Developed DTS Packages to transfer the data between SQL server database and files.
• Creation and management of database maintenance plan for various database consistency checks.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries 24x7 Production support.
• Managing of users including creation/alteration, grant of system/db. roles and permission on various database objects.

Environment: Windows 2000, SQL Server 7.0/2000, Enterprise Manager, SQL Profiler, DTS, T-SQL, BCP, Replication