SUMMARY

• Over 5 years of IT experience as a MS SQL Server 2005/2008/2008 R2/2012/2016 Developer and Business Intelligence with main focus on T - SQL, SSIS, SSRS and understanding of SSAS.
• Extensive programming experience as Database & Report Developer in Microsoft SQL Server 2005/2008/2012 using T-SQL and Business Intelligence Data Tools and various platforms.
• Good experience in Design, Development, Implementation and Testing of Database systems using MS SQL Server 2005/2008/2012 DDL, DML, DRL and DCL commands for various Data Warehouse and business applications.
• Experience in writing Complex T-SQL Queries, Dynamic Queries, Sub-queries, Complex Joins.
• Extensive experience in Database design using SQL, T-SQL in Stored Procedures, Views, Functions, Constraints (Primary Key, Foreign Key), Triggers, Indexes and Batch Scripts.
• Experience Using Version Controllers like GIT,TFS (Team Foundation Server)
• Scheduled Jobs Using Control-M and prepared IRD documents for the Jobs.
• Applied BIxPress Auditing Framework to monitor SSIS Packages.
• Experience in buildingDataIntegration,Workflow Solutions and Extract, Transform and Load (ETL) solutions fordatawarehousing usingSQLServerIntegration Service(SSIS).
• Good knowledge in Data Warehousing methodologies and ETL Process.
• Expertise in Power Bi, Power BI pro, Power BI Mobile
• Developed Power BI model used for financial reporting of P & L and Headcount.
• Designed and documented the entire Architecture of Power bi Poc
• Expertise in writing complex DAX functions in Power BI and Power Pivot
• Expert in Extraction, Transformation, and Loading (ETL) data from various data sources using SSIS. Created packages to extract data from Oracle, Flat file and load into MSSQL.
• Have got exposure on various database tools like Oracle SQL Developer etc.
• In SSIS I have worked with Lookups, Fuzzy Lookup, Web Services, and Container and used that in Reporting Service (SSRS).
• Developed POC’s in Java/Javascript.
• Maintenance for internal webportals developed in Java/JSP
• Expertise working under Agile SDLC using Scrum Methodology
• Developed Dashboard, Ad-hoc and parameterized reports, creating complex reports(ex:Drill Down reports using different objects) using SSRS reports
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations that are available in Power bi query editor
• Used SSRS and created Table Report, adding calculated Values, Adding Sub report to Parent Report, Reports with Interactive Navigation, and Display data in Various Formats.
• Created reports that TEMPhas been defined by Business Objects and generated Crystal reports.
• Expertise with job scheduling using SQL Server Agent to perform updates on completion of jobs inserted.
• Build, Deployed and Published the Reports to Report Manager Website. Have worked with XML and Web Services.
• Strong ability to share knowledge with others and collaborate as part of a team to achieve positive outcomes with good communication skills.

TECHNICAL SKILLS

Databases: Microsoft SQL Server 2005/2008/2008 r2/2012/2016

Languages: T-SQL, PL SQL

Tools: Microsoft SQL Server Management Studio, SQL Server Data Tools, SQL Server Business Intelligence Development Studio, Microsoft Visual Studio Control-M, Bi-Express, Team Foundation Server.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Report Manager, Report Builder, MS Excel.

PROFESSIONAL EXPERIENCE

Confidential, Birmingham, AL

MSBI Developer

Responsibilities:

• Developed SSIS packages fordataintegrationfrom manydatasources such as Flat file, Oracle, Access orSQLServer 2012 intoSQLServer and deployed them using configuration tools.
• Developed and implemented SSIS ETL process to load data from source tables to target tables.
• Created highly complex SSIS packages using variousDatatransformations such as conditional splitting, Lookup, derived column, Fuzzy Lookup, For Each Loop, Multi Cast, Merge.
• Used CDC (Change Data capture) tasks for incremental load.
• Added Dataflow tasks and Execute SQL Tasks to the existing packages and promoted them to the Model and Prod Environments.
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.
• Experience writing complex DAX functions in Power BI and Power Pivot
• Wrote calculated columns, measures in PowerBI desktop to show good data analysis techniques.
• Created duplicate tables and loaded data from source to destination tables using SSIS packages.
• Used Team Foundation Server (version Controller) for check In and Check out the code.
• Promoted SSIS packages From Dev to Model and Model to Prod environments in TFS.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Designed and implemented parameterized and cascading parameterized reports using SSRS.
• Added Expressions to the reports to get the current day and added calculated fields.
• Database Creation DDL,DML, database tuning, SQL tuning, Performance planning.
• Used Joins and Sub-Queries to simplify complex queries involving multiple tables
• Managed Indexes, Statistics and optimized queries by using execution plan for tuning the database.
• Scheduled Jobs Using Control-M and prepared IRD documents for the Jobs.
• Developed POC’s in Java/Javascript.
• Maintenance for internal webportals developed in Java/JSP
• Worked under Agile SDLC using Scrum Methodology.
• Applied Bi-xPress to Monitor SSIS Packages.
• Extensive understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Added Aggregate column in the view and processed the cube.
• Used TOAD, Oracle SQL Developer tool for faster application design and developments.
• Apply SSAS to deploy cubes with fact tables and dimensions tables. Upload and share cube information into Share Pointintegrationas well as output the cube into Excel using Power Pivot.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Share point.
• Used Service Now to raise the requests for approvals to deploy the code to different environments.
• Deployed designed dashboards & reports on MS SharePoint site using Performance Point Server Dashboard Viewer Web Part for web based to access for multiple end users.
• Performed daily tasks including backup and restore by using tools likeSQLServer Management Studio,SQLServer Profiler,SQLServer Agent, and Database Engine Tuning Advisor.

Environment: MSSQLServer 2012,SQLServer Reporting Service (SSRS),SQLServerIntegration Service (SSIS),SQLServer Analysis Services (SSAS), C#, ASP.NET, Visual Studio 2010 & T-SQL

Confidential, Dallas, TX

SQL Server/SSRS/SSIS Developer

Responsibilities:

• Involved in new BANNER DB design and created ETL using SSIS from legacy systems.
• Designed ETL sync bridges for Staff, Building and Department data using T-SQL and SSIS for supporting internal applications.
• Created and modified already existing stored procedures, triggers, views and indexes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Tested queries to optimize the procedures and triggers to be used in production.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Extensive experience in using SSIS transformations like Lookup, Data conversion, Aggregate, condition split.
• Hands on experience with Variable, Script Task and Execute SQL Task in SSIS using VB Script and T SQL.
• Responsible for optimizing allindexes,SQL queries,stored proceduresto improve the quality of software.
• Experience in counters, error handling, and event handlers, re-running failed SSIS packages using check points and scripting with Active-X and VB.Net in SSIS.
• Migrated the Existing DTS packages to the SSIS Batch jobs and enhanced the packages with monitoring features so that audit information of the packages and their execution results are loaded in to the audit table.
• Created SSIS Packages and used OLEDB Source as an existing Oracle Database.
• Involved in Performance tuning and Query Optimization.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Used execution plan, SQL profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of the database.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Created and managed the databases in development environment.

Environment: MS SQL Server 2010/2012/2016 , SSIS, SSRS, Unix, Microsoft Visual Studio 2010, VB.Net, ASP.NET, MS Access, MS Excel, Adobe Photoshop, IIS 6.0, Crystal Reports, XML, DTD, Microsoft Visio, Oracle 9i/10g.

Confidential, San Roman, CA

SQL Developer (SSRS, SSIS)

Responsibilities:

• Created new tables, views, indexes, stored procedures and user defined functions.
• Optimized query performance by creating indexes.
• Created users and roles and assigned permissions to them.
• Worked on DTS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Used Profiler for studying the performance problems and tuned them accordingly.
• Performed daily database backup & restoration of Database Server.
• Developed complex stored procedures to create various reports by using SQL server reporting service 2000.

Environment: Microsoft SQL Server 2008/2012 SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Report Manager, T-SQL.

Confidential, San Francisco, CA

OraclePL/SQL Developer

Responsibilities:

• Involved in the analysis, design, and development and testing phases of Software Development Life Cycle (SDLC).Managed and resolved design issues during deployment.
• Maintains the Information Systems Development Methodology (ISDM) document. Coordinates with system project administrators to promote integration, consistency, and quality. Reviews applications and deliverables to ensure compliance with the ISDM.
• Gathered the requirements from the data analysts and architects and performed technical analysis to reach a viable solution.Involved in tuning and optimization ofSQLstatements.
• Built complex queries usingSQLand wrote stored procedures &packages usingPL/SQL.
• Using OracleSQLDeveloperData Modeler create and edit logical, relational, physical, multi-dimensional and data type models. GeneratedDDLfrom data models using ODI.
• Worked withMicrosoftAccess, andSQLServer … to write functions, procedures and views to meet the user's requirements.
• Advanced execution in MS EXCEL, EXCEL macros, MS access,VBAscripting, MySQL, SSIS, SSRS, SSAS, OLAP, Reporting and Analytics, Oracle 9i, Oracle 8i,PL/SQL(Stored Procedures), T-SQL.
• WrotePL/SQLStored Procedures, Functions, and Packages to implement Business Rules.
• Designed and developedPL/SQLfunctions/ stored procedures/ cursors/ triggers/ packages.
• Involved in day-to-day duties of DBA work like taking backup and recovery of database environment.Worked with production support team in resolving production issues.
• DevelopedPL/SQLETL scripts to transfer data across the schemas and databases.
• Involved in development and scheduled jobs using Autosys for automation.
• Maintain (Add/Delete/Modify) Jobs based on business requirement using AutoSys.

Environment: ORACLE 11g/ 10g,SQL*Plus,PL/SQL,SQL*Loader, VBA, Autosys, Microsoft Access, TOAD,SQLDeveloper, UNIX, MS Visio, Windows XP/ 7.