SUMMARY

• 7+ years of experience with Full Development Life - cycle of Data Warehouse and Business Intelligence Solutions, including requirement gathering and analysis, data modeling, data analysis, data profiling, data cleansing and quality tracking, implementation, testing, maintenance, support and documentation.
• Proficient with RDBMS databases including MS SQL Server, Oracle, MS Access and MySQL.
• Defined data warehouse (star and snow flake schema), fact tables, cubes, dimensions, measures using SQL Server Analysis Services (SSAS).
• Extensive experience in acquiring requirements, creating and deploying reports using SQL Server Reporting Services (SSRS) and Business Intelligence projects.
• Experience in Conceptual Data Modelling, Dimensional Data Modelling, Logical Data Modelling, Physical Data Modelling, Enterprise Data Warehouse (EDW) Design, Data mart Design, Metadata and Master Data Management.
• Extensive experience of MS SQL Server development in Logistics, Healthcare and Real Estate with expertise in MS SQL Server 2005/2008/2008 R2 and 2012 suite of products like SSIS, SSAS, and SSRS.
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server .
• Business Intelligence, Data Warehouse, Data Visualization. SSRS, SSIS, SSAS, T-SQL, PL/SQL, SSMS, MS Access, Crystal Report,
• Well versed with teh knowledge of RDBMS, data warehousing me.e. OLTP & OLAP systems.
• Highly Experience in T-SQL (DDL, DML), documentation, coding, programming and using SQL Server 2000/2005/2008. Used Version control tool Team foundation server (TFS) for teh entire development cycle.
• Expertise on various manual testing types like System testing, Regression testing, Functional testing, UAT testing etc. Experienced in Database design, development, unit testing and Implementation.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data using Tableau Desktop 9.0.
• ETL/SSIS Hands-on experience using Business Intelligence technologies to implement data integration, data warehousing, analytics, reporting and dashboards.
• Integration Cloud applications with traditional Data Warehouse Applications.
• Creating dashboards using groups, sets, parameters, calculated fields and hierarchies using Tableau Desktop 9.0.
• Experience in working with Tableau Server 9.0 to deploy and publish teh report and experience in creating groups and user and manage them.

TECHNICAL SKILLS

Database: MS SQL Server 2014/ 2012/2008/2005 , MS Access, Oracle 11g/10g, Mongo DB, Power BI stack.

Programming Languages: T-SQL, PL/SQL, C, HTML, DHTML, XML, VB.NET, C#.Net

Framework: Microsoft .Net Framework 4.0/3.5/3.0

ETL / Reporting Tools: SQL Server Integration Services (SSIS), SSRS, Data Transformation Services (DTS), Informatica ETL, Tableau, Cognos.

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development studio, Enterprise Manager, SQL Profiler, Query Analyzer, Import & Export (DTS)

Database Tools: SQL Server Management Studio, SQL Developer, Toad

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash

Operating Systems: Windows 2008, 2003R2, 2003, 2000 Advanced Server, Windows XP, Windows Vista, Windows 7

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Database Engineer

Responsibilities:

• Create calculated measures associated with various dimensions according to user specifications dat drill down within teh Excel, SSRS, SSAS and SSMS interfaces.
• Worked on SQL Azure. Design and develop OLAP cubes used for reporting.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging toDatawarehouse using Fore Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Use T-SQL to write named queries for ETL purposes inside data source views.
• Use SSRS to write custom reports in accordance with user specifications. Use Excel, Excel Services, Pivot tables and Power Pivot to create reports and interactive self-service bi reporting tools.
• Create stored procedures using SSMS and SQL. Used Team Foundation Server (TFS) for central repository as a versioning control.
• Designed high level ETL/SSIS architecture for overalldatatransfer from teh OLTP toData warehouse with SSIS and also prepared ETL/SSIS mapping processes and maintained teh mapping documents.
• Created Web Application using Vb.Net to show Dashboard which takes input Confidential run time from end-user.
• Created Test plans and Test cases for objects based on teh use case prepared for logical data modeling.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS).
• Worked with teh BI (Tableau) offshore team and business partners to validate rules regarding data integrity and data quality.
• Designed and wrote teh entire ETL/SSIS process to support Real-Time Data Warehouse with complex dependencies including scheduler, SSAS cubes (Multidimensional and Tabular), SSRS reports, complex SSIS packages, multiple SQL stored procedures (T-SQL) and triggers.
• Performed tuning of large databases, performance optimization (SQL Server, Redshift), database partitioning, and ETL/Query optimization.
• Was responsible for a parallel conversion DW Star schema MS SQL Server 2012 to AWS cloud S3/Redshift DB.
• SQL data Base migration to Azure SQL Data Warehouse.
• Development of enterprise dashboards, reports, KPI and metrics using Tableau and SSAS.

Environment: SQL Server 2012/2008R2, Access. Excel, Power BI, Azure, Tableau, Server Integration Services 2012, Redshift DB, SQL server Reporting Service 2012, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, ERWIN 7.2, C#.

Confidential, Salem, NH

SQL MSBI Developer/ETL/Tableau Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding teh functional work flow of information from source systems to destination systems.
• Created visualizations inTableauusing Excel data extract source.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Identified teh dimension, fact tables and designed teh data warehouse using star schema.
• Created volatile tables and partitioning teh tables and Responsible for supporting existing projects.
• TEMPEffectively used data blending feature in Tableau.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Wrote custom queries against SQL databases while using Tableau and Excel for visualization.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for teh Application.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Created detailed reports in Tableau and SSRS based on business requirements including utilizing SQL views and SQL stored procedures.
• Created Data-driven Packages in SSIS as part of Referral Process.
• Identified Data Source and Data Source Views CUSTOM Mappings for ETL.
• Developed, deployed and monitored SSIS Packages for new ETL Processes.
• Migrated data from Heterogeneous Data Sources to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Generated periodic reports based on teh statistical analysis of teh data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports. Used cascaded parameters to generate a report from two different Data Sets.
• Created Mock Up screens using MS Visio for better visualization and understanding of teh software application & reports for business stakeholders (such as sales, marketing, finance & customer services), team members & company client.

Environment: SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), T-SQL, C#, .Net framework, XML.

Confidential, Dallas, TX

Data warehouse/ETL developer

Responsibilities:

• Teh project involved data modeling and designing of Data Warehouse and monitoring teh SSIS packages to upload data from teh staging to DW and generating reports using SSRS.
• Designs, Develops and Maintains an Enterprise Data Warehouse (EDW) - a business centric data model and data dictionary leveraging both internal and external information systems, provide relevant data elements for Executive Dashboard, KPI, Strategic Reporting & analytics as well as Daily Operational reports.
• Created BI Reports and Analytics project and configured teh database instance to point to anAmazonRed Shift data warehouse. Fine-tuned VLDB properties to optimize query performance and compatibility with teh server and teh data warehouse
• Over haul current EDW architecture and provide propose for improvement.
• Develop and maintain corporate metadata repository. dis includes Source to Target mapping document and ER Diagram.
• Provides guidance/assistance toBI development teamin teh design of database solution and data modeling best practices
• Supports teh strategic move to an expanded use of user driven ad-hoc query and reporting.
• Manage teh database architecture, including ensuring teh consistency of: data attributes, naming conventions, element value types (data cleansing)
• Working closely with Business and Business Analyst to gather requirements and turn them into technical specification.
• Heavily involve doing analysis to understand source data prior integrating into existing or new EDW.
• Develop, test, and implement Extraction, Transformation and Loading (ETL) processes from external and internal
• Design, maintains, monitors, and tunes ETL loads Enterprise Data Warehouse to ensure Enterprise reporting systems available for accessing earliest daily possible.
• Optimize performance of teh data warehouse by creating data archiving process.
• Perform capacity planning, monitoring data warehouse growth and processor usage
• Maintain quality of data in teh warehouse, ensuring: integrity of data in teh warehouse and correcting any data problems by implement Source & Target data validation process
• Successfully lead and implement teh migration of over 10 data mart with no interruption of business.
• Act as Key architect/modeler of Enterprise Data Warehouse (EDW)
• Provide 24/7 production support.

Environment: s: SSIS/ETL, SQL Server, T-SQL, .NET, Tableau MDX, DAX, oracle 10g, PL/SQL, windows NT.

Confidential, AUGUSTA, GA

Software Engineer / BI Developer

Responsibilities:

• Participated in Business Intelligence development lifecycle including dimensional fact model (DFM), logical, physical, ETL design for multidimensional data warehouse (Strategic Margin Initiative System) and multiple SSAS cubes.
• Provided technical leadership for large-scale database projects.
• Ensured development using industry-standard code guidelines and best practices.
• Participated in all of Software Development Life Cycle, starting from requirements, design, maintenance, enhancement, coding, and administration of SQL servers
• Worked to meet data requirement deliverables and integrations through advanced SQL queries and SQL scripts, as well as stored procedures and triggers.
• Co-ordinated with other architects to deploy database related changes to development and production environments. Designed and wrote teh entire ETL (SSIS) process to support Real-Time Data Warehouse with complex dependencies including scheduler, complex SSIS packages, multiple SQL stored procedures and triggers.
• For multiple SSAS cubes Designed: Partitions, Aggregations, Locking, Attribute relationships, Optimized Parent/Child and multiple many-to-many dimensions.
• Generated SSAS deploying scripts for executing in production. Utilized Backups of Analysis Services databases for reducing recovery times. For near real-time cube requirement optimized large ROLAP cubes.
• Measured application performance and provided suggestions for tuning and improvement to teh OLAP and OLTP systems.
• Provided customers with services dat measured application health and provided risk mitigation for areas Confidential risk.
• Implemented Table-based partitioning features to provide flexibility, performance and efficient concurrent updates.
• Designed and wrote teh entire ETL process with complex dependencies including scheduler, complex SSIS packages and multiple SQL stored procedures.
• Converted Large DataMart from SQL 2005 to SQL server 2008 and tuned large SQL queries.

Confidential, ALPHARETTA, GA

Data Base developer

Responsibilities:

• Senior database developer responsible for teh development of custom database applications using SQL Server, MS Access and VBA, as well as maintenance and enhancement of legacy applications.
• Solely responsible for all aspects of projects from gathering requirements, designing, coding, testing, documenting, implementing, training, support and maintenance of applications.
• Wrote stored procedures, views, triggers and functions in support of teh applications.
• Database design including table design, normalization, triggers, views, indexes and user defined functions.
• Wrote complex business reports using T-SQL stored procedures and views, MS Access, Reporting Services and Crystal Reports.
• Senior DBA providing 24/7 production support. Developed and implemented a backup and recovery plan. Responsible for all database maintenance and good health plans. Ensured database consistency. Monitored database growth and capacity planning.
• Responsible for performance tuning and query optimization including index creation. Resolved blocking/deadlock issues. Used profiler to analyze teh system load and improve database efficiency.
• Set up security, created groups, user defined roles, logins and granted permissions in SQL Server 2000 and SQL Server 2005.
• Responsible for SQL Server installation and upgrades.
• Used DTS/SSIS to import and transform data from various sources into SQL Server databases.

Environment: SQL Server 2005, SharePoint 2007, .NET, Windows XP, Excel, XML, DB2, Oracle, Reporting Services(SSRS), Integration Services(SSIS)