PROFESSIONAL SUMMARY

• Around 8+ years of experience in IT experience in Database Development of SQL Serverand Oracle and providing ETL/Business Intelligence solutions using Microsoft BI components (SSAS, SSIS, SSRS, Multi - Dimensional models, SQL Scripting, Tabular models, Power Pivot models) of SQL Server.
• Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL 2008/2012/2014/2016 .
• Expert in working with the Business Intelligence Development Studio (BIDS), which includes SSIS, SSAS and SSRS.
• Transformed data from various data sources using OLE DB / MS ACCESS connection by creating various DTS packages.
• Expertise in logical and physical data modeling using ERWIN.
• Experienced in Data Modeling logical modeling, Entity relationship diagram ERD development /normalization and physical database schema design using CA Erwin data modeler.
• Proficient in designing Data Mart and Data Warehouse using Star and Snowflake Schemas.
• Worked on SSAS (SQL ServerAnalysis Services) to build analytical cubes on Multi-Dimensional and Tabular Models and exposed data using Microsoft visual analytics tools like Excel Power Pivot and Power View and deployed power pivot models and reports on SharePoint Server.
• Expertise in creating Perspectives, Partitions, DesignAggregations, Cell Level Security in Cubesand Dashboard Reports to support end users using SSAS.
• Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS.
• Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Excellent experience in writing T SQL Queries using various objects like views, tables, Joins, Sub Queries, triggers, stored procedures, and other advanced SQL concepts.
• Excellent SQL tuning skills and ability to trouble shooting and recover data failures.
• Experience in Migrating and upgrading SQL Serverdatabases and SSIS packages into SQL Serverby In-place upgrade process and as well as side-by-side upgrade process.
• Expertise in Developing and Tuning T-SQL, Oracle PL/SQLComplex Queries, Stored Procedures, Packages, User Defined Functions, Triggers, Cursors, Views, Indexed Views and error handling techniques.
• Expertise in Creating and tuning the Indexes (clustered, Non-clustered, XML, Full text), table partitioning, troubleshooting blocking / dead locks for query optimization.
• Worked on SSIS (SQL ServerIntegration Services), DTS, BCP and Bulk inserts to Automate Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, SQL SERVER, Oracle and DB2), Data Migration, Maintenance and other ETL tasks.
• Extensively worked on SSIS to automate ETL Loads / Processes by using Control Flow items (for Loop, execute package, script task, send mail task, etc.,) and SSIS Data Flow items.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Skilled in SSIS error and event handling: precedence Constraints, Break Points, check points and applying different logging mechanisms.
• Experience in planning and implementing SQL Serversecurity Which Includes database permissions, schemas, roles, securable and principles.
• Experience in using SQL ServerProfiler, Dynamic Management Views, Performance Monitor, Database Engine Tuning Advisor and other monitoring tools.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Having good Experience in creating DAX queries to build formulas and expressions inMicrosoftSQL Server Analysis Services, Power Pivot in Excel, and Power BI Desktop.
• Experience in creating SSRS (SQL ServerReporting Services)likewise parameterized reports, linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS.
• Well versed in using multi-dimensional expression (MDX) queries, mathematical formulas, and user-defined functions for developing reports from Multi-Dimensional OLAP Cubes.
• Developed BIdata mapping andBI objects (dashboards, reports, analyses, visualizations, metrics, security) design documents using power BI.
• Working experience in a Scrum team as a Scrum Master to facilitate the communication between Product Owner and other Scrum team members as well as ensuring sprints were accomplished in a timely manner.

TECHNICAL SKILLS

RDMS/Databases: MSSQL Server 2008/2012/2014/2016 , Oracle 8i & 9i, Sybase, MS Access 97/2000/2003/2007 , MYSQL.

Programming Languages: T-SQL, PL/SQL, Dynamic SQL, C, DHTML, Shell Scripting, Visual Basic 6.0

Web Technologies: HTML5, CSS3, XML, JavaScript, AJAX, JSP.

Data Modeling: MS Visio, ERWIN 4.1, FACT & Dimensions tables, Physical & amp, Logical Data Modeling, Star Snowflake Schema Relational, Dimensional ad Multidimensional Modeling an De-Normalization Techniques, MS-Access

ETL-Tools: DTS, SQL Server Integration Services (SSIS). BI Tools: SQL, SQL Server Integration Services (SSIS 2005/2008/2012 ), SQL Server Reporting Services (SSRS 2005/2008/2012 ) SQL Server Analytical Services (SSAS 2005/2008/2012 ), Data Transformation Services (DTS), Visual Studio, BIDS.

Tools: /Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import Export Wizard, Visual Studio .Net, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Power BI, Visual Studio Team Foundation Server (TFS), ERWIN.

Application Packages: MS Office, Microsoft SharePoint Server (MOSS) 2007/2010/2013

PROFESSIONAL EXPERIENCE

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

Responsibilities:

• Involved in planning, defining and designing data based on business requirement and provided documentation for further reference. Involved in installation and configuration of MS SQL Server 2016.
• Involved in designing database and perform forward engineering, from conceptual data model to Logical and physical data model using Erwin 4.1.4 data modeler tool.
• Created new databases and objects such as tables, stored procedures, constraints, and indexes to maintain referential integrity of data.
• Worked in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSIS.
• Tested the ETL graphs and other ETL Processes (Data Warehouse Testing). Worked with ETL group for understanding Ab Initio graphs for dimensions and facts.
• Validated the ETL Scripts in the Target Database (MS SQL Server) for creating the cube before migrating it to Oracle.
• Used Team Foundation Server (TFS)to check in and check out the changes made to code.
• Involved Data modelling and Formalized Database design including creating Tables, Indexes, and Enforcing Data Integrity.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages. Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column etc.
• Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop).
• Modified the Existing SSIS Packages and added more audits and alerts in case of package failure.
• Developed unit test plans for SSIS packages. Modified the existing SSIS packages to meet the changes specified by the users. Scheduled jobs for executing the stored SSIS packages which were developed to update the database on Daily/Weekly/Monthly basis.
• Responsible for validation and deployment of SSIS packages from development to QA and production environment.
• Got a good knowledge on Team Foundation Server (TFS), in which we use to maintain databases up to date and we also use TFS for storage of updated scripts and to avoid the data loss.
• Designed, developed and deployed SSRS reports that include; parameterized reports, snapshot reports cached reports, drill down reports, drill through reports, linked reports, click-through reports, Sub-reports.
• Created and Deployed reports to Report Manager and Troubleshooting for any error occur in execution.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• 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.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Designed Power BIdata visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• UtilizedPower BI desktop to design real time dashboards and scorecards for analytical decision.
• Deployed reports andPowerBI dashboards on the reports/SharePoint server; scheduled deployments with subscriptions.
• Published reports and dashboards designed inPower BI utilizingPower BI services and shared it across through Microsoft Office 365.
• Fine-tuned SQL queries for maximum efficiency and performance. Provided documentation for all kinds of reports and SSIS packages.
• Developed aggregations and partitions in cubes as per business requirement.
• Identified and provided necessary steps to enhance the user response time by checking fragmentation and re-indexing tables for efficient application access and methods.
• Documented all processes and tasks of all databases, stored procedures, functions, views for future references and maintenance.

Environment: T SQL, SQL Server 2016, MSBI Tools, HTML5, CSS, JavaScript, .Net, Special Software Visual Studio, Team Foundation Server, Power BI, SQL Server Management Studio, SQL Profiler, SSDT 2016, Microsoft Azure.

Confidential, Forthworth, TX

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

Responsibilities:

• Database development experience with Microsoft SQL Server in OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation and Loading).
• Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different kinds of transformations like lookup transformations, merge joins, fuzzy look-ups, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.
• Created and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Maintain and optimize the existing databases; monitor database performance and growth, performance tuning, generate reports according to the business requirements using SQL Server Reporting Service (SSRS) and populate data warehouse using SQL Server Integration Service (SSIS).
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server.
• Developed packages using various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Designed, developed and deployed SSRS reports that include; parameterized reports, snapshot reports cached reports, drill down reports, drill through reports, linked reports, click-through reports, Sub-reports.
• Created and Deployed reports to Report Manager and Troubleshooting for any error occur in execution.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Generated daily, weekly and monthly reports for the managers.
• Write Stored Procedures to populate various dimensional tables and the fact tables for the Data Warehouse.

Environment: MS SQL Server 2014, Business Intelligence Development studio (SSRS/ SSAS/SSIS), Oracle 11g/10g/9i, MS Office Access 2012 and Visual Studio 2012, .Net 3.5, TFS2010.

Confidential, Columbus, OH

SQL / BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
• Installing, Configuring and Administering SQL server 2012.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Responsible for creating the reports based on the requirements using SSRS tool.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Thorough Software Development life cycle (SDLC) experience including development, designing, analysis, coding, testing and implementation. (Agile/Scrum, Waterfall)
• Created SSIS process design and architected the flow of data from various sources to target.
• Developed BI/SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Used multiple join statements to retrieve data from multiple tables.
• Continuously interacted with users to gather business requirements.
• Wrote parameterized queries for generating reports in SSRS.
• Converted Logical Database Diagram into Physical Schema using the balanced Normalization in 2nd and 3rd Normal Form.
• Successfully migrated a huge amount of data from heterogeneous source using BCP and Dynamic DTS Packages.
• Improved Data qualities in order to ensure the quality and accuracy of the master data by using business rules which will automatically update data, send email, start workflow validation, and Audit records which prevent from making changes, lock down models and also by sending notifications.
• Done research and suggested new methods to further enhance performance, compatibility.
• Developed third party Advanced reporting components for the storage, retrieval and querying of a database across multiple servers. Also served as the administrator of SQL client/server for applications.

Environment: SQL Server 2012, T-SQL, Data Transformation Services (DTS), Advanced Reporting Services (SSRS), Integration Services (SSIS), BCP, SQL Profiler, SSDT 2012.

Confidential, Des Moines, IA

Responsibilities:

• Created and updated database objects like Complex stored procedures, joins, tables, User Defined functions (UDF's) for business logic.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Transformed the data using different SSIS transformations like Aggregate, split, join, merge, derived column, Multicast, term extraction and data conversion of SQL Server Integration Services (SSIS).
• Created logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS.
• Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.
• Used Script task for Data Flow and Error Handling in SSIS.
• Responsible for ongoing maintenance and change management to existing reports and optimizer port performance in SSRS-2012.
• Used Reporting objects like Tabular, Matrix, Sub Reports, and Parameterized reports using SSRS.
• Designed and developed monthly, Bi - Weekly, Tax Reports for our Clients
• Extensively worked in migrating office writer reports to SSRS-2012.
• Participated in Databases Architecture and data modeling design.
• Interacted with the Business Admin and gather the requirements and analyzed them.

Environment: Microsoft SQL Server 2012 R2, T-SQL, SSIS, SSRS, Visual Source Safe, MS Excel, Performance Point Server 2007.

Confidential, Atlanta, GA

MS-SQL/BI Developer

Responsibilities:

• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• Involved in SQL Server 2008 reporting services to deliver automatically generated reports.
• Converted existing Excel reports into SSRS Reports.
• Creating Reports as per user requirements using MS Reporting Services 2005/2008
• Designed various reports using different reporting features such as group by, drilldowns, drill through etc.
• Created parameters (multivalued, 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.
• Experience in using T-SQL for creating stored procedures, indexes, cursors and function.
• Using SQL to create stored procedures to get the needed data from transactional server in to data ware house.
• Transformed the complex business logic and calculations into coding
• Creating SSIS Packages to get data from client data XL sheets to transactional server.
• Worked on applications that relied on ODBC connectivity to encompass data access from a wide range of database objects and granting permissions.
• Designed and created tables, Queries in Access database.
• Leading Business sign off meeting to confirm the pre UAT and Testing stage.

Environment: Microsoft SQL Server 2008 Enterprise Edition, Microsoft Visual Basic 6.5, Access, SQL LiteSpeed, OLAP, SSRS and SSIS.

Confidential

SQL Server Developer

Responsibilities:

• Installation and maintenance of SQL Server installations.
• Configuring and monitoring Log Shipping for few databases in the enterprise.
• Configuring and maintaining multiple replications for reporting.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Created DTS packages to export and import data from SQL Server to Access, text files and Excel files.
• Involved in creating Stored Procedures, views, tables, constrains.
• Involved in logical & physical design, development and testing of the system
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Developed automated backup and DBCC scripts for databases and transaction logs.
• Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, tables, and views, Developed complex T-SQL code for the application
• Developed and coded applications in T-SQL. Debugged and fixed the bugs. Performed database and SQL tuning by using various tools and techniques, like Tuning Advisors
• Involved in logical & physical design, development and testing of the system
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Dropped and recreated the indexes on tables for performance improvements.
• All regular SQL DBA tasks.

Environment: SQL Server 2008 Enterprise, Windows Enterprise Server 2005, Microsoft Visio 2008, Microsoft Reporting Service, Excel, Crystal reports, SQL Enterprise Manager.

Confidential

SQL Server Developer

Responsibilities:

• Coded the T-SQL stored procedures for the enhancements.
• Tuning and optimization of the stored procedures.
• Created databases, tables, relationships, constraints. Wrote T-SQL Queries, views, Stored Procedures for the interaction of transferring data to and from screens to the backend, at optimum performance.
• Enhancement involved implementation of SQL Server with the usage of T-SQL Stored Procedures, SQL Execution Statistics / Plans, Optimizer and SQL Profiler for back end.
• Planning & organizing the work structure, configuration, risk and delivery management.
• Administered various applications like Maintenance Management and Financial Account System.
• Maintained the client's policies and customer databases and tuning of the database instances.
• Worked with all database objects, including tables, clusters, indexes, views, and procedures.
• Troubleshoot problems concerned with the databases, applications, and development tools.
• Created new databases for users as required. Checking the alert logs daily for oracle errors.
• Tuning of I/O to reduce disk contention by distributing I/O.
• Data modeling, normalization, de-normalization, physical database design, and relational models.
• Creating and maintaining roles and profiles for security and limited access of data. Design and implementation of Backup & Recovery strategies.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Creation of logins and user ids and setting up privileges and procedures for protection of data. Designed screens and reports layout.

Environment: T-SQL, MSSQL Server 2005, Visual Studio 2005, Windows 2005, Business Intelligence Development Studio (BIDS), VB, C#, Office 2007, MS Access, MS Excel.