SUMMARY:

• 5 years’ experience of MS SQL Server 2016/ 2008/2012, SSAS,SSIS,SSRS, Oracle 11g/12c, MySQL, PeopleSoft ERP system and Data Warehousing, Object Oriented Design (OOD).
• Professional experience on Load variety of large volume data files into SQL Server database tables, migrate Oracle tables and MySQL into SQL Server database tables.
• Hands on experience in high performance data integration solutions - Informatica PowerCenter and Microsoft SQL Server Integration Service (SSIS), and including extraction, transformation, and load (ETL) packages for data warehousing.
• Strong technical knowledge in MS SQL Server development including Data Transformation Services (DTS), Microsoft Analysis Services(SSAS), Performance tuning, Reporting, Designing logical/physical databases Data Warehouse and Troubleshooting.
• Professional experience on OLAP and reporting tools with data warehouses. Using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes. Using SSAS database to develop including KPIs, Data mining, working with changing dimensions.
• Professional experience of Creating Dashboards and complex reports in SSRS, SSAS, Tableau and Crystal Reports. Troubleshoot and resolve reporting issues.
• Proficient in Microsoft Office Tools- MS Access and Excel skills with Pivot tables, vlook up, complex formulas, Macros and VBA.
• Hands on experience with Hadoop ecosystem components like Map Reduce, HDFS, Hive, Pig, Hbase, Sqoop, Impala, Spark, and ZooKeeper. Implementing various data processing techniques using SQL/MySql, T-SQL, Hive and Pig scripts.
• Responsible for all aspects of SDLC including gathering of requirements, business and technical assessments, complex back and front - end designs, implementations, testing, data validation, training and development.
• Proven ability to approach problems. Effectively, prioritize and complete multiple tasks.
• Quick learner, Organization, take initiator, and hard worker, willing to take responsibilities.

TECHNICAL SKILLS:

Database: MS SQL Server 2016/2008/2012, Oracle 11g/12c. My SQL, Access 2007/2010

Business Intelligence:: MSBI, SSMS, BIDS/SSDT, SSIS, SSAS, SSRS, OLAP, PowerBI, Informatica PowerCenter Express, SharePoint, TFS, Power Pivot/View, Tableau.

Reporting: Tableau, SSRS, SSAS, Crystal Reports, Access, Excel.

Language:: SQL, T-SQL, PL-SQL, MDX, C#, VB.NET, JavaScript

Internet: HTML, Apache Web Server log, MS Share Point

Software: MS SQL Server, Management Studio/SSMS, Power BI, Toad, Linux, UNIX, Tableau Desktop 8.2, Tableau server, Hadoop and related tools, Cloudera, MS Office-Word, Excel, PowerPoint, Access

PROFESSIONAL EXPERIENCE:

BI Developer

Confidential

Responsibilities:

• Working on OLAP & OLTP including Dev, Analysis, QA and Prod. Extensive programming knowledge in T-SQL .NET framework with Visual Studio.
• Working in an Agile environment as a Scrum Master leading and management for BI projects. Demonstrates ability to build effective relationships with a wide range of people.
• Design data integration ETL packages from difference database to destination and data warehouse. Proficient star schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.
• Working on SSIS ETL performance tuning, adjusting fast load techniques, clean data, debugging, error handling, event handling, re-running of failed packages using checkpoints, trouble shoot using break-points and other tuning techniques.
• Using several control flow tasks sequence container, For Loop, For Each Loop; ActiveX Script Task, CDC task in SSIS 2012, data flow task, Bulk Insert Task, Execute SQL, File System Task, and Script Task, Several Data Flow Transformations: Look Up, Cache transformation, Conditional Split, Derived Column, Row Count, Script Component, Merge Join and Union All.
• Designing the SSAS OLAP cubes right from the scratch, starting from gathering the requirements, understand the requirements, identifying the dimensions and facts, designing the dimensional model, create dimensions, time dimension, cubes, cube dimensions, dimension hierarchies, defining key columns, flexible and rigid relationships based on the requirement, measure groups, calculated measures, cube partitions, cube aggregations, and processing cubes with different conditions.
• Excellent analytical Report Life Cycle. Generated variety of business reports using SSRS including matrix report, sub report, parameter reports, and dashboard with graphs, drill thru, drill down.
• Work with Hadoop the open source community and collect logs data from various sources and integrated in to HDFS, MapReduce, data cleansing techniques and Generating Statistics/Analysis, extracts for Tableau Dashboard reports.
• Collaborate with Microsoft BI tools for the Business Systems Analyst. Like SQL Server, ACCESS-FORM, EXCLE-MACRO, POWER PIVOT…
• Involved in Data mining using Enterprise Miner for various health care datasets such as Financial, Eligibility, C laims data, Inpatient, Outpatient, Long Term Care and Pharmacy (Rx).
• Manage reports for organization, as well as programming features that enable to extend and customize. Configured report server and deployed reports from the projects in SSMS on web server and Share Point 2010.
• Extensively involved in doing user acceptance testing (UAT) and organized well with customer service.
• Involved in version control of Reports and updating the tasks completed using TFS.
• Highly motivated team lead with excellent interpersonal and customer relational skills, proven communication, organizational, analytical.

Research Data Scientist

Confidential,San Antonio,TX

• Successfully load the data from ChIP-Seq and for DNA microarray, Load variety of large volume data files into PowerCenter, SQL Server database tables, migrate Oracle tables into SQL Server; managing Big Data with MySQL.
• Retrieve and modify data using SQL Server 2008 and BIDS and Informatica PowerCenter from different database, participating with the business to identify Business Intelligence (BI) requirements.
• Created Technical Business Rules and ETL package for the Data Migration Project, which assisted the Project Management team with present and future development goals.
• Design and develop multi-dimensional OLAP cubes and tabular models as per industry standards to satisfy business requirements. Mapped data between Crystal Reports, Data Marts and the Enterprise Data Warehouse.
• Create stored procedures and Data Mining. Create Statistical modeling and implemented Analysis. Create interactive KPIs Chart or dashboards & reports using SSRS, automate & setup a process for collection of parameters/metrics.
• Statistical analysis using SAS /ODS and SAS /views from oracle database tables into different formats like HTML and RTF. Test modeling methodology and validate models, management Metadata.
• Participated Data warehouse design. Strong knowledge on relational database management (RDBMS) concepts and dimensional modeling, Database Logical and Physical models, Database Architecture, Data Mapping, Table Normalization (3NF), De-Normalization, DDL and DML.
• Using different biological database cross-reference other database with Primary key, Foreign Key and linking their related knowledge together.
• Proven ability to approach problems effectively, prioritize, complete multiple tasks and provide technical consultation.

Project Manager

Confidential

• Experience with econometric modeling, credit scoring, portfolio forecasting and stress testing, data mining, software development, R, SAS programming, statistical analysis, risk and response analytics, and new product forecasting.
• Involved in creating, reviewing and gaining approvals for initiatives/projects to deliver solutions in support of advanced data analytics enabling the transition from disease management to a broader analytics.
• Proficient Created tables, indexes, table spaces, views synonyms, and integrity constraints. Implemented business logic using stored procedures. Database Design and Normalization.
• Write database procedures, functions using SQL statement and export data from Access to Excel, designed and developed complex reports for the end user.
• Develop Data Entry Screens and Processor Forms. Troubleshoot on site issues such as data transfer errors.
• Importing and Exporting of Data between Spreadsheets and Access Database.
• Write VBA code for automated transferring of data between spreadsheets and other workbooks.
• Utilize data to streamline processes and improve financial, operations, pharmaceutical, research, and clinical outcomes.

Environment: My SQL, MS SQL Server, Java, Linux, MS Access, MS Excel, SAS, Advanced Statistics (I, II), Windows XP, Vista.