Working with WD manufacturing teams to provide analytics solutions using TIBCO Data Virtualization (TDV), SingleStore, HVR and there by eliminating traditional data mart. As part of this solution, we source data from multiple data sources (DB2, Oracle, SQL Server, My SQL, Redshift, etc) and enabling single data source connection for analytics team. We provide custom TDV views to manufacturing KPI dashboards and Smart Manufacturing dashboards.Experience with Tibco Composite and Spotfire.Implement design/architecture, data models by applying SDLC/Agile methodologies on the TDV platform.Experience in API Layers for internal/external stakeholders using REST/SOAP to deliver standardized data.Analyze, conceptualize, and create end-to-end technical design and mapping documents.Implement Data Integration, Data transformations within TDV platform.Implement Model and build solution within TDV platform as Data Services and Web services.Strong in Performance tuning within TDV platform.Exceptional SQL skills, proficient in working with large datasets. Strong understanding of SQL Queries/Procedures and DW concepts.

• Involved in creating Database Objects like Tables, Stored Procedures, Views, User defined functions, ER-diagram.• Develop SSIS packages to load data in OLTP database.• Recognize areas of spend inefficiency before it’s too late and simplify processes with fully automated suite of competitor.• Devised measurable and observable steps to achieving operational outcomes.• Manipulating, cleansing & processing data using Excel and SQL.• Responsible for loading, extracting and validation of client data. • Analyzing raw data, drawing conclusions & developing recommendations • Writing T-SQL scripts to manipulate data for data loads and extracts.• Worked on T-SQL Query optimization and performance tuning.

Freshtoget.com vision of delivering Prime quality raw meat items at your doorstep. We measures the impact of obtaining value for money.

• Engage client together software requirements/business rules, and ensure alignment with development teams• Working directly with product owners and stakeholders to elicit their feedback on customer satisfaction items.• Ability to write and break down feature epics into smaller user stories.• Analyze the feasibility and develop requirements for new systems and enhancements to existing systems, ensure the system design fits the needs of the users.• Involved in creating Database Objects like Tables, Stored Procedures, Views, User defined functions, ER-diagram. • Worked on T-SQL Query optimization and performance tuning. • Designing, developing and implementing new functionality.• Communicate client’s business requirements by constructing easy-to-understand data and process models.

Client Sears India into retail market. involved in functionality design technical point of view..• Subject Matter Expert and Advisor on regulatory compliance IT Solutions entailing implementations.• Analyze client’s business requirements and processes through document analysis, workshops, and workflow analysis.• Communicate client’s business requirements by constructing easy-to-understand data and process models.• Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.• Working directly with product owners and stakeholders to elicit their feedback on customer satisfaction items.

• Use our competitive intelligence data to identify emerging market strategies.• Manipulating & processing data using Excel and SQL.• Recognize areas of spend inefficiency before it’s too late and simplify processes with fully automated suite of competitor.• Analyzing raw data, drawing conclusions & developing recommendations • Designing, developing and implementing new functionality. • Advising on the suitability of methodologies and suggesting improvements. • Supplying qualitative and quantitative data to colleagues & clients.

Digital Harbor develops robust and intelligent case management and predictive analytics's platform. Developed solutions to digitize and automate complex knowledge worker processes across various verticals for government run health insurance programs towards managing the processes and risks associated with their provider network, claims and beneficiaries. The solution delivers full compliance with stringent regulatory (Affordable Care Act) requirements, improves efficiency and transparency of operations and minimizes risks associated with “bad” providers.Roles:• Manipulating, cleansing & processing data using Excel and SQL.• Responsible for loading, extracting and validation of client data. • Liaising with end-users and 3rd party suppliers. • Analyzing raw data, drawing conclusions & developing recommendations • Writing T-SQL scripts to manipulate data for data loads and extracts. • Developing data analytical databases from complex financial source data. • Data entry, data auditing, creating data reports & monitoring all data for accuracy. • Designing, developing and implementing new functionality. • Monitoring the automated loading processes. • Advising on the suitability of methodologies and suggesting improvements. • Carrying out specified data processing and statistical techniques.• Supplying qualitative and quantitative data to colleagues & clients.

• Attention to detail & ability to work in a pressurized time sensitive environment. • Experience running complex and high volume ETL processes. • Checking of supplied data for sense, consistency and accuracy. • Sound understanding of relational, object and dimensional databases. • Extensive experience with SQL/Server T-SQL, DTS/SSIS & Excel 2007/2010.

SQL Developer

Lecturer