SUMMARY:

• Result driven, Microsoft SQL Business Intelligence developer with working track of 7+ years. Who expertise in using SQL Server to create, maintain, analyze databases through SQL Server Analysis Services (SSAS), to generate reports through SQL Server Reporting Services (SSRS) and to process ETL operations through SQL Server Integration Services (SSIS).
• Outstanding in database designing, development and technical management using Microsoft SQL Server (2008/8R 2/10/12/14/16/17.1 ), Oracle client, ETL tools…
• Create analytical or ad - hoc reports using SSRS, SSAS, Power BI and Tableau.
• Excellent in written and verbal communication skills with capability to effectively identify functional requirements, analyze and implement client needs throughout the entire Software Development Lifecycle (SDLC), with on time and within budget delivery of high quality client solution and decision support services.
• 7+ Years of working experience in Microsoft Business Intelligence Suits (BIDS) SQL Server Integration services (SSIS), SQL Server Analysis services (SSAS) and Reporting using SQL Server Reporting services (SSRS)
• 7+ Years of High experience in designing, developing, maintaining and testing Reports using SSRS BI tools, report server.
• 7+ Years of Experience in Writing/Developing T - SQL queries, Store procedures, Function, Triggers, user defined Functions, views and indexes, exception handling using RDBMS, T-SQL, ORACLE Client, SQL developer, SQL Plus, performance tuning
• 6+ Years of excellent knowledge in collecting data and developing ETL processes, packages, configuring SQL Server Integration Services (SSIS)
• 6+ Years of Experience in design and implementation of On-Line Transactional Processing (OLTP), Data Warehouse and On-Line Analytical Processing (OLAP)
• 4+ Years of Experience in developing Dashboards and Scorecards using Microsoft Share Point 2010
• 6+ Years of Experience in creating Pivot Tables and Excel Charts from different data sources like MS SQL Server, MS Access, cubes using MS SQL Server Analysis Services
• 6+ year of Analytical Reports development experience using MS SQL Server Reporting Services (SSRS)\Tableau
• 6+ years of experience in LDM, PDM data modeling using Erwin and Enterprise Architecture
• Optimization of Queries, Stored Procedure and tested application for better performance, data integrity using SQL profiler along SQL Query Analyzer
• 5+ Years of Installation Configuration and update of SQL Server Management Studio
• 4+ Years of experience in XML, HTML, CSS
• Experienced in Power BI and SharePoint 2010, Performance Point, ASP.Net framework
• Agile/Scrum methodology using version control of TFS/VS
• Capability to familiarize quickly to new technologies with the Ability to manage multiple priorities, and assess and adjust quickly to changing priorities
• Excellent ability to work in a team environment, strong communication skills, and a positive attitude with Clients, stakeholders including senior leadership.

COMPUTER SKILLS:

Database: MS SQL Server 2008/08R2/10/12/14, SQL Reporting services (SSRS), SQL Analysis services (SSAS), SQL Integration Services(SSIS), Microsoft Visual studio 2008/10/12/13/15 Oracle 11g, SQL Developer, SQL Plus, T-SQL, PL-SQL, Team Foundation Server TFS/VSS, Enterprise Architecture V9.3, MS SQL profiler, SQL Query Analyzer, MS SQL Server Index Tuning, Erwin Data Modeler 7.1/5/4,VB6, MS SharePoint, Microsoft products MS Access, MS Excel, HTML, XML, C++, C#, ASP.Net, Notepad++

PROFFESSIONAL HISTORY:

Confidential, Washington, DC

Reports Developer

Responsibilities:

• Worked on DCPS Database/Student database
• SSRS reporting, power BI and Tableau analytical reporting
• SharePoint on cloud Office 365
• Data warehousing, data modeling
• Creating and maintaining Certica ETL Solution Rules
• Creating and converting DRT
• Creating jobs in Veera for reporting student data
• Working on Aspen Database
• SSIS ETL processes

Confidential, Washington, DC

Sr, BI (SSRS, SSIS, SSAS), SQL Developer

Responsibilities:

• Implemented PDM and LDM for Relational Database management system
• Wrote complex T - SQL Script (Join, Stored Procedures, Functions, and Triggers )
• Created SSIS packages for redirection, merging, standardization of the Global Single financial System to improve efficiency and remove duplication and redundancy in and marketing financial system process
• Created and managed ETL Package processes predominantly SSIS and IntApp
• SSIS Package Configuration, variables for different environment deployment
• Implemented Global analytics using SSRS and Tableau reporting
• Generated reports and dashboards leveraging SSRS reporting against relational databases as well as cubes (Parameterized, Drill Through, Cascading dashboard).
• Created, deployed and maintained new reports using SSRS and a third party report writing tool (3E reporting).
• Set up Report subscriptions (Data driven, Role base security) in Report manager
• Provided project support for reporting development as new processes are designed, written, tested and implemented.
• Evaluated and developed Self Service BI reports and dashboards using Power BI and similar.
• Code, Unit, and System test changes for the reporting solution domain; Develop/optimize SQL queries.
• Facilitate User Acceptance testing of all changes for the reporting solution domain.
• Customer relation skill with the ability to gather reporting requirements and present solutions to business users in a collaborative manner.
• Evaluate SQL Server 2016 Analytic functionality, documenting and providing recommendations to peers and management regarding same.

Confidential

Sr, BI (SSIS, SSRS, SSAS), ETL Developer

Responsibilities:

• Design and Develop Requirement Analysis for business Change requests by interaction with clients, stake holders, and preparing technical documentation
• Created technical documentation using use - case diagrams, Class diagrams, and sequence diagram, Activity diagram using Enterprise Architecture and ER win.
• Created LDM, PDM using Erwin Studio data Modeler
• Developed T-SQL Queries, Packages, Stored Procedures, Functions, Trigger using Oracle, T-SQL, SQL Developer
• Developed automation of SSRS Reports to provide Annual, monthly, weekly and on demand reports to clients.
• Uploading new Reports and maintaining existing on Report servers and shared locations using Visual studio
• ETL Processing SSIS Event Handlers, Logging, Containers, Deploying Packages to SQL Server
• Developed ETL data from different Data sources with target destination of SQL Server 2014 using SSIS ETL Packages.
• Developed and maintained ETL Processes/Packages along different environment.
• Generated dynamic, Reports that run on OLTP and OLAP databases used by Confidential
• Involved in all Software Development Lifecycle (SDLC) activities in requirement gathering, designing, writing Scripts, Unit Testing, Deployment and Maintenance
• Involved in developing, documentation and validation of batch jobs using .Net
• Worked on the Migration of SQL Server 2008 to SQL Server 2014 Performance optimization
• Review requirement and conduct impact analysis, test cases and unit test code, user acceptance test
• Agile/Scrum methodology using version control of TFS/VS

Environment: SQL Server 2008/10/2014 , Oracle 11g, SQL Plus, SQL SSRS, SSAS, SSIS, Enterprise Architecture, Visual Studio 2010/12/14, TFS, .Net, Xml, SQL BI Suits, Notepad++

Confidential, Washington, DC

MS SQL Server/SSRS/SSAS/SSIS Developer

Responsibilities:

• Migrate Legacy application/DB to MS SQL Server 2012 using SSIS.
• Going through the clients requirement coming up with Database solutions design and application architecture. Plan capacity specification requirement for new Database server using (SSAS).
• Created variety of reports using SSRS including matrix report, parameter report, dashboard, charts, drill - down, drill- through, cascade parameterized report, configured report server and deployed reports on the web server with SharePoint.
• Generated daily, weekly, monthly and Dashboard reports for analysis purposes and also created report models for ad hoc reports when the end user wants to see the reports on fly using Report Builder.
• Designed and implemented indexing to optimize transactional and reporting performance
• Developed Logical and physical data model using ERWIN and mapped the data into Database objects.
• Wrote T-SQL scripts, store procedures, User defined functions, views to extract data.
• Designed and Created different .DTSX packages to SQL Server 2008 source to SQL Server 2012 as destination to import and export data from Flat files, Text files, Excel spreadsheets. Using transformations such as data conversion, fuzzy look-up, conditional split, derived column transformation...
• Implemented data Integration processes to handle XML files generation or processing.
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS.

Confidential, Richmond, VA

ETL/SSIS/SSAS Developer

Responsibilities:

• Developed and designed various forms of Reports (Drill down, Drill through, parameterized, cascade parameterized) using SSRS.
• Designed and developed snowflakes and star schema data models with facts, dimensions, measure and cubes, also established data granularity using SSAS.
• Developed a dimensional database and OLAP cube using SSAS for analysis
• Scheduled Jobs, Alert, and Subscriptions using SQL Job Agent in SQL SSMS 2010.
• Design KPI, Scorecard and Dashboard reports Using PerformancePoint in Share Point.
• Developed mapping databases for (ETL) team with source to target data mapping with physical naming standards, data types, domain definitions, and corporate meta - data definitions.
• Developed SSIS packages to Extract, Transform and load data to Data warehouse with different control flow and data flow transformations (conditional split, multicast, Union all, for each loop, send mail and derived column).
• Used dynamic package configuration to move the package from development server to the testing server.
• Used Bulk Copy Program (BCP) to import and export large amount of data in and out of SQL Server Databases.
• Performed SQL performance tuning using SQL Profiler and query optimization to improve the performance of slow running queries.
• Worked on Agile methodology and Microsoft Team Foundation Server (TFS)

Confidential, NYC, NY

ETL/BI Suit Developer

Responsibilities:

• Worked on designing the SSIS packages to transform data various sources such as Text files, XML files, Excel, Flat files to SQL server 2008R2.
• Designed and developed various reports such as cascading reports, sub - reports, and charts, parameterized reports as per client requirements.
• Used Execute SQL task, Execute Process task, Execute SSIS package task and Script task, File System task.
• Used Event Handlers to send mail task in the background upon failure of SSIS package.
• Created and used stored procedures, triggers, views for Audit and Maintenance tasks.
• Monitored performance and optimized SQL queries for maximum efficiency using SQL profiler and Database Engine Tuning Advisor.
• Created cluster and non-cluster indexes based on Database Engine Tuning Advisor
• Worked with OLTP, OLAP, Data warehouse application on star schema and snowflakes schema dimensions.
• Created SSRS data models projects using Microsoft Visual Studio 2008 and using Reports Builder for report server to facilitate Ad-hoc reporting by the business user.