SUMMARY

• With more than 8 years of experince in teh field of Business Intelligence applications as a ETL developer with expertised in SQL Sever Integration,Reporting and Analysis Services.
• Having extensive experience as a SQL server Developer dat includes Database Design and Development of SQL Server 2005/2008R 2/2008/2012/2014
• Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, T - SQL, relational database models, data dictionaries, and data integrity.
• Excellent experience in developing complex Stored Procedures, Views and Indexed Views.
• Efficient in creating joins and sub-queries for complex queries involving multiple tables
• Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Proficient in Microsoft BI Tools and Tableau to generate reports and dashboards.
• Expert noledge of support agreements and their implied service levels
• Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
• Transformed data from various data sources using OLE DB / MS ACCESS connection by creating various DTS packages.
• Expertise in creating Report Models for building Ad hoc reports using SSRS.
• Very good experience in writing expressions in SSRS.
• Experience with data analysis and data analytics tools including Microsoft Machine Learning
• Experience with Big Data Technologies like Azure Data Lake/ USQL
• Expert in handling parameterized reports and Cascade Parameterized Reports in SSRS
• Created Reports with complex formulas and to query teh database for business Intelligence.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Solid understanding of network protocols / technologies such as DNS, WINS and TCP/IP
• Most possess teh ability to effectively communicate technical options and recommendations to stakeholders
• Experience working in an Agile/SCRUM SDLC environment
• Experience in creating and deploying parameterized reports using power BI
• Experience in creating hierarchies in Power BI reports using Data visualizations such as Bar charts, Line charts, pie charts, and forecast charts
• Sound Knowledge in Troubleshooting any performance issues in SQL using DMV’s and DTA.
• Expertise in creating Cell Level Security in cubes using SSAS.
• Expertise in using Data Mining tools Microsoft Analysis Services.
• Expertise in implementing SQL Server Security and Process Control.
• Expert noledge of Help Desk tools and trouble ticket tracking processes
• Proficient Knowledge with Database Backup, disaster recovery and Disaster recovery drill.
• Expertise in scheduling and Creating Jobs, alerts and DTS Packages
• Exposure to entire SDLC with noledge of SQL and relational databases, including Object Oriented Analysis/Design skills
• Driven, self-motivated, focused on project activities, strategy, and opportunities
• Strong work ethic with good time management with ability to work with diverse teams and lead meetings

TECHNICAL SKILLS

Databases: MS SQL SERVER 2016/2014/2012/2008/2005 , ORACLE, MS ACCESS, MY SQL

Programming Languages: SQL, T-SQL, VB.NET, C#.NET, PL/SQL, MDX, XML

Reporting Tools: SQL SERVER REPORTING SERVICES(SSRS), POWERBI, INFORMATICA

SQL Server Tools: SSMS, ENTERPRISE MANAGER, CONFIGURATION MANAGER, DTS, SSIS, SSRS, SSAS, QUERY ANALYZER, DATABASE TUNING ADVISOR

RDBMS: SQL SERVER 2005/2008/2008 R2/2012, ORACLE 11G/10/9I

Operating systems: WINDOWS NT/XP/2000/2003. WINDOWS 9X, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

SQL BI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Designed best practices document for ETL and Reporting systems.
• Hands on Experince with SQl Server 2016.
• Gatheird requirement and designed technical document to implement teh application.
• Implemented security for customer information by encrypting sensitive data using SQL
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user groups.
• Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database
• Developed new mappings using SSIS Look Up/Aggregation transformations to match teh needs of teh business case.
• Strong experience in Database Administration & Development in SQL Server
• 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.
• Experience in performing data migrations.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Involved in daily loads (FULL & INCREMENTAL) into Staging and ODS areas, troubleshooting process issues and errors.
• Captured technical metadata through data modeling tools
• Developed Data Mart using Star Schema. Reviewed teh Current Data Mart and OLAP Cubes and Proposed Corrections and enhancements.
• Participated in teh research and resolution of enterprise data governance issues
• Expertise in upgrading or migrating Analysis Services.
• Responsible for maintaining cubes using SSAS and populate teh cubes with teh data.
• Identified teh fact and dimension tables from teh SQL server based on teh requirements.
• Used SSAS MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
• Created reports with Analysis Services Cube as teh data source using SQL Server 2014 Reporting Services.
• Used SSRS Report Catalog to store teh Configuration, Security and Caching Information for teh Operation of teh Report Server.
• Created Ad-hoc reports, Tabular reports, Drill down and Drill up reports.
• Delivered teh final SSRS Report using teh Request Handler.
• Generated Parameterized/dropdown SSRS Reports.
• Responsible for gathering/refining requirements from teh customer for developing reports.
• Created and developed both physical models and DDL scripts to create database schema and database objects
• Created reports using Crystal Reports by importing data sources.
• Created interactive dashboards by using SSRS 2008 R2 and Tableau 8.3.
• Created and managed schema objects such as tables, views, joins, clusters, indexes, functions, procedures, triggers & maintaining Referential Integrity
• Created Distributed Partitioned Views, Debugging/Troubleshooting Stored Procedures, and upgrading existing ones.
• Monitor and optimize ETLs and BI databases to ensure performance and data integrity. Assist in determining teh impact of operational issues, provide input to resolution and perform root cause analysis (RCA)
• Handful Experience in star schema by building relationships between Fact Table and Dimension tables.
• Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: MS SQL Server 2008R2/2008 and 2012 Enterprise Edition, Microsoft Visual Basic, VBScript, XML, SQL Server Reporting Service(SSRS), SQL Server Integration Service(SSIS), Power BI, SQL Server Analysis Service(SSAS), .NET Framework, MS Excel, T-SQL, Tableau 8.3

Confidential, Cleveland, OH

SQL Developer/SSIS/SSRS/SSAS

Responsibilities:

• Communicate to teh business analyst, Data Modeler on a regular basis to be informed on changing requirements or data model design alterations.
• Built Data marts (Fact and Dimension tables) from teh warehouse tables.
• Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX
• Created SSIS Packages according to teh requirements.
• Worked with Flat Files (Pipe Delimited) sources and implemented error handling routines.
• Worked with Flat Files Data source connections, ODBC data source connections (to SQL server sources) and DB2 data source connections.
• Constructed OLTP and OLAP Databases.
• Created ETL package for data conversion using various transformations tasks.
• Used Query, SQL, Merge, Case, Validation transforms to transform teh data (as needed) before loading into teh warehouse tables.
• Experience on publishing Power BI reports of dashboards in Power BI server and Scheduling teh dataset to refresh for upcoming data in power BI server
• Experience in writing complex queries and stored procedures (apply, cross joins, and dynamic SQL)
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
• Created OLAP Dimensions, Measures and Cubes using SSAS
• Design and set up of firewall systems, and DNS servers from scratch
• Worked with Date/time manipulations in SQL Server 2012 built in functionalities as well as Data Integrator Date functions.
• Developed a data warehouse consolidating data from various SQL Application databases
• Oversees teh data load production process and teh implementation of new data load files in accordance with teh departments change management process.
• Handled teh cross schema (Warehouse, Data mart) challenges between teh different environments (Development, QA and Production) by granting permissions on tables using Database functions in scripts before running work flows.
• Prepared ETL design documents for implemented work flows and loaded teh documents in teh project share point site.
• Wrote custom functions to produce teh derived fields using teh source table fields for each record from source
• Created components, tools, techniques, methods and procedures used in an on OLAP environment for accessing and translating data into understandable and usable business information using SSAS.
• Reviewed Cube with End user and changing teh cube according to their requirements.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.

Environment: MS SQL Server 2008R2/2008 and 2012, Query Analyzer, SSIS, T-SQL, Excel, Microsoft SQL Reporting Services (SSRS), Analysis Services (SSAS), XML, MS Excel, MS Access, Power BI, Business Intelligence Development Studio(BIDS)

Confidential, BLOOMINGTON, IL

SQL BI Developer

Responsibilities:

• Promote databases from QA to Production environment.
• Modified databases in QA and Production environment as per need and user’s request.
• Development and modification of document related to systems and operational procedures.
• Monitor teh performance of SQL server using Windows Performance Monitor and Spotlight.
• Tuned Stored Procedures and Queries for optimal Database performance.
• Creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at teh database side for performance improvement.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created Complex ETL Packages using SSIS which upsets data from staging table to database tables.
• Development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting.
• Developed multiple reports using reporting services.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008 with .NET applications.
• Developed Report Models for building Ad hoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.
• Worked on performance tuning on existing stored procedures and existing reports for teh faster processing of reports.
• Involved in database Backup and Restore.
• Configured Server for sending automatic mails to teh respective people when a DTS process fails or succeeds.
• Created Crystal Reports on daily, weekly and monthly basis for manger’s review.
• Responsible for MS SQL Server 2012 in Production, Test, Development and Replication & Cluster Server Environments.

Environment: MS SQL Server 2008/2012, SSRS, SSIS, XML, T-SQL, MS Excel, MS Access, VB.NET, Crystal Reports 2008, VisualStudio2005/2008

Confidential, Berkeley, CA

SQL BI Developer

Responsibilities:

• Determined teh MS SQL Server 2008 installation options. Installed SQL Server Management tools using SQL Server Setup Program.
• Test teh Installation of SQL Server and implemented different security modes.
• Worked on Client/Server tools like MS SQL Server 2008 Enterprise Manager and Query Analyzer to Administer SQL Server.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Used Aggregation Design Wizard to decide best possible aggregation for a given amount of disk space in MS Analysis services 2008.
• Implemented a successful security plan by creating statement permissions, linked servers and encryption of connections by creating certificates.
• Experience in star schema over one year by building relationships between Fact Table and Dimension tables.
• Created Distributed Partitioned Views, Debugging/Troubleshooting Stored Procedures, and upgrading existing ones.
• Responsible for creating dimensional and fact tables and building cubes using SSAS
• Modifying and Creating SSAS Measures, Dimensions Attribute relationships and Hierarchies.
• Created Cubes from which data can be retrieved rapidly by enterprise information consumers
• Developed multiple reports using reporting services.
• Configured Database Mail, created operators, jobs and alerts for automating databases.
• Data migration (Import & Export - BCP) from text to SQL Server.

Environment: MS SQL Server 2008, MS Analysis Services 2008, MS Access 2008 & Windows 2008 platform, SSIS 2008, SSAS 2008, Crystal Report 8.0, Windows Active Directory, ActiveX

Confidential, ST.LOUIS MO

SQL BI Developer

Responsibilities:

• Performed Mapping for multiple related systems.
• Used BCP command line utility to replicate a database.
• Designed different kinds of transactions for teh application.
• Developed packages using SSIS and controlled its execution, by implementing teh infrastructure dat enables execution order, logging, variables, and event handling.
• Generated periodic reports based on teh statistical analysis of teh data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed Various kinds of tabular, matrix, drilldown, drill through, charts and web receiving reports using SSRS
• Generated and formatted reports using global variable, Expressions and functions designed and implemented stylish report layouts
• Used Performance Point Server to create reports, scorecards and dashboards.
• Created packages and scheduled it to get data from OLTP.
• Extensively worked on OLAP cubes using SSAS.
• Created and Managed OLAP Cubes using SSAS.
• Involved in creating calculated members, named set, advanced KPI’S for teh SSAS cubes
• Created variety of reports for business to provide them with critical information about business status.
• Involved in Job scheduling and alerts.
• Developed cursors and views to improve performance in data transactions.
• Experienced in integrating different Microsoft BackOffice Components such as Share Point and IIS with MS SQL Server
• Established backup and recovery procedures for databases and implemented automated jobs for backup.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into teh databases.

Environment: SQL server Integration Services (SSIS), SQL server Reporting Service(SSRS), MS SQL Server 2005/08, MS SQL Enterprise Manager, T-SQL, Windows 2008 Server, TFS (Share Point)

Confidential

SQL Developer/SSIS/SSRS

Responsibilties:

• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Install, tune, maintain and monitor SQL Serverfor teh Production environment
• Used Performance Monitor and SQL Profiler to optimize queries and enhance teh performance of database servers.
• Actively involved in Normalization & De-normalization of database.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Wrote expressions in SSRS to provide flexibility to users by providing them with variety of options for seeing teh business information in tables/charts etc.
• Identified and added teh report parameters
• Trouble shooting Problems by using SQL server profiler
• Developed row level audit tables, stored procedures and triggers in SQL Server.
• Implemented and maintained database security.

Environment: MS SQL Server 2005, SSIS, T-SQL, VB.Net, Microsoft Excel, SSRS 2008

Confidential

SQL SERVER DEVELOPER

Responsibilities:

• Created technical, user documentation as per requirements
• Creation, manipulation and supporting teh SQL Server databases.
• Involved in teh Data modeling, Physical and Logical Design of Database
• Used T-SQL queries for teh retrieval of teh data.
• Tuning front-end applications like Visual Basic, which query teh SQL Server databases.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages
• Created DTSX Packages to import and export data from Excel Spreadsheets, People Soft, Text files and CSV files.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS).

Environment: MS SQL Server 2005, T-SQL, DTS, VB.Net, Microsoft Excel.