SUMMARY:

• Over 8 Years of extensive experience as SQL Server and Microsoft Business Intelligence applications developer, Specialized as an ETL Developer with expertise in SQL Server Integration, Analysis and Reporting Services
• Broad experience with Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP and OLAP
• Experienced in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules
• Extensive experience in Implementation of Microsoft Business Intelligence (BI) platforms including SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Microsoft Office SharePoint Server (MOSS) in SQL Server 2008/2012/2014
• Worked with T - SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys
• Experience in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects
• Extensive experience in administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs
• Expert in Query Tuning and activities including Updating Statistics, Re-building and Re-Organizing Indexes. Rebuild online index and worked with Dynamic Management Views (DMV) for improving query performance
• Good understanding of Microsoft Reporting Service(SSRS) with Report authoring, Report management, Report delivery and Report security
• Experience in designing complex reports including sub reports and formulas with complex logic using SQL Server Reporting Services (SSRS)
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS)
• Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server 2005 using SSIS tools like Import and Export Wizard, Package Installation and BIDS
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL)solutions for data warehousing using SQL Server Integration Service (SSIS)
• Developed ETL process using SSIS with various control flow, data flow tasks and store procedures for work order validation process
• Good understanding of ETL, Dimensional Data Modeling, Slowly Changing Dimensions (SCD) and Data Warehouse Concepts
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications
• Design and develop dynamic advanced T-SQL, PL/SQL, MDX query, stored procedures, XML, user defined functions, parameters, views, tables, triggers, indexes, constraints, SSIS packages, SSAS Cubes, SQL Server Agent jobs, deployment scripts and installation instructions for enterprise data warehouse and applications
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2008/2012
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Bar Graphs, Pie Charts, Geographic Maps, Heat Maps, Bubble Charts, Funnel Charts, Circle views Area Charts Experienced in creating Indexes, planning and implementing Server Security and authentication
• Very good experience in Relational Database Management System
• Experience in database architecture, design, coding, implementation and production support
• Experience in working on Team Foundation Service (TFS)
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs

TECHNICAL SKILLS:

Development Skills: C, SQL, T-SQL, PL/SQL, ASP.NET

RDBMS: MS SQL Server 2008 r2, 2012

Database Tools: SQL Server Management Studio (SSMS),,Business Intelligence Development Studio (BIDS)

ETL Tools: SQL Server Integrated Services(SSIS)

OLAP Tools: SQL server Analysis Services (SSAS)

Reporting Tools: SQL Server Reporting Services (SSRS)

IDE Tools: Visual Studio .NET

Markup Languages: XML, HTML

Operating Systems: Windows XP/Vista/7

Miscellaneous: MS Office Suite

PROFESSIONAL EXPERIENCE:

Confidential,Atlanta,Georgia

ETL/SQL Developer

Responsibilities:

• Created, Built and deployed successfully dynamic SSIS packages into SQL Server 2008/2012 databases and scheduled them according to requirements.
• Actively participated in gathering User Requirements and Online System Specifications.
• Experience in ETL Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data)
• Performed query plans and making sure every query is using appropriate useful indexes.
• Modified current database by adding tables and relationships to support online system.
• Coordinated with the front-end developer to put in the business rules and wrote stored procedures to check some of the rules at the backend at the time of entering data.
• Worked in extract, transform and load(ETL).
• Designed SSIS packages to load Trading data from different sources Text file, Excel to staging and staging to Data warehouse
• Generated Reports using Global Variables, Expressions and Functions for the reports in SQL server reporting services (SSRS)
• Experience in developing Database Schemas / Stored Procedures / Data Dictionary
• Created views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Created various connection managers (OLE DB connection, flat file connection, ADO.NET connection, FTP Connection) available in SSIS to collect data from heterogeneous sources such as SQL Server, flat files.
• Created SSIS packages to automate the Import and Export of data to and from SQL Server 2008/2012 using SSIS tools like Import and Export Wizard, Package Installation and BIDS
• Applied different transformations, control, lookups, Derived column to easily migrate SSIS package from one server to another
• Identified Dimensions and Facts, Used MDX to extract data from cubes and created MDX script for representing Cube Calculation Used DTS Migration Wizard to convert DTS to SSIS packages and develop new SSIS packages
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights
• Create reports in Power BI review entryway using the SSAS Tabular by means of Analysis connector.
• Responsible for making SQL datasets for Power BI and Ad-hoc Reports.
• Created packages in SSIS with error handling using various data transformations like conditional split, fuzzy look up, for each loop, multi cast, column conversion, fuzzy grouping, and script components for de-duplication of data

Environment: SQL Server 2012/2014, SSIS, Windows Enterprise Server 2010, MS Office 20010, VB.Net, MDX, ALM, Tableau Desktop, Power BI.

Confidential, Wayne, NJ

Responsibilities:

• Gathered requirement and designed technical document to implement the application.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers
• Extensively used the dataflow task to transfer data from AS400 to SQL.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs).
• Involved in daily loads (FULL&INCREMENTAL) into Staging and ODS areas, troubleshooting process issues and errors.
• Managing Extraction, Transformation and Loading (ETL) process pulling of data from various data sources using into staging areas and then target data base
• Used various Control Flow tasks in SSIS like For Each Loop Containers, Sequence container etc. and data flow tasks like derived column, lookup, Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user groups.
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Ware House and for OLTP side
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Migrating MS Access/ Excel reports to SQL Reports using SSRS.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end.
• Created AdHoc reports by building models in Report Builder using Model Designer and Report Builder.
• Designed various reports using different reporting features such as group by, drilldowns, drill through etc.
• Created parameters (multi value, hidden, default etc...) for the required fields using the report designer in order to see the dropdowns in the end report.
• Used various types of report layout options like charts (bars, lines, pie etc...), images, graphs, sub reports, hyperlinks etc. to make them more attractive and understandable.
• Created new reports from the scratch for new requirements and modified some of the existing reports using SSRS.
• Provided documentation of reports and the development process in order to support the system
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.
• Created Sales, inventory and finance cubes in SSAS and designed dashboards on cubes to give users valuable information about business.
• Created partitions, aggregations on measure groups in SSAS for better performance.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services cubes& Reporting Services.
• Created calculated members, named sets and scopes to implement business logic in SSAS cube.
• Created Scorecards based on Key Performance Indicators(KPI’s), and generate KPI Score-card dashboard and pivot tables/charts for decision making, data mining
• Usage of Power BI assets and executing on the information.
• Created SSIS Packages and Tableau Dashboard for Altice Audience Measurement Analytics
• Created and debugged data connections, data sources and Data Source Views.

Environment: SQL Server 2012/2008 R2 Enterprise Edition, .NET Framework, XML, T-SQL, SSIS, SSRS, SSAS, VisualStudio.NET IDE, Windows 2000 Advance Server, Windows 2003 Advance Server, ASP, MS Excel, MS Access, Tableau Desktop.

Confidential,Brecksville,OH

Sr. BI Developer

Responsibilities:

• Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application
• Involved in designing the physical databases model on SQL Server 2005 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system
• Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations
• Extensively used T-SQL to manipulate and architect to produce results for users
• Worked with development teams in the design of physical databases and in modification
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality
• Involved in writing views, cursors, triggers
• Used SQL profiler to view indexes performance to mostly eliminate table scan
• Created MDX script for representing Cube Calculation using SSAS
• Designed MDX queries for the querying data from Data Warehouse
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
• Implemented business intelligence dashboards using MOSS 2007 Report Center and Excel Services producing different summary results based on user view and role membership

Environment: MS SQL Server 2008 R2, BIDS,SSIS, SSRS, SSAS, Business Objects.

Confidential

SQL Server Developer

Responsibilities:

• Actively participated in gathering User Requirements and Online System Specifications.
• Created Database objects - views, and functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Performed query plans and making sure every query is using appropriate useful indexes.
• Modified current database by adding tables and relationships to support online system.
• Defined constraints, rules and defaults.
• Coordinated with the front-end developer to put in the business rules and wrote procedures to check some of the rules at the backend at the time of entering data.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Created views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Documented all processes involved in maintaining the database for future reference.
• Worked on database system construction to include stored procedure construction and testing, OLAP/ROLAP cube design and construction, persistence and business logic layer development
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Wrote Some KPI for Cube development
• Generated Dynamic reports from Cubes coming from OLAP (MOLAP) using SSRS.
• Involved in rebuilding the indexes at regular intervals for better performance.

Environment: SQL Server 2008/2005, Windows Enterprise Server 2000, ERWIN, MS Office.

Confidential

SQL developer

Responsibilities:

• Created new tables, stored procedures for Application Developers and some user defined functions.
• Performed data conversions from flat files into a normalized database structure.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Created DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Development of T-SQL Stored Procedures for moving and maintaining synchronization of data between legacy system and newly developed application.
• Expertise in using variables, property expressions, script tasks in SSIS Integrated Database Maintenance jobs to perform full, differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Documented and maintained history of changes for future reference.
• Tuned the batch programs and online transactions to alleviate performance problems.
• Developed & executed several Optimized queries in SQL.
• Assigned Index tuning scripts to run at regular intervals.
• Performance monitoring and tuning MS SQL Server.
• Assisted the Application team in data modeling and T-SQL coding.

Environment: SQL Server 2005/2008, SSRS, SSIS, T-SQL, Script, JavaScript, ASP, Microsoft Office, Windows 2003/XP