SUMMARY

• 8+ 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.
• Highly Proficient in T - SQL DDL/DML in constructing tables, Normalization techniques on database tables, perform the greater part of the SQL Server Enterprise Manager and Management studio functionality utilizing T-SQL Scripts.
• 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.
• Experienced in creating, modifying and debugging Stored Procedures, Views, User Defined Functions.
• 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 SQLServer 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).
• Good Understanding in transforming unstructured data from various data sources using SSISlike Sort, Merge Join, Conditional Split and Lookup.
• Extensively worked on packages to extract, transform and load data (ETL) using SSIS, designed packages which are used for tasks and transformations Data Conversion and Pivot tables
• 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.
• Expertise in creating SQL server Reports using SSRS 2005/2008.
• 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 noledge 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 noledge of System Development Life Cycle (SDLC).
• Explore data in a variety of ways and across multiple visualizations usingPower BI.
• Created reports in Power BIpreview 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 usingsharedandglobal variablesacross crystal reports.
• Expert in generatingSub Reports, Standard, Mailing Labels, Cross Tab ReportsandGraph Reportsby usingChart expertof 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, Dallas TX

Sr. SQL/SSIS/SSRS/SSAS/Power BI Developer

Responsibilities:

• Involved in analysis, design and development of project to consume transactional data, consolidate into data warehouse and creating reports and dashboards, writing complex Stored Procedures for creating datasets for Reports and dashboards.
• Gathered business requirements, defined and designed the data sources, data flows, data quality analysis, worked in conjunction with the data warehouse architect on the development of logical data models.
• 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.
• 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 dat 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.
• Designed SSAS cube to hold summary data for Targit dashboards.
• 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.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Targit.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.
• Populated data store with CRM Data (Oracle) using Integration Services (SSIS) as catalyst for ETL process.
• 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, Dallas TX

Sr. SQL/SSIS/SSRS/SSAS/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.
• Configured the SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Worked on Data Stage 8.7 to develop the jobs and upgrading it to 11.5.
• Responsible for preparingETLstrategies 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 dat occur with SSRS and SSIS packages dat 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 intoETLcode 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 builtETLmappings and workflows to load data from different DB2 sources.
• Expertise in project scope, analysis, requirements gathering,ETLDevelopment, system testing, implementation and production support.
• Automated KPI metrics reporting using Visual Studio Team Services/Power BI.
• Exported or Imported data from other data sources like flat files using Import/Export through SSIS.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point 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.
• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports.
• 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.
• Worked onSQLservertools like enterprise manager andSQLquery analyzer.
• Implemented and managed performance tuning tasks with developers in optimizing the long run queries.
• Implemented side-by-side migration and in-place upgrade of MSSQLServer.
• 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.
• Created SSIS packages in SQL Server 2012 for sources database forTableaudashboards.
• 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, Buffalo NY

SQL/SSIS/SSRS/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 maintainETLprocesses of Financial and Employee data sourced from PeopleSoft (Oracle) to Data Warehouse (SQL Server)
• Responsible for debugging failedETLsessions and taking steps to mitigate impact to business users.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way dat 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 SSRSreports 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 SSASTabular 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 onPowerView andPowerMap to visualize reports.
• Created reports with Analysis Services Cube as the data source using SQL Server 2012 Reporting Services.
• Experienced in SDLClife 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, Detroit MI

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).
• Designed and implemented parameterized and cascading parameterized reports using SSRS.
• Worked on creating multiple SSRS reports in Drill-through mode and Cross Tab Reports.
• Used SSRSReport 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 tan 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 SQLProfiler for troubleshooting, monitoring, and optimization of TSQL code.
• Performance tuning for existing queries in SQL ServerDatabases 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.
• Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table.
• 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 SSAS.
• 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 Server2012, T-SQL, SQL ServerIntegration Services(SSIS), SQL ServerReporting Services(SSRS).

Confidential, Long beach CA

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 Serverby 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 requiredWorked with Installation/Management of MSTeam Foundation Serverand TFS Migration processes.
• WroteT-SQLqueries, Stored Procedures and used them to build packages.
• Created automatedT-SQLscripts to process summary database transactions dat run off-hours.

Environment: SQL Server2008 R2, SQL ServerIntegration Services (SSIS), SQL Server Reporting Services (SSRS), Windows Server2008, T-SQL, SQLProfiler, SQL ServerAgent, MSExcel, Visual Studio 2010, T-SQL.

Confidential, Maryland

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

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 SQLServer.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Used SQLProfiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Created Stored Procedures to transform the Data and worked extensively in T-SQLfor 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).