SUMMARY

• Strong experience in logical and physical database design and development, Normalization and data modeling.
• Practice on Data Modeling (ERD)experience usingER diagram, Dimensional data modeling, Star Schema modeling, Snow - flake modeling using tools like Erwin,EMBARCADERO ERStudio.
• Creating and managing schema objects such as tables, views, indexes, Triggers, Stored Procedures and referential integrity depending on user requirements and converting them into technical specifications.
• Subscribe and connecting to SQL AZURE Data Bases and wring the scripts to Create Data Base Objects Within the SQL AZURE.
• Writing T-SQL Script for creation of data base objects Stored Procedures, User Defined Functions, Triggers, Views, Sub Queries, Stored Procedures in T-SQL, /MySQL PL/SQL/ Sybase (ASE)/DB2
• Writing Sub Queries to avoid complexity to join Data sets and Common table Expressions (CTE) for Temporary result set.
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Worked on SQL Server 2014 migration from SQL Server 2012/2008R2 / 2008, Master in scripting for Homogenous and Heterogeneous sources Migration.
• Good knowledge inRDBMSconcepts, Data warehousing concepts,OLTPandOLAP and Data Modeling.
• Designed, created, and maintained DB2 database objects. Involved in migration projects tomigrate datafrom data warehouses on Oracle/DB2 and migrated those toTeradata.
• Expert in Data Extraction, Transformation, and Loading (ETL) using Talend, Oracle Data Integrator (ODI) or similar tools such as BODI, Informatica, Data Stage, SSIS, or related technologies.
• Migrating data from various sources such as Excel, Oracle, MS Access, OLE DB, DB2, flat files to SQL server. To different destinations using SSIS.
• Great Expertise in creating and managingEvent, Handlers, Package Configurations, LoggingandUser-defined VariablesforSSIS Packages.
• Utilize existing enterprise BI tool set (e.g., SQL Server Reporting Services, SS Analysis Services, SharePoint, and Crystal reports and Power BI, Tableau) and web servicesthat provide standard analytic computations that can be leveraged in multiple BI solutions.
• Experience in generating and handling parameterized reportsDrill throughandDrill downreports with Drop down menu option,sorting the data, defining subtotalsin SSRS. Splunk, Spot fire.
• Generated reports usingSSRS, Excel (Pivot) that could be used to send information to diverse group of users.
• Extensive experience in different type of reports including:Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Experience in TroubleshootingReport Processing, Subscription, Delivery and ConfigurationProblems.
• Connecting to different data sources to blend and modeling Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server 7.0 and 8.2,9.0 for reporting and analyzing of data.
• Experienced with all phases of Data Warehousedevelopment life cycle, from gathering requirements, testing, Functional Specifications, Technical Specs, Design documents, Implementation and support
• Expert knowledge in developing, Multidimensional databases using SSAS. Experience in OLAP cubes using SSAS for data mining with Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Extensive experience in Data warehousing like identifying the Facts and Dimensions, creating Star and Snowflake schemas.
• Proficient in buildingCubes, definingReferenced Relationshipsand creatingHierarchies, Perspectives, PartitionsandDesigned Aggregationsin cubes using SSAS.
• Advanced working knowledge of report development, data models, and administration processes in Business Intelligence tools such as IBM Cognos, Oracle OBIEE, SAS BPC, etc.
• Knowledge on Cognos version 11 (COGNOS Analytics, Dashboard) and DQM
• Experience in utilizingSASProcedures, Macros, and otherSASapplications for data extraction, data cleansing, data loading and reporting. Involved in the data analysis, DB creation, applying database constraints and make ready to load onto database
• Good Understanding of Kimball and Bill Inmon warehouse modeling and usage of modeling tools such as Embarcadero, Erwin and DB Artisan.
• Well Experienced in SAPBusiness Object for report development.
• Extensive experience in writing MDX Scripting and MDX, DAX Queries.
• SSAS and building data cubes. For the ETL process worked on 10 million records at a time.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. inPower BI, Qlick view.
• Interact With front end applications by Web and Client/Server Application development using Microsoft .NET Framework with C# and VB.NET,ASP.NET, C#, programming languages
• Working with Web Technologies Java, AJAX, HTML, PHP, JavaScript, Rest API, JSON, Ruby, and Python. Through visual studio as programmer.
• Ability to configure SQL server to XML and HTML used to extract and store. Expert Excel user including VBA programming.
• Strong expertise in writing complex Access, Excel Macros with Excel VBA for different Business Environments.
• Good Experience in any big data platforms such as Hadoop (e.g. Cloudera, Hortonworks), AWS, MapR)
• Writing Unix/Linux/Perl, Python Scripting.
• Customizing Microsoft’s Team Foundation Server according to the company’s requirements. And generating multiple TFS reports, Upgrading TFS 2010 to TFS 2012.
• Work with customers to ensure user acceptance testing and complete delivery of reporting/analysis solution for DSRIPreporting.
• Provided Technical/ Production Support, and on-going maintenance for Crystal Reports.
• High interest and earnest fondness for Quantitative Finance, Trading and Risk Management.
• Experience in working with software methodologies like Agile, SCRUM, and Waterfall
• Good Experience on MS Dynamics CRM.
• Used to work on MicrosoftAnalytics Platform System (APS), for data warehousing and Big Data analytics and data integration, high-speed query processing, to store large amount of data and simple maintenance for end-to-end business intelligence solutions.
• Documentation of logic used in Tableau
• Ability to communicate to a variety of audiences in both verbal and written form.
• Exposure to AWS platform, Red shift Data warehouse, Alteryx is nice to have
• Reports development utilizing Information Builders' Web Focus version 8.1and App Studio
• Knowledge on Exposure to Big data and related technologies like SQOOP, SyncSor.

TECHNICAL SKILLS

Platforms: Windows XP/2003, 2008 Server/Vista/ Windows 7, Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADandSQL*LOADER, Net Framework 1.0/2.0/3.5/4.0 , CSOM, SSOM, REST API, MS Excel APIs, Linux, FTP, REST and JSON.

Languages: T-SQL, SQL, SQL*PL/SQL, MY SQL VB .NET, C#, HTML, MDX/DAX, Java script

RDBMS: Microsoft SQL Server 2005/2008/2012/2014 ,2016 MS Access, DB2, Oracle11g/10g, Tableau Desktop 7.0, 8.0,9.0

SQL Server Tools: DTS, SSIS, SSAS, SSRS, SSMS, OWB, ODI, Power BI Configuration Manager, Enterprise Manager, Query Analyzer Profiler, Database Tuning Advisor, SAP BO data services 9.0, IBM’s Data stage version 9.0.

Other Tools: MS Office Suite, MS Visio, Crystal Reports, MIS Reports, TFS, Share point 2013.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Data warehouse & BI Developer

Responsibilities:

• Design SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Design Dimensional model by analyzing all the requirements from the clients for the different source systems.
• Extract data from various sources like SQL Server 2008, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Assist in production OLAP cubes and writing queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS)
• Involved in creation/review of functional requirement specifications and supporting documents for business systems.
• Design SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Finding the gaps between different modules of the system and discussing the gaps with the functional personal.
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Geographic Visualization according to the end user requirement.

Environment: Microsoft SQL Server 2012 Integration Services, Analysis services and Reporting Services, Performance point server, Team Foundation server, Tableau Desktop 8.0, Microsoft Windows Server 2012, Microsoft SQL Server 2012.

Confidential, Woonsocket, RI

SQL BI /Data warehouse Developer

Responsibilities:

• Writing New T-SQL, PL/SQL/ Teradata queries for Table design and creation.
• Involved in Data Warehouse Design and Development by using star Schema Design Method.
• Migrated Data from SQL server 2012 to SQL Server 2014.
• Implemented stored procedures with proper Set Commands and enforced business rules via checks and constraints.
• Writing T-SQL, PL/SQL/MySQL Joins, correlated and non-correlated Sub Queries to avoid complexity to join Data sets and Common table Expressions (CTE) for Temporary result and Temporary tables and Pivoting tables and functions.
• Performance tuning to optimize any existing queries to speed up performance with modifications in removed unnecessary columns eliminated redundant and inconsistent data by applying Normalization techniques, established joins and created indexes whenever necessary.
• Review/modify current database design for better performance
• Implement database management tasks backup and Restore and recovery and disaster recovery and high availability.
• Used to work with troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, security issues etc.
• Creating SSIS and OWB, ODI packages and Modify/optimize existing SSIS packages to accomplish ETL Process for Data Ware House Development.
• Monitoring SQL server transactional replication heath
• Power Bl server (on-premises) performance monitoring; SQL SSIS and/or Powers hell scripts to automate SQL server monitoring tasks.
• Used to work on MicrosoftAnalytics Platform System (APS), for data warehousing.
• Designed, developed and deployed custom reports to Report Manager in MS SQL Server environment using SSRS 2012 to Create Data Driven, Drill Through, Drill Down, Tabular, Matrix reports & created charts, graphs using SQL Server 2012 Reporting Services (SSRS).
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Connecting to different data sources to blend and modeling of data within the Tableau server 9.0 to create interactive dash boards for reporting and analyzing of data and Splunk, Spotfire.
• Good Analytic capabilities in analyzing data, reporting requirements, identify KPIs, insights and trends.
• Worked withPower BImobile app and created mobile layouts to view reports and dashboards effectively
• Installed On premise data gateway and scheduled daily data refresh inPower BI. Microsoft Power Query years)M query language.
• Power BI technical skill set and experience as it related to loading data, transforming data, and presenting data (visualization);
• New QlikView application data modeling and UI development, i.e. building and maintaining QVDs and QVWs
• Production support and optimization of existing QlikView dashboards.
• Good Experience on DAX and OLAP, OLTP in Data Ware House Development.
• Detail-oriented Financial Analyst with hands-on experience in quantitative / statistical analysis, and forecasting budgeting, accounting, and forecasting with Excel VBA.
• Develop new VBA code (Excel) and Modify/optimize any existing VBA (Macros) code if necessary, Pivot tables.
• Worked on data preparation, data blending, and the creation of data models / sets using Alteryx
• Performed designing, building, and testing several complex workflows in Alteryx
• Working with SharePoint Designer to create work flow intex forms using share point 2013.
• Created Attributes, Metrics, security filters and other report objects, drilling, defined hierarchies using Micro Strategy Desktop.
• Business Analyst (BA) experience, especially regarding documentation of existing data sources; and the apparent ability to train the users in using and configuring Power BI and Qlick view.
• Upgraded the Micro Strategy 8.0.1 version on Windows to the 9.0.1 Version on UNIX.
• Subscribe and connecting to SQL AZURE Data Bases and writing the scripts Create Data Base Objects Within the SQL AZURE.
• Good Experience in any big data platforms such as Hadoop (e.g. Cloudera, Hortonworks), AWS, MapR)
• Interact With front end applications by Web and Client/Server Application development using Microsoft .NET Framework with C# and VB.NET as programming languages.
• Reports development utilizing Information Builders' Web Focus version 8.1and App Studio
• Working with Web Technologies Java, AJAX, HTML, PHP, JavaScript, Rest API, JSON, Ruby, and Python.Through visual studio as programmer.
• Ability to configure SQL server to XML and HTML used to extract and store. Expert Excel user including VBA programming.
• Working with Linuxand UNIX Operating system and shell scripting migration process. Writing Unix/Linux/Perl, Python Scripting.
• Proven experience working with large teams, in Agile/Scrum models required.

Environment: MS SQL Server 2012/2014, T-SQL, SSIS 2008/2012, SSRS 2012/2014 and MySQL5.0.22 and 5.1.24Oracle11g/10g, Oracle9i/8i Tableau Desktop 9.0

Confidential, New York, NY

SQL BI Developer

Responsibilities:

• Writing New T-SQL, PL/SQL/ MySQL queries for Table design and creation.
• Good Experience on MS Dynamics CRM.
• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2014/2012 Enterprise Edition.
• Designed and developedSSIS Packages migrating data from various sources such as MS Excel, Oracle, MS Access, OLE DB, and flat files to different destinations using SSIS/ OWB, ODI for ETL Process to accomplish Data ware house Development in Star and Snow flake Schema Design Method.
• Designed, developed and deployed custom reports to Report Manager in MS SQL Server environment using SSRS 2012.
• Experience in creating Data Driven, Drill Through, Drill Down, Tabular, Matrix reports & created charts, graphs using SQL Server 2005 Reporting Services (SSRS) and Splunk, Spotfire.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Used ETL to implement the slowly changing Dimensions (SCD) in data warehouse. Expert knowledge in developing multidimensional databases (MDX, DAX) using SSAS. Experience in OLAP cubes using SSAS for data mining with Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Good Experience on DAX and OLAP, OLTP in Data Ware House Development.
• Utilize existing enterprise BI tool set (e.g., SQL Server Reporting Services, SS Analysis Services, SharePoint, and Crystal reports and Power BI) and web servicesthat provide standard analytic computations that can be leveraged in multiple BI solutions.
• Delivered custom and scheduled reports using Crystal Reports, Built andperformance tuned back end T-SQL, PL/SQL code.
• Created effective Dashboards inPower BI, and Service and made the reports user friendly and interactive.
• Worked withPower BImobile app and created mobile layouts to view reports and dashboards effectively
• Installed On premise data gateway and scheduled daily data refresh inPower BI.
• Power Bl server (on-premises) performance monitoring; SQL SSIS and/or Powers hell scripts to automate SQL server monitoring tasks.
• Connecting to different data sources to blend and modeling of data within the Tableau server 8.0 a Tableau Server Performance tuning. To create interactive dash boards for reporting and analyzing of data.
• Experience in QlikView dashboard development skills - intermediate to advanced understanding of scripting and front-end development, and Splunk and spot fire.
• Good Experience in any big data platforms such as Hadoop (e.g. Cloudera, Hortonworks), AWS, MapR)
• Develop new VBA code (Excel) and Modify/optimize any existing VBA code if necessary.
• Used to work with Team foundation server TFSto open bugs, create tasks and user stories, initiate change requests.
• Deploy applications and test plans and regression testing, data base testing used to work with TFS Generated and executedVB scriptsusingTest Complete.
• Interact With front end applications by Web and Client/Server Application development using Microsoft .NET Framework with C# and VB.NET as programming languages, Restful webapi using c#api.
• Working with Web Technologies Java, AJAX, HTML, PHP, JavaScript, Rest API, JSON, Ruby, and Python.Through visual studio as programmer.
• Ability to configure SQL server to XML and HTML used to extract and store. Expert Excel user including VBA programming.
• Wrote Scripts in UNIX Shell scripting for migration process.
• Writing Unix/Linux/Perl, Python Scripting.
• Created Attributes, Metrics, security filters and other report objects, drilling, defined hierarchies using Micro Strategy Desktop.
• Worked on Analytical and Visualization Tool: Tableau, Excel, VB, Alteryx, and Qlikview Data Manipulation: Excel, Alteryx.
• Upgraded the Micro Strategy 8.0.1 version on Windows to the 9.0.1 Version on UNIX.
• Subscribe and connecting to SQL AZURE Data Bases and wring the scripts Create Data Base Objects Within the SQL AZURE.

Environment: MS SQL Server 2008R2/2012/, T-SQL, SSIS 2008/2012, SSRS 2008R2/2012/2014 and MySQL5.0.22 and 5.1.24Oracle11g/10g, Oracle9i/8i Tableau Desktop 7.0, 8.0.