SUMMARY:

• Over 8 years of IT experience in various sectors, including Healthcare, Banking, Financial and Retail as a SQL Server Developer that includes Database Design and Development of MS SQL Server 2016/2012/2008 /2005/2000.
• Experience in Data Modeling, Databas e Design, SQL Scripting, Development and Implementation of Client - Server & Business Intelligence (SSIS, SSAS, SSRS) applications.
• Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
• Experience working on production environments including delivering an Internet of Things (IoT)
• Expertise in writing and debugging Stored Procedures and Triggers in SQL Server and PL/SQL.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, and XML).
• Expert in creating SSIS packages to manage SQL Server databases and SQL Server objects between instances of SQL Server.
• Experience in PerformanceTuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experienced in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Extensive experience in SQL Server 2014/2012/2008/2005 in writing complex stored procedures, Triggers, Schema design, Index, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS) and Power BI.
• Expert in designing complex reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Extensive knowledge of designing, developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Experienced working with various services in Azure like Data lake to store and analyze the data.
• Expert in generating Drilldown reports, Parameterized reports, Linked reports, Ad-Hoc reports, Sub reports and filters, charts in SSRS 2016/2012/2008 .
• Good knowledge on data visualization and dashboard designing using Power BI.
• Knowledge on Active Directory Administration and Good understanding of Change Control process.
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
• Created SSIS packages with script task using .NET code to perform business requirements which are not provided by default SSIS components

TECHNICAL SKILLS:

Operating Systems: Windows, Unix, Linux, Mac OS

Database Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), DataStage

Reporting Tools: SQL Server Reporting Services (2012/2008), Power Pivot, Power BI, Tableau, QlikView

Programming: T-SQL, PL-SQL, C, LINUX (Shell Scripting), .NET

Database: MS SQL Server 2016/2012/2008, MS Access, Oracle 11g/10g/9i/8i, MySQL

Web Technologies: HTML, DHTML, Visual Studio.

Other Tools: MS Office Suite (Microsoft Word, Power Point, Azure Stack, MS Visio), ERWIN, Adobe Photoshop, Abode Flash, Mac Office Suite, Rational Rose

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. MSBI Developer

• Gathering and analyzing functional and non-functional requirements based on domain rules and requirements through conducting JRD sessions.
• Preparing instructions and specifications such as data mapping document for data extraction and other usage of data.
• Applying SDLC methodology, specifically Agile during the development process.
• Creating new tables, views, functions, and stored procedures in various complexity, as well as modifying existing structures for front end applications as well as ETL processes and reports.
• Enhancing SQL functionality with adding error handling methods such as applying try/catch and if/else blocks and fixing existing errors during execution.
• Optimizing existing T-SQLstored procedures, functions, etc. by modifying code structure or certain statements with low performance, recompiling storedprocedure, etc. with SQL Profiler and information in execution plan.
• Built a NationalDataWarehouse for the Confidential organization to maintain backup of the National Wide Membership Data and about the Programs conducted by the local Y’s for every 6months at each Confidential branch.
• Created a Thriving-Y Dashboard using PowerBI Data Visualization for with in the Organization People to look after every
• Created data sets for analysis using database and analytic tools like Tableau and Qlikview
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Created a Metrics Data to generate the reports for the National Wide programs held in the Local Y’s Organization according to the year.
• Managing the entire ETL process involving the extraction, analysis, transformation, loading and presentation of information to the end users.
• Designing data mappings between sources to operational staging targets, using starschema, and designing logic for incremental load using slowchangingdimension and check sum.
• Creating SSIS packages providing specific functionality like dataprofiling and data cleansing for a clean ETL process and populating data-marts.
• Involving in debugging of packages with help of breakpoints, checkpoints, event handlers and loggings.
• Designing SSIS package templates for package development incorporating package configurations, connection managers and logging in it.
• Incorporating GIT to keeping track of the history, merging code between the different versions of the software, check-in/check-out options.
• Preparing SSRS reports in different levels of complexity according to specific business requirements and render to pdf or excel formats.
• Optimizing performance of SSRS reports through avoiding sub reports, optimizing T-SQL scripts and stored procedures, implementing report subscriptions, caching reports, and/or providing snapshots on reports.
• Deploying SSIS packages and SSRS reports to corresponding development and testing servers and testing with basic cases and/or simple data to ensure functionality.
• Communicating with Database Administrator for instructions on deploying the SSIS packages and SSRS reports, setting up subscriptions, etc.
• Great communication, technical and problem-solving skills, and capability of working closely with teammates and independently.

Environment: Windows server 2003, MS SQL Server- 2016/2012/2008 /2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Power BI, Erwin VB.NET, OLAP, OLTP, Erwin, UNIX, Performance Point Server, Office-2007, MS Excel, C#.NET, ProClarity Analysis, MS SharePoint, GIT, VSTS.

Confidential, Dallas, TX

Sr. T-SQL/SSIS Developer

• Extensively worked on Data Flow tasks like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Migrated data from heterogeneous data sources (Data mart, Access, Excel, Flat file) to centralized SQL server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2016 as SSIS packages.
• Extracted data from various sources like MS SQL Server 2008, DB2, flat files, Excelspreadsheets, Oracle and XML files and loaded into the oracle database.
• Excellent report creation skills using Microsoft SQL Server 2016/2012 ReportingServices(SSRS) with proficiency in using Report Designer as well as Report Builder and MS SharePoint.
• Created calculated members and KeyPerformanceIndicators (KPIs), perspectives and partitions with existing SSAS cube objects for better analysis.
• Consulting for medium sized companies on how to reduce costs by using Azure Stack effectively.
• Implemented report manager to set up roles, security, and subscripts (data driven/standard) on the existing SSRSreports.
• Implemented data blending using various data sources and created stories using Tableau for better understanding of the data.
• Creating different visualizations using Bars, Bullets, Heat maps, Scatter plots, Gantts, Bubbles, Histograms, Lines and Pies, Maps and Highlight tables.
• Put together Email notification from tableau reports and load errors monitoring to end users as soon as pipelines finish for the game teams to react quickly in case of discrepancy.
• Tableau server administration and maintaining user permissions.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard utilizing Power BI.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008(SSAS)
• Designed and coded 3-tier applications with front-end development in MS VB.NET, C#.NET, ASP.NET, SQL Server
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers

Environment: Windows server 2003, IIS 6.0, MS SQL Server- 2016/2012/2008 /2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Power BI, Erwin VB.NET, OLAP, OLTP, Erwin, UNIX, Performance Point Server, Office-2007, MS Excel, C#.NET, ProClarity Analysis, MS SharePoint.

Confidential, Detroit, MI

Sr. T-SQL/SSISDeveloper

• Extensively worked on Data Flow tasks like foreach Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.
• Facilitated (JAD) JointApplicationDevelopment sessions to identify business rules and requirements and documented them.
• Created EntityRelationship (ER) diagrams for the proposed database utilizing conceptual, logical and physical data models.
• Developed Stored Procedures, triggers, views, Indexes using SQL Server 2008 and SQL Azure.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Used Text Files/ SQL Server TableLogging for all SSIS packages.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Developed HIPAA ANSI X12 834 benefit enrollment and maintenance transactions and ANSI X12 837 health care claim transactions.
• Used .NET code in script task to perform some business requirements when dealing with images.
• Deployed and configured the reports in the Report Server.
• Developed various Custom Code functions using VB Script.
• Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL server 2016/2012/2008 R2 using SSIS.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked with various SSIS packages which involve Transactions, restart ability and roll backtechniques.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application

Environment: SQL Server 2016/2012/2008 R2/2008, SSRS 2008, SSIS 2008, Power Pivot, Tableau, DB2, Oracle 9i/10g, .NET, XML, XSLT, MS Office and Visual source safe, Visual Studio 2012.

Confidential, Pittsburgh, PA

SQL BI Developer

• Worked with TechnicalArchitects and Databaseanalysts for the Design of Summary tables required for efficient Report Design.
• Designed the functional and technicaldocuments, reporttemplates and reportingstandards for the developers to work on the report development.
• Created cubes and dimensions and measures and calculated measures according to the businessrequirements.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2008as well as Created interface storedprocedures used in SSIS to load/transformdata to the database.
• Worked on T-SQLprogramming, storedprocedures, user-definedfunctions, cursors, viewssetup and management of linked servers to Non-SQL-Server databases.
• Involved in the implementation of various structured modules for the application using VB.NET, ASP.NET, ADO.NET, Web Services and SQL Server
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Involved in ReportAuthoring, ReportDelivery (using both Pull and Push strategy) and Report Management for several types of reports.
• Worked in creatinghierarchies for dimensionaltables like datedimensions and regiondimensiontables. Browsing the cube for analysis and validation of the data. Processing the cubes and dimensions daily using the SSIS tasks
• Extensively involved in the SSASstorage and partitions, and Aggregations, calculation of queries with MDX, Data MiningModels, developing reports using MDX and SQL.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Extracting the data from the various sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSISETL tool.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and email them to director and analysts to review in Excel Sheet.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: SQL Server 2008/2008 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, T SQL, Erwin, TFS, MDX, Oracle 10g, ProClarity, MS Excel.

Confidential, Dallas, TX

Sr. ETL Developer

• Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2008
• Filtered and cleansed dirty data from legacy system using complex T- SQL statements in staging area, and implemented various constraints and triggers for data consistency
• Created Power BI Dashboards to show KPI's in the project
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot and Unpivot Transformation
• Successfully migrated old data from legacy systems (FoxPro) and external system including excel and oracle into SQL Server 2008 using SSIS Packages
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Created scripts to verify and reconcile the migrated data from legacy system to SQL Server.
• Developed interface stored procedure to upload Insurance Record from XML format to Customer Insurance System
• Developed complex Stored Procedures to process prospective customer information and balanced the processing load between front end and back end
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Designed the Forms, templates & created Reports using SSRS 2008 reporting services.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Performed Unit testing for the screens and code in SQL Server 2008

Environment: SQL Server 2008, Oracle 9i, T-SQL, Excel, Access, Report Builder 3.0, Windows Server 2003, .NET, Query Analyzer, SQL Server Profiler, Erwin 7.3/MS Visio 2007

Confidential, Miami, FL

SQL Server BI Developer

• Worked with project lead and business users to understand business processes
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2008
• Worked with T-SQL to create Tables, View and stored Procedures
• Created triggers on DML actions for security purpose
• Worked with Scalar and Table Value User Defined Function as per business requirement
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables
• Encapsulated frequently used SQL Statements into stored procedures and reduced the execution time
• Wrote Merge Statement to handle insert, update and delete within single statement between source and destination table
• Scheduled jobs to call the packages and Stored Procedures as per business requirement
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle)
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Created SSIS Packages to move the data from tab delimited flat flies into SQL database
• Made dynamic SSIS packages which did data scrubbing, including data validation
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them
• Developed Cascading, Drill-down Reports to get monthly card details and profits using SSRS 2008
• Deployed, configured and managed reports using Report Manager and Report Builder
• Created Cross-Tab and Sub-Report using RDL
• Promoted RDLs to Reporting Service Server
• Used Visual Source Safe (VSS) for version control.

Environment: Microsoft SQL Server 2008, SQL Server Integration Services tools (SSMS, BIDS and SQL Server Manager), SSRS, SSAS, Business Objects, Windows Server, MS Visio, Oracle, MS Excel.

Confidential

ETL Developer

• Upgraded to latest version from SQL Server 7.0 to 2005.
• Developed User Defined Functions for giving Scores and views for the application
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database
• Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS
• Wrote various Stored Procedures for application development
• Tuned SQL statements (e.g.: using Indexes) and Stored Procedures
• Worked on replication of data (Transactional method used)
• Designed and implemented data access stored procedures and triggers for automating tasks
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder
• Formatted the reports using the Global variables and expressions
• Performed job scheduling and alerts
• Designed and implemented user log in and security
• Resolved any deadlocks issues with the databases/servers on a real-time basis

Environment: SQL Server 2005, SSIS 2005, Management Studio, DTS, Windows 2003/NT.