SUMMARY

• Having 8 years of IT experience as a MS SQL Server Developer in various Industry verticals like Finance, Banking and Health Care with experience in MS SQL Server 2019/2017/2016/2014/2012/2008/2005, Business Intelligence in MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), and MS SQL Server Analysis Services(SSAS).
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL)/DTS packages to perform data transfer from different server locations and heterogeneous sources like Oracle, Excel, CSV, XML, MS Word and Text Format Data.
• Expert in Creating, Configuring and Fine - tuning MS SQL Server Integration Services (SSIS).
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2005.
• Experience in designing and building database schema for various industries including finance and retailing industries.
• Expertise in Ralph Kimball Methodology, Bill Inmon Methodology, Logical Modelling, Physical Modelling, Dimensional Data Modelling, Star Schema, Snowflake Schema, FACT tables, Dimension tables.
• Hands on Experience on major components in Hadoop Eco Systems like Spark, HDFS, HIVE, PIG, HBase, Zookeeper, Sqoop, Oozie, Flume, Kafka.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS,Bulk Insert and BCP.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models, SQL joins and Query Writing.
• Highly experienced in using SSIS Import / Export Wizard, SSIS designer and other package execution utilities for performing the ETL operations.
• Highly experienced in strategically implementing the indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
• Experience in performance tuning and optimization.
• Experience in SAS/BASE, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, and SAS/CONNECT in UNIX and Windows environments.
• Experience in Extract, Transform and Load (ETL) activities using SSIS and Azure Data Factory (ADF2).
• Develop the datasets in COSMOS using Scope scripts.
• Developed new or modified existing SAS programs to load data from the source and create study specific datasets.
• Created reports in SAS and exported to Excel spreadsheets, created web reports using Web Report Studio.
• Strong ability to write SQL queries using PROC SQL.
• Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting.
• Experience in writing SQL's, Stored Procedures, Triggers, Functions and Views on SQL Server 2019/2017/2016/2014/2012/20 .
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI.
• Solid knowledge of Power BI and Tableau Desktop report performance optimization.
• Proficient in Extraction Transformation and Loading (ETL) process by pulling large volumes of data (VLDB) from various data sources using SSIS.
• Expert writing SSIS Configuration, Logging, Procedural Error Handling and Data Error Handling, Master Child Load methods using Control tables.
• Good Hand on Resolving complex issues and Error Handling in SSIS.
• Developed cubes, partition aggregation and optimization using SSAS.
• Experienced in using multiple transformations provided by SSIS such as script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, Merge, Merge Join, Union All, and Slowly Changing Dimension.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Extremely dedicated, hardworking, strong team player with an ability to take new roles, excellent communication and strong analytical skills.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Profiler, Sybase 12.5 ASE

IBM Tools: IBM DB2.

Languages: C, C++, SQL, T-SQL, PL/SQL, Visual Basic 6.0, C#. NET, My SQL, VB.NET, HTML, CSS, AJAX, XML

Operating Systems: Windows 95/2000/2003/ XP/VISTA/7/8/8.1,UNIX, LINUX

Databases: MS-SQL Server 2012/2008 R 2/2008/2005/2000, MS-Access 2007/2010

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), dashboards tools, web tools.

Scripting: HTML, DHTML, XML, Shell Scripting, Power Shell 2.0.

Reporting Tools: SSRS, SSAS, Crystal Reports, Business objects, Report Builder 3.0.

DB Utilities and design tools: SQL Server Management Utility, SSAS Cubes, Query Analyzer, MDX scripting.

Application Software: Visual Studio, SQL dialect, MS Office.

Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential - Charlotte, NC

MS SQL Server / Data Warehouse Engineer

Responsibilities:

• As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of BI Analytics needs.
• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Creating Database Objects likeTables, Indexes,User defined functions, Triggers, Parameterized Stored Procedures, Constraints and Roles.
• Knowledge in designing and developing Data Warehouses, Data marts andBusiness Intelligenceusing multi-dimensional models such asStar SchemasandSnow Flake Schemafor developing Cubes using MDX.
• Development of Python API's for monitoring of data acquisition and automation of data quality check process.
• Designed and Architected Spark programs using Python to compare the performance of Spark with Hive and SQL and developed python scripts using both RDD and Data frames/SQL/Data sets in Spark 1.6 for Data Aggregation, queries and writing data.
• Created Kafka data pipelines to ingest credit data to Data Lake.
• Employed Spark API over Hortonworks Hadoop YARN to perform analytics on data in Hive and optimized the existing algorithms in Hadoop using Spark Context, Spark -SQL, Data Frames and RDD's.
• Designed, developed and tested various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and 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.
• Install, configure and maintain Storage account, Azure File Sync, Resource group, Azure Data factory (ADf2), Azure Sql DB server, Database, SQL elastic pools,, Index advisor, Query Store, Geo-Replication.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Building the pipelines to copy the data from source to destination in Azure Data Factory (ADF V2).
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.
• Created C# applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads.
• Transforming data in Azure Data Factory with the ADF Transformations.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Design and implementation ofPerformance TuningandMaintenance planfor consistency checks,backup/restore and Indexes.
• Conductedperformance monitoringand measurement includingTuningand executedDBCC Commands,Sizing Procedure cache,Sizing Data cache, configuredlocksandTransaction Isolation levelsandIndex Management.
• Experience in configuringpackage logging, error loggingandevent handlingto redirect error rows and fix the errors in SSIS.
• Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports.
• Involved in writing code using SAS/ Base SAS/Macros for creation of analysis datasets.
• Developed and executed SAS SQL queries for merging, concatenating and updating large volumes of data.
• Working on SAS business intelligence platform to drive the automation of standardized analytics. generating SAS EG stored process with static and dynamic prompts for product specific analyses
• Modifying existing codes for improvement in the performance.
• Advanced querying using SAS EG,Calculating computed columns, using filter, manipulate and prepare data for reporting, graphing, and summarization, statistical analysis, finally generating the data marton weekly basis.
• Importing SAS datasets, OLAPCubes in SAS information Map Studio. Using instructions on how to access and combine relational data tables, calculating new data items, Created multiple pre-defined filters.
• Worked closely with different business teams to gather requirements, prepare functional and technical documentsand UAT Processfor CreatingData quality rules in cosmos & Cosmos Streams.
• Created interactive workbooks using Tableau 10 and 9.x with multiple connections to multiple data sources using data integration.
• Created worksheets using Tableau with primary and secondary data sources using data blending where primary and secondary data sources where linked by specified relationships.
• Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources.
• Worked on Key performance Indicators KPIs, design o star schema and snowflake schema in Analysis Services SSAS.
• Migrated Data from SQL Server 2019 to Snowflake using ELT Maestro.
• Used Data Stage as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database.
• Converted the SQL Server Stored procedures and views to work with Snowflake.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports
• Created various views in Tableau - like Tree-maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts etc.
• Extensively used crystal reports and migration of VB6.0 applications to .Net VS IDE 2010 with VB.Net.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually.
• Involved in creating SSISpackages with various transformations like Slowly Changing Dimensions,Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Monitoring the Data Stage job on daily basis by running the UNIX shell script and made a force start whenever job fails.
• Work on Generating dashboards in Tableauserver using various data sources
• Migrated very complicated Bank Actuate reports into SSRS 2005 and SSRS 2008 R2 which are some not able to migrate but used many work around techniques to migrate this complicated reports.
• Designed and implemented groupby, drilldowns, drillthrough, sub-reports, Parameterized and cascading parameterized reports using SSRS.
• 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: MS SQL Server 2019/2017/2016 R2/2012,Linux, MS SQL Integration Services 2008 R2/2012, MS Access, Crystal Reports, MS SQL Reporting Services 2008 R2/2012, SSAS Cubes, SharePoint 2013, MS Excel Power Pivot, IBM DB2, SQL Server Agent, Tableau, SQL Server Reporting Services(SSRS).

Confidential, Dayton OH

MS SQL Server/SSIS, ETL/BI Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specifications and design documents for development.
• Designed database after analysis of the business requirement.
• Development of Data Stage jobs from Informatica jobs (Migration of entire ETL framework from Informatica to DataStage).
• Manage all aspects of the OGG design, implement and support in development, UAT and production environments. Identify and resolve OGG problems occurring in all database environments including performance related issues (i.e. database & SQL tuning).
• Setting up High Availability Oracle Golden Gate (OGG) systems on Oracle 11gR2 RAC environments (Front-end: Sun SPARC Server, Back-end: Oracle Exadata Full Rack).
• Worked closely in developing the detail design document and presenting to the client and implementing their feedback on a weekly basis.
• Worked with an offshore development team, communicating on a daily basis with the team.
• Designed the complete flow of the file processing.
• Writing detail technical design, mapping documents and develop report queries in snowflake and Java based on the metric calculations provided by the Product Leadership Team.
• Developing and supporting Data loading to snowflake database from Microsoft Azure Blob storage.
• Design and Developed DTSX packages to extract, transform and load into the Campaign database from OLAP cubes and various Cosmos streams using of SQL Server Integration Services (SSIS).
• Configure Integration Runtime Setup, Schedule SSIS, create Trigger, maintain and monitor SQL jobs (Store proc & SSIS) using Azure Data factory (ADF2).
• Updating the existing snowflake queries based on changing needs.
• Analyzing and validating the snowflake data based on expectations.
• Created Stored Procedures, Triggers, Indexes, UserdefinedFunctions, constraints on various database objects to obtain the required results.
• Performed T-SQL tuning and optimized stored procedures using SQL Profiler, DBCC Commandsand byanalyzingExecutionPlans.
• Prepared Documentation for the Stored Procedures consuming the greatest amount of CPUresources, taking the longest time to run and which performs the most physical and logical I/O operationsusing Dynamic Management Views and Functions.
• Data migration (Import & Export using BCP) from text to SQL Server 2008.
• Created Pipelines, Datasets and worked with datascientists&analysts as a part of POC of internal confidential product key analytics which are implemented on Azure Data Factory (ADF).
• Migration of on premise data (Oracle/ SQL Server/ DB2/ MongoDB) to Azure Data Lake Store(ADLS) using Azure Data Factory(ADF V1/V2).
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLsetc.) and loaded the data into target data sources by performing different kinds of transformations like Conditional Split, Derived Column, Data Conversion, Look Up and Merge Join as required using SQL Server Integration Services (SSIS).
• Utilized expertise in models that leverage the newest data sources, technologies, and tools, such as Python, Hadoop, Spark, AWS, as well as other cutting-edge tools and applications for Big Data.
• Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc. using Tableau.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web
• Developed various data connections from data source to Tableau Desktop for report and dashboard development
• Involved in Tableau server installations, configuration, creating users, groups, and projects
• Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data
• Mentored business power users to create reports/dashboards using Tableau desktop
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive. Management to view past, current and forecast sales data
• Built compelling, interactive dashboards in Tableau that answer key business questions
• Utilized Data story telling in Tableau to provide more dynamic and more effective stories from the hidden insights locked in the data
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Created SSIS packages and scheduled the jobs to run automatically to process the cube, loaddata.
• Develop the datasets in COSMOS using Scope scripts.
• Deployed SSIS packages with a simple one-click deployment to the integration server.
• Developed and executed SAS SQL queries for merging, concatenating and updating large volumes of data.
• Generated high quality reports and listings in HTML, EXCEL and PDF formats using
• SAS/Enterprise Guide software was used for file and program management purposes.
• Creating various transformation procedures by using SAS 9.1, SAS Cube Studio, SAS Data Integration Studio, and SAS Enterprise guide.
• Involved in writing code using SAS/ Base SAS/Macros for creation of analysis datasets.
• Knowledge about the SAS Metadata Server and Data Warehousing development
• Complete understanding of SAS OLAP.
• Maintained OLAP cubes using SAS OLAP CUBE Studio to support reporting of information maps and Web.
• End to End application development right from ingesting the data feeds from upstream, Extraction, transformation and loading, Data enrichment using PL/SQL and python.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Generated multiple Enterprisereports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as groupby, drilldowns, drillthrough, sub-reports, ParameterizedReports.
• Generated parameterized queries in SSRS 2008 R2 using data from SSAS Cubes and various heterogeneous data sources.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters) to minimize the report execution time and to limit the no of records required.
• Experience in ReportBuilder in SSRS2005 and 2008.
• Developed Spark/Scala, Python for regular expression (regex) project in the Hadoop/Hive environment with Linux/Windows for big data resources.
• Scalable Web Architecture based AWS Cassandrain Python Linux OS for High I/O GPS Application DevOps.
• Created the SQL server users and file server users with required permissions by including them in the scripts. Created Cross-Tab reports, Summary reports by using SSRS and designed reports using Crystal Reports.
• Implemented the SQL agent jobs creation while deploying the database instance itself by adding them on to the post deployment scripts.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and datasourceview.
• Created complex expressions using the MDX scripting to solve complex designs.
• BI reporting using Excel with Power Pivot.
• Performed transactional-level process using Micro Strategy’s relational OLAP (ROLAP) architecture.

Environment: MS SQL Server 2012/2014 R2/2012, Micro strategy, MS Access, MS SQL Integration Services 2008 R2/2012, Crystal Reports, MS SQL Reporting Services 2008 R2/2012, SharePoint 2013, SSAS Cubes, MS Excel Power Pivot, IBM DB2, SQL Server Agent, SQL Server Reporting Services(SSRS).

Confidential, Philadelphia, PA 

SQL Server/ BI 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.
• Created Complex Stored procedures, user defined Functions, Schema Binding Views. Extensively used CTE's for complex coding.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS 2012.
• Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Data migration (import & export/BCP) from Text to SQL Server.
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data in Database Tables.
• Troubleshooting typical OGG technical problems such as unique key violation / long transaction abend by using GGSCI / Log dump / discard file analysis etc.
• Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments (from MySQL/Sybase to Oracle Exadata).
• Converted Non-Unicode data from different databases into Unicode data and move the data to staging databases.
• Involved in Query optimization and tuning stored procedures for better performance.
• Executed database backup task, check database integrity, rebuild indexes, update statistics task for maintenance.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2012 and also have hand on experience in PVCS, EDI etc.
• Created packages in SSIS with error handling.
• Developed Spark applications using Pyspark and Spark-SQL for data extraction, transformation and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into the customer usage patterns.
• Developed Drill Down, Cascading, and Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users.
• Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.
• Identified and worked with parameters for parameterized reports in SSRS in SQL Server 2012.
• Work closely with internal customers analyzing problems and to create and maintain reports, maintaining SSRS Reports and ad-hoc SQL scripts.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Experience in Designing and Building the Dimensions and Facts with star schema and snowflake schema using SQL Server Analysis Services (SSAS).
• Developed Multi-dimensionalObjects (Cubes, Dimensions) using SSAS 2012.
• Carry out creation of SDLC documentation for existing applications.
• Efficiently helped in the Software Development Life Cycle (SDLC) processes specifically waterfall and Agile Scrum methodology including Analysis, Design, Programming, Testing and technical Documentation.

Environment: SQL Server 2012 Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), MDS, Netezza database, DQS, DTS, C#, .Net, T-SQL, XML, XD, MS Excel, MS Access, MS visual Studio, BIDS, MS Power Point 2012.

Confidential

SQL Server/ BI Developer

Responsibilities:

• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports.
• Writing queries to generate reports for analysis of data usingSQLServer Reporting Services (SSRS), Report Builder.
• Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset usingSQLServer 2014 Analysis Services (SSAS)
• Exported reports from crystal to PDF and Microsoft excel formats.
• Implemented dashboards and scorecards with power pivot for executive management for data insights as per business requirements.
• Performed key role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• Involved in various projects related to Data Modeling, System/Data Analysis, Design, and Development for both OLTP and Data warehousing environments.
• Worked heavily onSQLServer database to extract data and build Business reports.
• Generated Reports using Global Variables, Expressions, and Functions for the reports in SSRS.
• Generated various Drill-through reports, parameterized reports, sub-reports, and linked reports using SSRS and integrated into the web front end.
• Experience setting up reporting platforms ground up in Microsoft technology stack (Share point, SSRS, SSAS, DAX, MDX, T- SQL, Dimensional Modeling, SSIS)
• Developed Database structures, store procedures, DDL triggers and user defined functions to optimize the database performances.
• Project includes extracting, transforming, loading data from ERP database in OLAP cubes.
• Implementation ofSQLServer Analysis Services, design/change/deploy OLAP Cubes.
• Security fixes. Implementing database standards and naming convention for the database objects.
• Involved in Migration of Databases from SQL Server 2012 to SQL Server 2014 using SSIS 2014.
• CreatedSQLScripts for data loads and upgrades for data migrations and data validations.
• Developed and scheduled DTS packages for each system Interface usingSQLcode in combination with VB ActiveX scripts and built-in DTS transformations.
• Worked on Data Driven Subscription Tables for Quarterly Reports, Monthly Reports as well as Daily Reports.
• Identified and added the report parameters and created the reports based on the requirements using SSRS.
• Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
• Wrote custom tasks using C# within SSIS to enhance processing of both Excel and flat-files intoSQLServer.
• Built and published customized interactive dashboards utilizing Excel Power BI.
• Expertise in writing performance MDX, DAX queries against cubes for SSRS datasets.
• Extensively used DAX patterns and design patterns for configuring Currency calculations, snapshot measures, time series calculations.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact, and Dimension tables.
• Created very complex SSIS Packages with considering all the best practice like error handling, logging, configurations, deployments, maintenance.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using MDX.
• Created complex Stored Procedures, Triggers, Cursors, Tables and otherSQLJoins and Statements for Applications by using T- SQL.
• Involved extensively in designing of OLTP database.
• Created schemas, keys and indexes considering the granularity of the data.
• Designed Data flows, Workflowsand jobs to load data from source to target in BO Data Integrator.
• Iteration planning for new features and user stories in Agile Development methodology.
• Deployed SSIS packages and Reports to Production Servers.

Environment: SQL Server 2008 R2/2012 (SSIS, SSAS, SSRS), MDX, T-SQL, Teradata, SQL Server Analysis Services, EDI, SQL Profiler, VSS, MS Excel 2010, MS Word 2010, Power point 2010, Netezza database, Crystal Reports.

Confidential

SQL Server/ BI Developer

Responsibilities:

• Designed Dashboards with all kinds of charts (Gauges, Bar/Line charts, Maps, heat maps, Area charts). Designed ad-hoc reports, grouping and sorting using SSRS.
• Involved in designing sub reports and linked reports depending on the user requirement and to limit the number of Data Sources.
• SSRS reports to SharePoint Server for the end users to look at them.
• Created SSIS packages to transfer data from various sources like Oracle 10g, Excel, flat files into SQL server using different SSIS components and used dynamic configuration files and variables for production deployment.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Worked on creating calculated measures that fits business logic, using MDX queries.
• Handling Initial and Delta loads and processing Cubes (Star Schema) across all environments.
• Worked on Key Performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS) involved in designing Data Marts.
• Wrote stored procedures for all the Database Interfaces, created user defined functions, constructed triggers, tables, views, indexes and user profiles.
• Developed Windows User Controls using Win forms controls and custom controls using c#.
• Configured application settings using the Configuration files.
• Consumed and created XML Web Services.

Environment: MS SQL Server 2000/2005, T-SQL, DTS, Oracle 8i/9i, TOAD, Micro strategy, Microsoft Visual Source Safe, MS Visio 2007, MS Projects 2007(v12.0)