SUMMARY:

• Around 8 Years of extensive experience as SQL Server and Microsoft Business Intelligence applications developer, Specialized as an ETL/Business Intelligence Developer with expertise in SQL Server Integration Services, Analytics, Reporting and Self Service BI
• Expert in working with the Business Intelligence Development Studio (BIDS), which includes SSIS, SSAS and SSRS.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Experienced in writing complex T - SQL queries using Inner, Outer and Cross Joins.
• Experienced in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Extensive experience in Writing Transact SQL (T-SQL) Queries, Dynamic-queries and implementing SQL Server Indexing.
• Having strong experience in scheduling all the T-SQL jobs to run at particular times.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Integrity using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique).
• Strong Experience in Interface programs to import data from legacy systems and excellent skills in writing PL/SQL stored procedures, functions, packages, triggers and cursors.
• Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
• Developed PL/SQL Packages, Procedures and Functions accordance with requirements for loading data into database tables.
• Proficient in OLTP, OLAP and Data warehousing Design concepts.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Implemented the business rules in writing Oracle PL/SQL functions and procedures and Wrote Queries to retrieve data in XML format from the tables.
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Strong experience in creating complex reports that use cascaded parameters.
• Very good experience in writing expressions in SSRS.
• Review, validate and cleanse claims data towards preparation of the final data set for claims analysis
• Good Knowledge in OLAP Storage modes likes Rolap/Molap/Holap
• Experience in Relational, Multi-Dimensional (Star) and Snowflake logical modeling.
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development and Implementation.
• Solid understanding of RDBMS database concepts and Experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation.
• Experience in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Developed reports using global variables, expressions and functions using SSRS.
• Excellent communication, analytical and inter personal skills and ability to learn new concepts.
• Ability to work individually as well as in a team, quick learner, self-motivated, out of box thinker with excellent communication and interpersonal skills.
• Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.

TECHNICAL SKILLS:

Business Intelligence Tools: Microsoft BI (SSAS, SSRS), SSAS Tabular, Self-service BI (Power Pivot, Power View, Power Map, Power Query), Cognos 8.x (Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Connection, Transformer), Qlikview Self Service BI

ETL Tools: SSIS, Informatica Power Center 7.x, Ascential Data Stage 7.5, SAP - Business Warehouse, Power Query

Database Systems: MS-SQL Server 2000/2005/2008/ R2/012, Oracle 10g/11g, DB2MS Access

Database Management Tools: SQL Query Analyzer, SQL Profiler, DTA, SQL Server Activity Monitor, SQL Server Logs

Programming Languages: T-SQL, PL/SQL, .Net, MDX, DAX, HTML

Operating Systems: Windows 98/ME/2000/NT/XP/2003/7, MS DOS, Linux, IIS 5, 6

Project Management/ Database Design: Microsoft Project/Office 2003,2007, 2010, 2013, Microsoft Visio, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

SQL BI Developer\MSBI Developer

Responsibilities:

• Installed SQL SERVER 2008/2008r 2/2012/2014/2106 FAILOVER Cluster and standalone installation on Windows Server 2008 r2 64-bit system and VM WARE, Hyper - V in PROD/TEST/DEV from scratch.
• Regularly supported service packs and hot fixes for both clustered and standalone SQL Server.
• Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server.
• Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
• Involved in creating dashboards and reports in Tableau 7.1. Created report schedules on Tableau server.
• Installed and upgrade Tableau server from Tableau 7.0 to Tableau7.1 and experienced in server performance tuning for optimization.
• Optimized the performance of queries in TSQL queries, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Extensively used BI tools like Integration service, Reporting Services and Analysis services in MS SQL server 2005 and 2008R2.
• Developed SSIS packages and SSRS reports in SQL Server 2005/2008/ 2008 R2/2012.
• Filtered and cleansed bad data from legacy system using complex Transact- SQL statements in staging area, and implemented various constraints for data consistency.
• Performed data cleansing by creating tables to eliminate the dirty data and implemented Error Logging using SSIS.
• Developed Packages using most of the Tasks, Containers and Transformations in SSIS.
• Strong background in Data Warehousing principles and methodologies.
• Designed different kinds of reports like Linked, cascaded and parameterized reports and worked on Drill Down and Drill-through Reports, Tabular, Matrix etc.
• Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
• Created Report Models for building Ad hoc reports using SSRS and deployed reports into SharePoint.
• Created and managed roles for security in Reports.
• Created Cubes with Star schema in SSAS and developed SSRS reports based on the cubes.
• Worked in AGILE methodology in development of Database Objects in SQL Server 2008R2/2012.
• Report writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) and Power BI.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: MS SQL Server 2016,2014,2012,2008R2,VS2010, Business Intelligence Development Studio (BIDS), T-SQL, XML, Performance Point Server 2007, SSIS, SSRS, SSAS,OLAP, OLTP, Windows 7, Microsoft Excel.

Confidential, Baltimore, MD

SSIS/SSRS Developer

Responsibilities:

• Developed and deployed SSIS packages also upgrading DTS packages to SSIS.
• Used various transformations while mapping the data from source to destination using SSIS.
• Created database links and accessed the data through SQL statements
• Designed and Built ETL packages to migrate data from different source systems using Data value modeling concept.
• Created SSIS packages to load data from different sources such as Excel, Flat file, DB2 to SQL server 2012 Data warehouse and SQL Server Transactional database.
• Used data transformation like look up, Script component, Merge, Merge Join, Multicast, Derived column, copy column, condition split, sort, union all, data conversion, conditional split and row count to clean the data and modify it. Loaded the data in various destination like SQL server, flat file, excel in SSIS package
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created and used Package, Data flow task and sequence container.
• Designed and deployed various complex reports using MS Reporting Services.
• Prepared Documents of each process involved.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests. creating users row based security (permissions) for cubes,dimensions and measure groups.
• Developed complex stored procedures using T-SQL to generate reports using SSRS 2008/2012.
• Created Tabular reports, Cross Tab Reports, Matrix, Sub Reports, and Parameterized reports.
• Analyzed reports and fixed bugs in stored procedures
• Transferred data from various sources like MS Excel, MS Access, SQL Server using SSIS and then created reports using this data using SSRS.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Tested the SSIS packages using debugging process.
• Deployed and uploaded the SSRS reports to Report Manager & SharePoint server for the end users and involved in enhancements and modifications.
• Build the Data Visualizations using the Power BI Concepts.
• Created reports and dashboards using MS Power BI and deployed into Power BI service.
• Worked on UAT activities by validating the data on Power BI reports and dashboards.

Environment: MS SQL Server 2008R2/2012, T-SQL, SQL Server Reporting services, SQL Integration Services, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Management Studio, Visual studio 2012

Confidential, Los Angeles, CA

SSAS/SSRS Developer

Responsibilities:

• Built MDX queries used in reports of various clients' legal related documents using tuples and sets.
• Designed and built SSAS complex cubes which include millions of records which were complex and deployed them.
• Worked on cube partitioning, refresh strategy and SSAS performance tuning.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Created relationship in both cube structure as well as in DataSource view. Created relationship like many to many, fact, reference, and regular. Used refresh strategy after the modification made to the cube in DataSource view.
• Assigned to roles to particular user to access the SSAS cube. Deployed and processed the cube.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008/2008r2 and in adding calculations using MDX.
• Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.
• Created various Dimensional Hierarchies, KPI's as part of cube design.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.
• Processed and deployed the cube into analysis server.
• Implemented the roles for the security purpose on the cube access.
• Configured the report viewing security for various users at various levels using Report Manager.
• Used SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS).
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Added indicators, document maps to the SSRS reports.
• Created List report, dynamic report and enabling the sorting to the report
• Exported reports in SSRS to Excel, PDF and word document
• Created Subscriptions for SSRS reports both data driven and standard subscription.

Environment: MS SQL Server 2008R2/2012, T-SQL, SQL Server Reporting services, SQL Integration Services, SQL Server Analysis Services, SQL Server Management Studio, Visual studio 2012.

Confidential

MSBI Developer

Responsibilities:

• Involved in Installation, Configuration, Development, Deployment and Troubleshooting Reporting services using SSRS 2000/2005/2008 across various environments.
• Responsible for getting, understanding the business specifications, preparing technical specifications, DTS Packages.
• Responsible for creating appropriate loaders and relational writes toload the Data from SSIS.
• Involved in migration of DTS packages to SSIS.
• Creating jobs for scheduling the SSIS packages.
• Using different transformations like excel source, data conversions, lookup functions, Pivot tables OLEDB command, derived columns, OLEDB destination, etc.,
• Designed dynamic SSIS with VB.Net to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS.
• Loading these data into data warehouse like SQL server.
• Worked on SSRS to design reports and deploy them to the Report Manager.
• Worked on SSRS with expressions and designing of reports.
• Participated in report authoring, used conditional formatting to make the reports more user friendly.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Wrote and integrated stored procedures to generate the reports.
• Used various report items like tables, sub report and charts, Graphs to develop the reports in SSRS.
• Multilingual SSRS reports are built based on client specifications
• Fine-tuned the complex database stored procedures and increase performance up to 5%.

Environment: SQL Server 2005 Enterprise Edition, SSIS 2005, SSRS 2005, XML, c#, T-SQL, Windows 2000/2003 Advance Server, MS Excel, MS Access, Visual Studio 2008/2005, VB.Net

Confidential

MSBI Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Identified various data sources, formulated data dictionaries, design and develop data models (Physical/ logical data models) based on the given specs and requirements.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Experience in end-user reporting definition, development and platform support using SQL Server Reporting Services (SSRS) and Performance Point.
• Performed ad hoc queries, design and deployed reports using SSRS and resolved any issues related with it.
• Created Logical and physical Data models for SQL server 2008.Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Created complex Stored Procedures, Triggers, Cursors, Tables, Views, Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.

Environment: s: SQL Server 2008/2005, SQL BI Suite (SSIS, SSRS), MS Power point, MS Project