SUMMARY

• Over 12+ years of IT Management and Technical experience with focus on, Enterprise Applications, Team Leadership and strategic initiatives to drive organizational teams, customer relationship, IT operations, organizational support and business process improvement.
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in different type of reports including Tabular forms, Matrix (Cross /tab Report) form, Conditional, Drill down, Top N, Summary, List items, Charts and Sub Reports.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• In Depth Knowledge in Tableau Desktop, Tableau Server and Tableau Viewer, Business Objects Enterprise suite using Crystal Reports and Web Intelligence and Universe Designer.
• Expert in creating SQL Server Reports using SSRS 2012 in designing stylish report layout parameterized, performance, Chart Reports, ad - hoc reports.
• Experience in administrating teh created reports and assigning permission to teh valid users for executing teh reports.
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• Expertise in enhancing and deploying teh SSIS Packages from development server to production server.
• Expertise on data management methods and practices including Data modeling, Creation of Logical and Physical Data Models (LDMs/PDMs), Design of DW schemas, Re-engineering and reverse engineering, Data migration/ conversion with ETL tools and data warehousing.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Expertise in report writing according to teh business requirement in SSRS.
• Experience in Logical modeling using teh Dimensional Modeling techniques such as Star Schema and Snow Flake Schema. Experience in creating multidimensional cubes using SSAS (SQL Server Analytical Services) and OLAP (Creating Cubes) including interfaces with BIDS.
• Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Experience in enhancing and deploying teh SSIS Packages from development server to production server.
• Experience in managing and automating control flow, data flow, events and logging programmatically using Microsoft .NET framework for SSIS packages.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Strong analytical, administration and problem solving skills dedicated to maintain teh high quality standards. Good communication skills, ability to work independently.
• Developed and designed architecture for Business Intelligence (BI) applications
• Experience in Databases, Data warehousing, Business Intelligence and Corporate Performance
• Built Dashboards, Scorecards, Key Performance Indicators (KPIs), Cubes, decision-tree metrics
• Developed BI data marts and OLAP applications on SSIS, SSRS, SSAS, Tableau, Oracle BI suite
• Performed development & administration for MS SQL Server in multiple environments
• Experience in ETL workflows, database normalization, disaster recovery and capacity planning
• Experience in SQL Server optimization, upgrades, configuration and database performance tuning
• Optimized KPIs for business growth and Analytic /Predictive Forecasting / Reporting for sales

TECHNICAL SKILLS

Databases: SQL Server / 2005/ 2000, Oracle, MySQL, Sybase, MS-Access

Reporting Tools: Reporting Services(SSRS), Cognos, Business Objects, Tableau, QlikView

Business Intelligence: Analysis Services (SSAS), PowerPivot, Power BI, Performance Point Server

Data Modeling Tools: ERWin, ER-Studio, DB Visualizer,TOAD, Big Data stack

Data warehousing: SQL Integration Services (SSIS), Reporting Services (SSRS), Informatica

Operating Systems: Windows Server, MacOSX, Windows, iOS and Android

Programming: C, C++, Pascal, Visual Basic, ASP, PHP, MS.NET framework, Objective C

Project Management: MS-Project, MS-Visio, Team Foundation Server, Project Server, Excel

PROFESSIONAL EXPERIENCE

Confidential - Irving, TX

BI Architect/Tableau Developer

Responsibilities:

• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Wrote SQLscripts to transform/ load data in Staging environment
• Wrote SQL scripts and used SSIS packages to export/Export data
• Created complex Stored Procedures, functions, tables, temp tables, views and using T-SQL and PL/SQL.
• Created complex SSIS packages to extract data from Oracle, Hadoop and SQL Server sources.
• Created an ETL architecture, performed advanced lookups, transformations, created slowly changing dimensions, and execution of stored procedures.
• Developed SSRS 2012 reports and dashboards for Vendor management and Sales management by creating parameter driven interface, custom SQL.
• Developed Dashboards in Tableau for Sales, marketing information.
• Created visualization for Sales /procurement calculation and department spend analysis.
• Designed, built and tested SSAS Cubes on SQL Server 2008.

Confidential, Newark, NJ

BI Architect /Tableau Developer

Responsibilities:

• Wrote SQL scripts and used SSIS packages to export/Export data
• Created complex Stored Procedures, functions, tables, temp tables, views and using T-SQL and PL/SQL.
• Created complex SSIS packages to extract data from Oracle and SQL Server sources.
• Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Developed logical and physical data models, designed data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Created calculated measures and dimension members using multi dimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Gatheird user requirements, drafted specifications, designed, documented and wrote test script for testing of all teh report.
• Developed dashboards / Visualization using Tableau as per Business requirements.
• Designed databases for applications with requirements for large numbers of transactions, heavy access and high availability.
• Optimized T- SQL code.

IT Business Intelligence / Reporting

Confidential, Irving TX

Responsibilities:

• Research and analyze Enterprise Integration Software Systems and tools for NEC America
• Design, develop technical solutions to integrate B2B Microsoft BizTalk Server applications with Cisco
• Develop integrated ESB service layer to share data between PeopleSoft and Oracle CRM
• Identify Key Performance Indicators and build metrics for OLTP and OLAP systems for IT processes
• Analyze and Optimize internal and external IT systems, software and applications at NEC America
• Design and architect business intelligence and data warehouse solutions for NEC network operations
• Responsible for PMO strategic projects and implemented business processes for speedy delivery
• Reporting dashboard using Cognos and Tableau 8.0

Confidential

Responsibilities:

• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Used Query Analyzer to optimize SQL Queries.
• Generated reports from teh cubes by connecting to Analysis server from SSRS.
• Created Dimensions and facts tables
• Developed visualization using Tableau and SSRS
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Designed and created Report templates, bar graphs and pie charts based on teh financial/Sales data
• Created reports with Analysis Services Cube as teh data source using SQL Server 2005/2008 Reporting Services.

Confidential

Responsibilities:

• Involved in interacting with business users for requirements.
• Dashboard using Tableau for reporting.
• Responsible for translating teh Business requirements into technical specifications.
• Analyzed data flow and business requirements to create High Level Design document.
• Made use of teh aggregated tables on teh most frequently queried data for Monthly and Yearly based reports.
• Worked extensively with @functions (@aggregate aware (Aggregate Navigation), @select, @prompt, @where) in teh creation of dimensions, measures and conditions.
• Made use of alerts, filters and Breaks in teh reports.
• Used Database Delegation property for teh objects dat involves ratios or averages.
• Created hierarchies in teh universe for drilling down teh data from highest granularity to lowest granularity.
• Created Tableau dashboard using combined Queries, Slice and Dice, Drill Down, Cross tab and Master Detail Reports.
• Co-ordinated with teh Business users for teh UAT testing.
• Created teh Universe and report check list templates, which are used as check points before migrating teh objects to QA and Production environments.
• Worked on very tight deadlines and aggressively for teh completion of teh Project

Confidential

Responsibilities:

• Created project plan, WBS tasks for DBA, communicated to all stakeholders on potential impact and downtimes in advance to minimize business impact
• Conducted mock rehearsals with multiple teams for precise timing and scheduling of teh migration plan sequence
• Identified risks of delta transactions during migration period and mitigated them by appropriate DR plans and strategy with technical team members

Confidential

Responsibilities:

• Key responsibilities included integrating IT system functions, gathering requirements, analysis, defining project scope and communication executive sponsor approvals, create project plan and project schedule with WBS.
• Coordinated B2B tasks, weekly meetings, assisted in validation of parts feed, assessed data quality risks and completed UAT with stakeholders before going live.

Confidential

Responsibilities:

• Defined project scope and business requirements with all stakeholders, developing project plan and schedule with detailed WBS for each team member.
• Responsible for validating design, execution, coordination for B2B tasks, conducting review meetings, identifying risks, communicating risk status to stakeholders
• Led User Acceptance Testing (UAT) and completed project with business process documentation.

Business Intelligence Architect

Confidential, Dallas, TX

Responsibilities:

• Architect, design and develop BI systems and Data Marts for Enterprise Technologies
• Build enterprise dashboards, SSRS reports, Scorecard analytics for Datacenter Power Metering
• Build SSIS packages for ETL, data cleansing using fuzzy lookups and data transformations
• Identify and create specialized data center metrics for Capital Planning and Funding (CPF)
• Standardize best practices for BI multi-dimensional workflows and creating SSAS Cubes
• Consolidation of datamarts to EDW Enterprise Data warehouse to support DEV, STAG, PROD
• Database Performance Tuning of T-SQL code, Index Tuning, Stored procedures optimization

Environment: and Tools:SQL Server 2008, SSAS / SSIS/ SSRS, ProClarity, PerformancePoint 2007, Win Server 2008

Business Intelligence Architect -

Confidential, Plano TX

Responsibilities:

• Designed physical and dimensional database models for EDS Business Intelligence projects
• Developed OLAP cubes in SSAS 2005/2000 with appropriate dimensions, facts and measures
• Created Metrics and Key Performance indicators for tracking profits, costs, finance and revenues
• Built DTS/SSIS ETL packages to extract, transform, and consolidate data from data sources
• Built Account Summary reports using MS-Reporting Services for ASLAP project and ADAPT
• Designed, developed and published Reports using MS-Reporting Services 2005 and ProClarity
• Performed cube optimization and partitioning and usage-based optimizations based on client needs

Environment: and Tools:SQL Server Analysis Services (SSAS) 2005, Informatica, Erwin, SQL Server, DTS, Win 2003

SQL Database Consultant

Confidential, Irving, TX

Responsibilities:

• Maintained and developed SQL Server databases for Confidential .com and I2O eOrdering.
• Created and optimized Stored procedures and DBI layer code (database interface modules)
• Imported data from teh legacy systems like NOCV (West), DOE(North) and SSNS(South states)
• Built and deployed SQL Server scripts, batch files for code drops on SIT, UAT and production
• Loaded product data in Stage tables and mirrored data using Object Matrix and SQL replication
• Created database health-check test scripts to ensure consistency of data in all environments.
• Generated reports and scripts to track New Connect, Add Line, Add Feature and SAS orders

Environment: and Tools:MS SQL Server 2000, Windows 2000, Erwin, DB-Artisan, Visual source Safe, Visio