PROFESSIONAL SUMMARY:

• Having 7+ years data processing and business development experience.
• Responsible for developing and implementing corporation - wide content strategy including content creation and management, social media, content engagement and voice-of-the-customer programs.
• Defines content policies and processes including content curation, creation and partnerships. Created the business plan for and directs the strategy and content for all digital properties.
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS and T-SQL Programming using DDL, DML, DCL commands for various business applications.
• Created various INetsoft reports involving variety of features like Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parameters etc.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Excellent verbal and written communication skills combined with strong interpersonal and conflict resolution skills and possess strong analytical skills.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans.
• Experience in conversion of packages from legacy systems (DTS SSIS) and migrating, deploying the packages across Dev/UAT/Prod environments.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Created various INetsoft reports involving variety of features like Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parameters etc.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Excellent verbal and written communication skills combined with strong interpersonal and conflict resolution skills and possess strong analytical skills.

TECHNICAL SKILLS:

Operating systems: Windows 98/NT/2000/XP/Vista/Windows7/8

Databases: MS SQL Server 2000/ 2005/2008/2012, MS Access SQL Enterprise Manager, SQL Profiler, DTS Import/Export, SQL Client: Configuration utility, Backup Server, OLAP Services, SQL Server Management

Database Tools: Studio, SQL Server Business Intelligence Development Studio (BIDS)

ETL Tools: DTS, SQL Server Integration Services, SQL Server Analysis

Reporting Tools: INetsoft Reporting services

Development Skills: Transact SQL (T-SQL), PL/SQL, Stored Procedures, Triggers

Application Packages: Microsoft Office Suite

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Business Data Analyst

Responsibilities:

• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Involved in entire Software Development Life Cycle of multiple projects related to healthcare.
• Developed complex T SQL code for Customer Imports and other interfaces for the PAT and Portal.
• Modified the existing database by adding the tables and maintained relationships between the tables.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of schemas.
• Performance monitored & optimized webapps for slow performance and most expensive user queries using SQL coding best practices
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services 2012.
• Developed strategies for content delivery via smartphone apps. Launched and managed websites. Reported to the CEO and rapidly increased level of responsibility within first 6 months.
• Collaborated with executive team to define product vision and user experience for 4 smartphone apps and earned a reputation as a creative problem solver.
• Orchestrated marketing, PR, and content strategy for the successful launch of 3 smartphone apps,
• Scoped and delivered numerous web projects, including the redesign of aro.com; managed external vendors and delivered on time and within budget.
• Delivered well-received talks and workshops at conferences.
• Developed content architecture and strategy for apps and websites, resulting in delightful user experiences.
• Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.
• Experienced in implementation of strong referential integrity and auditing by the use of triggers. Environment: Windows 2008, IIS, SQL Server 2014, MS SQL Server 2005/2008/2012, T-SQL, Office, Visual Studio, Database Engine Tuning Advisor, SQL Server Management Studio, SSIS, SSRS, SSAS.

Confidential

Sr Business Data Analyst

Responsibilities:

• Served as collaboration ambassador; improved employee engagement and internal collaboration by 73% through blogging and other content marketing strategies as a result
• Performance monitored website runtime and webapp efficiency.
• Created tables with Cluster/Non-Cluster Index, Stored Procedures, and Triggers; programmed and designed reports off transactional databases
• Monitored performance and optimized SQL queries; and created and modified T-SQL stored procedures.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults user defined data types and functions
• Scheduled batch jobs; ran daily SSRS reports
• Designed Reports that had complex SQL, PL/SQL code and stored procedures using Reports 10g.
• Tracked and resolved issues of JIRA Issue Tracking System application with multiple features and capability like data upload, work flow, various reports, dashboards and filters that enable to get data for required criteria.
• Created tables with Cluster/Non-Cluster Index, Stored Procedures, and Triggers; programmed and designed reports off transactional databases
• Oracle.
• Responsible for maintaining and documenting intellectual property while serving as SharePoint content owner.
• Monitored performance and optimized SQL queries; and created and modified T-SQL stored procedures.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL

Environment: SQL Server 2005/2008/2012, T-SQL, Windows XP, Visual Studio, Report Builder, SQL Profiler, SSIS, SSRS, SSAS.

Confidential

Business Data Analyst

Responsibilities:

• Shared ideas which are used to solve issues and grow company.
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Created OLAP Cube from Staging Database Tables using SQL Server Agent.
• Collaborated with clients (ING-Spain and Westpac) to gather Business Requirements for customizing Knome; customized versions of the application are now used by Westpac and ING respectively.
• Involved in Performance Tuning, Indexing, Query Optimization.
• Performed Extract, Transform and Load (ETL) process using SQL Server Integration Services (SSIS).
• Used various Control flow items for each loop, for loop and Data Flow transformations data conversion, conditional split, multicast, derived column, lookup, sort, union all, Merge, Merge join etc.
• Implemented check point configuration, package configuration in packages for better reusability.
• Involved in creation of the package and was responsible for moving the package from development server to production server.
• Implemented Performance Tuning at various levels.
• Used UTL FILE built-in package to generate files as per the requirement.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.

Environment: SQL Server 2008R2/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), XML, MS Visual Source Safe and Windows Server 2003

Confidential

Business Data Analyst

Responsibilities:

• Technical documentations, business requirement gathering & recommendations for technical issues.
• Active in overseeing key projects while serving as project manager for global communications team; helped to establish and document best practices for key processes as a result.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Displayed excellent presentation skills while hosting 7 strategic planning meetings.
• Experience in Deploying and scheduling the Packages.
• As per the requirements develop the reports in the form of Table, Matrix, and Chart using Sql Server 2008 reporting services.
• Adding parameters and filters while building advanced reports.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• As per the requirements, rendering the reports in the form of PDF, XML and CSV formats.
• Primarily responsible for developing applications in SSIS as per Business Rules and features of the tool.
• Implemented check point configuration, package configuration in packages for better reusability.
• Scheduled the ETL Package (Monthly) Using SQL Server 2005 Management Studio.

Environment: T-SQL, SSIS, SSRS, SQL Server and Microsoft Visual Studio, OLTP, ETL, XML, Windows XP.

Confidential

Business Data Programmer

Responsibilities:

• Provided backend support for customer complaints municipality database.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts and Decision Support Systems (DSS) using Multidimensional and Dimensional modeling (Star and Snowflake schema) Concepts.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Developed SSIS packages with various tasks like - FTP, file system, for-each-loop, execute package, data flow task, execute SQL task, custom script task, analysis services task, data mining task.
• Database Maintenance, Replication, Tuning, System Database Migrations and Maintenance
• Perform database administration tasks including; Installation, Configuration, Upgrades, Capacity Planning, Performance Tuning, Backup and Recovery.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Identified and worked with Parameters (e.g. cascading parameters) for parameterized reports in SSRS.
• Create Stored Procedures, Triggers, Tables and Indexes for MSSQL 2005
• Perform database maintenance tasks which includes Rebuilding and Reorganizing Indexes, Updating Statistics as well as running Integrity Checks (DBCC)
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Developed various T-SQL stored procedures, triggers based on the requirement.
• Defined Check constraints, Business Rules, Indexes and Views.
• Involved in tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard. Environment: T-SQL, SSIS, SSRS, SSAS, ODS, SQL Server and Microsoft Visual Studio, Data Marts, XML, EDW, Windows XP.