OBJECTIVE

• An Organized and creative professional with proven skills and a desire to learn more. Gained expertise in Integrations, reporting and Data Analysis. Currently looking for a position with an organization where I can utilize my existing skills set and knowledge to increase company profitability.

SUMMARY

• Over 8 years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2000/2005/2008 R2/2012, SSIS, SSRS and SSAS.
• Experienced in Installing, Upgrading and Configuring Microsoft SQL Server.
• Extensive experience working in various domains like Financial, Banking and health care Sectors.
• Experience in Database Development, modeling, Data Warehousing, Design and Technical management.
• Experience in creating complex SSIS packages using proper control and data flow elements ts for complex data warehouse in SQL Server Integration Services (SSIS).
• Good Experience in creating Tabular and Multi - Dimensional modeling using star and snowflake schemas in SQLServer Analysis Services (SSAS).
• Expertise in creating various type of reports, Charts and dashboards using SQL Server Reporting Services (SSRS).
• Experience in Creating MDX for querying in multidimensional cube and DAX formulas to create measures in SSAS
• Experience in complex dashboards, reports and visualization on Tableau.
• Experience in creating dashboards, scorecards and building reports using performance point server
• Supported team in resolving SQLReporting services and T-SQLrelated issues.
• Automated SSIS Packages by generating batch scripts.
• Wrote Complex SQLqueries for verifying data integrity in Dimension and Fact tables and created and have In-depth knowledge in various RDBMS concepts.
• Designed dimension and fact tables using Ralph Kimball methodology.
• Worked on complete Software life-cycle (SDLC) projects including Design, Analysis, Development, Quality Testing and deployment.
• Developed test plans, test cases and test scripts for Dimension and Fact Tables.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Key.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation skills with a strong desire to achieve specified goals.
• Experience in SSIS (SQL Server Integration Service) package design, constructing, and deployment.
• Hands-on working experience in populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Excellent in creating SSIS Packages from multiple sources Excel, CSV, flat file, Text Format Data by using multiple transformations provided by SSIS.
• Worked on SSIS Script component using Visual Basic Applications, VB.NET and C#
• Extensive knowledge of using System and User-Defined Variables, creating Property Expressions, Script Tasks for SSIS Packages.
• Extensive experience in creating Jobs, Alerts, SQLMail Agent, and automating SSIS Packages.
• Extensive knowledge of using Package Configuration wizard to configure SSIS packages.
• Wrote Complex Queries from the Control flow using SQL Execution Task.
• Used multiple Transformations like Aggregate, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Multicast, Percentage Sampling, Slowly Changing Dimension, Pivot and Un Pivot Transformations etc.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert and Data Replication in SQLServer Integration Services (SSIS).
• Experience in SQLServer Analysis Services (SSAS) CUBE design, development and deploying
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Experience in Creating, Modifying Cubes, Measures, Dimensions, Attribute relationships and Hierarchies.
• Experience in MDX to create Named Sets, Named Members, Calculated Members and other calculations.
• Created DAX formulas to create measures in SSAS
• Worked on OLAP Storage modes in dimension tables like ROLAP/ MOLAP/ HOLAP. worked on deploying SSAS package to different environments.
• SSRS and other Reporting Experience (SSRS, Performance Point, Power View):
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports using SQLServer Reporting Services (SSRS).
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Created various expression and complex calculations based on the required data in SSRS.
• Experience in creating dashboards, scorecards and building reports using performance point server 2007 and deployed the report in SharePoint 2013
• SQLServer Experience (SQL Server, DB2):
• Good knowledge in RDBMS concepts, Data warehousing concepts, Data Modeling (Logical and Physical Design of Databases), OLTP & OLAP.
• Expert in all areas of SQLServer development including tables, user defined functions, views, Indexes, CTE (Common Table Expression), stored procedures, triggers, clustering, constraints Good experience on Writing Transact SQL(T-SQL) Queries for implementing Stored Procedures, Functions, cursors and views.
• Good knowledge of Scheduling Jobs and Alerts using SQLServer Agent.
• Created linked servers to retrieve the source data from different environments.
• Experience in developing dashboards pertaining to KPI monitoring using QlikView10.x.
• Developed complex QlikView scripts to build model, to support various KPIs and time comparison.
• Maintained Server for smooth QlikView development. Checked and updated environmental file, assigned task, path and triggers for QMC, QEMC.
• Created and Scheduled Weekly QlikView reports to distribute on email using NPrinting and publisher.
• Experience in developing Dashboards which were served to track inventory and sales as well as to monitor various KPIs. Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Experience in developing Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.

TECHNICAL SKILLS

Languages: T-SQL, SQL, HTML, C#SQLServer Tools Enterprise Manager, SQL Profiler, Query Analyzer, SSRS,SSIS,SSAS, Business Intelligence Development Studio, Data Transformation Services (DTS), Import Export Data

RDBMS: SQL Server 2000/20 /2014 , Oracle 10g/9i/8i

Applications: Microsoft Word, Microsoft Excel, PowerPoint, Access

Reporting Tools: MS Office 2003/2007, SQL Server Reporting Services 2005/2008/2012 , Tableau, Power BI dashboards, QlikView 10.0x

IDE’s: Eclipse, Visual Studio

PROFESSIONAL EXPERIENCE

Confidential, LA, CA

SQL Server SSIS Developer

Responsibilities:

• Gathered business requirements and analyzed and designed software solution for the Data migration from the Microsoft GP databases into the Warehouse and also to Windows Azure for AX Dynamics. Databases which will be used by application for POS systems and also linked to the AX Dynamics.
• Updated functional specification and technical design documents.
• Design pattern for the load process. Wrote Documentation for the designed packages.
• Created SSIS packages to extract data from OLTP to EDW systems and scheduled Jobs to call the packages.
• Designed SSIS Packages to transfer data from various sources like Excel Files, SQL Server using Business Intelligence Development Studio.
• Wrote T-SQL queries, Stored Procedures and used them to build packages.
• Designed, Developed and Deployed packages in SQL server environment using SSIS-2014. Using Visual studio 2012.
• Helped in the design of the Data warehouse model.
• Created cubes to feed the data for SSRS reports, which were earlier using only SQL server as the source for the data.
• Designed, modified and troubleshoot SSIS packages.
• Used SSIS to load data from various sources into on SQL Server 2014 database and created packages.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Involved in tuning and configuration of SSIS.
• Deployed SSIS packages from Development to Testing Servers for Covariance deployed the project in production.
• Debugging of SSIS packages by using data viewers and the audit logs generated with the Metadata.
• Designed and implemented event handlers, which are workflows that runs in response to the events raised by a package, task or container in SSIS.
• Involved in utilizing SSIS Checkpoint, Loading Dimension and Fact tables for Covariance
• Worked on Data Profiling in SSISand used Lookup component efficiently.
• Running and Scheduling SSIS Packages.
• For coordination among SQL developers used Team Foundation as the mean of communication.
• Created Dash boards using QlikView.

Environment: SQL Server 2014, SQL Server Integration Services 2014, SQL Data Tools 2014, T-SQL, SQL Query Analyzer, IIS (5.0), Visual Studio 2012

Confidential, SFO, CA

SQL Server SSIS/SSRS Developer

Responsibilities:

• Gathered and analyzed reporting requirements for the sales and marketing departments.
• Created complex T- SQL queries, stored procedures, functions, triggers, joins and SSIS packages.
• DevelopedSSIS 2012 Packagesto migrate data from Oracle, Access, flat files and Excel into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.
• Configured Database Mail for sending automatic emails when a SSIS package is failed or succeed.
• Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS.
• Formatted reports using Global Variables, Expressions and Functions for the reports using T-SQL in SSMS.
• Designed and developeddifferent type of reports including:Tabular forms, Matrix (crossTab report) form, Conditional, List items, Charts and Sub reports, Drill down reports..
• Experience in creating dashboards, scorecards and building reports using performance point server 2007 and deployed the report in SharePoint 2013
• Built data connection to the database using C#
• Used C# and vb.net to create script tasks in SSIS.
• Created various database objects in C#, Visual Studio and ASP.net and deploying them to the SQL Server 2005/2008.
• Configured Report Model for developing ad-hoc reports by the end-users.
• Uploaded reports on to the report manager and organized them into folders.

Environment: MS SQL Server 2008 and 2012, Windows Server 2008, SSIS, SSRS, SharePoint, Power Point Sever, T-SQL, C#, Vb Script, ETL, MS Access, XML, Excel, Visual Studio 2008, Visual Studio 2012, MS office 2007,outlook

Confidential, SFO,CA

SQL Server SSIS Developer

Responsibilities:

• Interacted with functional and technical leads, other business users to conduct meetings with business representatives for gathering the Finance Team’s Reports / Dashboards business requirements.
• Migrated data from SQL Server 2005 to SQL Server 2008.
• Developed Logical and physical data model and mapped the data into database objects.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Coordinated with front End developers using C#, understanding there methods and giving stored procedures accordingly for data retrieval and insertion.
• Used C# to write complex SSRS reports.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Prepared report using advanced formulas of Excel and summary of them using VBA and Excel
• Assess detailed specifications against design requirements.
• Prepared and updated dynamic and statistical reports and charts using advanced formulas of Excel and pivot table
• Experience with the Share point 2007 to upload the SSIS packages in to Web portal.
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.
• Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Environment: SSIS, SSRS, MS SQL Server 2005/ 2008, Visual studio 2008, MS Access, MS Excel, Outlook, SharePoint, T-SQL, C#, VB, Excel, MS Word, Powerpoint, Tableau

Confidential, Boston

SQL Server SSIS Developer

Responsibilities:

• Created and managed databases for clients as well as systems to provide import of client data, and reporting of finalized data.
• Created schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity and TSQL Scripting for complex business queries.
• Developed scripts to migrate data from multiple sources.
• Maintained the security, integrity and availability of SQL Server.
• Performed data backup, recovery, and transfer operations.
• Analyzed business recovery requirements and maintenance strategies and plans for critical databases.
• Database space management.
• Was Responsible for creating, deploying and scheduling new SSIS packages.
• Did Migration of the data from DTS to SSIS packages.
• Created reports using SSRS.
• Managed devices and databases, administered security, scheduled tasks, monitored server and database performance. Monitored allocation of memory and procedure cache, etc.
• Worked with the other IT associates to design, implement, test, and enhance stored procedures and other applications necessary to support systems and file processing.
• Designed, added, eliminated, and maintained indexes, organized tables, recommended changes to application development team.
• Appropriately tuned database applications and monitored their performance for achievement of efficient database access for applications.
• Performed data extraction and migration activities for populating test (or non-production) and customerdatabases.

Environment: SQL Server 2000/2005 Enterprise Edition, SQL Enterprise manager, MS PowerPoint, MS Excel, MS Access 2000 & Windows 2003/2000 platform, DTS, SSIS, SSRS.

Confidential

SSAS/SSRS Developer

Responsibilities:

• Created and managed databases for clients as well as systems to provide import of client data, and reporting of finalized data.
• Worked extensively in writing and debugging TSQL Scripting complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB.
• Experience with the Share point to upload the SSIS packages in to Web portal.
• Participated in requirement gathering, cube design, application design, SSAS development, training operational users.
• Implemented SQL Server OLAP services (SSAS) for building the data cubes.
• Creating complex cubes for seeing business data from different perspectives by slicing and dicing the data.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Collected and analyzed data from various systems using pivot table and vlookup prepared monthly financial reports to identify unapplied cash and credits and allocated money to outstanding invoices.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Designing and building data load procedures using MS SQL Server.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Configured product meta-data tables to support client data reporting needs.Incremental and full database recovery with experience of complex recovery scenarios.

Environment: MS SQL Server 2000/05, SQL Server Integration Services (SSIS), SSRS, SSAS, T-SQL, OLAP Services, MDX, Share point 2007, Windows 2003, MS Excel

Confidential

SQL Server SSIS/SSRS Developer

Responsibilities:

• Support the Debt Collection Application specifically application related Payment Imports and skip tracing of the consumer address information.
• Responsible for creating Summary reports, Sub reports, Drill Down reports, Matrix reports.
• Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS.
• Created ad-hoc reports using SQL server 2000 Reporting Services (SSRS).
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Cleaned, validated and consolidated address and demographic data from CSV and flat files using Access Query, complex lookup and text formulas of Microsoft Excel
• Prepared report using advanced formulas of Excel and summary of them using VBA and Excel
• Assess detailed specifications against design requirements.
• Prepared and updated dynamic and statistical reports and charts using advanced formulas of Excel and pivot table
• Knowledge of financial instruments such as making payments to the account after splitting them to the accounts based on the commission rates and the bucket levels.

Environment: SQL Server 2000/2005 Enterprise Edition, SQL Enterprise manager, oracle, MS PowerPoint, MS Access 2000 & Windows 2003/2000 platform, DTS, SSIS, SSRS, MS Excel