SUMMARY

• Around 6+ years of IT Experience in Database Design, Development and Business Intelligence of Microsoft SQL Server 2008/2012/2014 in Development, Test and Production Environments.
• Experienced in all phases of Software development life cycle (SDLC).
• Extensive design experiences in UML, using MS Visio focusing on Use Case diagrams.
• Proficient in creating UML Diagrams including User Stories, Product Backlogs, Use Cases Diagrams, using Rational Requisite Pro and MS Visio.
• Expertise in Requirements gathering sessions and Interviews wif end users and translating those requirements to Functional/System requirement specification documents.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) wif good knowledge on SQL Server Analysis Services (SSAS).
• Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages.
• Strong Knowledge on Data warehouse in designing and maintaining by updating Data modelling wif Star Schema/Snowflake, FACT & Dimensions tables and Logical/Physical data.
• Experience working in Datawarehouse Design, methodologies Extraction, Transformation and Loading,DataAnalysis,Datamigration,Datapreparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and Documentation.
• Exposure to OLAP, OLTP, datawarehouse development, system analysis, design, development, maintenance and implementation.
• Worked Extensively on ETL process using SSIS package maintenance and Administration of SSIS by creating Jobs, Alerts and SQL Mail Agent.
• Highly proficient in the use of T - SQL for developing stored procedures, triggers, tables, Views, Group By, and Joins.Transferred data from flat files, Excel spreadsheets and heterogeneous data to SQL Server using DTS and had experience wif large amount of data.
• Experience in analysis services in cube designing and data mining.
• Good Knowledge and experience on SharePoint.
• Experience in all the latest BITools Tableau, Qlikview Dashboard Design, and Spotfire.
• Extensive experience in working wif Tableau Desktop, Tableau Server and Tableau Online in various versions of Tableau
• Extensively worked on Performance Tuning and Query Optimization.
• Used AGILE Methodology and SCRUM Process.
• Experience working on Hadoop, HDFS, Hive, Impala and knowledge on SAS, GitHub,
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
• Excellent analytical, communication, interpersonal skills and problem solving skills and ability to work on own besides being a valuable and contributing team player.

TECHNICAL SKILLS

SQL Server Tools &Packages/BI tools: SQL Server Management Studio, Business Intelligent Studio, Query Analyzer, Profiler, Performance Monitor, SQL Server Agent, ETL, SSAS, SSRS, Data Transformation Services

Web Services/Messaging: Web Services, REST, SOAP,JMS

Languages: T-SQL, My SQL, VB.NET, HTML, XML, Bash, BTEQ, Machine Learning & Python (learning)

Operating Systems: Windows 7/8/10, UNIX and LINUX, Mac OS X

Version Control Tools: GIT/ CVS/ SVS and Rational Clear Case

Databases: MS-SQL Server 2014/2012/2008 R2/2008, Oracle 10g,11g

Data Visualization Tools: Tableau, Power BI, Qlickview

Application Software: Visual Studio 2010/2012, TFS, MS Office Suite

Other Software: MS Office 2007/2003, MS Visio, SharePoint, Tableau, Spotfire, Qlikview

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Functional Consultant

Responsibilities:

• Gather and discuss the requirement from the client and the business team, devise the architecture and process it wif the team for the final output.
• Extensively closely worked wif clients, stakeholders and lead consulting engagements independently.
• Working wif content management/portal areas.
• Analyze client's business requirements and processes through document analysis, interviews, workshops, and workflow analysis.
• Hands on experience wif MS Office (Excel, Power Point and Visio) and Data crunching wif excel.
• Created leadership summaries, reports and client presentations.
• Working closely wif technology simplification leaders, providing inputs into leadership updates.
• Reviewed, Analysed and documented the "AS-IS" business Workflows and "To-BE" business Process Workflow diagrams in MS Visio.
• Facilitated meetings, including creating of agendas and recording of action items from meetings, received, consolidated and produced status reports for business consultants etc. using M.S Word & PowerPoint wif SME's and researched on the process flow application.
• Participated in ongoing technology simplification program for a major client.
• Worked on technology simplification efforts for assigned application rationalization projects to closure.
• Extensively worked on dashboards, inventories and other aggregation frameworks.
• Worked closely wif technology simplification leaders, providing inputs into leadership/sponsor updates.
• Coordinate and lead development teams in project execution as required.

Confidential, Charlotte, NC

Application Developer V/Reporting Analyst/ Data Analyst

Responsibilities:

• Gather and discuss the requirement from the client and the business team, devise the architecture and process it wif the team for the final output.
• Created a Control Plan Dashboard from scratch for monitoring Performance and Operations of ERICA.
• Extensively used Tableau 10.2 COE for creating workbooks and dashboard and stories
• Created daily Refreshes, Subscriptions and permissions for end users to view ERICA Dashboards on Tableau Server.
• Hands on experience wif Hadoop Eco-system, data query and cloudera tools (Hive + Impala)
• Actively designed and Developed visual insights, active dashboards and mobile.
• Having strong SQL skills wif ability to optimize, analyze and improved database T-SQL performance.
• Extensively used Terra data, Advanced SQL and BTEQ scripts to create and load tables.
• Navigate multi-dimensional business source systems and participated in warehouse design.
• Worked on smart data presentations like Scorecards, Dashboards and other advanced analytics.
• Extensively used Bash script.
• Scheduled Autosys Jobs.

Environment: SQL, T-SQL, Tableau 10.2, Tableau Server, Cloudera, Hadoop, Hive, Impala, Terradata, SQL Server, Oracle, Splunk, BTEQ, Autosys

Confidential, San Jose, CA

Data / Reporting Analyst

Responsibilities:

• Gatheird requirements from users and prepared templates accordingly.
• Created multiple visualization reports/dashboards using Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc
• Used multiple Tableau datasources (.tds) from excel, CSV, text files and as source systems for workbook generation using Extract/Live connections.
• Created Tableau dataextracts for improving query performance and enable efficient in-memory data access on Tableau dataEngine.
• Developed Tableau workbooks involving advanced analysis techniques like Sets & Filters, data Grouping/Visual Grouping, Computed Sort features and maps.
• Implemented unit testing, regression testing on the developed reports.
• Involves in the creation of complex SQL/HQL scripts for all dataanalysis and businessdatavalidation.
• Effectively handles ambiguous business requirements wif excellent prioritization and time management abilities.
• Involved in identifying the business-critical/regression scenarios and performed incremental, history load and regression testing using SQL scripts in TOAD.
• Involved indataload through AUTOSYS and verified the job log error /status in the INFORMATICA workflow monitor.
• Involved in creating Hive tables, and loading and analyzing datausing Hive queries.
• Moved all RDBMSdatainto flat files generated from various channels to HDFS for further processing
• Performed DataManipulation and Aggregation from Various source including HDFS.
• Expertise in transforming business requirements into analytical models, designing algorithms, building models, developing datamining and reporting solutions that scales across massive volume of structured and unstructured data.

Environment: Tableau, Windows XP, UNIX, HTML, SQL, HQL, HDFS, Hive

Confidential, Charlotte, NC

Data Analyst/Tableau Consultant

Responsibilities:

• Responsible for Documenting, Developing and delivering samples to be tested that adhere to the Enterprise Testing Standards.
• Work closely wif data source owners to ensure test population eligibility. Develop the logic required for providing samples for tests.
• Extensively Worked on TOAD wif different Data Sources.
• Worked wif both Production and Development data.
• Developed ComplexT-SQLQueries, stored procedures to fetch data from source systems.
• Extensively used joins and sub-queries to simplify complex queries involving multiple tables.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Designed and developedSSISPackagesto import and export data fromMS Excel, SQL Server 2012 add Flat files.
• Worked onCreation of tables, indexes, sequences, constraints and procedures.
• Performed data conversions fromFlat filesinto a normalized database structure.
• Development and maintenance of business metadata for their assigned applications and any corporate-level reports.
• Responsible for Ad-hoc reporting, which consists of Client and account data reporting.
• Work closely wif data source owners to ensure test population eligibility.
• Created calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.
• Involved in installation and configuration of Tableau Server. Maintained and Installed Tableau Server in all the environments.Manipulating, cleansing & processingdatausing Excel, Access and SQL.
• Participated in meetings, reviews, and user group discussions as well as communicating wif stakeholders and business groups.
• Developed and tested SQL and bash scripts that provided status data.
• Development of BashShell scripts.
• Involved in evaluation, datacleaning, dataenrichment and reprogramming process of the company's Quality Assurance (QA) system.
• Collaborate wif Test Developer, Sample Requirements Lead and LOB to refine data/sample requirements.
• Develop the logic (code or processes) required for providing samples for tests.
• Update Intake Request form as development evolves.
• Updates procedures and finalizes prior to submission for QA Review.
• Designed and implementeddataintegration modules for Extract/Transform/Load (ETL) functions.
• Involved inDatawarehouse andDatamart design.
• Experience wif various ETL,datawarehousing tools and concepts.
• Actively document each intake to ensure consistency through the Sample Requirements process.
• Ensure the code, supporting documentation and accurate approvals has been completed for the development intake Request being reviewed
• Knowledge of Python scripts to parse XML documents and load the datain database..
• Review code and supporting documentation to ensure they meet requirements of the intake Request and the expectations established in the QA Checklist.

Environment: SQL, T-SQL, SSIS, SSRS, MS Word, MS Excel, MS Access, DB2, Oracle10 &11g, Informatica 8.1, SQL/Server, SPUFI, TOAD, CDOL, Python, Tableau Desktop, MS-Office, Mainframes, ETL. .

Confidential, Columbus, OH

Data Analyst

Responsibilities:

• Involved in SDLC which included requirements gathering, analysis, design, and development and in application design and designed Use case diagrams, Class diagrams, and Sequence diagrams using UML
• Maintained a huge database wif twenty five million unique records.
• Identify and assist in resolving issues, questions, and scope/requirements gaps quickly to effectively enable delivery and support of applications.
• Implementation of Metadata Repository, MaintainingDataQuality,DataCleanup procedures, Transformations, DataStandards, Scripts, Stored Procedures, triggers and execution of test plans
• Analyzed and designed the business rules fordatacleansing that are required by the staging and OLAP & OLTP database.
• Worked on building queries to retrieve data into Tableau from SQL Server 2008 and Oracle SQL Developer, and developed T-SQL statements for loading data into Target Database.
• Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online.
• Enhanced performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views and managing Cache etc.
• Useddataanalysis techniques to validate business rules and identified low quality missingdatain the existing Amgen enterprisedatawarehouse (EDW).
• Implemented theDataCleansing using various transformations
• Designed and implemented basic SQL queries for testing and report/datavalidation
• Manipulating, cleansing & processingdatausing Excel, Access and SQL.
• Liaising wif end-users and 3rd party suppliers. Analyzing rawdata, drawing conclusions & developing recommendations Writing SQL scripts to manipulatedatafordataloads and extracts.
• Developingdataanalytical databases from complex financial sourcedata. Performing daily system checks.Dataentry,dataauditing, creatingdatareports & monitoring alldatafor accuracy. Designing, developing and implementing new functionality.
• Involved in defining the source to targetdatamappings, business rules anddata definitions.
• Document, clarify, and communicate requests for change requests wif the requestor and coordinate wif the development and testing team.
• Coordinate wif the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user wif the existing functionality.
• Designed and implementeddataintegration modules for Extract/Transform/Load (ETL) functions.
• Experience wif various ETL,datawarehousing tools and concepts.

Environment: MS Word, MS Excel, MS Access, SQL Server, Tableau, MS Visio, Oracle,, Informatica 8.1, SQL/Server,Oracle10 &11g, MS-Office, Embarcadero, Netezza, Terradata, JIRA,JMS, ER Studio, XML, OBIEE,ETL, EDW.

Confidential

SQL Developer

Responsibilities:

• Gatheird functional requirements, Business requirements and wrote the technical specifications for building the Global Enterprise Data warehouse.
• Designed and maintained a web reporting environment including portal, dashboards, scorecards and presentations using SQL Server 2005 and ASP.Net.
• Creating SSIS package based jobs for bulk data loading, updating and exporting.
• Using new features of SQL Server 2008 like Log compression, transparent data encryption TDE, Policies, Performance data collector, Auditing.
• Performance tuning, trouble shooting and monitoring using Performance Dashboard reports, Database Tuning Advisor, SQL Profiler, Dynamic Management views (DMV).
• Creation of tables, views, triggers, stored procedures and functions using T-SQL (Transact-SQL).
• Extensively using XML for input and export operations.
• Using TFS for version control of Database code.
• Implemented Database Replication (Merge and Transactional) for Call Center Database on SQL Server 2005.
• Implemented transactional replication among different servers to has high availability of the data.
• Created DDL, DML scripts, stored procedures and triggers according to the requirement and designed ad hoc queries on the database tables.
• Created views/indexed views consisting of computed columns to facilitate easy user interface.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
• Done High Level Design of ETL using transformations in SSIS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat files, Text Format Data).
• Provided technical guidance and support to end-users by developing documentations required.
• Performed final verification procedure for SQL release to production environment.
• Creating SSIS package based jobs for bulk data loading, updating and exporting.
• Prepare technical reports by collecting, analyzing, and summarizing information from about one hundred web applications and find conclusions
• Documented all database changes, followed and enforced change and release management processes.

Environment: SQL Server 2005/2008, SSIS, SSRS, SSAS, Transact-SQL MS-Excel, Visual Studio.Net 2005, Windows server 2008.