PROFESSIONAL SUMMARY:

• More than 12 years of experience in Python, Neo4j, Hadoop Big Data, MS SQL Server, MSBI (SSIS, SSRS, SSAS), ASP.Net with C#.
• Mastering/Leading in the development of applications/tools using Python.
• Worked on several python packages like numpy, scipy, pytables etc..
• Having Good Experience in Object Oriented Concepts with Python .
• Integrated different data sources, data wrangling: cleaning, transforming, merging and reshaping data data sets by writing Python scripts.
• Created Nodes and Edges in NoSql Database Neo4j.
• Implemented Proofs of Concept on Hadoop stack and different big data analytic tools, migration from different databases (i.e Teradata, Oracle,MYSQL ) to Hadoop.
• Strong Knowledge of Hadoop and Hive and Hive's analytical functions.
• Capturing data from existing databases that provide SQL interfaces using Sqoop.
• Efficient in building hive and pig scripts.
• Having good experience in Hadoop Big Data processing. Expertise in developing the queries in Hive, Pig .
• Successfully loaded files to Hive and HDFS from Mysql.
• Loaded the dataset into Hive for ETL Operation.
• Expert in SSIS Package development, deployment,Job Scheduling and Error Trapping, SSRS Report development, deployment, subscription, SSAS Tabular and Multidimensional Cube development.
• Created Transformation and Modelling in Power BI Visualizations.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (9.x) reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Strong experience as Business Intelligence Developer and Data Analyst in Production, Development and Staging Environments.
• Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services with DAX.
• Designing and Deployment of Reports for the end - user Requests using SharePoint & SSRS.
• Expert in creating Parameterized Reports.
• Expert in T-SQL to create Table, view, user Defined Function (UDF), Stored Procedures, Triggers etc.

TECHNICAL SKILLS:

TSQL: , C#, Python

SQL Server: 2005/2008/R2/2012/2014,PGAdmin 1.4, Hadoop, Hive, Pig, Sqoop, Talend

Internet Technologies: ASP.Net with C# and VB, JavaScript HTML

GUI Tools: Visual Studio 2005,2008,2010,2012

Operating Systems: Window 2000 Server, Windows Server 2003, XP, Windows 7

Version Control System: VSS, TFS. SVN

Graphical Database: IIS, HTML, HTTP, SSIS, Talend, Tableau, Power BI

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Data Analyst

Responsibilities:

• Worked on python files to load the data from csv, json, mysql, hive files to Neo4j Graphical databse.
• Implemented list and dictionary as data structure to manipulate data from sql server, csv and hive files.
• Import csv, pyodbc and pyhive to deal with different structured files.
• Used sets to compare metadata and differentiate .
• Customized error logging as well as exceptional handling.
• Validate the extracted data and prepare valid files as well as data quality error files.
• Created Neo4j Graphical database nodes and relationship.
• Implement cypher queries to manipulate data on Neo4j database.
• Designed and developed a decision tree application using Neo4J graph database to model the nodes and relationships for each decision.
• Implemented data wrangling: cleaning, transforming, merging and reshaping data frames.
• Configure Neo4j on Unix as well as windows system.

Environment: Python, Hive, Neo4j 3.3, Sql Server 2017

Confidential, Los Angles, CA

Sr. Data Analyst

Responsibilities:

• Worked on python files to load the data from csv, json, mysql, hive files to Neo4j Graphical databse.
• Created Neo4j Graphical database nodes and relationship.
• Implement cypher queries to manipulate data on Neo4j database.
• Designed and developed a decision tree application using Neo4J graph database to model the nodes and relationships for each decision
• Explored different implementations in hadoop environment for data extraction and summarization by using packages like Hive, Pig.
• Importing and exporting data into HDFS using Sqoop.
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
• Used Talend as a Data Cleansing tool to correct the data before loading into the staging area.
• Collect and link metadata from diverse sources, including relational databases and flat files.
• Extracted data from different Flat files, MS Excel, HIve and transformed the data based on user requirement using Talend and loaded data into target, by scheduling the sessions.
• Supporting daily loads and work with business users to handle rejected data.
• Implemented data cleansing for files using Talend.
• Created data model in Postgres using dimensional model.
• Load data into Postgres using snow flake schema.
• Performed Unit Testing and tuned for better performance.
• Created Reusable Transformations and multiple Mappings.

Environment: Python, Hive, Pig,Sqoop, Neo4j 3.2, Talend 9.6, PGAdmin 1.4

Confidential, Miami, FL

Sr. Data Analyst

Responsibilities:

• Developed and maintained Python ETL scripts to scrape data from external sources and load cleansed data into a Sql Server. The data was used for daily electrical power virtual trading activities in several markets.
• Implemented discretization and binning, data wrangling: cleaning, transforming, merging and reshaping data frames using Python.
• Integrated applications with designing database architecture and server scripting, studying & establishing
• Designed data visualization to present current impact and growth
• Loaded the dataset into Hive for ETL Operation.
• Written Hive scripts to extract data from staging tables
• Building, publishing customized interactive reports and dashboards, report scheduling using Power BI Desktop.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Power BI Models.
• Designing and apply Microsoft Project Plan.
• Requirement, Design, Development and Testing.
• Data Modeling and Cube design in SSAS using Tabular Model.
• Monitoring overall progress and use of resources, initiating corrective action where necessary.
• Planning and monitoring the project.
• Preparing and maintaining project, stage and exception plans as required.

Environment: Hadoop, Hive, Python, SSAS, Power BI

Confidential, Irvine, CA

Data Analyst

Responsibilities:

• Designing, developing, deploying, job scheduling reports and success/failure notifications in MS SQL Server environment using SSIS in Sql Server data Tools (SSDT).
• Used ETL (SSIS) tasks to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Extracted data from various sources like SQL Server 2008, Oracle, CSV, Excel and Text file from Client servers and through FTP.
• Experience working in a large data environment doing SQL development.
• SQL query optimization (Knowledge of Transactions, Isolation Levels, Indexes, Blocks, Locks, and Database Partitioning etc.)
• Implemented SQL constraints (Primary Key, Foreign Key,Index, Unique, Not Null, Default)
• Experience managing large projects with a close attention to detail and high-quality performance.
• Data modelling and mapping using UML in visio.
• Experience in handling Enterprise datasets.
• Identify issues and fix those issues while troubleshooting.
• Experience in writing MDX queries to access cubes data in SSAS.
• Monitor scheduled SSIS Package through the BIxPress tools
• Error Trapping through BIxPress tool, Script Writing in .net, Transaction, Email Alert and some complex Transformation in SSIS
• Deployment and Scheduling SSIS Package through SQL Server and file system Report development in SSRS
• Create SSIS packages, Email alert for SSIS packages and schedule it through SQL Server and file system.
• Manage the Dev, SQA and Production Environments.

Environment: SQL Server 2012 with Integration, Reporting Services and Analysis Services, C#.net code for SSIS scripting, BIxPress, Microsoft Business intelligence development studio, SQL Server 2012.

Confidential, Miami, FL

Data Analyst

Responsibilities:

• Data warehouse architecture designing.
• ETL package Development in SSIS.
• Deployment and Scheduling of SSIS Package in SSIS.
• Populate data marts with the right data at the right time.
• Performance Tuning/ SQL Query Optimization, Complex Query Design.
• Stored Procedure Writing, Function Writing.
• Creating Reports in SSRS.
• Project monitoring, Status reporting and client interaction.
• Monitoring the critical components of the System.
• Implementation and support of systems in production environment.

Environment: SQL Server 2008 R2 with Integration and Reporting Services, SSIS Scripting, Microsoft Business intelligence development studio, SQL Server 2008 R2

Confidential

ETL Developer

Responsibilities:

• ETL package Development in SSIS.
• Integration of real-time cloud data (NetSuite) with data Warehouse for critical business requirements.
• Report development in SSRS.
• Project monitoring, Status reporting and client interaction.
• Operate as the liaison between Digital Analytics team and IT Development team for all projects and releases including testing pre/post deployment of changes to ensure timely and accurate reporting and insights

Environment: SQL Server 2008 R2 with Integration and Reporting Services, Microsoft Business intelligence development studio, SSMS, SQL Server 2008 R2

Confidential

ETL and Report Developer

Responsibilities:

• ETL package Development in SSIS.
• Report development in SSRS.
• Database Design.
• Understanding the business problem, identifying relevant data, gathering and summarizing data meaningfully.
• Performance Tuning/Query Optimization in SPs.
• Complex Query Design, Stored Procedure Writing.
• Function Writing, Trigger Writing.

Environment: SQL Server 2008 R2/SSIS/SSRS, Microsoft Business intelligence development studio, SQL Server 2008 R2

Confidential

Asp.Net Developer

Responsibilities:

• Coordination and handling tasks among team members.
• Designing of HTML pages, JavaScript validations.
• Assist Project Manager in Feasibility study and requirement Analysis phase.
• Implement web service as business layer.
• Deploy application on Client Server.
• Designing Database, Creation and implementation of View, Stored Procedures.
• Documentation for coding.
• Configuring, deploying Database and web application for testing environment.
• Code review during different stage of development life cycle.

Environment: Web, Framework 2.0, ASP.Net 2.0, C#, Web Service, TFS, Visual Studio 2005, JavaScript, Oracle 10G

Confidential, Hartford, CT

Asp.Net Developer

Responsibilities:

• Requirement Gathering of defects.
• Onsite Coordination.
• Estimation of defects.
• Defect Fixing
• Code review

Environment: Web, Framework 2.0, VB.Net, VB6, SQL Server 2005

Confidential, Hartford, CT

Asp.Net Developer

Responsibilities:

• Coordination and handling tasks among team members.
• Designing of HTML pages.
• Assist Project Manager in Feasibility study and requirement Analysis phase.
• Deploy application on Client Server.
• Database Design, Creation and implementation of View, Stored Procedures.
• Taking Backup and Restore Database.
• Implement Web services as business tier.
• Documentation for coding.
• Configuring, deploying Database and web application for testing environment.
• Code review during different stage of development life cycle.
• Developed HL7 translator.
• Write Store Procedure to implement HL7 translator.

Environment: Web, Framework 2.0, Asp.Net with C#, SQL Server 2005

Confidential, Princeton, NJ

Asp.Net Developer

Responsibilities:

• Designing of HTML pages, JavaScript validations.
• Programming for Referral, People, and System admin, Organization, Policy, Quotes Location Upload and Reporting.
• Identifying the Functionality of the Application.
• Designing of framework.
• Designing Database Model, Creating Views and Stored Procedure.
• Requirement gathering phase and UAT.
• Extensive work on web services as business tier.
• Deploying application for testing environment.
• Documentation for specific modules
• Integration and System Testing
• Programming in XSLT for location upload

Environment: Web, Framework 2.0, Microsoft Framework 2.0(ASP.Net) with C#, Oracle 10G