PROFESSIONAL SUMMARY:

• 9+ years of Professional experience as a BI/SQL Developer dealing with SQL server, Business Intelligence tools on various versions of SQL Server. Worked widely on almost all the versions of SQL server like 2005, 2008, 2012, 2014, 2016.
• Extremely efficient in writing T - SQL scripts to develop complex Stored Procedures, SQL joins, Tables, Views, User Functions, Triggers, Temporary Tables and Ranking Functions.
• Executed best practice in structuring SQL queries, debugging unexpected SQL results etc.
• Knowledge in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Efficient in creating Sub-Queries and Joins for complex queries linking multiple tables and Exception Handlers.
• Used all kinds of SQL Server Constraints like Primary Keys, Foreign Keys, Defaults, Check, Unique etc.
• Proficient in MS SQL Server, Expert Knowledge of Integration Services(SSIS), Reporting Services(SSRS) and Analysis Services (SSAS).
• Designing and creating different SSIS packages using OLE DB connection sources from different sources by making use of multiple transformations provided in SSIS.
• Knowledge in enhancing and deploying the SSIS Packages from development server to production server.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
• Experience in creating Report Models for building Ad hoc reports using SSRS
• Experience in handling Drill through, Drill down, Parameterized, Cascaded Parameterized reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Extensive knowledge in Administering, Managing and Troubleshooting Reporting services.
• Created Reports with complex formulas and to query the database for Business Intelligence.
• Created shared dimension tables, measures, hierarchies, levels and aggregations on MS OLAP/ Analysis Server (SSAS).
• Skill in SQL Server Analysis Services (SSAS) CUBE design, development and deploying.
• Used SSAS Cubes for creating reports in SSRS and Customized SSAS cubes according the Clients requirement.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis Services (SSAS).
• Good knowledge of System Development Life Cycle (SDLC).
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Responsible for creating and changing the visualizations in Power Bi reports and Dashboards on client requests.
• Created Calculated Columns and Measures in Power Bi and Excel depending on the requirement using DAX queries.
• Good at using shared and global variables across crystal reports.
• Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS:

Operating Systems: Windows (All Versions) Unix, Linux, Mac

Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000, MS Access, Oracle 8i & 9i, Sybase, MS Access 97/2000/2003/2007, MYSQL.

Database Design Tools and Data Modeling: Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical and Logical Modelling, Dimension Data Modelling, Fact Tables, Dimension Tables, Normalization, Denormalization, MS Visio.

Modelling Techniques/Tools: Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, Data Modelling, ER Diagrams

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, Power BI, Tableau.

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), Toad, IIS 6.0/7.0, Business Objects, Crystal Reports 9.0, Web Services, XML, SOAP, WSDL, UDDI, Clear Case, Clear Quest, Visual Source Safe 6.0/2005, Visual Studio Team Foundation Server (TFS), ERWIN 7.3/7.2.

Languages: C, C++, HTML, XML/XSLT/.Net/C#, Core Java, Python, VB.NET

PROFESSIONAL EXPERIENCE:

Confidential, Torrance, CA

Sr. SQL/Power BI Developer

Responsibilities:

• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Created logs 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.
• Implemented error handling and roll back process in ETL load.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis
• Used XML and environmental variables in the package configuration for Deploying SSIS packages.
• Created region level security in reports to prevent users of one region from seeing data of a different region and implemented subscriptions for Reports using SSRS.
• Created Cross-Tabs, Drill-down and Sub-Reports using SSRS. Deployed RDLs to Report Server.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Created User Defined Hierarchies depending on the business requirement using SSAS.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Created different measure groups and calculations using SSAS.
• Successfully migrated content from MS Access to SQL Server 2000, SQL server 2000 to SQL server 2005, SQL Server 2005 to Oracle 10.g,
• Created Databases, Tables, Views, Indexes and Created and maintained Roles and Database users.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Scheduling Jobs and Alerting using SQL Server Agent
• Created datasets for reports using T-SQL and stored procedures
• Performed DBA tasks like Backup, Restoration of tables and Stored Procedures and Refreshing Databases on weekly basis.
• Involved in creating windows installer to install the application in SIT/UAT/Production environments.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Environment: MS SQL Server 2000, .Net 2002, MS SQL 2005/2008, SSIS, SSRS, Windows 2000 Advance Server, ASP, VB .Net, XML, T-SQL, MS Excel, SharePoint Portal Server 2003/2007, Targit, MS Access. Visual Studio 2005, Oracle 9i/10g

Confidential, long Beach, CA

Sr. SQL/ Power BI Developer

Responsibilities:

• Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, C# code as required.
• Perform Code review of Stored Procedures and prepare for database build steps for weekly change cycle.
• Extracted data from SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
• Responsible for preparing ETL strategies for extracting data from different data sources
• Implemented various strategies for Slowly Changing Dimensions using Data Stage Server/Parallel Jobs using the Frame Work approach.
• Used SAP HANA, SQL Server, Microsoft Azure, SharePoint, One Drive Business as sources of data.
• Closely worked with SAP for the issues in Standard SAP and implementing the OSS notes for • Permanent solution/fix.
• Support and resolve any issues that occur with SSRS and SSIS packages that run daily.
• Troubleshoot and tune Reporting Stored Procedure (SSRS) performance issues. Troubleshoot blocking issues.
• Hands On experience in developing ETL DTS Packages and SSIS Packages for integrating data using OLEDB connection from various sources like excel, csv, Flat file by using multiple transformations provided by SSIS Packages.
• Tested the ETL graphs and ETL processes (Data warehouse Testing).
• Experienced in working with business analysts to understand requirements and translating them into ETL code in Requirement Analysis phase
• Created Shell scripts for scheduling the Data Stage jobs using wrappers.
• Extensively used Data Stage Designer to Export/Import Data Stage components.
• Designed and built ETL mappings and workflows to load data from different DB2 sources.
• Server and published them via Power BI.
• Building Ad-Hoc reports in Power BI depending on Business requirements is one of the major responsibility.
• Reports developed with Flat files, SQL Database.
• Used to connect different data sources like SQL DB (SQL Query), Tabular Model (MDX Query), Web Trends to Power BI and generate reports with different visualizations.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Created bottom count, top count, cross join, non-ascendants, log MDX queries for creating Calculations and KPI's on a cube.
• Designed a Data Model with multiple Fact Tables and Dimensions depending on the business requirements.
• Built a Tabular Model cube from scratch data and by MDX queries fetched data to SSRS and Power BI reports.
• Developed Job Sequences for automating and scheduling the Data Stage Jobs.
• Performed Database Upgrades from 2008R2 to 2012 and .
• Worked on Analysis services for three different approaches for creating a business intelligence semantic model such as tabular, multidimensional, and Power Pivot.
• Extensive Backup and Recovery procedures using Full, Differential, Transactional backups.
• Resolve issues with Clusters (2 Node Active/Passive). Process log of various daily backup jobs to ensure backups are current for disaster recovery events.

Environment: MS SQL Server 2012, SSIS, SSRS, SSAS, Windows 8/8.1, Tableau, MS Office 2007/2010, T-SQL, POWER BI, Team Foundation Server (TFS).

Confidential, New York, NY

SQL/ /SSAS Developer

Responsibilities:

• Created SQL Server (T-SQL) Objects like Databases, Tables, Stored Procedures, Normalizations, Triggers, Joins, Cursors, Views, Functions, Data Types, Indexes.
• Analyzed and designed software and database solutions.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Used SQL Profiler and Query Analyzer to optimize SSIS package queries and stored procedures.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Develop, test, implement, and maintain ETL processes of Financial and Employee data
• Responsible for debugging failed ETL sessions and taking steps to mitigate impact to business users.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Used Data Stage as an ETL to extract data from sources like DB2 & flat files and loaded to target Oracle.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, and Sub Reports using SQL Server Reporting Services (SSRS).
• Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Worked on other packages of the SQL server 2012 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).
• Extracted data transformed and loaded into databases according to the required provision using Data Stage.
• Modified SSAS Tabular models with dimensions and fact tables from data sources.
• Created components, tools, techniques, methods and procedures used in an on OLAP environment for accessing and translating data into understandable and usable business information using SSAS.
• Designed and developed ETL processes using Data Stage designer to load data from MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data warehouse database
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2012 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies using SSAS.
• Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies and implemented cell level security in cubes using SSAS.
• Worked on Power View and Power Map to visualize reports.
• Created reports with Analysis Services Cube as the data source using SQL Server 2012 Reporting Services.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, and E-R Diagrams.

Environment: MS SQL Server 2012, SQL Server Analytical Services, SQL Server Reporting Services 2012, SQL Server Integration Services, Windows 8/8.1, MS Office 2007/2010, T-SQL.

Confidential, Jersey City, NJ

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

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Involved in gathering user requirements and system specifications.
• Designed and created views for security purposes. Implemented rules, defaults, and user-defined data types. Tested queries to optimize procedures and triggers to be used in production.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and loaded data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used SSRS Report Manager to assign roles, permissions and to create report schedules.
• Transferred data from various sources like MS Excel, Flat File and SQL Server using SSIS and then created reports using this data using SSRS .
• Generated the weekly, monthly, and quarterly report by using SQL Server Reporting Services (SSRS) for the managers.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of TSQL code.
• Performance tuning for existing queries in SQL Server Databases to reduce Production environment time cost.
• Improved the performance of many queries by reducing the usage of the cursors and other complex joins along with implementation of new indexes.
• Performed Data modeling for existing Databases using Toad Data Modeler and ER Studio.
• Creating documentation for all databases when they are in different stages.
• Be involved in the planning of system, development and deployment plans as well as responsible for meeting software compliance standards.
• Performed tuning to optimize SQL queries using SQL profiler and query analyzer.
• Experienced in loading data into Oracle Database using Data Loader and SQL Loader.
• Implemented named queries and created usage-based aggregations within SSAS Cubes to optimize performance.
• Involved in Dimensional Data Modeling and Cube partitioning in S SAS.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed Dimensional Modeling using SSAS cubes for End-User. Created Hierarchies in Dimensional Modeling.
• Generated and implemented schema objects and application objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics and templates using ETL.
• Perform system optimization, database performance analysis, capacity planning, and system sizing.

Environment: SQL Server 2012, T- SQL, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS).

Confidential, Wayne, NJ

SQL/BI (SSIS/SSRS) Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Developed Queries for generating drill down and drill through reports in SSRS 2008 R2.
• Uploaded reports on to the report manager and organized them into folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Created Linked servers to connect OLE DB data sources and providers.
• Administered the SQL Server by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc. as required Worked with Installation/Management of MS Team Foundation Server and TFS Migration processes.
• Wrote T-SQL queries, Stored Procedures and used them to build packages.
• Created automated T-SQL scripts to process summary database transactions that run off-hours.

Environment: SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services ( SSRS), Windows Server 2008, T-SQL, SQL Profiler, SQL Server Agent, MS Excel, Visual Studio 2010, T-SQL.

Confidential, Phoenix, AZ

MS SQL Server Developer

Responsibilities:

• Gathered functional and Business requirements and wrote technical specifications for building the Global Enterprise Data Warehouse.
• Involved in re-designing of database to create de-normalized reporting schema for better throughput.
• Developed new mappings using transformations like Look Up, Aggregation, Derived Column, Data Conversion etc. transformations to match the needs of the business case.
• Created packages for error handling, logging and custom logging to log the error information to SQL Server, Flat files and XML files
• Created DTSX Packages to import and export data from Excel, Access, SQL Server 2008 and Text files.
• Created SSIS Packages using Variables, Expressions and Environment Variables
• Created Production support packages.
• Migrated DTS 2005 packages to SSIS 2008 Packages.
• Used SSAS (SQL Server Analysis Services) for designing UDM including dimension and Fact Tables.
• Deployed the generated reports directly on the client’s workstation.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Generated reports using global variables, expressions and functions for the reports.
• Designed and implemented stylish report layouts.
• Identified and worked with parameters for parameterized reports in SSRS 2008.
• Developed Store Procedures and User defined functions (UDF) to access data from Data Mart.

Environment: SQL Server 2005/2008 Enterprise Edition, Reporting Services, SQL Enterprise Manager, Windows XP, MS Access, MS Excel, Windows 7, HTML, Visual Source safe.

Confidential, Danvers, MA

Jr. SQL SERVER DEVELOPER

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Worked with the developing team in the writing functions in Visual Basic 6.0 for upload download functionality, data transfer and migration.
• Prepared daily and weekly status reports and collaborated with other team members.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, triggers and maintained referential integrity.
• Involved in gathering business requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2005.
• Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.
• Created Linked Servers to connect OLE DB data sources and providers.
• Responsible for Cleansing up database for Maintenance of the database.
• Maintained security by creating users and giving appropriate permissions to users. Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.

Environment: SQL Server 2005, T-SQL, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Visual Source Safe, SQL Server Management Studio (SSMS).