PROFESSIONAL SUMMARY:

• Around 6+ years of Experience in SQL/MSBI DEVLOPER.
• Experience in writing complex SQL queries, procedures, functions, packages, cursors, exception handling, triggers, collections and performance tuning.
• Extensive experience in Design, Development, Implementation & Administration of Database systems using MSSQL 2005/2008/2012/2014 for Batch Processing using DDL, DML, DCL commands for various business applications and Data warehousing Systems (SSRS, SSIS, SSAS)
• Managed entire project lifecycle - requirements gathering through implementation including: preparing the functional, scope, mapping documents and high level and low level design specification documents, Dimensional Data Modeling (Logical and Physical).
• Expertise in deploying Materialized Views, indexing and partitioning techniques for highly responsive Decision Support Systems.
• Expert in Designing Dimensional Modeling (Star Schemas, Snow flake schema) and Operational Data store (ODS) in Data Warehouse design.
• Expertise in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using SSIS.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in TOAD v9.5 for developing and managing PL/SQL scripts
• Hands on Programming skills in SQL, PL/SQL, Stored procedures, packages, functions, triggers. Managed all upgrades, maintenance, and support of the Business
• Creating SSIS packages and executing stored procedures, to load the files into destination tables and sending email notifications.
• Creating dashboards in PowerBI
• Expertise in deploying OLAP tools, Materialized Views, indexing and partitioning techniques for highly responsive Decision Support Systems.
• Documenting the types and structure of the business data (logical modeling),
• Analyzing and mining business data to identify patterns and correlations among the various data points
• Verify that both source and destination servers are running the most current service packs that are available for their operating systems once the migration is completed.
• Mapping and tracing data from system to system in order to solve a given business or system problem
• Worked on TFS environment.
• Having Experience in Migration from Sql server .
• Expert in Designing Dimensional Modeling (Star Schemas, Snow flake schema) and Operational Data store (ODS) in Data Warehouse design.
• Design and create data reports and reporting tools to help business executives in their decision making,
• Perform statistical analysis of business data.
• Part of the migration team to validated the packages and update as per new version of the SQL server
• Worked on Salesforce wave analytics on creating the different types of reports.
• Have extensive knowledge on Ralph Kimball’s and Bill Inmon’s modelling concepts and
• Created tabular and matrix reports in SSRS. Wrote stored procedures and functions to create SSRS report
• Involved in the creation and deployment of the reports using SSRS and configuring the SQL Server Reporting Server
• Experience in database programming in writing T-SQL Stored procedures, Triggers, Contraints (Primary Key, Foreign Key, and Unique) Indexes and Batch Scripts using various DDL and DML commands.
• Used integration services (SSIS) to extract data in to the tables from Salesforce
• Worked on Insurance projects in health care industry, Medical Claims Experience.
• Develop tabular model cubes and write DAX queries.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions, and data source view
• Hands-on Experience with different types of Normal forms (1NF,2NF and 3NF)
• Experience in developing SSIS packages to bring data from Insurance Claims databases to data warehouse tables.
• Knowledge of SSIS Including Data flow component, control flow component, SSIS Logging, SSIS Configuration, SSIS Security. SSIS Error handling
• Knowledge in SQL Server database including SQL Queries, joins, functions, trigger, store procedure.
• Have Working knowledge on HCM
• Built DAX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Experience in creating Jobs, and Sending Alerts using SQL Mail, backups, performance issues, connectivity to databases, upgrade strategies, capacity planning.
• Experience in migrating DTS packages, reports and analysis services projects from SQL Server 2005 to SQL server 2008R2, 2012 and 2014.
• Involved in Huge Data Migrations and Data Transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert
• Good knowledge in Tuning SQL queries & improving the performance of the Database.
• Analysis and performs data profiling to create logical and physical models according the data modeling standards and deploy it in OLTP and OLAP databases as part of various new and existing projects.
• Strong complex reporting skills - complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports.
• Experience in writing expressions in SSRS and Expert in fine-tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012/2014 )
• Expert in creating Parameterized Reports.
• Experience in deploying Reports to Report Server . Creating user interface on Report Server for the users to access reports on Report Manager.
• Hands on experience in Creating Star Schema and Snow Flake Schemas.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Have working knowledge on sales force wave analytics
• Sound knowledge of software development life cycle (SDLC) with substantial experience with object-oriented analysis and design methodologies.
• Good understanding of Data Marts, Data Warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Create Users and assign permissions based on the level of database access the user would need.
• Created SSIS packages to load data from Teradata to Sql server.
• Monitor and improve performance of the ETL applications such as Data Stage and SSIS.
• Check for the failed jobs, investigate the route cause and resolve the issue. Native SQL notification alert sends a mail to DBA team and also we can design a customized SSRS report which reports all failed/success job details with delta value.
• Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS:

Databases: MS SQL Server 2005/2008r2/2012/2014

Database Tools: Enterprise Manager, Query Analyzer, SQL Server Management Studio (SSMS), SQL Profiler, Upgrade Wizard, Database Engine Tuning Advisor, Business Intelligence Development Studio (BIDS). Oracle, HBase

Reporting Tools: SQL Server Reporting Services (SSRS) 2012/2008/2005 , SAP BW, Tableau, Business Objects 4.1, Salesforce Wave analytics, Power Bi

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), BCP, SQL Server Analysis Services (SSAS), ABINITIO, Informatica

Languages: C, C++, C#, T-SQL

Web Technologies: Web Services, XML, HTML

Operating System: Windows 98 /2003/NT/XP/7, MS DOS

Applications: MS Visual Studio 2010, MS office 2003/2007/2010 , HTML/DHTML, XML, Visual Studio IDE,HP ALM

Protocols: HTTP, TCP/IP, FTP

PROFESSIONAL EXPERIENCE:

Confidential, FL

MSBI Developer/T-SQL Developer

Responsibilities:

• Designed SSIS packages to transfer the data from DB2, flat files and excel documents to the Staging Area in SQL Server 2012 and 2014.
• Used SQL Server Destination in Data flow to improve a great performance changes in Replications. (Admin rights for this operation).
• Have good Knowledge on writing MDX queries and the MDX datatypes.
• Mentored the team of 3 on the daily basis for the development activities.
• Used various Data Flow Transformations, like Derived Column, Data Conversion, Union All, Multicast and Copy Column while developing the packages.
• Used Event Handlers for Error Handling and Alert Operations.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Design Cubes and hierarchies in SSAS.
• Having Experience in Migration from Sql server .
• Creating reports in PowerBI.
• Involved in designing, deploying and processing OLAP Cubes using SSAS for the analysis of data with pre-calculated aggregations and in summarized fashion which can be modeled into a report accordingly.
• Expertise in creating Cubes with dimensions and Facts Tables in MOLAP Warehouse using SQL
• Server Analysis Services (SSAS).
• Expertise in deploying OLAP tools, Materialized Views, indexing and partitioning techniques for highly responsive Decision Support Systems.
• Expert in Designing Dimensional Modeling (Star Schemas, Snow flake schema) and Operational Data store (ODS) in Data Warehouse design.
• Hands on Programming skills in SQL, PL/SQL, Stored procedures, packages, functions, triggers.Managed all upgrades, maintenance, and support of the Business Objects System and Expertise in Migrating the Business objects from 5.1.x/6.1a/6.1b/6.1.5/XI r2 to XI 3.1.
• Good working experience in Business Objects, Supervisor, Designer, Broadcast Agent (BCA), ZABO, Web Intelligence and Business Objects SDK.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon.
• Created reports including dynamic calculations involving Contexts, Queries, Hierarchies, list of values (LOVS), local variables, Alerters, Ranking and multiple data providers.
• Diversified experience in implementation of Crystal Enterprise with multiple domains.
• Having hands on experience in BI 4.1 on both SAP and Non SAP Systems.
• Built DAX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Developing reports in power BI
• Documenting the types and structure of the business data (logical modeling),
• Analyzing and mining business data to identify patterns and correlations among the various data points,
• Mapping and tracing data from system to system in order to solve a given business or system problem,
• Design and create data reports and reporting tools to help business executives in their decision making,
• Perform statistical analysis of business data.
• Scheduled Packages using SQL Server Agent Jobs, Monitoring nightly jobs.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Have extensive knowledge on Ralph Kimball’s and Bill Inmon’s modelling concepts and
• Check for the failed jobs, investigate the route cause and resolve the issue. Native SQL
• Documenting major changes to the SQL Servers.
• Created SSIS packages to load data from Teradata to Sql server.
• From time to time recover the databases to a specific point of time, as per the requests
• Mentored the team of 3 on the daily basis for the development activities.
• Involved in high level architectural design discussions for designing the MDF(meta data framework) tables which store the business and supplier data.
• Part of the migration team to validated the packages and update as per new version of the SQL server
• Having Experience in Migration of Sql server .
• Used T-SQL queries to insert the complete file information and layout to MDF tables.
• Created Multiple SSIS packages for Big Data (Hadoop to Teradata to sql)
• Data loading using SSIS into different DW like Netezza.
• Designed SSIS Package to check the row count of the source and target tables of oracle source.
• Worked on SSIS Packages to load data from different source to target sql database using SQL 2008, Sql 2012 and 2014
• Have written MDX queries on Cubes
• Experience in writing expressions in SSRS and Expert in fine-tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012/2014 )
• Expert in creating Parameterized Reports.
• Hands-on Experience with different types of Normal forms(1NF,2NF and 3NF)
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.

Environment: T-SQL, MS SQL Server 2008R2/2008 and 2012 and 2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP,Power BI

Confidential, MN

MSBI Developer

Responsibilities:

• Designed SSIS packages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2012 and 2014.
• Written stored procedures and used them in packages.
• Create Users and assign permissions based on the level of database access the user would need.
• Created XML configuration files to dynamically alter package properties.
• Documenting the types and structure of the business data (logical modeling),
• Analyzing and mining business data to identify patterns and correlations among the various data points,
• Mapping and tracing data from system to system in order to solve a given business or system problem,
• Design and create data reports and reporting tools to help business executives in their decision making,
• Perform statistical analysis of business data.
• Have Knowledge on HIPAA rules. And other Medicare plans.
• Working in an agile environment. along with scrum master with team of 8
• Migrated data from SQL Server .
• Analysis and performs data profiling to create logical and physical models according the data modeling standards and deploy it in OLTP and OLAP databases as part of various new and existing projects.
• Created various reports with functionalities like Cross tab, Embedded Summary, Calculate member of, Charts, Graphs, and sub reports.
• Worked with several features like Query Stripping, Input Controls, Sub Query, Scope of Analysis and Drill functionality.
• Monitor and improve performance of the ETL applications such as Data Stage and SSIS.
• Developed Complex Universes by linking different data sources.
• Create Aliases and Contexts for resolving Loops and check the Integrity of the Universe.
• Fine-tuned universes and reports by creating aggregate tables and filters.
• Configured BW Publisher service for Crystal reports migration.
• Generated various Drill down reports and Alerts. Business Intelligence reports using Web Intelligence module.
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments
• Data capture from various source.
• Worked on MS access databases, extracting the data form Access.
• Worked on Writing VBA on MS Access to enhance reports and macros
• Experience in deploying Reports to Report Server . Creating user interface on Report Server for the users to access reports on Report Manager.
• Have good Knowledge on writing MDX queries and the MDX datatypes.
• Worked on for each loop containers, sequence containers.
• Generate reports using tableau.
• Used various tasks like Execute SQL task which calls stored procedures and takes parameters, Script component task for reading the file and removing trailer records.
• Created source, stage and archive folders as per the requirements using expressions in file system task.

Environment: T-SQL, MS SQL Server 2012/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SCRUM Business Intelligence Development Studio (BIDS),Team foundation Server(TFS), SharePoint, MS Excel,Hadoop,Teradata, Windows 2008 R2, Microsoft windows server 2016,MS Access.

Confidential

Database Developer

Responsibilities:

• Created/reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Coded Stored Procedures, functions and triggers at high level.
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Participated in User Acceptance Testing for different modules.
• Implementing user and providing technical support.
• Prepared proper backup and recovery plans.
• DBA activities like creating users, roles and granting and revoking privileges.
• Merging data into a single server for achieving better control, consistency & security of data.
• Designed the Logical and Physical design of database for projects on basis of user requirements.

Environment: MS SQL Server 2005, T-SQL, SQL Windows Server 2003, and MS Access and Excel.