SUMMARY

• A passionate result - driven Data Analyst, Business Intelligence Developer and MS SQL Server Administration&Azure Service Engineer having 8+ years of software industry experience. Passionate about technology, extensive business insight, consultative and analytic skills to assist in achieving strategic objectives.
• Experience in Microsoft Business Intelligence technologies: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• 3+ Years of Tableau Visualization.
• Experience in designing Tableau Dashboards to help business get insights from the data.
• Implementing ETL's via SSIS by creating packages along with logging reports and then schedule using SQL Server Agent.
• Experience in designing SSIS and Packages for integrating data using OLEDB connection from heterogeneous sources (JSON, Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Multicast.
• Debugging SSIS packages scheduled on SQL Server Agent when they fail during production.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring SSIS sessions as well as performance tuning of mappings and sessions. Experience in User Defined Functions (UDF), Database Triggers, using tools like SQL Profiler and Database Tuning Advisor (DTA).
• Used SSIS Checkpoints, property expressions and variables to customize data processing.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables
• Performs analysis on the given data and draws accurate inferences, in accord with the Business objectives and explores the ‘why’ behind the trends. Deep knowledge on business functionality blended with solid management and technical skills.
• Strong working knowledge of Excel, PowerPoint, Visio, SharePoint Designer, ER/Studio
• Experience in Supporting large scale analytical platforms at least 5000+ users
• Experience in Designing Data Mart and Data Warehouse using Star Schema and Snowflake Schema in implementing Decision Support Systems. Ability to quickly stage & shape data from data warehouses into reporting and analytics solutions.
• Exceptional team-management, leadership and communication skills coupled with the technical and functional proficiency required to successfully oversee and complete challenging IT development projects.
• Excellent program/project management, interpersonal and business communication skills with the experience required to remain highly focused and self-possessed in fast-paced, demanding environments.
• Experience in SharePoint 2013, Windows PowerShell, SP Administration.
• Experience working with different configuration management systems like TFS, SVN, GIT.
• Worked across different domains & multiple portfolios and have gone through all the SDLC phases in my service.

TECHNICAL SKILLS:

Reporting: Advanced Excel functions, SSRS and Tableau.

DBMS / RDBMS: SQL Server Administration, T-SQL, SQL Server Analysis Services n-dimensional, Tabular, SQL Server Reporting Services, SQL Server Integration Services(SSIS), DAX and MDX.

Administration: Windows Server Administration, SQL Server Administration, IIS Administration, SharePoint Server Administration.

Programming Languages: C#, JavaScript.

Configuration Management: TFS, GIT, SVN.

Scripting: PowerShell, VBScript.

Project Management: Agile methodology, Waterfall model

PROFESSIONAL EXPERIENCE:

Confidential

Senior Business Intelligence Developer/Analyst.

Environment: SQL Server 2016, SSIS, Excel 2016, DAX and MDX, ER Studio, Visual Studio 2016.

Responsibilities:

• As a part of global supply chain, I was involved in integrating Change Point one of the 40+ data sources for Unity Reporting end to end from Acquire jobs, Integration layer & jobs.Data mart including cube / tabular changes and Reporting Changes and Excel 2016 built dashboards & scorecards and reports, which includes 700 + SSIS packages.
• As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of BI Analytics needs.
• As a scrum master, responsible for conducting daily scrums and followed agile Processes of sprint planning and backlog grooming.
• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Performed T-SQL query optimization and tuning tasks to enhance performance in daily data processes of large external and internal data files and data tables.
• Developed and tuned Stored Procedures for optimum performance that are used in the daily data processing.
• Designed, developed and implemented Tableau Business Intelligence reports.
• Created multiple visualization reports and dashboards by usingTableau.
• Analyzed data from various databases and formatted it into graphs using Tableau Desktop.
• Involved in creating SSIS packages with various transformations like Slowly Changing Dimensions,Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Generated and Deployed ETL SSIS packages both design and code to process data to target databases.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases and process SSAS cubes.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables.
• 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.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.

Confidential, Margate, FL

BI Developer/ MS SQl Server Developer

Environment: SQL Server 2012/2014, Report Builder SSRS, SSIS, SSAS, Excel 2016 add-ins PowerPivot.

Responsibilities:

• Was involved in analyzing Microsoft’s revenue amounting and reconciliation of Actual receivables numbers. Partner with a multi-functional team to create systematic approach to reporting and analysis of credit services reports
• Drive financial process improvement to help credit managers to resolve credit risk, credit dispute and any delays caused in data process ETL’s.Develop and improve robust analysis and reporting tools and methodologies resulting in greater understanding of revenue flow, international exchange cash flow. Support Business by generating ad-hoc reports from multiple corporate datasets with Microsoft Analytics Reporting tool MSRA
• Set up meeting with key stakeholders from different departments to gather, analyze, and determine data and information requirements in support of the Data & Analytics roadmap, as well as business-as-usual requests.
• Analyze and resolve data load using (ETL-SSIS) issues from different data sources
• Performed T-SQL query (Stored Procedures) optimization and tuning tasks to enhance performance in daily data processes of large external and internal data files and data tables using ETL processing.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
• Designed ETL(SSIS) packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) 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 SSIS.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS.
• Designed, developed and implemented Tableau Business Intelligence reports.
• Created multiple visualization reports and dashboards by usingTableau.
• Maintain and support SQL Server database server and hosting - monitor SQL Server connectivity and performance, user session timeouts, load time.
• Worked closely in developing the detail design document and presenting to the client and implementing their feedback on a weekly basis.
• Perform data warehousing, relational database and dimensional database modeling maintenance and support tasks
• Assist business units with several types reports Dashboard, scorecards, Report builder, MSRA
• Proactively looks for new ways of introducing process improvement in all aspects of the SDLC
• Test the code&document the changes and monitor the deployments in different environments.
• Provide technical assistance and cross training to other team members within the team
• Communicates at all levels as a key factor for success utilizing technical documentation, emails, meetings and client updates.
• Work on data control validation for different data sources to destination and provide resolution and RCA on completeness for accounting document number, currency code and company code and perform reconciliation between the source and destination numbers.
• Coordinate with Audit teams to clarify the data processing queries related to sales and revenue.

Confidential, Portland,OR

Service Engineer/BI Developer (SSIS, SSRS, SSAS).

Environment: SQL Server 2012/2014, Report Builder SSRS, SSIS, SSAS, Excel 2016

Responsibilities:

• Service Engineer role in BI-PLATFORMs is to own some set of applications ensuring no downtimes and smooth functionality at any point in time.
• Providing anytime assistance in case of any downtimes or SQL issues for the applications on boarded.
• Performed T-SQL query (Stored Procedures) optimization and tuning tasks to enhance performance in daily data processes of large external and internal data files and data tables using ETL(SSIS) processing.
• Perform data warehousing, relational database and dimensional database modeling maintenance and support tasks
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) 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 SSIS.
• Scheduled Server patching, Server upgrading, migrating applications in clustered environments, keeping all the systems updated by testing on the new upgraded versions of SQL & windows server products.
• Coordinating with multiple source teams, Data protection management and Server support teams to get rid of any processing or infrastructure challenges during financial year end period.
• 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.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Worked on the Reports module of the project as a developer on MS SQL Server 2012 (using SSRS, T-SQL, scripts, stored procedures and views).
• Direct and independent interaction with the client and getting the requirement on application deployments, stay current activities, frozen servers, server mapping.
• Leading triage discussions to understand customer issues, analyzing them, understand root cause and delivering solutions.
• Taking accountability and ownership of delivering the deployments and commitments
• To determine customer pain points and drive improvements in quality of service
• Ensure issues are identified, tracked, report and resolved and timely manner
• To work on Test, UATand production deployments.

Confidential, Jacksonville, FL

MS SQL Server/ L3 support engineer/BI Developer (SSIS, SSRS.SSAS)

Environment: SQL Server, Windows Server 2012, C#, SQL Server integration services(SSIS), SQL Server reporting services(SSRS), Analysis services(SSAS).

Responsibilities:

• Direct and independent interaction with the client and getting the requirement on application deployments, stay current activities, frozen servers, server mapping.
• Leading triage discussions to understand customer issues, analyzing them, understand root cause and delivering solutions.
• Created Complex Stored procedures, user defined Functions, Schema Binding Views.
• Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Involved in Query optimization and tuning stored procedures for better performance.
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Created SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data
• Worked on ETL(SSIS) design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables.
• Identified and worked with parameters for parameterized reports in SSRS in SQL Server 2012.
• Worked closely with internal customers analyzing problems and to create and maintain reports, maintaining SSRS Reports and ad-hoc SQL scripts.
• Developed Multi-Dimensional Objects (Cubes, Dimensions).
• Efficiently helped in the Software Development Life Cycle (SDLC) processes specifically waterfall and Agile Scrum methodology including Analysis, Design, Programming, Testing and technical Documentation.
• To work on SQL Server IPAK installation, server upgrades, database migrations.
• To work on Test, UAT, PPE and production deployments

Confidential, Nashville, TN

MS SQL Server Developer/BI Developer

Environment: Windows Server 2003, ASP.NET, SQL Server 2000, ASP, JavaScript, SQL Server 2000, and Crystal Reports

Responsibilities:

• Created SSIS packages to load data into SQL Server using various transformations in SSIS.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS and designed reports using Crystal Reports. Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2012 database and performed tuning and audit analysis on it.
• Migrated database from SQL server 2008 R2 to SQL server 2012 using utilities i.e. exporting/importing and attach/detach for SQL servers 2012 features.
• Involved in developing SSRS reports using T-SQL.

Confidential

RoleSoftware Engineer

Environment: Windows Server 2003, VB.NET, C#, ASP.NET, SQL Server 2000 and Crystal Reports

Responsibilities:

• Querying with Transact-SQL.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.